spring+mybatis(二)

在spring-config.xml加上 数据库的引用

<import resource="ext/spring-db.xml"/>

srping-db.xml(连接池选用DruidDataSouce)

pom.xml

 <!-- druid -->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.0.17</version>
        </dependency>

spring-db.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:tx="http://www.springframework.org/schema/tx"
       xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd
		http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.0.xsd
		http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd">

    <!-- 创建SqlSessionFactory，同时指定数据源 -->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource"/>
        <property name="mapperLocations" value="classpath:mapper/*.xml"/>

    </bean>

    <!-- (事务管理)transaction manager, use JtaTransactionManager for globaltx -->
    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource"/>
    </bean>

    <!-- Mapper接口所在包名，Spring会自动查找其下的Mapper -->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="lf.dao"/>
        <!--<property name="sqlSessionFactoryBeanName" value="lazySqlSessionFactory"/>-->
    </bean>

    <!-- 连接事务的注解配置 -->
    <tx:annotation-driven transaction-manager="transactionManager"/>

    <aop:config proxy-target-class="false">
        <!-- 控制payment下dao层增删改事务 -->
        <aop:pointcut id="daoOperation" expression="execution(* lf.service.*Service.*(..))"/>
        <aop:advisor advice-ref="txAdvice" pointcut-ref="daoOperation"/>
    </aop:config>

    <tx:advice id="txAdvice" transaction-manager="transactionManager">
        <tx:attributes>
            <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="update*" propagation="REQUIRED" rollback-for="java.lang.Exception"/>
        </tx:attributes>
    </tx:advice>

    <!-- druid数据源 -->
    <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close">
        <property name="driverClassName" value="${irecognize.mysql.driver}"/>
        <property name="url" value="${irecognize.jdbc.url}"/>
        <property name="username" value="${irecognize.jdbc.username}"/>
        <property name="password" value="${irecognize.jdbc.password}"/>
        <property name="maxActive" value="${irecognize.jdbc.maxActive}"/>
        <!-- 属性类型是字符串，通过别名的方式配置扩展插件，常用的插件有：监控统计用的filter:stat，日志用的filter:slf4j，防御sql注入的filter:wall -->
        <property name="filters" value="stat"/>
        <!-- 初始化时建立物理连接的个数。初始化发生在显示调用init方法，或者第一次getConnection时 -->
        <property name="initialSize" value="${datasource.initialSize}"/>
        <!-- 获取连接时最大等待时间，单位毫秒。配置了maxWait之后，缺省启用公平锁，并发效率会有所下降，如果需要可以通过配置useUnfairLock属性为true使用非公平锁。 -->
        <property name="maxWait" value="${datasource.maxWait}"/>
        <!-- 最小连接池数量 -->
        <property name="minIdle" value="${datasource.minIdle}"/>
        <!-- 有两个含义：1) Destroy线程会检测连接的间隔时间 2) testWhileIdle的判断依据，详细看testWhileIdle属性的说明 -->
        <property name="timeBetweenEvictionRunsMillis" value="${datasource.timeBetweenEvictionRunsMillis}"/>
        <!-- Destory线程中如果检测到当前连接的最后活跃时间和当前时间的差值大于minEvictableIdleTimeMillis，则关闭当前连接。 -->
        <property name="minEvictableIdleTimeMillis" value="${datasource.minEvictableIdleTimeMillis}"/>
        <!-- 用来检测连接是否有效的sql，要求是一个查询语句。如果validationQuery为null，testOnBorrow、testOnReturn、testWhileIdle都不会其作用 -->
        <property name="validationQuery" value="${datasource.validationQuery}"/>
        <!-- 建议配置为true，不影响性能，并且保证安全性。申请连接的时候检测，如果空闲时间大于timeBetweenEvictionRunsMillis，执行validationQuery检测连接是否有效。 -->
        <property name="testWhileIdle" value="${datasource.testWhileIdle}"/>
        <!-- 申请连接时执行validationQuery检测连接是否有效，做了这个配置会降低性能。 -->
        <property name="testOnBorrow" value="${datasource.testOnBorrow}"/>
        <!-- 归还连接时执行validationQuery检测连接是否有效，做了这个配置会降低性能 -->
        <property name="testOnReturn" value="${datasource.testOnReturn}"/>
    </bean>
</beans>

config.properties

#JDBC CONFIG
irecognize.mysql.driver=com.mysql.jdbc.Driver
irecognize.jdbc.url=jdbc:mysql://127.0.0.1:3306/lfData?useUnicode=true&characterEncoding=utf8
irecognize.jdbc.username=root
irecognize.jdbc.password=root
irecognize.jdbc.maxActive=20

# Basic DataSource
datasource.initialSize=3
datasource.minIdle=0
datasource.maxWait=5000
datasource.testWhileIdle=true
datasource.testOnBorrow=true
datasource.testOnReturn=false
datasource.validationQuery=SELECT 1 FROM DUAL
datasource.timeBetweenEvictionRunsMillis=30000
datasource.minEvictableIdleTimeMillis=60000

测试，查询所有： UserContoller.java

 @ResponseBody
    @RequestMapping(value="/selectAllUser",method=RequestMethod.GET)
    public  Map<String, Object> selectAllUser(){
        Map<String, Object> resultMap = new HashMap<String, Object>();
        try {
           List<User> userList=userService.selectAllUser();
            resultMap.put("userList",userList);
        } catch (Exception e) {
            resultMap.put("msg", "查询用户信息失败");
            resultMap.put("code", 1);
        }
        return resultMap;
    }

UserDao.java

    List<User> selectAllUser();

UserService.java

    List<User> selectAllUser();

UserServiceImpl.java

 @Override
    public List<User> selectAllUser(){
        List<User> userList=new ArrayList<User>();
        try{
            userList=userDao.selectAllUser();
        }catch (DataAccessException e){}
        return   userList;
    }

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="lf.dao.UserDao">
    <resultMap id="BaseResultMap" type="lf.model.User">
        <id property="id" column="id"/>
        <result property="username" column="username"/>
        <result property="password" column="password"/>
        <result property="salt" column="salt"/>
        <result property="email" column="email"/>
        <result property="mobile" column="mobile"/>
        <result property="rdate" column="rdate"/>
        <result property="udate" column="udate"/>
        <result property="status" column="status"/>
    </resultMap>
    <sql id="Base_Column_List">
        id,username,email,mobile,rdate,udate,status
    </sql>
    <select id="selectAllUser" resultMap="BaseResultMap" >
    select
    <include refid="Base_Column_List"/>
    from user where 1!=0</select>
</mapper>

建个测试，调用controller的selectAllUser方法,成功