Mybatis的sqlSessionTemplate直接使用

本文的持久化操作使用的是mybatis的sqlSessionTemplate，可用
除了mapper.xml中的sql语句 还可以用这个提供好的类来操作数据库

 
 

   
   

    
    

   
   
   
   

    
    

     
     SqlSession sqlSession= sqlSessionTemplate.getSqlSessionFactory().openSession(ExecutorType.BATCH, 
     
     false);
    
    
   
   

   
   

    
    

   
   
   
   

    
    

     
     //增
    
    
   
   

   
   

    
    

   
   
   
   

    
    

     
     int result = sqlSession.insert(
     
     "userMapper.insertUsers",user);
    
    
   
   

   
   

    
    

   
   
   
   

    
    

     
     //删
    
    
   
   

   
   

    
    

   
   
   
   

    
    

     
     int result = sqlSession.delete(
     
     "userMapper.deleteUsers",
     
     49);
    
    
   
   

   
   

    
    

   
   
   
   

    
    

     
     //改
    
    
   
   

   
   

    
    

   
   
   
   

    
    

     
     int result = sqlSession.update(
     
     "userMapper.updateUsers",user);
    
    
   
   

   
   

    
    

   
   
   
   

    
    

     
     //查
    
    
   
   

   
   

    
    

   
   
   
   

    
    

     
     List<User> list = sqlSession.selectList(
     
     "userMapper.queryUsers");
    
    
   
   

   
   

    
    

   
   
   
   

    
    

     
     User user = sqlSession.selectOne(
     
     "userMapper.queryUserById",
     
     2);
    
    
   
   
 
 

