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
- hibernate5.2使用注解方式进行增删改查
- Mybatis注解方式进行简单的增删改查
- mybaits(3)_使用注解进行增删改查
- MyBatis使用注解实现增删改查
- mybaits(2)_使用xml进行增删改查
- 简单使用GreenDao3.2进行增删改查
- 使用hibernate进行增删改查
- ibatis使用sql进行增删改查
- Oracle使用JDBC进行增删改查
- 使用Dbutils进行增删改查
- Mybatis--使用xml进行增删改查
- Spring Mvc那点事---(12)Spring Mvc之mybatis使用注解进行增删改查
- mybatis3.2.8注解方式实现数据的增删改查
- 注解实现增删改查
- iOS使用读写plist文件方式对数据进行增删改查
- Mybatis用接口XML方式进行增删改查
- Hibernate5增删改
- Hibernate5配置及实现简单增删改查
- spark 读取hbase中的数据
- ElasticSearch java API (1)
- asp.net Textbox获取焦点并且内容全选
- 网络虚拟化技术(二): TUN/TAP MACVLAN MACVTAP
- Elasticsearch java API (2)
- hibernate5.2使用注解方式进行增删改查
- swift3.0和Objective-C交互事项(转)
- OPENWR更改私有参数
- 文章标题
- 嵌入式学习-uboot-lesson4.1-异常向量表
- Android中通过socket建立长连接实现推送功能
- 如何实现界面的跳转
- java分层概念
- NotRxJava懒人专用指南-RxJava的演进过程