81,092
社区成员
发帖
与我相关
我的任务
分享
/*
* 系统用户数据模型
*/
public class User {
private int user_id;
private String username;
private String password;
private int sex; //1:男 ;0:女
private int age;
private int identity; //身份 --1:管理员;2:学生;3:教师
/*省略setter getter 方法 */
}
/*
*用户权限数据模型
*/
public class Purview {
private int pid;
private User user;
private String pname;
private String obj;//操作对象:数据库中的表
private int type; //操作类型,增删改查依次为:1,2,3,4
/*省略setter getter 方法*/
}
<hibernate-mapping>
<class name="bean.User" table="bcw_user">
<id name="user_id" column="user_id">
<generator class="sequence">
<param name="sequence" >bcw_user_seq</param>
</generator>
</id>
<property name="username" type="string"/>
<property name="password" type="string"></property>
<property name="sex" ></property>
<property name="age" />
<property name="identity" ></property>
</class>
</hibernate-mapping>
<hibernate-mapping>
<class name="bean.Purview" table="bcw_purview">
<id name="pid" column="p_id">
<generator class="sequence">
<param name="sequence" >bcw_purview_seq</param>
</generator>
</id>
<property name="obj" type="string"/>
<property name="pname" type="string"></property>
<property name="type" ></property>
<many-to-one name="user" fetch="select" column="user_id" class="bean.User" outer-join="true"/>
</class>
</hibernate-mapping>
public static void main(String[] d) {
HibernateUtil util = new HibernateUtil();
Session session = util.getSession();
Transaction tx = session.beginTransaction();
User user = (User) session.get(User.class, 21);
//System.out.println(user+"\t"+user.getUser_id());
Purview p = new Purview();
p.setObj("bcw_source");
p.setPname("add source");
p.setType(1);
p.setUser(user);session.saveOrUpdate(p);
tx.commit();
}
Hibernate: select user0_.user_id as user1_0_0_, user0_.username as username0_0_, user0_.password as password0_0_, user0_.sex as sex0_0_, user0_.age as age0_0_, user0_.identity as identity0_0_ from bcw_user user0_ where user0_.user_id=?
Hibernate: select bcw_purview_seq.nextval from dual
Hibernate: insert into bcw_purview (obj, pname, type, user_id, p_id) values (?, ?, ?, ?, ?)