hibernate5.2使用注解方式进行增删改查

1.下载hibernate
2.创建工程，解压zip包，把hibernate-release-5.2.0.Final\lib\required下所有jar包及数据库驱动jar包添加到工程lib下。
3.工程src目录下hibernate.cfg.xml
4.创建POJO类
第一种方式：主键采用UUID：

@Entity
@Table(name="r_user")
@NamedQuery(name = "user.byGender", query = "from User where gender = :gender",
        hints = {@QueryHint(name = "org.hibernate.cacheable", value = "true"),
        @QueryHint(name = "org.hibernate.cacheRegion", value = "testedCacheRegion"),
        @QueryHint(name = "org.hibernate.timeout", value = "100"),
        @QueryHint(name = "org.hibernate.fetchSize", value = "1"),
        @QueryHint(name = "org.hibernate.flushMode", value = "Commit"),
        @QueryHint(name = "org.hibernate.cacheMode", value = "NORMAL"),
        @QueryHint(name = "org.hibernate.comment", value = "Plane by id")})
public class User {
    @Id
    @GeneratedValue(generator = "system-uuid")
    @GenericGenerator(name = "system-uuid",strategy = "uuid")
    @Column(length = 32,unique = true,nullable = false)
    private String id;
    @Column(name="user_name",length = 10,nullable = false)
    private String userName;
    @Column(name = "password",length = 15,nullable = false)
    private String password;
    @Column(name = "last_login_date",nullable = true,columnDefinition="DATE")
    private Date lastLoginDate;
    @Column(name = "register_Date",nullable = true,columnDefinition="DATE")
    private Date registerDate;
    @Column(name = "gender",nullable = true,length = 1)
    private String gender;
    @Column(name = "age",nullable = true,length = 3,columnDefinition="number")
    private int age;
    set/get ......
}

第二种方式：主键采用表HIBERNATE_SEQUENCES：

import javax.persistence.*;
import org.hibernate.annotations.GenericGenerator;
import org.hibernate.annotations.Parameter;
@Entity
@Table(name="r_Person")
//使用 表HIBERNATE_SEQUENCES
@GenericGenerator(name = "mySEQUENCE",
        strategy = "org.hibernate.id.enhanced.TableGenerator",
        parameters = {
                @Parameter(name = "table_name", value = "HIBERNATE_SEQUENCES"),
                @Parameter(name = "initial_value", value = "1"),
                @Parameter(name = "increment_size", value = "1"),
                @Parameter(name = "prefer_entity_table_as_segment_value", value = "true")
        }
)
public class Person {
    @Id
    @Column(unique = true,nullable = false,columnDefinition="number")
    @GeneratedValue(generator = "mySEQUENCE"  )
    private Long  id;
    @Column(name="name",length = 10,nullable = false)
    private String name;

  set/get ...
}

第三种方式：采用自己的序列：

@Entity
@Table(name="r_city")
public class City {
    @Id
    @Column(unique = true,nullable = false,columnDefinition="number")
    @GeneratedValue(strategy=GenerationType.SEQUENCE, generator="mySEQUENCE")
    @SequenceGenerator(name="mySEQUENCE",allocationSize=1,initialValue=1, sequenceName="TEST_SEQUENCE")
    private Long  id;

    @Column(name="name",length = 10,nullable = false)
    private String name;

    set/get ....
}

第四种方式：主键采用自增：

import org.hibernate.annotations.GenericGenerator;
import javax.persistence.*;
@Entity
@Table(name="r_Car")
public class Car {
    @Id
    @Column(unique = true,nullable = false,columnDefinition="number")
    @GeneratedValue(generator="increment")
    @GenericGenerator(name="increment", strategy = "increment")
    private long id;
    @Column(name="name",length = 10,nullable = false)
    private String name;

   set/get ...
}

src下配置hibernate.cfg.xml

<!DOCTYPE hibernate-configuration PUBLIC
        "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
        "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
    <session-factory>
        <!-- 配置数据库连接信息 -->
        <property name="connection.driver_class">
            oracle.jdbc.driver.OracleDriver
        </property>
        <property name="connection.url">
            jdbc:oracle:thin:@127.0.0.1:1521:ORCL
        </property>
        <property name="connection.username">***</property>
        <property name="connection.password">***</property>

        <property name="show_sql">true</property>
        <property name="format_sql">true</property>
        <property name="hbm2ddl.auto">update</property>

        <mapping class="com.***.pojo.User"></mapping>
        <mapping class="com.***.pojo.Person"></mapping>
        <mapping class="com.***.pojo.Car"></mapping>
        <mapping class="com.***.pojo.City"></mapping>
    </session-factory>
</hibernate-configuration>

如果使用表HIBERNATE_SEQUENCES，测试时使用hibernate的sequence,需要将该表建立

create table HIBERNATE_SEQUENCES
(
  SEQUENCE_NAME VARCHAR2(255) not null,
  NEXT_VAL      NUMBER not null
)

5.开始测试：

private static Session session;
    private static Transaction transaction;
    private static SessionFactory sessionFactory;
    static {
        Configuration configuration = new Configuration().configure();
        sessionFactory = configuration.buildSessionFactory();
        session = sessionFactory.openSession();
        transaction = session.beginTransaction();
    }
    public static void main(String[] args){
        try {
            for(int i=0;i<10 ; i++){
                User user = new User();
                user.setUserName("zhangSan"+i);
                user.setPassword("123456");
                user.setGender("M");
                user.setAge(10+i);
                user.setRegisterDate(new Date());
                session.save(user);

                Person p = new Person();
                p.setName("liSi"+i);
                session.save(p);

                Car c = new Car();
                c.setName("BMW"+i);
                session.save(c);

                City city = new City();
                city.setName("BJ"+i);
                session.save(city);
            }
            transaction.commit();
        }catch (Exception e){
            e.printStackTrace();
            transaction.rollback();
        }finally {
            if(session != null){
                session.close();
            }
            if(sessionFactory != null){
                sessionFactory.close();
            }
        }
    }
       /**
     * 修改或保存
     */
    public static  void testSaveOrUpdate(){
        Job job = new Job();
        job.setId(1L);
        job.setName("job");
        session.saveOrUpdate(job);
    }
    //测试删除
    public static void testDelete(){
        Job job = new Job();
        job.setId(1L);
        job.setName("job");
        session.delete(job);
    }
    //测试查询
    public static void testQuery(){

        List<Job> list = session.createQuery("from Job").setFirstResult(0).setMaxResults(5).list();
        System.out.println(list);
    }
    //测试命名查询
    public static void testNameQuery(){
       Query query = session.createNamedQuery("user.byGender");
        query.setParameter("gender","M");
        System.out.println("aaa:"+query.list());
        List<Job> resultList = query.getResultList();
        System.out.println("bbb:"+resultList);
    }

测试成功，数据库会自动建表并有数据，如下图：