67,512
社区成员
发帖
与我相关
我的任务
分享
<hibernate-mapping>
<class name="com.shili2.vo.RoleVO" table="role" schema="dbo" catalog="shilikaifa">
<id name="roleID" type="java.lang.String">
<column name="roleID" length="50" />
<generator class="assigned" />
</id>
<property name="roleCode" type="java.lang.String">
<column name="roleCode" length="50" />
</property>
<property name="roleName" type="java.lang.String">
<column name="roleName" length="20" />
</property>
<many-to-one name="UserRoleVO" class="com.shili2.vo.UserRoleVO"
fetch="select" update="false" insert="false">
<column name="roleID" />
</many-to-one>
</class>
</hibernate-mapping>
<hibernate-mapping>
<class name="com.shili2.vo.UserRoleVO" table="userRole" schema="dbo" catalog="shilikaifa">
<id name="userRoleID" type="java.lang.Integer">
<column name="userRoleID" />
<generator class="native"/>
</id>
<property name="userID" type="java.lang.String">
<column name="userID" length="50" />
</property>
<property name="roleID" type="java.lang.String" update="false" insert="false">
<column name="roleID" length="50" />
</property>
<property name="password" type="java.lang.String">
<column name="password" length="50" />
</property>
<set name="role" inverse="true">
<key>
<column name="roleID" />
</key>
<one-to-many class="com.shili2.vo.RoleVO" />
</set>
</class>
</hibernate-mapping>
public class RoleVO {
private String roleID;
private String roleCode;
private String roleName;
private UserRoleVO userRoleVO;
public UserRoleVO getUserRoleVO() {
return userRoleVO;
}
public void setUserRoleVO(UserRoleVO userRoleVO) {
this.userRoleVO = userRoleVO;
}
public String getRoleID() {
return roleID;
}
public void setRoleID(String roleID) {
this.roleID = roleID;
}
public String getRoleCode() {
return roleCode;
}
public void setRoleCode(String roleCode) {
this.roleCode = roleCode;
}
public String getRoleName() {
return roleName;
}
public void setRoleName(String roleName) {
this.roleName = roleName;
}
}
public class UserRoleVO {
private int userRoleID;
private String userID;
private String roleID;
private String password;
private Set role;
public String getRoleID() {
return roleID;
}
public void setRoleID(String roleID) {
this.roleID = roleID;
}
public int getUserRoleID() {
return userRoleID;
}
public void setUserRoleID(int userRoleID) {
this.userRoleID = userRoleID;
}
public String getUserID() {
return userID;
}
public void setUserID(String userID) {
this.userID = userID;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public Set getRole() {
return role;
}
public void setRole(Set role) {
this.role = role;
}
}
select 1 from UserRoleVO b where a.roleid = b.roleid and b.userid = ?
select * from RoleVO a where exists(select 1 from UserRoleVO b where a.roleid = b.roleid and b.userid = ? )
<set name="UserRoleVO">
<key column="roleID" />
<many-to-many class="UserRoleVO" column="roleID" />
</set>