Spring5：整合Hibernate(xml配置方式，问题和错误)

1.声明

当前内容主要为复习使用当前的Spring5整合Hibernate5的操作，并发现其中的问题

当前出现的问题：

Could not obtain transaction-synchronized Session for current thread（当前执行的hibernate的session中没有事务支持）
1. 需要创建Hibernate的事务管理器<tx:advice>
2. 需要添加aop-config的配置并未当前的执行的sql的方法动态织入事务
Legacy-style query parameters (?) are no longer supported; use JPA-style ordinal parameters (e.g.,?1) instead : from com.hy.java.spring.database.hibernate.entity.User u where u.name=? [from com.hy.java.spring.database.hibernate.entity.User u where u.name=?](当前执行的sql中使用？已经被废弃，更换为?参数下标)

2.当前的pom依赖

<properties>
		<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
		<project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
		<java.version>1.8</java.version>
		<!-- <spring.version>5.1.5.RELEASE</spring.version> -->
		<!-- 用于5.3.0版本用于测试当前的r2dbc -->
		<spring.version>5.3.0</spring.version>
	</properties>
	<dependencies>

		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<version>6.0.6</version>
		</dependency>

		<!-- https://mvnrepository.com/artifact/org.apache.commons/commons-dbcp2 -->
		<!-- <dependency> 这个是最近新建立的2020都在更新 <groupId>org.apache.commons</groupId> 
			<artifactId>commons-dbcp2</artifactId> <version>2.1.1</version> </dependency> -->
		<!-- https://mvnrepository.com/artifact/commons-dbcp/commons-dbcp -->
		<dependency>
			<groupId>commons-dbcp</groupId>
			<artifactId>commons-dbcp</artifactId>
			<version>1.4</version>
		</dependency>

		<!-- 导入最基本的spring-core -->
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-core</artifactId>
			<version>${spring.version}</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-beans</artifactId>
			<version>${spring.version}</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-context</artifactId>
			<version>${spring.version}</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-jdbc</artifactId>
			<version>${spring.version}</version>
		</dependency>
		<!-- https://mvnrepository.com/artifact/org.springframework/spring-orm，其中包含了jpa和hibernate -->
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-orm</artifactId>
			<version>${spring.version}</version>
		</dependency>
		<!-- https://mvnrepository.com/artifact/org.aspectj/aspectjweaver -->
		<dependency>
			<groupId>org.aspectj</groupId>
			<artifactId>aspectjweaver</artifactId>
			<version>1.9.6</version>
		</dependency>
		
		<!-- 配置Hibernate -->
		<!-- https://mvnrepository.com/artifact/org.hibernate/hibernate-core -->
		<dependency>
		    <groupId>org.hibernate</groupId>
		    <artifactId>hibernate-core</artifactId>
		    <version>5.4.3.Final</version>
		</dependency>

	</dependencies>

3.当前的demo

当前的applicationContext.xml配置文件

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns:aop="http://www.springframework.org/schema/aop"
    xmlns:context="http://www.springframework.org/schema/context"
    xmlns:tx="http://www.springframework.org/schema/tx"
    xsi:schemaLocation="
        http://www.springframework.org/schema/beans
        https://www.springframework.org/schema/beans/spring-beans.xsd
        http://www.springframework.org/schema/tx
        https://www.springframework.org/schema/tx/spring-tx.xsd
        http://www.springframework.org/schema/aop
        https://www.springframework.org/schema/aop/spring-aop.xsd
        http://www.springframework.org/schema/context
        https://www.springframework.org/schema/context/spring-context.xsd">
	
	<context:property-placeholder location="classpath:/com/hy/java/spring/database/hibernate/db.properties"/>
    <!-- SessionFactory, DataSource, etc. omitted -->
	<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
        <property name="driverClassName" value="${jdbc.driverClassName}"/>
        <property name="url" value="${jdbc.url}"/>
        <property name="username" value="${jdbc.username}"/>
        <property name="password" value="${jdbc.password}"/>
    </bean>

    <bean id="sessionFactory" class="org.springframework.orm.hibernate5.LocalSessionFactoryBean">
        <property name="dataSource" ref="dataSource"/>
        <!-- 扫描包 -->
        <property name="packagesToScan" value="com.hy.java.spring.database.hibernate.entity"></property>
        <property name="mappingResources">
            <list>
                <value>/com/hy/java/spring/database/hibernate/entity/User.hbm.xml</value>
            </list>
        </property>
        <property name="hibernateProperties">
           <!-- 配置hibernate的方言 -->
	    	<!-- 配置打印sql -->
	    	<!-- 配置格式化sql -->
	    	<props>
	    		<prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
	    		<prop key="hibernate.show_sql">true</prop>
	    		<prop key="hibernate.format_sql">true</prop>
	    	</props>
        </property>
    </bean>

    <bean id="userService" class="com.hy.java.spring.database.hibernate.service.UserService">
        <property name="sessionFactory" ref="sessionFactory"/>
    </bean>
    
    <bean id="txManager"
            class="org.springframework.orm.hibernate5.HibernateTransactionManager">
        <property name="sessionFactory" ref="sessionFactory"/>
    </bean>
    
    <tx:advice transaction-manager="txManager" id="txAdvice">
		<tx:attributes>
			<!-- 以update、insert、delete开头的需要事务 -->
			<tx:method name=""/>
			<tx:method name="update*" propagation="REQUIRED" rollback-for="java.lang.Exception"/>
			<tx:method name="insert*" propagation="REQUIRED" rollback-for="java.lang.Exception"/>
			<tx:method name="delete*" propagation="REQUIRED" rollback-for="java.lang.Exception"/>
			<tx:method name="get*" propagation="SUPPORTS" read-only="true"  />
			<tx:method name="select*"  propagation="SUPPORTS"  read-only="true" />
		</tx:attributes>
	</tx:advice>
	<!-- 用于控制事务织入方式 -->
	<aop:config>
        <aop:pointcut expression="execution(* com.hy.java.spring.database.hibernate.service.*.*(..))" id="txPointcut"/>
        <aop:advisor advice-ref="txAdvice" pointcut-ref="txPointcut"/>
    </aop:config>
