SpringData【Spring整合Hibernate】

Spring整合Hibernate

1.建立maven項目

通過IDEA或者Eclipse建立一個簡單的maven工程(jar)即可

2.添加相關的依賴

在pom檔案中添加如下依賴

<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-context</artifactId>
    <version>4.3.21.RELEASE</version>
</dependency>
<dependency>
    <groupId>org.aspectj</groupId>
    <artifactId>aspectjweaver</artifactId>
    <version>1.6.8.RELEASE</version>
</dependency>
<dependency>
    <groupId>com.mchange</groupId>
    <artifactId>c3p0</artifactId>
    <version>0.9.5.3</version>
</dependency>
<dependency>
    <groupId>org.hibernate</groupId>
    <artifactId>hibernate-core</artifactId>
    <version>5.0.7.Final</version>
</dependency>
<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-orm</artifactId>
    <version>4.3.21.RELEASE</version>
</dependency>
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>5.1.32</version>
</dependency>
<dependency>
    <groupId>junit</groupId>
    <artifactId>junit</artifactId>
    <version>4.12</version>
</dependency>
<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-test</artifactId>
    <version>4.3.21.RELEASE</version>
</dependency>

3.添加對應的配置檔案

在resources目錄下建立spring的配置檔案和資料庫連接配接的屬性檔案，如下:

jdbc.properties檔案中的内容:

jdbc.url=jdbc:mysql://localhost:3306/ssm?characterEncoding=utf-8

jdbc.driver.class=com.mysql.jdbc.Driver

jdbc.username=root

jdbc.password=123456

applicationContext.xml内容:

<?xml version="1.0" encoding="UTF-8"?>

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context"
xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"
xsi:schemaLocation="http://www.springframework.org/schema/beans 
http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop.xsd
http://www.springframework.org/schema/tx 
http://www.springframework.org/schema/tx/spring-tx.xsd">

<!-- 配置讀取properties檔案的工具類 -->
<context:property-placeholder location="classpath:jdbc.properties"/>

<!-- 配置c3p0資料庫連接配接池 -->
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
    <property name="jdbcUrl" value="${jdbc.url}"/>
    <property name="driverClass" value="${jdbc.driver.class}"/>
    <property name="user" value="${jdbc.username}"/>
    <property name="password" value="${jdbc.password}"/>
</bean>

<!-- 配置Hibernate的SeesionFactory -->
<bean id="sessionFactory" class="org.springframework.orm.hibernate5.LocalSessionFactoryBean">
    <property name="dataSource" ref="dataSource"/>
    <!-- hibernateProperties屬性：配置與hibernate相關的内容，如顯示sql語句，開啟正向工程 -->
    <property name="hibernateProperties">
        <props>
            <!-- 顯示目前執行的sql語句 -->
            <prop key="hibernate.show_sql">true</prop>
            <!-- 開啟正向工程 -->
            <prop key="hibernate.hbm2ddl.auto">update</prop>
        </props>
    </property>
    <!-- 掃描實體所在的包 -->
    <property name="packagesToScan">
        <list>
            <value>com.dpb.pojo</value>
        </list>
    </property>
</bean>


<!-- 配置HiberanteTemplate對象 -->
<bean id="hibernateTemplate" class="org.springframework.orm.hibernate5.HibernateTemplate">
    <property name="sessionFactory" ref="sessionFactory"/>
</bean>
<!-- 配置Hibernate的事務管理器 -->
<bean id="transactionManager" class="org.springframework.orm.hibernate5.HibernateTransactionManager">
    <property name="sessionFactory" ref="sessionFactory"/>
</bean>

<!-- 配置開啟注解事務處理 -->
<tx:annotation-driven transaction-manager="transactionManager"/>

<!-- 配置springIOC的注解掃描 -->
<context:component-scan base-package="com.dpb"/>

4.建立pojo

資料的表結構請自行建立一張簡單的users表即可，就三個簡單的字段(userid,username,userage),pojo如下:

/**

@program: spring-hibernate
@description: Users的Pojo對象
@author: 波波烤鴨
@create: 2019-05-18 09:37

*/

@Entity

@Table(name="users")

public class Users implements Serializable {

@Id
@GeneratedValue(strategy= GenerationType.IDENTITY)//strategy=GenerationType.IDENTITY 自增長
@Column(name="userid")
private Integer userid;

@Column(name="username")
private String username;

@Column(name="userage")
private Integer userage;

public Integer getUserid() {
    return userid;
}

public void setUserid(Integer userid) {
    this.userid = userid;
}

public String getUsername() {
    return username;
}

public void setUsername(String username) {
    this.username = username;
}

public Integer getUserage() {
    return userage;
}

public void setUserage(Integer userage) {
    this.userage = userage;
}

@Override
public String toString() {
    return "Users [userid=" + userid + ", username=" + username + ", userage=" + userage + "]";
}

}

5.建立持久層的接口和實作

建立持久層的Dao接口和實作類，具體如下:

定義接口中的方法

