<div dir="ltr">$B>.NS(B (koichik) $BMM(B conpota$B$G$9!#(B $B$G$-$^$7$?!*(B $B2sEz$"$j$,$H$&$4$6$$$^$7$?!#(B <div class="gmail_quote">2008/09/09 18:00 Koichi Kobayashi <<a href="mailto:koichik@improvement.jp">koichik@improvement.jp</a>>: <blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">$B>.NS(B (koichik) $B$G$9!%(B Date:    Tue, 9 Sep 2008 17:15:15 +0900 From:    <a href="mailto:conpota@gmail.com">conpota@gmail.com</a> To:      <a href="mailto:Seasar-user@ml.seasar.org">Seasar-user@ml.seasar.org</a> Subject: [Seasar-user:15710] [S2JDBC]$BJ#?t%F!<%V%k$N7k9g(B <div class="Ih2E3d"> > $B$5$i$K%F!<%V%k$r7k9g$7$F(B > Two two = > jdbcManager.from(Two.class).innerJoin("oneTwo").innerJoin("oneTwo.oneList").where("name > = ?", "two1").getSingleResult(); > $B$H$9$k$H0J2<%(%i!<$K$J$j$^$9!#(B > $B%(%s%F%#%F%#(B(One)$B$N%W%m%Q%F%#(B(oneTwo)$B$,IT@5$G$9!#(BJoinColumn$B$N(Bname$B$G;XDj$5$l$F$$$k30It%-!<(B(ONE_TWO_ID)$B$,B8:_$7$^$;$s!#(B </div><div class="Ih2E3d">> One$B%(%s%F%#%F%#(B > @ManyToOne > public OneTwo oneTwo; </div>One $B$+$i(B OneTwo $B$X$N4XO"$,B?BP(B 1 $B$J$i!$(B one $B$+$i(B one_two $B$X$N30It%-!<$,I,MW$G$9$,!$(B <div class="Ih2E3d"> > CREATE TABLE one( >   id SERIAL PRIMARY KEY, >   name VARCHAR(64) NOT NULL > ); </div>$B$"$j$^$;$s!%(B $B!V30It%-!<(B(ONE_TWO_ID)$B$,B8:_$7$^$;$s!W$O(B $B$=$&$$$&0UL#$G$9!%(B $B<B:]$O(B one_two $B%F!<%V%k$,4XO"%F!<%V%k$G$7$g$&$+$i!$(B one $B%F!<%V%k$K30It%-!<$r;}$A$?$$$o$1$G$O$J$/!$(B One#oneTwho $B$NB?=EEY$N;XDj$,4V0c$C$F$$$k$N$@$H(B $B;W$$$^$9!%(B $BNc$($P!$4XO"%F!<%V%k$r30$7$F9M$($?>l9g$K(B # '*' $B$OB?$NB&(B +-----+    +-----+    +-------+ | One |*---| Two |---*| Three | +-----+    +-----+    +-------+ $B$H$7$?$$>l9g!$4XO"%F!<%V%k$r4^$a$k$H(B +-----+    +--------+    +-----+    +----------+    +-------+ | One |----| OneTwo |*---| Two |---*| TwoThree |----| Three | +-----+    +--------+    +-----+    +----------+    +-------+ $B$H$J$j$^$9!%(B $B$^$?!$4XO"$O30It%-!<$r;}$C$F$$$kB&$,=jM-B&$J$N$G!$(B One$B!$(BTwo$B!$(BThree $B$N;}$D4XO"$OA4$FHo=jM-B&$H$J$j!$(B mappedBy $B$,I,MW$K$J$j$^$9!%(B One$B%(%s%F%#%F%#(B @OneToOne(mappedBy = "one") public OneTwo oneTwo; Two$B%(%s%F%#%F%#(B @OneToMany(mappedBy = "two") public List<OneTwo> oneTwoList; @OneToMany(mappedBy = "two") public List<TwoThree> twoThreeList; Three$B%(%s%F%#%F%#(B @OneToOne(mappedBy = "three") <div class="Ih2E3d">public TwoThree twoThree; OneTwo$B%(%s%F%#%F%#(B @OneToOne </div>public One one; @ManyToOne public Two two; TwoThree$B%(%s%F%#%F%#(B @ManyToOne public Two two; @OneToOne public Three three; -- <component name="koichik">    <property name="fullName">"Koichi Kobayashi"</property>    <property name="email">"<a href="mailto:koichik@improvement.jp">koichik@improvement.jp</a>"</property>    <property name="blog">"<a href="http://d.hatena.ne.jp/koichik" target="_blank">http://d.hatena.ne.jp/koichik</a>"</property> </component> _______________________________________________ Seasar-user mailing list <a href="mailto:Seasar-user@ml.seasar.org">Seasar-user@ml.seasar.org</a> <a href="https://ml.seasar.org/mailman/listinfo/seasar-user" target="_blank">https://ml.seasar.org/mailman/listinfo/seasar-user</a> </blockquote></div> -- conpota <<a href="mailto:conpota@gmail.com">conpota@gmail.com</a>> </div>