把一个User对象写入数据库，相当于之前一直使用的parameterType="User"，它不需要使用dao层，而直接用sqlSessionTemplate去使用mapper.xml里具体的持久化方法。它在spring-mybatis.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: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/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.1.xsd
    
    
   
   

   
   

    
    

   
   
   
   

    
    

     
                                ">
    
    
   
   

   
   

    
    

   
   
   
   

    
    
 
    
    
   
   

   
   

    
    

   
   
   
   

    
    

     
         <bean 
     
     class=
     
     "org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
    
    
   
   

   
   

    
    

   
   
   
   

    
    

     
             <property name=
     
     "ignoreUnresolvablePlaceholders" value=
     
     "true"/>
    
    
   
   

   
   

    
    

   
   
   
   

    
    

     
             <property name=
     
     "order" value=
     
     "1"/>
    
    
   
   

   
   

    
    

   
   
   
   

    
    

     
             <property name=
     
     "locations">
    
    
   
   

   
   

    
    

   
   
   
   

    
    

     
                 <list>
    
    
   
   

   
   

    
    

   
   
   
   

    
    

     
                     <value>classpath:oracle.properties</value>
    
    
   
   

   
   

    
    

   
   
   
   

    
    

     
                 </list>
    
    
   
   

   
   

    
    

   
   
   
   

    
    

     
             </property>
    
    
   
   

   
   

    
    

   
   
   
   

    
    

     
         </bean>
    
    
   
   

   
   

    
    

   
   
   
   

    
    
 
    
    
   
   

   
   

    
    

   
   
   
   

    
    

     
         <!-- 自动扫描 -->
    
    
   
   

   
   

    
    

   
   
   
   

    
    

     
         <context:component-scan base-
     
     package=
     
     "cn.richinfo.**" />
    
    
   
   

   
   

    
    

   
   
   
   

    
    
 
    
    
   
   

   
   

    
    

   
   
   
   

    
    

     
         <!-- 数据库配置 -->
    
    
   
   

   
   

    
    

   
   
   
   

    
    

     
         <bean id=
     
     "dataSource" 
     
     class=
     
     "org.apache.commons.dbcp.BasicDataSource" destroy-method=
     
     "close">
    
    
   
   

   
   

    
    

   
   
   
   

    
    

     
             <property name=
     
     "driverClassName"  value=
     
     "oracle.jdbc.OracleDriver"/>
    
    
   
   

   
   

    
    

   
   
   
   

    
    

     
             <property name=
     
     "url" value=
     
     "${oracle.datasource.url}" />
    
    
   
   

   
   

    
    

   
   
   
   

    
    

     
             <property name=
     
     "username" value=
     
     "${oracle.datasource.username}" />
    
    
   
   

   
   

    
    

   
   
   
   

    
    

     
             <property name=
     
     "password" value=
     
     "${oracle.datasource.password}" />
    
    
   
   

   
   

    
    

   
   
   
   

    
    

     
             <property name=
     
     "maxActive" value=
     
     "${oracle.datasource.maxActive}"/>
    
    
   
   

   
   

    
    

   
   
   
   

    
    

     
             <property name=
     
     "maxIdle"   value=
     
     "${oracle.datasource.maxIdle}"/>
    
    
   
   

   
   

    
    

   
   
   
   

    
    

     
             <property name=
     
     "maxWait"   value=
     
     "${oracle.datasource.maxWait}"/>
    
    
   
   

   
   

    
    

   
   
   
   

    
    

     
             <property name=
     
     "logAbandoned" value=
     
     "${oracle.datasource.logAbandoned}"/>
    
    
   
   

   
   

    
    

   
   
   
   

    
    

     
             <property name=
     
     "removeAbandoned" value=
     
     "${oracle.datasource.removeAbandoned}"/>
    
    
   
   

   
   

    
    

   
   
   
   

    
    

     
             <property name=
     
     "removeAbandonedTimeout" value=
     
     "${oracle.datasource.removeAbandonedTimeout}"/>
    
    
   
   

   
   

    
    

   
   
   
   

    
    

     
             <property name=
     
     "validationQuery" value=
     
     "select 1 from dual" />
    
    
   
   

   
   

    
    

   
   
   
   

    
    

     
         </bean>
    
    
   
   

   
   

    
    

   
   
   
   

    
    
 
    
    
   
   

   
   

    
    

   
   
   
   

    
    

     
         <bean id=
     
     "transactionManager" 
     
     class=
     
     "org.springframework.jdbc.datasource.DataSourceTransactionManager">
    
    
   
   

   
   

    
    

   
   
   
   

    
    

     
             <property name=
     
     "dataSource" ref=
     
     "dataSource"/>
    
    
   
   

   
   

    
    

   
   
   
   

    
    

     
         </bean>
    
    
   
   

   
   

    
    

   
   
   
   

    
    
 
    
    
   
   

   
   

    
    

   
   
   
   

    
    

     
         <tx:annotation-driven transaction-manager=
     
     "transactionManager" />
    
    
   
   

   
   

    
    

   
   
   
   

    
    
 
    
    
   
   

   
   

    
    

   
   
   
   

    
    

     
         <!-- 扫描包的方式注入所有的Mapper -->
    
    
   
   

   
   

    
    

   
   
   
   

    
    

     
         <bean id=
     
     "sqlSessionFactory" 
     
     class=
     
     "org.mybatis.spring.SqlSessionFactoryBean">
    
    
   
   

   
   

    
    

   
   
   
   

    
    

     
             <property name=
     
     "dataSource" ref=
     
     "dataSource"/>
    
    
   
   

   
   

    
    

   
   
   
   

    
    

     
             <property name=
     
     "mapperLocations" value=
     
     "classpath:cn/richinfo/mapper/*.xml"/>
    
    
   
   

   
   

    
    

   
   
   
   

    
    

     
         </bean>
    
    
   
   

   
   

    
    

   
   
   
   

    
    
 
    
    
   
   

   
   

    
    

   
   
   
   

    
    

     
         <!-- 配置扫描器 -->
    
    
   
   

   
   

    
    

   
   
   
   

    
    

     
         <!--<bean 
     
     class=
     
     "org.mybatis.spring.mapper.MapperScannerConfigurer">-->
    
    
   
   

   
   

    
    

   
   
   
   

    
    

     
             <!--<property name=
     
     "basePackage" value=
     
     "com.richinfo.**.dao" />-->
    
    
   
   

   
   

    
    

   
   
   
   

    
    

     
             <!--<property name=
     
     "sqlSessionFactoryBeanName" value=
     
     "sqlSessionFactory" />-->
    
    
   
   

   
   

    
    

   
   
   
   

    
    

     
         <!--</bean>-->
    
    
   
   

   
   

    
    

   
   
   
   

    
    
 
    
    
   
   

   
   

    
    

   
   
   
   

    
    

     
         <bean id=
     
     "sqlSessionTemplate" 
     
     class=
     
     "org.mybatis.spring.SqlSessionTemplate" scope=
     
     "prototype">
    
    
   
   

   
   

    
    

   
   
   
   

    
    

     
             <constructor-arg index=
     
     "0" ref=
     
     "sqlSessionFactory"/>
    
    
   
   

   
   

    
    

   
   
   
   

    
    

     
         </bean>
    
    
   
   

   
   

    
    

   
   
   
   

    
    
 
    
    
   
   

   
   

    
    

   
   
   
   

    
    

     
     </beans>
    
    
   
   
 
 

并且在applicationContent.xml中导入

 <import resource="classpath*:spring-mybatis.xml" />
 
 

mqpper.xml中的写法与spring结合mybatis一直使用的那一套一致。这里要注意的是:

 
 

   
   

    
    

   
   
   
   

    
    

     
     <mapper 
     
     namespace=
     
     "userMapper">
    
    
   
   

   
   

    
    

   
   
   
   

    
    

     
     <insert id=
     
     "insertUser" parameterType=
     
     "cn.data.User">
    
    
   
   
 
 

如上例，在使用中要用"mapperName.methodName"