1、引入hibernate 框架必须的jar 包,包括连接数据库的,自动生成的时候,为自动导入
2、hibernate 配置文件位于src 下,hibernate.cfg.xml 如下:
<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<property name="connection.url">jdbc:mysql://127.0.0.1:3306/test</property>
<property name="connection.username">root</property>
<property name="connection.password">123</property>
<property name="connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="dialect">org.hibernate.dialect.MySQLDialect</property>
<property name="show_sql">true</property>
<!-- <property name="format_sql">true</property>-->
<mapping resource="User.hbm.xml"/>
</session-factory>
</hibernate-configuration>
3、编写polo类
package com.model;
public class User {
private String id;
private String username;
private String password;
public String getId() {
return id;
}
public void setId(String id) {
this.id = id;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public User() {
}
}
4、对象映射文件 User.hbm.xml位于src 下:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="com.model.User" table="user">
<!-- 设定主键的生成方式-->
<id name="id" column="id" type="string">
<generator class="uuid"></generator>
</id>
<!-- 当类属性名称与数据库中字段名称一致时,column 可以省略-->
<property name="username" column="username" type="string"></property>
<property name="password" column="password" type="string"></property>
</class>
</hibernate-mapping>
5、将对象映射文件加入到hibernate配置文件中。
6、编写获取单实例的SessionFactory的 类 HibernateUtil.java
package com.util;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;
public class HibernateUtil {
private static SessionFactory sessionFactory;
static {
try {
//加载类的时候获取sessionFactory
sessionFactory = new Configuration().configure().buildSessionFactory();
} catch(Exception e) {
e.printStackTrace();
}
}
public static Session getSession() {
return sessionFactory.openSession();
}
public static void closeSession(Session session) {
session.close();
}
}
7、编写 crud 的测试代码如下:
package com.test;
import java.util.Iterator;
import java.util.List;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;
import com.model.User;
import com.util.HibernateUtil;
public class HibernateTest {
public static void main(String[] args) {
User user = new User();
//user.setId(100);
user.setUsername("test4");
user.setPassword("test4");
save(user);
//queryAll();
//query("402880ea40478f420140478f46890001");
//deleteAll();
deleteAll2();
}
//插入
public static void save(User user) {
Session session = HibernateUtil.getSession();
Transaction tx = null;
try {
tx = session.beginTransaction();
String id = (String) session.save(user);
System.out.println(id);
tx.commit();
} catch (Exception e) {
if (tx!=null) tx.rollback();
e.printStackTrace();
} finally {
HibernateUtil.closeSession(session);
}
}
//遍历
public static void queryAll() {
Session session = HibernateUtil.getSession();
//User 是类名 而不是表名
Query query = session.createQuery("from User as u order by u.username asc");
List<User> list = query.list();
for(int i=0; i<list.size(); i++) {
User user = list.get(i);
System.out.print(user.getId() + "\t");
System.out.print(user.getUsername() + "\t");
System.out.println(user.getPassword());
}
}
//删除
public static void delete(String id) {
Session session = HibernateUtil.getSession();
Transaction tx = null;
try {
tx = session.beginTransaction();
User user = (User) session.get(User.class, id);
session.delete(user);
tx.commit();
} catch(Exception e) {
if (tx!=null) tx.rollback();
e.printStackTrace();
} finally {
HibernateUtil.closeSession(session);
}
}
//查询
public static void query(String id) {
Session session = HibernateUtil.getSession();
User user = (User)session.get(User.class, id);
System.out.println(user.getId());
System.out.println(user.getUsername());
System.out.println(user.getPassword());
HibernateUtil.closeSession(session);
}
//删除全部
public static void deleteAll() {
Session session = HibernateUtil.getSession();
Transaction tx = null;
try {
tx = session.beginTransaction();
Query query = session.createQuery("from User");
//按需加载 延迟加载 只返回id 然后根据需要再次查询,要求session 必须是打开的。
Iterator<User> iter = query.iterate();
while(iter.hasNext()) {
session.delete(iter.next());
}
tx.commit();
} catch(Exception e) {
if(null != tx) tx.rollback();
e.printStackTrace();
} finally {
HibernateUtil.closeSession(session);
}
}
//删除全部2
public static void deleteAll2() {
Session session = HibernateUtil.getSession();
Transaction tx = null;
try {
tx = session.beginTransaction();
Query query = session.createQuery("from User");
//返回全部的实体所有字段
List<User> list = (List<User>)query.list();
Iterator<User> iter = (Iterator<User>)list.iterator();
while(iter.hasNext()) {
session.delete(iter.next());
}
tx.commit();
} catch(Exception e) {
if(null != tx) tx.rollback();
e.printStackTrace();
} finally {
HibernateUtil.closeSession(session);
}
}
}