Spring框架-sixteen(Hibernate的基本用法)

柔光的暖阳◎ 2022-03-09 00:36 148阅读 0赞

## 16-【熟悉】Hibernate的基本用法 ##

**1.创建项目**  
![在这里插入图片描述][20190311214938448.png]  
2.导包  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0MDEzNzkw_size_16_color_FFFFFF_t_70]  
3.创建Person  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0MDEzNzkw_size_16_color_FFFFFF_t_70 1]  
**4.创建Person.hbm.xml**

<?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 package="com.sxt.entity">
    	<class name="Person" table="sys_person">
    		<id name="id" column="id" type="java.lang.Integer">
    			<type name="identity"></type>
    		</id>
    		<property name="name" column="name" type="java.lang.String" ></property>
    		<property name="address" type="java.lang.String">
    			<column name="address" ></column>
    		</property>
    	</class>
    </hibernate-mapping>

**5.创建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.driver_class">com.mysql.jdbc.Driver</property>
    		<property name="connection.url">jdbc:mysql://localhost:3306/test</property>
    		<property name="connection.username">root</property>
    		<property name="connection.password">123456</property>
    		
    		
    		<property name="dialect">org.hibernate.dialect.MySQLDialect</property>
    		
    		
    		<property name="hbm2ddl.auto">update</property>
    		
    		<property name="show_sql">true</property>
    		
    		<property name="format_sql">true</property>
    		
    		<mapping resource="com/sxt/entity/Person.hbm.xml"/>
    		
    	</session-factory>
    </hibernate-configuration>

6.创建PersonDao  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0MDEzNzkw_size_16_color_FFFFFF_t_70 2]

**7.创建HibernateUtils**

public class HibernateUtils {
        
    
    	// 读取配置文件
    	static Configuration cfg = new Configuration().configure();
    	// 创建注册对象
    	static ServiceRegistry registry = new StandardServiceRegistryBuilder()
    			.applySettings(cfg.getProperties()).build();
    	// 创建session工厂
    	// 创建工厂对象
    	static SessionFactory factory = cfg.buildSessionFactory(registry);
    	
    	
    	/**
    	 * 得到session
    	 * @return
    	 */
    	public static Session getSession(){
        
    		return factory.openSession();
    	}
    	
    	/**
    	 * 关闭session
    	 */
    	public static void close(Session session){
        
    		session.close();
    	}
    
    }

**8.创建PersonDaoImpl**

public class PersonDaoImpl implements PersonDao {
        
    
    	@Override
    	public void add(Person person) {
        
    		// 从sessionFactory里面得到session
    		Session session = HibernateUtils.getSession();
    		// 开启事务
    		Transaction transaction = session.beginTransaction();
    		// 调用API保存
    		session.save(person);
    		// 提交事务
    		transaction.commit();
    		// 关闭sesison
    		HibernateUtils.close(session);
    	}
    
    	@Override
    	public void update(Person person) {
        
    		// 从sessionFactory里面得到session
    		Session session = HibernateUtils.getSession();
    		// 开启事务
    		Transaction transaction = session.beginTransaction();
    		// 调用API保存
    		session.update(person);
    		// 提交事务
    		transaction.commit();
    		// 关闭sesison
    		HibernateUtils.close(session);
    	}
    
    	@Override
    	public void delete(Person person) {
        
    		// 从sessionFactory里面得到session
    		Session session = HibernateUtils.getSession();
    		// 开启事务
    		Transaction transaction = session.beginTransaction();
    		// 调用API保存
    		session.delete(person);
    		// 提交事务
    		transaction.commit();
    		// 关闭sesison
    		HibernateUtils.close(session);
    	}
    
    	@Override
    	public List<Person> queryAll() {
        
    		// 从sessionFactory里面得到session
    		Session session = HibernateUtils.getSession();
    		// 开启事务
    		Transaction transaction = session.beginTransaction();
    		// 调用AIP查询
    		Query createQuery = session.createQuery("from Person");
    		List<Person> list = createQuery.list();
    		// 提交事务
    		transaction.commit();
    		// 关闭sesison
    		HibernateUtils.close(session);
    		return list;
    	}
    
    	@Override
    	public Person queryById(Integer id) {
        
    		// 从sessionFactory里面得到session
    		Session session = HibernateUtils.getSession();
    		// 调用AIP查询
    		Person person =(Person) session.load(Person.class, id);
    		System.out.println(person);
    		// 关闭sesison
    		HibernateUtils.close(session);
    		return null;
    	}
    
    }

9.测试  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0MDEzNzkw_size_16_color_FFFFFF_t_70 3]

**10.Hibernate和mybatis的本质区别**

Hibernate 是把类和属性和数据库的字段进行映射  
mybatis 是把类的属性和查询的结果集映射

create table sys\_user()\{  
id int primary key auto\_increment,  
name varchar(20) not null,  
address varchar(60) not null  
\}

查询  
mybatis select id as uid,name as uname,address as uaddress from sys\_user  
hibernate from User

Hibernate 完全面向对象 不用写SQL HQL 多表连接查询很麻烦  
mybatis是半自动化的 ，要写sql 更加灵活 多表连接查询很简单

[20190311214938448.png]: /images/20220309/d20af041f96048adb550013edbcd307c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0MDEzNzkw_size_16_color_FFFFFF_t_70]: /images/20220309/393d1a5ef05b4855928b74a78fa59768.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0MDEzNzkw_size_16_color_FFFFFF_t_70 1]: /images/20220309/f17467fa2b014a6db572b7a27fa46ae2.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0MDEzNzkw_size_16_color_FFFFFF_t_70 2]: /images/20220309/d6dd16139e2c4f9e9d69140435ca7cbe.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0MDEzNzkw_size_16_color_FFFFFF_t_70 3]: /images/20220309/fa8b52be2a534522a1dd0a1e9cd5f48b.png