public interface UserDao {

void insertUsers(Users users);

void updateUsers(Users users);

void deleteUsers(Users users);

Users selectUsersById(Integer userid);

List<Users> selectUserByName(String username);

List<Users> selectUserByNameUseSQL(String username);

List<Users> selectUserByNameUseCriteria(String username);

實作類----注意導入的jar包

import com.dpb.dao.UserDao;

import com.dpb.pojo.Users;

import org.hibernate.Criteria;

import org.hibernate.Query;

import org.hibernate.Session;

import org.hibernate.criterion.Restrictions;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.orm.hibernate5.HibernateTemplate;

import org.springframework.stereotype.Repository;

import java.util.List;

@description: 使用者持久層的實作類
@create: 2019-05-18 09:43

@Repository

public class UserDaoImpl implements UserDao {

@Autowired
private HibernateTemplate hibernateTemplate;

@Override
public void insertUsers(Users users) {
    this.hibernateTemplate.save(users);
}

@Override
public void updateUsers(Users users) {
    this.hibernateTemplate.update(users);

}

@Override
public void deleteUsers(Users users) {
    this.hibernateTemplate.delete(users);

}

@Override
public Users selectUsersById(Integer userid) {
    return this.hibernateTemplate.get(Users.class, userid);
}

/**
 * HQL 使用
 * @param username
 * @return
 */
@Override
public List<Users> selectUserByName(String username) {
    //getCurrentSession:目前session必須要有事務邊界，且隻能處理唯一的一個事務。當事務送出或者復原後session自動失效
    //openSession:每次都會打開一個新的session.加入每次使用多次。則獲得的是不同session對象。使用完畢後我們需要手動的調用colse方法關閉session
    Session session = this.hibernateTemplate.getSessionFactory().getCurrentSession();
    //sql:select * from t_users where username =
    Query query = session.createQuery(" from Users where username = :abc");
    Query queryTemp = query.setString("abc",username);
    return queryTemp.list();
}

/**
 * SQL 的使用
 * @param username
 * @return
 */
@Override
public List<Users> selectUserByNameUseSQL(String username) {
    Session session = this.hibernateTemplate.getSessionFactory().getCurrentSession();
    Query query = session.createSQLQuery("select * from t_users where username = ?").addEntity(Users.class).setString(0, username);
    return query.list();
}

/**
 *  Criteria
 * @param username
 * @return
 */
@Override
public List<Users> selectUserByNameUseCriteria(String username) {
    Session session = this.hibernateTemplate.getSessionFactory().getCurrentSession();
    //sql:select * from t_users where username = 張三
    Criteria c = session.createCriteria(Users.class);
    c.add(Restrictions.eq("username", username));
    return c.list();
}

6.單元測試

在test目錄下建立單元測試類，測試相關的操作

@description: 單元測試
@create: 2019-05-18 09:48

@RunWith(SpringJUnit4ClassRunner.class)

@ContextConfiguration("classpath:applicationContext.xml")

public class TestDemo {

@Autowired
private UserDao usersDao;

/**
 * 添加使用者
 */
@Test
@Transactional// 在測試類對于事務送出方式預設的是復原。
@Rollback(false)//取消自動復原
public void testInsertUsers(){
    Users users = new Users();
    users.setUserage(20);
    users.setUsername("張三");
    this.usersDao.insertUsers(users);
}

/**
 * 更新使用者
 */
@Test
@Transactional
@Rollback(false)
public void testUpdateUsers(){
    Users users = new Users();
    users.setUserid(2);
    users.setUserage(22);
    users.setUsername("李四");
    this.usersDao.updateUsers(users);
}

/**
 * 根據userid查詢使用者
 */
@Test
public void testSelectUsersById(){
    Users users = this.usersDao.selectUsersById(2);
    System.out.println(users);
}

/**
 * 删除使用者
 */
@Test
@Transactional
@Rollback(false)
public void testDeleteUsers(){
    Users users = new Users();
    users.setUserid(2);
    this.usersDao.deleteUsers(users);
}

/**
 * HQL測試
 */
@Test
@Transactional
public void testSelectUserByName(){
    List<Users> list = this.usersDao.selectUserByName("張三");
    for (Users users : list) {
        System.out.println(users);
    }
}

/**
 * SQL測試
 */
@Test
@Transactional
public void testSelectUserByNameUseSQL(){
    List<Users> list = this.usersDao.selectUserByNameUseSQL("張三");
    for (Users users : list) {
        System.out.println(users);
    }
}

/**
 * Criteria測試
 */
@Test
@Transactional
public void testSelectUserByNameUseCriteria(){
    List<Users> list = this.usersDao.selectUserByNameUseCriteria("張三");
    for (Users users : list) {
        System.out.println(users);
    }
}

作者：波波烤鴨

來源：CSDN

原文：

https://blog.csdn.net/qq_38526573/article/details/90312221

SpringData【Spring整合Hibernate】

繼續閱讀

Java小案例——随機數猜測随機數猜測

nginx location中斜線的位置的重要性

27 Best Free Eclipse Plug-ins for Java Developer to be ProductiveCode Quality PluginsText Editor PluginsDependency ManagementVersion Control Integration PluginsFramework Development Continuous Integration Related PluginsOther Utility Plugins

Java String.format方法的簡單使用

neo4j之cypher使用文檔

GitHub連夜封殺！這份阿裡 10W 字内部 Java 字面試手冊到底有多強？

spark/scala關于【資源檔案】加載方法概述外部檔案加載方案測試資源檔案打包入jar包中小結

mybatis_入門程式Mybatis入門

AOP程式設計_Android優雅權限架構(1)概念基礎，2021金三銀四前言正文大綱正文

sqlServer根據經緯查距離

Effective Java 8:通用程式設計

OOM三種類型

工廠模式-三種類型

【遞歸】高效率求2的n次幂

win10本地scala和spark安裝安裝scala安裝spark

scala (3) Function 和 Method