
(1)pom中添加相关依赖
<dependency>
<groupId>org.hibernate</groupId>
<artifactId>hibernate-core</artifactId>
<version>5.4.0.Final</version>
</dependency> <dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-orm</artifactId>
<version>4.3.22.RELEASE</version>
</dependency>
(2)声明数据源(Druid),声明Hibernate的Session工厂,声明Hibernate的事务管理器
package cn.coreqi.config; import com.alibaba.druid.pool.DruidDataSource;
import org.hibernate.SessionFactory;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.orm.hibernate5.HibernateTransactionManager;
import org.springframework.orm.hibernate5.LocalSessionFactoryBean;
import org.springframework.transaction.annotation.EnableTransactionManagement; import javax.sql.DataSource;
import java.util.Properties;
@EnableTransactionManagement
@Configuration
public class JdbcConfig {
@Bean
public DataSource dataSource(){
DruidDataSource ds = new DruidDataSource();
ds.setDriverClassName("com.mysql.jdbc.Driver");
ds.setUrl("jdbc:mysql://localhost:3306/hibernatedemo?serverTimezone=UTC");
ds.setUsername("root");
ds.setPassword("123456");
return ds;
} @Bean
public LocalSessionFactoryBean sessionFactory(DataSource dataSource){
LocalSessionFactoryBean sessionFactoryBean = new LocalSessionFactoryBean();
sessionFactoryBean.setDataSource(dataSource);
sessionFactoryBean.setPackagesToScan(new String[]{"cn.coreqi.entities"});
Properties props = new Properties();
props.setProperty("dialect","org.hibernate.dialect.MySQL8Dialect");
props.setProperty("show_sql","true");
props.setProperty("format_sql","true");
props.setProperty("hbm2ddl.auto","update");
return sessionFactoryBean;
}
@Bean
public HibernateTransactionManager transactionManager(SessionFactory sessionFactory){
return new HibernateTransactionManager(sessionFactory);
}
}
(3)编写dao
package cn.coreqi.dao.SpringHibernate; import cn.coreqi.entities.Users;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.query.Query;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Repository;
import org.springframework.transaction.annotation.Transactional; import javax.persistence.criteria.CriteriaBuilder;
import javax.persistence.criteria.CriteriaQuery;
import javax.persistence.criteria.Root;
import java.util.List; @Repository
@Transactional
public class UsersSpringHibernate {
@Autowired
private SessionFactory sessionFactory; private Session currentSession(){
return sessionFactory.getCurrentSession();
} public int count(){
return getAll().size();
} public Users getUserByUserName(String username){
CriteriaBuilder builder = currentSession().getCriteriaBuilder();
CriteriaQuery<Users> query = builder.createQuery(Users.class);
Root<Users> root = query.from(Users.class);
query.select(root).where(builder.equal(root.get("UserName"),username));
Query<Users> q = currentSession().createQuery(query);
return q.getSingleResult();
} public List<Users> getAll(){
CriteriaBuilder builder = currentSession().getCriteriaBuilder();
CriteriaQuery<Users> query = builder.createQuery(Users.class);
Root<Users> root = query.from(Users.class);
query.select(root);
Query<Users> q=currentSession().createQuery(query);
List<Users> users=q.getResultList();
return users;
}
public Users getUserById(Integer id){
return (Users)currentSession().get(Users.class,id);
}
}
Hibernate5和Hibernate4有些区别,具体的dao编写方式请参考这篇文章 https://www.boraji.com/hibernate-5-criteria-query-example