一:创建Hibernate的,如
Hibernate技术学习 https://www.itkc8.com
导入Hibernate的jar包
-hibernate-->lib-->required
-hibernate-->hiberate.jar
-hibernate-->lib-->jpa
-log4j
-mysql-connector
二:创建相应的业务对象(User)
/**
* @author HUXU
*
*/
public class User implements Serializable {
/**
*
*/
private static final long serialVersionUID = 1L;
/**
*
*/
private Integer id;
private Integer myid;
private String username;
private String password;
public Integer getId() {
省略set和get方法
三、创建Hibernate的配置文件
-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>
<!-- hibernate的方言,用来确定连接的数据库 -->
<property name="hibernate.dialect">org.hibernate.dialect.OracleDialect</property>
<!-- 数据库的连接类 -->
<property name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
<!-- 数据库的连接字符串和用户名密码 -->
<property name="hibernate.connection.url">jdbc:oracle:thin:@localhost:1521:orcl</property>
<property name="hibernate.connection.username">goddog</property>
<property name="hibernate.connection.password">goddog</property>
<!-- 在使用hibernate时会显示相应的SQL -->
<property name="show_sql">true</property>
<!-- 会自动完成类到数据表的转换 -->
<property name="hibernate.hbm2ddl.auto">update</property>
<!-- 加入实体类的映射文件 -->
<mapping resource="com/goddog/bean/User.hbm.xml"/>
</session-factory>
</hibernate-configuration>
四:为相应的业务对象创建hbm的配置文件,在这个文件中说明与数据库的映射关系,如果为User对象创建就在User对象所在的包中创建一个User.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">
<hibernate-mapping package="com.goddog.bean">
<class name="com.goddog.bean.User" table="t_user">
<id name="id">
<generator class="sequence">
<param name="sequence">user_seq</param>
</generator>
</id>
<property name="username"/>
<property name="password"/>
<property name="myid"/>
</class>
</hibernate-mapping>
五:创建HibernateUtil工具类
/**
*
*/
package com.goddog.util;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;
import org.hibernate.service.ServiceRegistry;
import org.hibernate.service.ServiceRegistryBuilder;
/**
* @author HUXU
*
*/
public class HibernateUtil {
private final static SessionFactory FACTORY = buildSessionFactory();
/**
*
*/
public HibernateUtil() {
// TODO Auto-generated constructor stub
}
//创建工厂
private static SessionFactory buildSessionFactory() {
// TODO Auto-generated method stub
Configuration cfg = new Configuration().configure();
//cfg.buildSessionFactory();
ServiceRegistry serviceRegistry = new ServiceRegistryBuilder().applySettings(cfg.getProperties()).buildServiceRegistry();
SessionFactory factory = cfg.buildSessionFactory(serviceRegistry);
return factory;
}
//得到工厂
public static SessionFactory getSessionFactory(){
return FACTORY;
}
//打开session
public static Session openSession(){
return FACTORY.openSession();
}
//关闭session
public static void close(Session session){
if(session != null) session.close();
}
}
六:创建TestCRUD测试类
/**
*
*/
package com.goddog.test;
import java.util.List;
import org.hibernate.HibernateException;
import org.hibernate.Session;
import com.goddog.bean.User;
import com.goddog.util.HibernateUtil;
import org.junit.Test;
/**
* @author HUXU
*
*/
public class TestCRUD {
//增
@Test
public void testAdd(){
Session session = null;
try{
session = HibernateUtil.openSession();//打开session
session.beginTransaction();//开启事务
User user = new User();
user.setMyid(0);
user.setUsername("cat");
user.setPassword("111");
session.save(user);//save
session.getTransaction().commit();//提交事务
}catch (HibernateException e) {
// TODO: handle exception
e.printStackTrace();
if(session != null) session.getTransaction().rollback();
}finally{
HibernateUtil.close(session);
}
}
//改
@Test
public void testUpdate(){
Session session = null;
try {
session = HibernateUtil.openSession();
session.beginTransaction();
User user = (User)session.load(User.class, 28);//先load
user.setUsername("gogo");
session.update(user);//update
session.getTransaction().commit();
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
if(session != null) session.getTransaction().rollback();
}finally{
HibernateUtil.close(session);
}
}
//删
@Test
public void testDelete(){
Session session = null;
try {
session = HibernateUtil.openSession();
session.beginTransaction();
User user = new User();
user.setId(1);//根据id删除
session.delete(user);
session.getTransaction().commit();
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
if(session != null) session.getTransaction().rollback();
}finally{
HibernateUtil.close(session);
}
}
//查
@Test
public void testLoad(){
Session session = null;
try {
session = HibernateUtil.openSession();
User user = (User)session.load(User.class, 1);//1为id
System.out.println(user);
} catch (Exception e) {
e.printStackTrace();
// TODO: handle exception
}finally{
HibernateUtil.close(session);
}
}
//list查询
@SuppressWarnings("unchecked")
@Test
public void testList(){
Session session = null;
try {
session = HibernateUtil.openSession();
List<User> users = session.createQuery("from User").list();
for(User u : users){
System.out.println(u);
}
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}finally{
HibernateUtil.close(session);
}
}
//分页查询
@SuppressWarnings("unchecked")
@Test
public void testPager(){
Session session = null;
try {
session = HibernateUtil.openSession();
List<User> users = session.createQuery("from User").setFirstResult(2).setMaxResults(3).list();
for(User u : users){
System.out.println(u);
}
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}finally{
HibernateUtil.close(session);
}
}
public TestCRUD() {
// TODO Auto-generated constructor stub
}
}
Hibernate技术学习 https://www.itkc8.com