MyBatis-Spring整合注入SqlSessionTemplate

秒速五厘米 2022-06-08 02:50 144阅读 0赞

**SqlSessionTemplate**

SqlSessionTemplate 是 MyBatis-Spring 的核心。 这个类负责管理 MyBatis 的 SqlSession, 调用 MyBatis 的 SQL 方法, 翻译异常。 SqlSessionTemplate 是线程安全的。

最终要的是让spring获取到SqlSessionTemplate然后注入给工具类，让工具类操作数据库

![Center][]

为了方便看，把所有文件都放一个文件夹里了。

总共是5个文件：

1.Mybatis.xml

<?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD SQL Map Config 3.0//EN"  
    	"http://mybatis.org/dtd/mybatis-3-config.dtd">
    <configuration>
    	<mappers>
    		<mapper resource="bs/UserMapper.xml" />
    			
    	</mappers>
    </configuration>

2. UserMapper.xml

<?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" 
    	"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
    <mapper namespace="UserMapper">
    	 <select id="insert" parameterType="Map" resultType="java.util.Map">
    		INSERT INTO user
    		(id) 
    		VALUES
    		(#{id})
    	</select>
    	
    	<select id="findById" parameterType="int" resultType="java.util.Map">
    		SELECT *
    		FROM user
    		WHERE id=#{id}
    	</select>
    	
    
    </mapper>

3. spring.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 
          http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
          http://www.springframework.org/schema/aop 
          http://www.springframework.org/schema/aop/spring-aop-3.0.xsd
          http://www.springframework.org/schema/context 
          http://www.springframework.org/schema/context/spring-context-3.0.xsd
          http://www.springframework.org/schema/tx 
          http://www.springframework.org/schema/tx/spring-tx-3.0.xsd
     ">
    
    	<bean id="dataSource"
    		class="org.springframework.jdbc.datasource.DriverManagerDataSource">
    		<property name="driverClassName">
    			<value>org.gjt.mm.mysql.Driver</value>
    		</property>
    		<property name="url">
    			<value>jdbc:mysql://localhost:3306/zdy?useUnicode=true&characterEncoding=UTF-8
    			</value>
    		</property>
    		<property name="username">
    			<value>root</value>
    		</property>
    		<property name="password">
    			<value>1111</value>
    		</property>
    	</bean>
    	
    		
    	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
    		<property name="dataSource" ref="dataSource"></property>
    		<property name="configLocation" value="bs/Mybatis.xml"></property>
    	</bean>
    	
    		
         <bean id="sqlsessionTemplate" class="org.mybatis.spring.SqlSessionTemplate">
    		<constructor-arg index="0" ref="sqlSessionFactory" />
    	</bean>
    		
    		
    	<bean id="user" class="bs.UserImpl">
    	<property name="sqlsession" ref="sqlsessionTemplate">
    	</property>
    	</bean>
    </beans>

4. UserImpl.java :操作数据库工具类

package bs;
    
    import java.util.List;
    import java.util.Map;
    
    import org.mybatis.spring.SqlSessionTemplate;
    
    public class UserImpl {
    	//注入以后就可以直接使用sqlsession
    	private SqlSessionTemplate sqlsession;
    	public void setSqlsession(SqlSessionTemplate sqlsession) {
    		this.sqlsession = sqlsession;
    	}
    	//用sqlsession去操作数据库
    	public void insert(Map user){
    		sqlsession.insert("UserMapper.insert", user);
    	}
    	public void findById(int id){
    		 sqlsession.selectOne("UserMapper.findById", id);
    		 System.out.println(sqlsession.selectOne("UserMapper.findById", id));
    		 //因为输出值是一个map集合，所以打印一个map
    	}
    }

5. Test.java

package bs;
    
    import java.util.Map;
    
    import org.springframework.context.support.ClassPathXmlApplicationContext;
    
    public class Test {
    	public static void main(String[] args) {
    
    		ClassPathXmlApplicationContext ctx = new ClassPathXmlApplicationContext("bs/spring.xml");
    		UserImpl userImpl = (UserImpl)ctx.getBean("user");
    		//固定格式  取出bean中创建的UserMapper对象		
    		userImpl.findById(1);
    	}
    }

数据库内容

![Center 1][]

查询出来内容

![Center 2][]

[Center]: /images/20220608/52118db0abd04894addbd38a76e5b87a.png
[Center 1]: /images/20220608/78587f9c4c824251832b2fb8f17e5c08.png
[Center 2]: /images/20220608/2b644e1c105044f890129802e8922acd.png