慕課網(wǎng)Hibernate學習筆記
開發(fā)環(huán)境
- eclipse mars
- hibernate toos
最簡單的例子
創(chuàng)建java Project
導入相關依賴
- 導入hibernate-re...\lib\required中的jar包
- 導入mysql驅(qū)動
- 導入Junit4包
- 創(chuàng)建hibernate.cfg.xml配置文件
<?xml version="1.0" encoding="UTF-8"?>
<!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.user">root</property>
<property name="connection.password">root</property>
<property name="connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="connection.url">jdbc:mysql://localhost:3306/hibernate?useUnicode=true&characterEncoding=UTF-8</property>
<property name="dialect">org.hibernate.dialect.MySQLDialect</property>
<property name="show_sql">true</property>
<property name="format_sql">true</property>
<property name="hbm2ddl.auto">update</property>
</session-factory>
</hibernate-configuration>
- 創(chuàng)建持久化類(javabean)
- 公有
- 提供不帶參數(shù)的的構造方法
- 屬性私有
- 有setter和getter
public class Student {
private int id;
private String name;
private String sex;
private int age;
public Student() {
}
public Student(int id, String name, String sex, int age) {
this.id = id;
this.name = name;
this.sex = sex;
this.age = age;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getSex() {
return sex;
}
public void setSex(String sex) {
this.sex = sex;
}
public int getAge() {
return age;
}
public void setAge(int age) {
this.age = age;
}
@Override
public String toString() {
return "Student [id=" + id + ", name=" + name + ", sex=" + sex + ", age=" + age + "]";
}
}
- 創(chuàng)建對象關系映射文件(*.hbm.xml)
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated 2016-10-2 16:35:18 by Hibernate Tools 3.5.0.Final -->
<hibernate-mapping>
<class name="Student" table="STUDENT">
<id name="id" type="int">
<column name="ID" />
<generator class="assigned" />
</id>
<property name="name" type="java.lang.String">
<column name="NAME" />
</property>
<property name="sex" type="java.lang.String">
<column name="SEX" />
</property>
<property name="age" type="int">
<column name="AGE" />
</property>
</class>
</hibernate-mapping>
- 將映射添加到hibernate.cfg.xml
<mapping resource="Student.hbm.xml"/>
- 創(chuàng)建JUnit測試類
public class StudentTest {
private SessionFactory sessionFactory;
private Session session;
private Transaction transaction;
@Before
public void init(){
StandardServiceRegistry registry = new StandardServiceRegistryBuilder().configure("hibernate.cfg.xml").build();
sessionFactory = new MetadataSources(registry).buildMetadata().buildSessionFactory();
session = sessionFactory.openSession();
transaction = session.beginTransaction();
}
@After
public void destroy(){
transaction.commit();
session.close();
sessionFactory.close();
}
@Test
public void testSaveStudent() {
Student student = new Student(2, "老王", "男", 13);
session.save(student);
}
}
- 運行測試即可將數(shù)據(jù)存入數(shù)據(jù)庫
Hibernate相關介紹
hibernat.cfg.xml屬性介紹
hibernat.show_sql:(true|false)是否輸出sql語句到控制臺
hibernat.format_sql: (true|false)是否對輸出的sql語句進行排版
hbm2ddl.auto:(create|update|create-drop|va|idate)
create每次插入都會刪除原來的表改艇,update會更新原來的表hibernate.default_schema:(hibernate)設置默認數(shù)據(jù)庫,會在sql語句中的表名前加入前綴
hibernate.dialect:(org.hibernate.dialect.MySQLDialect)數(shù)據(jù)庫方言,可針對特定數(shù)據(jù)庫進行優(yōu)化
hibernate.current_session_contex_class:(thread|jta):
用于指定getCurrentSession是獲取本地事務還是全局事務
session
SessionFactory一個系統(tǒng)一般只創(chuàng)建一個
openSession每次獲取的事務時不同事務
getCurrentSession獲取的是同一個事務鉴裹,會自動關閉
通過session進行增刪改查
操作前需開啟transaction,完成后提交transaction
*.hbm.xml配置文件介紹
<hibernate-mapping
schema="schema_name"
catalog="catalog_name"http://目錄mysql不支持
default_cascade="cascade_style"http://級聯(lián)風格
default_access="field|property|ClassName"http://訪問策略
default-lazy="true|false"http://加載策略
package="packageName"
>
<id>
<generator class="assigned|native|increment"/>
</id>
//組件屬性
<component name="address" class="">
<property name="" column></property>
</component>
增刪改查
- save
- update
- delete
- get //一次性獲取
- load // 懶加載
一對多
實體類中設置多方的set
在一方的映射文件中設置
<set name="students" table="student" lazy="true" inverse="true" cascade="all">//inverse=true表示由多方維護關聯(lián)關系(多方add元素后,插入時不會出現(xiàn)update)
//cascade="all|save-update|delete|none"
<key column="gid"></key>
<one-to-many class="student">
</set>
多對一
在實體類中設置一方的實例
在多方映射文件中設置
<many-to-one name="grade" class="Grade" conlumn = "gid"></many-to-one>
HQL語句
select xxx from xxx where xxx group by xxx having xxx order by xxx
使用方法
大小寫敏感
簡單例子
@Test
public void testQuery(){
String hql = "from Student as s";
List<Student> students = session.createQuery(hql).list();
for(Student student : students){
System.out.println(student);
}
}
- 返回Object[]
//只選擇一個屬性則返回object
@Test
public void testSelect(){
String hql = "select s.id, s.name from Student as s";
Query<Object[]> query = session.createQuery(hql);
List<Object[]> list = query.list();
for(Object[] objects : list){
System.out.println(objects[0]);
System.out.println(objects[1]);
}
}
- 返回list
@Test
public void testSelectWithList(){
String hql = "select new list(s.id, s.name) from Student as s";
Query query = session.createQuery(hql);
List<List> lists = query.list();
for(List list : lists){
System.out.println(list.get(0));
System.out.println(list.get(1));
}
}
- 返回自定義類
//需要有相應的構造方法
String hql = "select new Student(s.id, s.name) from Student as s"
List<Student> lists = query.list();
沒有指定構造器會調(diào)用默認構造器即無參構造函數(shù)
集合運算"from grade g where g.students is not empty";
獲取單個對象
@Test
public void testGetOne(){
String hql="from Student as s where s.id=1";
Query query = session.createQuery(hql);
Student student = (Student) query.uniqueResult();
System.out.println(student.getName());
}
Hibernate 緩存
一級緩存
與session相同的生命周期
示例代碼
@Test
public void testCache(){
Student student1 = session.get(Student.class, 1);
//清除指定對象緩存
session.evict(student1);
//清除所有緩存
session.clear();
Student student2 = session.get(Student.class, 1);
//list()不使用緩存
String hql = "from Student";
Query query = session.createQuery(hql);
List<Student> students = query.list();
//iterator 先從數(shù)據(jù)庫獲取所有id,判斷緩存中是否有對應記錄四啰,若有則直接使用緩存
Iterator iterator = query.iterate();
while(iterator.hasNext()){
Student student = (Student) iterator.next();
System.out.println(student.getName());
}
}
Hibernate注解
類級別注解
- @Entity(name="tableName")
- @table(name="", catalog="", schema="")
- @Embeddable // 在嵌入類上添加(如Address類)
屬性級別注解
可寫在屬性上也可以寫在get方法上
@Id
//多個屬性Id實體類需要實現(xiàn)serializable接口
//字符串主鍵需要通過@Column指定長度@GeneratedValue(strategy=(), generator="")
//主鍵生成策略
@GeneratedValue(generator="id")
@GenericGenerator(name="id", strategy="assigned")
- @Column(length="", name="", nullable="", insertable="", unique="", updateable="")
- @Embedded
//嵌入類需要@Embeddable - @EmbeddedId
//嵌入類(需要@Embeddable,實現(xiàn)Serializable接口,有無參構造方法粗恢,覆蓋equals,hashCode)作為主鍵 - @Transient
//忽略某個字段柑晒,不映射到數(shù)據(jù)庫
關聯(lián)映射注解
@OneToOne(cascade=CascadeType.ALl, mappedBy="id")
//mappedBy設置主控放
@JoinColumn(name="id", unique=true)@ManyTOOne(cascade={CascadeType.ALL} fetch=FetchType.EAGER)
//fetch抓取策略默認積極
@JoinColumn(name="gid", referenceColumnName="gid")@OneToMany(cascade={CascadeType.ALL} fetch=FetchType.LAZY)
@JoinColumn(name="gid")@ManyToMany(mappedBy="")
@JoinTable(name="",JoinColumns="",
inverseJoinColumns={@JoinColumn(name="tid")})