框架hibernate的使用（数据库增删改查、hql）

最新推荐文章于 2021-10-20 16:47:31 发布

伊人冰

最新推荐文章于 2021-10-20 16:47:31 发布

阅读量749

点赞数

分类专栏：框架

本文链接：https://blog.csdn.net/sxb956347789/article/details/54291923

版权

框架专栏收录该内容

9 篇文章 0 订阅

订阅专栏

运用hibernate lib需要的包。

model层User类如下:

package cn.scxh.hibernate.model;

import java.util.Date;

public class User {
	private int id;
	private String name;
	private String passWord;
	private Date birthday;
	
	public User() {
		
	}

	public User(int id, String name, String passWord, Date birthday) {
	
		this.id = id;
		this.name = name;
		this.passWord = passWord;
		this.birthday = birthday;
	}
	
	
	public User(String name, String passWord) {
		this.name = name;
		this.passWord = passWord;
	}

	@Override
	public String toString() {
		return "User [id=" + id + ", name=" + name + ", passWord=" + passWord
				+ ", birthday=" + birthday + "]";
	}
	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 getPassWord() {
		return passWord;
	}
	public void setPassWord(String passWord) {
		this.passWord = passWord;
	}

	public Date getBirthday() {
		return birthday;
	}

	public void setBirthday(Date birthday) {
		this.birthday = birthday;
	}
		
}

User.hbm.xml(和User在同一包中)如下:

<?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 2017-1-6 16:34:38 by Hibernate Tools 3.5.0.Final -->
<hibernate-mapping>
    <class name="cn.scxh.hibernate.model.User" table="USER">
        <id name="id" type="int">
            <column name="ID" />
             <!-- 自动生成主键  increment  identity  sequence;  native根据底层数据自动选择相应生成策略 -->
			<!-- assigned 根据java代码生成 -->
            <generator class="native" />
        </id>
        <property name="name" type="java.lang.String">
            <column name="NAME" />
        </property>
        <property name="passWord" type="java.lang.String">
            <column name="PASSWORD" />
        </property>
       <!-- date (日期)  time(时间)  timestamp(日期时间)=java.util.Date   -->
        <property name="birthday" type="java.util.Date">
            <column name="BIRTHDAY" />
        </property>
    </class>
</hibernate-mapping>

hibernate.cfg.xml（和model层包属于同一级)

<?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 2017-1-6 16:34:38 by Hibernate Tools 3.5.0.Final -->
<hibernate-mapping>
    <class name="cn.scxh.hibernate.model.User" table="USER">
        <id name="id" type="int">
            <column name="ID" />
             <!-- 自动生成主键  increment  identity  sequence;  native根据底层数据自动选择相应生成策略 -->
			<!-- assigned 根据java代码生成 -->
            <generator class="native" />
        </id>
        <property name="name" type="java.lang.String">
            <column name="NAME" />
        </property>
        <property name="passWord" type="java.lang.String">
            <column name="PASSWORD" />
        </property>
       <!-- date (日期)  time(时间)  timestamp(日期时间)=java.util.Date   -->
        <property name="birthday" type="java.util.Date">
            <column name="BIRTHDAY" />
        </property>
    </class>
</hibernate-mapping>

UserTest类如下:

package cn.scxh.hibernate.model;

import java.util.List;

import org.hibernate.Query;
import org.hibernate.SQLQuery;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.boot.registry.StandardServiceRegistryBuilder;
import org.hibernate.cfg.Configuration;
import org.hibernate.service.ServiceRegistry;
import org.junit.After;
import org.junit.Before;
import org.junit.Test;

public class UserTest {
	SessionFactory sessionFactory;
	Transaction transaction;
	Session session;
	@Before
	public void setUp() throws Exception {
		// 读取hibernate.cfg.xml文件
		Configuration config = new Configuration().configure();
		ServiceRegistry serviceRegistry = new StandardServiceRegistryBuilder().applySettings(config.getProperties())
						.build();
				// 建立SessionFactory
		sessionFactory = config.buildSessionFactory(serviceRegistry);
//		session = sessionFactory.openSession();
		session = sessionFactory.getCurrentSession();
		transaction = session.beginTransaction();
	}

	@After
	public void tearDown() throws Exception {
		transaction.commit();
//		session.close();
//		sessionFactory.close();
	}
/**
 * 运用sql语句实现查询
 */
	@Test
	public void test() {
//		User user = new User(7,"6","test",new Date());
//		session.save(user);
//		session.delete(user);
		String sql = "select * from user where name = 1";
		SQLQuery sqlQuery = session.createSQLQuery(sql).addEntity(User.class);
		List<User> list =sqlQuery.list();//java.util包
		for(User user : list){
			System.out.println(user);
		}
	}
	@Test
	public void testSelectAllUser(){
		String sql = "select * from user";
		SQLQuery sqlQuery = session.createSQLQuery(sql).addEntity(User.class);
		List<User> list =sqlQuery.list();//java.util包
		for(User user : list){
			System.out.println(user);
		}
	}
	/**
	 * 用hql实现查询 
	 * org.hibernate.hql.internal.ast.QuerySyntaxException: user is not mapped [from user]
	 * user不应该是表单而是User类
	 */
	@Test
	public void testSelectAllUserByHql(){
		String hsql = "from User";
		Query query = session.createQuery(hsql);
		List<User> list =query.list();
		for(User user : list){
			System.out.println(user);
		}
	}
	/**
	 * 查询用户个数
	 * java.lang.ClassCastException: java.lang.Long cannot be cast to java.lang.Integer
	 * 格式转换异常:此处应该用Long型
	 */
	@Test
	public void testSelectNumUser(){
		String hql ="select count(*) from User";
		Query query = session.createQuery(hql);
		long num = (long) query.uniqueResult();//如果查询结果唯一用 uniqueResult
		System.out.println(num);
	}
	/**
	 * 查找指定属性记录
	 * 1.创建包含查询属性构造方法
	 * 2.若查询结果唯一，用uniqueResult()，有多条结果，用list()
	 */
	@Test
	public void testSelectActionById(){
		//如果只查询一部分属性，需要写一个需要查询的构造方法
		String hql = "select new User(u.name,u.passWord) from User as u where u.id=:num";
		Query query = session.createQuery(hql);
		query.setParameter("num", 5);
		User user = (User) query.uniqueResult();
		System.out.println(user);
	}
}

hibernate.cfg.xml（和model层包属于同一级)

<?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="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
		<!-- 设置数据库URL -->
		<property name="hibernate.connection.url">jdbc:mysql://192.168.5.7:3306/hibernate</property>
		<!-- 数据库用户名 -->
		<property name="hibernate.connection.username">test</property>
		<!-- 数据库密码 -->
		<property name="hibernate.connection.password">123321</property>
		<!-- 指定对应数据库的方言，hibernate为了更好适配各种关系数据库，针对每种数据库都指定了一个方言dialect -->
		<property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
		<!-- 指定ddl的生成方式 第一次用create创建表,第二次用update修改 -->
		<property name="hibernate.hbm2ddl.auto">update</property>
		<!-- 输出sql语句 -->
		<property name="hibernate.show_sql">true</property>
		<!-- 格式化输出sql语句 -->
		<property name="hibernate.format_sql">true</property>
		<!-- 配置CurrentSessionContext 使用getCurrentSession()获取Session实例时 -->
		<property name="hibernate.current_session_context_class">thread</property>
		<!-- 映射文件 -->
		<mapping resource="cn/scxh/hibernate/model/User.hbm.xml" />
	</session-factory>
</hibernate-configuration>