主要代码在下面,配置文件有问题还是??刚研究这个
SUser.hbm.xml
<id name="id" type="java.lang.String" column="CONFLICT_ID">
<generator class="sequence">
<param name="sequence">ID_SEQ</param>
</generator>
</id>
<property name="created" type="timestamp">
<column name="CREATED" />
</property>
<property name="createdBy" type="java.lang.String">
<column name="CREATED_BY" />
</property>
<property name="rowId" type="java.lang.String">
<column name="ROW_ID"/>
</property>
<one-to-one name="userx" class="com.itpoints.entity.sys.SUserX" cascade="all" />SUserX.hbm.xml
<id name="conflictId" type="java.lang.String" column="CONFLICT_ID">
<generator class="sequence">
<param name="sequence">ID_SEQ</param>
</generator>
</id>
<property name="rowId" type="java.lang.String">
<column name="ROW_ID" />
</property>
<property name="attrib01" type="java.lang.String">
<column name="ATTRIB_01" />
</property>
<one-to-one name="user" class="com.itpoints.entity.sys.SUser" cascade="all" />
select new com.itpoints.entity.OperaterUser( s.id,x.attrib01,s.created) from SUser as s left join SUserX as x where s.rowId=x.rowId
SUser.hbm.xml
<id name="id" type="java.lang.String" column="CONFLICT_ID">
<generator class="sequence">
<param name="sequence">ID_SEQ</param>
</generator>
</id>
<property name="created" type="timestamp">
<column name="CREATED" />
</property>
<property name="createdBy" type="java.lang.String">
<column name="CREATED_BY" />
</property>
<property name="rowId" type="java.lang.String">
<column name="ROW_ID"/>
</property>
<one-to-one name="userx" class="com.itpoints.entity.sys.SUserX" cascade="all" />SUserX.hbm.xml
<id name="conflictId" type="java.lang.String" column="CONFLICT_ID">
<generator class="sequence">
<param name="sequence">ID_SEQ</param>
</generator>
</id>
<property name="rowId" type="java.lang.String">
<column name="ROW_ID" />
</property>
<property name="attrib01" type="java.lang.String">
<column name="ATTRIB_01" />
</property>
<one-to-one name="user" class="com.itpoints.entity.sys.SUser" cascade="all" />
select new com.itpoints.entity.OperaterUser( s.id,x.attrib01,s.created) from SUser as s left join SUserX as x where s.rowId=x.rowId
from SUser s left join s.userx x where s.rowId=x.rowId好像是这样,不大记得了,试下
好像是这样的吧