mybatis spring整合 SqlSessionTemplate类使用

ゝ一纸荒年。 2022-05-29 03:13 137阅读 0赞

SqlSessionTemplate 通过使用SqlSession接口来完成工作, 所以他也有selectOne等方法。

在applicationContext.xml 中可以通过SqlSessionFactory作为参数来构建SqlSessionTemplate

<bean id="sqlSessionTemplate" class="org.mybatis.spring.SqlSessionTemplate">
            <constructor-arg index="0" ref="sqlSessionFactory" ></constructor-arg>
        </bean>

### 使用列子 ###

创建pojo类

public class Student {
    
        private Integer stuId;
        private String stuName;
        private Integer stuAge;
        private String stuMajor;
        private Date birthday;
    ...
    }

### dao层接口 ###

public interface StudentDao{
        public List<Student> selectStu();
    }

### dao层实现类 ###

提供setSqlSession方法

public class StudentDaoImpl implements StudentDao { 
        private SqlSessionTemplate sqlSession;
    
        public List<Student> selectStu() {
            return sqlSession.selectList("com.cyh.mapper.selectAll");
        }
    
        public void setSqlSession(SqlSessionTemplate sqlSession) {
            this.sqlSession = sqlSession;
        }
    }

### 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:p="http://www.springframework.org/schema/p" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:context="http://www.springframework.org/schema/context" xmlns:jee="http://www.springframework.org/schema/jee" xmlns:tx="http://www.springframework.org/schema/tx" xsi:schemaLocation=" http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.0.xsd http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee-4.0.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd">
    
        
        <context:property-placeholder location="classpath:jdbc.properties"/>
    
        <bean id = "dataSource" class = "org.springframework.jdbc.datasource.DriverManagerDataSource">
            <property name="driverClassName" value="${driverClassName}"/>
            <property name="url" value="${url}"/>
            <property name="username" value="${username}"/>
            <property name="password" value="${password}"/>
        </bean>
    
        <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
            <property name="dataSource" ref="dataSource"></property>
            <property name="configLocation" value="mybatis-config.xml"></property>
        </bean>
    
        
        <bean id="sqlSessionTemplate" class="org.mybatis.spring.SqlSessionTemplate">
            <constructor-arg index="0" ref="sqlSessionFactory" ></constructor-arg>
        </bean>
    
    
        <bean id="studentDao" class="impl.StudentDaoImpl">
            <property name="sqlSession" ref="sqlSessionTemplate" />
        </bean>
    
    </beans>

其中jdbc.properties如下

## studentMapper.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="com.cyh.mapper">
            <select id="selectAll" resultType="student">
                select * from student
            </select>
        </mapper>

### 整合后的mybatis-config.xml ###

主要声明mappre.xml文件的位置， 和类型别名

<?xml version="1.0" encoding="utf-8"?>
    <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">
    <configuration>
        
        <typeAliases>
            <typeAlias type="pojo.Student" alias="student"></typeAlias>
            </typeAliases>
    
        <mappers>
        <mapper resource="StudentMapper.xml" />
        </mappers>
    
    </configuration>