Spring如何整合Hibernate？
1、准备数据库
#创建数据库
CREATE SCHEMA `springdata`
CHARSET utf8
COLLATE utf8_general_ci;
#使用数据库
USE `springdata`;
2、创建项目
此处创建Maven项目来进行Spring整合Hibernate的学习
添加jdbc.properties、applicationContext.xml配置文件
3、导入Spring整合Hibernate所需的依赖
4、配置jdbc.properties
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3308/springdata?useSSL=true&\
useUnicode=true&characterEncoding=UTF-8
jdbc.user=root
jdbc.password=你的数据库用户密码
5、编写Spring整合hibernate的配置文件application.xml
6、创建实体类User
package site.hclz.springdata.pojo;
import javax.persistence.*;
import java.io.Serializable;
@Entity
@Table(name = "t_user")
public class User implements Serializable {
@Id@Column(name = "u_id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer userId;
@Basic@Column(name = "u_name")
private String userName;
@Basic@Column(name = "u_age")
private Integer userAge;
@Basic@Column(name = "u_address")
private String userAddress;
public User(){}
public User(Integer userId, String userName, Integer userAge, String userAddress) {
this.userId = userId;
this.userName = userName;
this.userAge = userAge;
this.userAddress = userAddress;
}
//省略getter/setter方法 toString方法
}
7、UserDao接口
package site.hclz.springdata.dao;
import site.hclz.springdata.pojo.User;
import java.util.List;
public interface UserDao {
//增加
Integer insertUser(User user);
//删除
void deleteUser(Integer userId);
//修改
void updateUser(User user);
//查询
User selectUserById(Integer userId);
//HQL带条件查询
List<User> selectUserListByAddressUseHQL(String address);
//SQL带条件查询
List<User> selectUserListByAddressUseSQL(String address);
//QBC带条件查询（hibernate5.2中已过时，推荐使用jpaCriteria）
List<User> selectUserListByAddressUseQBC(String address);
}
8、接口实现类UserDaoImpl
package site.hclz.springdata.dao.imp;
import org.hibernate.Criteria;
import org.hibernate.Session;
import org.hibernate.criterion.Restrictions;
import org.hibernate.query.NativeQuery;
import org.hibernate.query.Query;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.orm.hibernate5.HibernateTemplate;
import org.springframework.stereotype.Repository;
import site.hclz.springdata.dao.UserDao;
import site.hclz.springdata.pojo.User;
import java.util.List;
@Repository("userDao")
public class UserDaoImpl implements UserDao {
@Autowired
private HibernateTemplate hibernateTemplate;
@Override
public Integer insertUser(User user) {
return (Integer) hibernateTemplate.save(user);
}
@Override
public void deleteUser(Integer userId) {
hibernateTemplate.delete(hibernateTemplate.get(User.class,userId));
}
@Override
public void updateUser(User user) {
hibernateTemplate.update(user);
}
@Override
public User selectUserById(Integer userId) {
return hibernateTemplate.get(User.class,userId);
}
@Override
public List<User> selectUserListByAddressUseHQL(String address) {
Session session = hibernateTemplate.getSessionFactory().getCurrentSession();
Query<User> query = session.createQuery(
"from User where userAddress=:addr",
User.class).setParameter("addr", address);
return query.list();
}
@Override
@SuppressWarnings("unchecked")
public List<User> selectUserListByAddressUseSQL(String address) {
Session session = hibernateTemplate.getSessionFactory().getCurrentSession();
NativeQuery nativeQuery = session.createSQLQuery(
"SELECT * FROM springdata.t_user WHERE u_address=:addr")
.addEntity(User.class)
.setParameter("addr",address);
return nativeQuery.list();
}
@Override
@SuppressWarnings("unchecked")
public List<User> selectUserListByAddressUseQBC(String address) {
Session session = hibernateTemplate.getSessionFactory().getCurrentSession();
//@deprecated (since 5.2) for Session, use the JPA Criteria
Criteria criteria = session.createCriteria(User.class);
criteria.add(Restrictions.eq("userAddress",address));
return criteria.list();
}
}
9、编写测试类测试Spring整合Hibernate
