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.xsdhttp://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.0.xsdhttp://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 CONFIGirecognize.mysql.driver=com.mysql.jdbc.Driverirecognize.jdbc.url=jdbc:mysql://127.0.0.1:3306/lfData?useUnicode=true&characterEncoding=utf8irecognize.jdbc.username=rootirecognize.jdbc.password=rootirecognize.jdbc.maxActive=20# Basic DataSourcedatasource.initialSize=3datasource.minIdle=0datasource.maxWait=5000datasource.testWhileIdle=truedatasource.testOnBorrow=truedatasource.testOnReturn=falsedatasource.validationQuery=SELECT 1 FROM DUALdatasource.timeBetweenEvictionRunsMillis=30000datasource.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方法,成功