[Seasar-user:19692] Re: 【S2Dao】キーワード検索などで、スペース区切りをAND検索にする

Hidemasa Aoki [E-MAIL ADDRESS DELETED]
2010年 5月 6日 (木) 19:18:05 JST 

$B$$$D$b$*@$OC$K$J$C$F$*$j$^$9!#(BITP$[E-MAIL ADDRESS DELETED]$G$9!#(B

EntityManager$B$r;n$7$F$_$^$7$?$,!"$@$a$G$7$?!#(B
Teeda$B$+$i(BS2Dao$B$rMxMQ$7$F$$$k$N$G$9$,!"(BSMART Deploy$B$[E-MAIL ADDRESS DELETED]$,0-$$$h$&$G$9!#(B

$BE:IU$7$?(BDao$B$d(BDaoImpl$B!"(BSQL$B%U%!%$%k!"(Bdicon$B%U%!%$%k$J$I$r:[E-MAIL ADDRESS DELETED]$7$^$7$?!#(B

http://s2dao.seasar.org/ja/s2dao.html#EntityManager
$B-!>e5-$K=q$$$F$"$kDL$j!"(B
$B8F$S=P$7ItJ,$G!"(B
		S2Container container = S2ContainerFactory

.create("jp/co/tsys/sfi/cardentry/dao/CardEntryPreprintEmDao.dicon");
		container.init();
		try {
			CardEntryPreprintEmDao dao =
(CardEntryPreprintEmDao) container

.getComponent(CardEntryPreprintEmDao.class);
			cardEntryItems =
dao.findByPreprintMemoPagerCondition(
					getTextPreprintMemo(), dto);
		} finally {
			container.destroy();
		}
$B$N$h$&$K$9$k$H!"$9$G$K:[E-MAIL ADDRESS DELETED]$5$l$F$$$k%3%s%F%J$rGK2u$7$F$7$^$&!J!)!K$h$&$G!"Nc(B
$B30$,H/@8$7$^$9!#(B
$B"(@53N$K8@$&$H!"$3$A$i$G%;%C%7%g%s$K3JG<$7$F$$$k(BDto$B$,$I$&$?$i$3$&$?$i!J%(%s(B
$B%O%s%9!)!K!"$H$$$&Nc30$,H/@8$7$^$9!#(B

$B-"(BCardEntryPreprintEmDao.dicon$B$r(Bapp.dicon$B$K(Binclude$B$7$F!"@[E-MAIL ADDRESS DELETED]$7$F$b$i$&$h$&$K(B
$B$7$^$9!#(B
$B$7$+$7!"$=$&$$$&@_Dj$r$7$F$$$F$b!"(BCardEntryPreprintEmDaoImpl$B$N=hM}$,8F$P$l(B
$B$:!"@_Dj$7$F$$$J$$$N$HF1$8$h$&$K(BCardEntryPreprintEmDao$B$,8F$P$l$^$9!#(B
$B$^$?!"(BCardEntryPreprintEmDaoImpl$B$r(BDI$B$7$F$b$i$&$h$&(BPage$B%/%i%9$r=q$-49$($k$H!"(B
$B3N$+$K(BCardEntryPreprintEmDaoImpl$B$O!"8F$S=P$9$3$H$,$G$-$k$h$&$K$J$k$N$G$9$,!"(B
CardEntryPreprintEmDao$B$H%j%s%/$7$F$$$k(BSQL$B%U%!%$%k$O8F$P$l$:!"<[E-MAIL ADDRESS DELETED]@.(BSQL$B$K(B
$B$J$C$F$7$^$$$^$9!#(B

$B$J$*!"(BCardEntryPreprintEmDaoImpl$B$r(BCardEntryPreprintEmImplDao$B$H$$$&L>>N$KJQ99(B
$B$7!"(BSMART Deploy$B$[E-MAIL ADDRESS DELETED]@.$7$F$b$i$&$h$&$K$b$7$F$_$^$7$?$,!"$3$l$b7k2L$OF1$8$G$7(B
$B$?!#(B

$B!=!=!=!=!=!=!=!=!=!=!=!=!=!=!=!=!=!=!=!=!=!=!=!=!=(B

SMART Deploy$B>e$G!"(BEntityManager$B$rMxMQ$9$kJ}K!$J$I$,$"$j$^$7$?$i!"65$($F$/$@(B
$B$5$$!#(B

-----Original Message-----
From: [E-MAIL ADDRESS DELETED]
[mailto:[E-MAIL ADDRESS DELETED]] On Behalf Of Hidemasa Aoki
Sent: Thursday, May 06, 2010 10:41 AM
To: [E-MAIL ADDRESS DELETED]
Subject: [Seasar-user:19688] Re: $B!Z(BS2Dao$B![%-!<%o!<%I8!:w$J$I$G!"%9%Z!<%[E-MAIL ADDRESS DELETED](B
$B$j$r(BAND$B8!:w$K$9$k(B

$B$$$D$b$*@$OC$K$J$C$F$*$j$^$9!#(BITP$[E-MAIL ADDRESS DELETED]$G$9!#(B

$B$^$@2r7h$K$O;j$C$F$$$^$;$s$,!"$3$&$$$&$H$-$N$?$a$K(B
EntityManager
$B$H$$$&$b$N$,MQ0U$5$l$F$$$k$3$H$K5$IU$-$^$7$?!#(B

http://s2dao.seasar.org/ja/s2dao.html#EntityManager

$B$3$l$r;H$C$F$_$h$&$H;W$$$^$9!#(B


-----Original Message-----
From: [E-MAIL ADDRESS DELETED]
[mailto:[E-MAIL ADDRESS DELETED]] On Behalf Of Hidemasa Aoki
Sent: Friday, April 23, 2010 4:31 PM
To: [E-MAIL ADDRESS DELETED]
Subject: [Seasar-user:19648] $B!Z(BS2Dao$B![%-!<%o!<%I8!:w$J$I$G!"%9%Z!<%[E-MAIL ADDRESS DELETED]$j$r(B
AND$B8!:w$K$9$k(B

$B$$$D$b$*@$OC$K$J$C$F$*$j$^$9!#(BITP$[E-MAIL ADDRESS DELETED]$G$9!#(B

S2Dao$B$N(BSQL$B%U%!%$%k$N;H$$J}$G:$$C$F$$$k$3$H$,$"$j!"BP1~J}K!$d%"%$%G%"$r$$$?$@(B
$B$1$l$P$H;W$$$^$9!#(B

$B7oL>$N$H$*$j!"%-!<%o!<%I8!:w$J$I$G!"%9%Z!<%[E-MAIL ADDRESS DELETED]$j$GF~NO$5$l$k$H(BAND$B8!:w$K$J(B
$B$k!"$H$$$&;EMM$O$h$/$"$k$H;W$$$^$9!#"((BGoogle$B$_$?$$$K!#(B

$B$3$l$r!"(BS2Dao$B$N(BSQL$B%U%!%$%k$G<B8=$9$k$K$O$I$&$9$l$P$h$$$N$G$7$g$&$+!)(B

$B$?$H$($P!"8=:_$N(BSQL$B%U%!%$%k$G$O!"(B
       /*IF argPreprintMemo != null*/
         CEP.PREPRINT_MEMO LIKE '%' || /*argPreprintMemo*/' ' || '%'
       /*END*/
$B$H$$$&>r7o$K$7$F$$$F!"%-!<%o!<%I$R$H$D$N8!:w$O$G$-$F$$$^$9!#(B
$B$3$l$r!"(B
         CEP.PREPRINT_MEMO LIKE '%' || /*argPreprintMemo[0]*/' ' || '%'
	 AND
         CEP.PREPRINT_MEMO LIKE '%' || /*argPreprintMemo[1]*/' ' || '%'
	 AND
         CEP.PREPRINT_MEMO LIKE '%' || /*argPreprintMemo[2]*/' ' || '%'
$B$N$h$&$K!"%-!<%o!<%IJ#?t$N(BAND$B8!:w$,$G$-$k$h$&$K$7$?$$$G$9!#(B

S2Dao$B$d(BSQL$B%U%!%$%k$G$G$-$^$9$+!)(B
$B$=$l$H$b!"(BSQL$B$r<+J,!J(BJava$B%W%m%0%i%`Fb!K$G:[E-MAIL ADDRESS DELETED]$7$FH/9T$9$k$7$+$"$j$^$;$s$+!)(B
$B"*$=$NJ}K!$b$o$+$j$^$;$s!#(B

$B$h$m$7$/$*4j$$$$$?$7$^$9!#(B


_______________________________________________
Seasar-user mailing list
[E-MAIL ADDRESS DELETED]
https://ml.seasar.org/mailman/listinfo/seasar-user

_______________________________________________
Seasar-user mailing list
[E-MAIL ADDRESS DELETED]
https://ml.seasar.org/mailman/listinfo/seasar-user
-------------- next part --------------
A non-text attachment was scrubbed...
Name: AbstractCardEntryPreprintPage.java
Type: application/octet-stream
Size: 6920 bytes
Desc: $BL5$7(B
URL: <http://ml.seasar.org/archives/seasar-user/attachments/20100506/d68a8a4f/attachment.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: CardEntryPreprintEmDao.dicon
Type: application/octet-stream
Size: 333 bytes
Desc: $BL5$7(B
URL: <http://ml.seasar.org/archives/seasar-user/attachments/20100506/d68a8a4f/attachment-0001.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: CardEntryPreprintEmDao.java
Type: application/octet-stream
Size: 492 bytes
Desc: $BL5$7(B
URL: <http://ml.seasar.org/archives/seasar-user/attachments/20100506/d68a8a4f/attachment-0002.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: CardEntryPreprintEmDao_findByPreprintMemoPagerCondition.sql
Type: application/octet-stream
Size: 1171 bytes
Desc: $BL5$7(B
URL: <http://ml.seasar.org/archives/seasar-user/attachments/20100506/d68a8a4f/attachment-0003.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: CardEntryPreprintEmDaoImpl.java
Type: application/octet-stream
Size: 1616 bytes
Desc: $BL5$7(B
URL: <http://ml.seasar.org/archives/seasar-user/attachments/20100506/d68a8a4f/attachment-0004.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: PreprintMemoListPage.java
Type: application/octet-stream
Size: 5071 bytes
Desc: $BL5$7(B
URL: <http://ml.seasar.org/archives/seasar-user/attachments/20100506/d68a8a4f/attachment-0005.obj>

Seasar-user メーリングリストの案内