hibernate联合主键

复合主键与Hibernate操作

最新推荐文章于 2021-03-02 15:37:27 发布

free0006

最新推荐文章于 2021-03-02 15:37:27 发布

阅读量123

点赞数

CC 4.0 BY-SA版权

分类专栏： hibernate 文章标签： java

本文链接：https://blog.youkuaiyun.com/free0006/article/details/84377483

hibernate 专栏收录该内容

27 篇文章

订阅专栏

本文介绍使用Hibernate框架对具有复合主键的Users类进行CRUD操作的方法。包括创建、读取、更新和删除等核心功能实现。

<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd" >

<hibernate-mapping package="classweb.model.po">
<class
   name="Users"
   table="USERS"
>
   <meta attribute="sync-DAO">false</meta>
   <composite-id name="id" class="UsersPK">
    <key-property
     name="name"
     column="NAME"
     type="string"
    />
    <key-property
     name="tel"
     column="TEL"
     type="string"
    />
   </composite-id>

   <property
    name="age"
    column="AGE"
    type="string"
    not-null="false"
   />

</class>
</hibernate-mapping>

以下代码生成一个Users对象，并保存．

    Session s = HibernateUtil.currentSession();
    Transaction t = s.beginTransaction();
    UsersPK usersPK = new UsersPK();
    usersPK.setName(1);
    usersPK.setTel(4);
    Users user = new Users();
    user.setAge("19");
    user.setId(usersPK );
    s.save(user);
    t.commit();
    HibernateUtil.closeSession();
    System.out.println("insert success!");

更新．

    Session s = HibernateUtil.currentSession();
    Transaction t = s.beginTransaction();
    UsersPK usersPK = new UsersPK();
    usersPK.setDbid(1);
    usersPK.setRowUID(4);
    Users user = (Users)s.load(Users.class, usersPK);

    user.setAge("20");
    s.update(user);
    t.commit();
    HibernateUtil.closeSession();
    System.out.println("update success!");

删除．

Session s = HibernateUtil.currentSession();
    Transaction t = s.beginTransaction();
    UsersPK usersPK = new UsersPK();
    usersPK.setDbid(1);
    usersPK.setRowUID(4);
    Users user = (Users)s.load(Users.class, usersPK);

    s.delete(user);
    t.commit();
    HibernateUtil.closeSession();
    System.out.println("delete success!");

最后讲select

如果对复合主键中的一个主键进行查询，必须

    Session s = HibernateUtil.currentSession();
    Criteria c = s.createCriteria(Users.class);
    c.add(Restrictions.eq("id.name", "levi"));
    List list = c.list();
    Iterator iter = list.iterator();
    while (iter.hasNext()) {
      Users item = (Users) iter.next();
      System.out.println("name:" + item.getId().getName());
      System.out.println("tel;" + item.getId().getTel());
      System.out.println("age:" + item.getAge());
    }
    HibernateUtil.closeSession();
    System.out.println("select success!");