1.配置文件設(shè)置
spring.jpa.properties.hibernate.current_session_context_class = org.springframework.orm.hibernate5.SpringSessionContext
2.創(chuàng)建hibernate sessionFactory config
import org.springframework.boot.autoconfigure.EnableAutoConfiguration;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.transaction.annotation.EnableTransactionManagement;
import javax.persistence.EntityManagerFactory;
@Configuration
@EnableAutoConfiguration
@EnableTransactionManagement
public class HibernateAutoConfiguration {
@Bean
public SessionFactory sessionFactory(EntityManagerFactory factory) {
if (factory.unwrap(SessionFactory.class) == null) {
throw new NullPointerException("factory is not a hibernate factory");
}
return factory.unwrap(SessionFactory.class);
}
}
3.創(chuàng)建dao接口
public interface DemoDao {
List selectBySql(String sql);
}
4.實(shí)現(xiàn)dao
@Repository
public class DemoDaoImpl implements DemoDao {
@Resource(name = "sessionFactory")
private SessionFactory sessionFactory;
@Override
public List selectBySql(String sql) {
Session currentSession = sessionFactory.getCurrentSession();
Query query = currentSession.createSQLQuery(sql);
return query.list();
}
}
這樣就能在springboot中運(yùn)行原生sql語句了
