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

来源:互联网 发布:惠普服务器数据恢复 编辑:程序博客网 时间:2024/06/06 17:38

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);    }

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

0 0