</beans>

db.properties文件

jdbc.driverClassName=com.mysql.cj.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/test?useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=UTC
jdbc.username=root
jdbc.password=root

实体类User.java

public class User {
	private int id;
	private String name;
	//省略get、set、toString方法
}

User.hbm.xml配置文件

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
      "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
          "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping package="com.hy.java.spring.database.hibernate.entity">
   <class name="User" table="User">
      <meta attribute="class-description">
         This class User the User detail. 
      </meta>
      
      <id name="id" type="int" column="id">
         <generator class="native"/>
      </id>
      <property name="name" column="name" type="string"/>
   </class>
</hibernate-mapping>

UserService.java


public class UserService {
	private SessionFactory sessionFactory;

	public void setSessionFactory(SessionFactory sessionFactory) {
		this.sessionFactory = sessionFactory;
	}

	// 使用当前的实体查询方式
	public List getUserByUserName(String name) {	
		return this.sessionFactory.getCurrentSession().createQuery("from User u where u.name=?0")
				.setParameter(0, name).list();
	}
	
	// 使用原生的sql查询方式
	public List<User> getAllUsers() {	
		return this.sessionFactory.getCurrentSession()
				.createSQLQuery("select * from user").addEntity(User.class).list();
	}
}

测试类

public class HibernateTest {
	public static void main(String[] args) {
		String xml = "/com/hy/java/spring/database/hibernate/applicationContext.xml";
		ApplicationContext context = new ClassPathXmlApplicationContext(xml);
		UserService userService = context.getBean("userService", UserService.class);
		Collection loadUserByUserName = userService.getUserByUserName("admin");
		System.out.println(loadUserByUserName);
		List<User> allUsers = userService.getAllUsers();
		System.out.println(allUsers);
	}
}

当前执行结果：

SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
SLF4J: Defaulting to no-operation (NOP) logger implementation
SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.
二月 16, 2021 10:19:40 上午 org.hibernate.Version logVersion
INFO: HHH000412: Hibernate Core {5.4.3.Final}
二月 16, 2021 10:19:41 上午 org.hibernate.boot.jaxb.internal.stax.LocalXmlResourceResolver resolveEntity
WARN: HHH90000012: Recognized obsolete hibernate namespace http://hibernate.sourceforge.net/hibernate-mapping. Use namespace http://www.hibernate.org/dtd/hibernate-mapping instead.  Support for obsolete DTD/XSD namespaces may be removed at any time.
二月 16, 2021 10:19:42 上午 org.hibernate.annotations.common.reflection.java.JavaReflectionManager <clinit>
INFO: HCANN000001: Hibernate Commons Annotations {5.1.0.Final}
二月 16, 2021 10:19:43 上午 org.hibernate.dialect.Dialect <init>
INFO: HHH000400: Using dialect: org.hibernate.dialect.MySQLDialect
二月 16, 2021 10:19:44 上午 org.hibernate.engine.transaction.jta.platform.internal.JtaPlatformInitiator initiateService
INFO: HHH000490: Using JtaPlatform implementation: [org.hibernate.engine.transaction.jta.platform.internal.NoJtaPlatform]
Hibernate: 
    select
        user0_.id as id1_0_,
        user0_.name as name2_0_ 
    from
        User user0_ 
    where
        user0_.name=?
[User [id=3, name=admin]]
Hibernate: 
    select
        * 
    from
        user
[User [id=1, name=Joe], User [id=2, name=李四], User [id=3, name=admin], User [id=5, name=kkkk], User [id=6, name=joe]]

执行操作成功！

4.总结

小心当前的Hibnernate的使用session执行sql需要事务的支持，只有一个txManager是不行的，需要事务织入配置<aop:config>
使用Hibernate的执行的时候可以指定当前的XXX.hbm.xml和实体类对应的包，建议XXX与实体类名完全一致
小心参数绑定方式？，可能在不同的版本中已经可能废弃

原文链接：https://blog.csdn.net/weixin_45492007/article/details/113822582