Spring注解之mybatis集成

背景：

基于mybatis的3.1.1和Spring的3.1.0.RELEASE做集成操作，不采用事务控制。

依赖jar：

<dependency><groupId>org.mybatis</groupId><artifactId>mybatis</artifactId><version>3.1.1</version></dependency><dependency><groupId>org.mybatis</groupId><artifactId>mybatis-spring</artifactId><version>1.1.1</version></dependency><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><version>5.1.25</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-webmvc</artifactId><version>3.1.0.RELEASE</version></dependency>

?web.xml中感知到spring的存在：

<context-param><param-name>contextConfigLocation</param-name><param-value>/WEB-INF/spring-*.xml</param-value></context-param>

?spring-db.xml：

<?xml version="1.0" encoding="UTF-8"?><beans xmlns="http://www.springframework.org/schema/beans"xmlns:task="http://www.springframework.org/schema/task" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xmlns:p="http://www.springframework.org/schema/p" xmlns:mvc="http://www.springframework.org/schema/mvc"xmlns:aop="http://www.springframework.org/schema/aop" xmlns:context="http://www.springframework.org/schema/context"xmlns:beans="http://www.springframework.org/schema/beans"xsi:schemaLocation="http://www.springframework.org/schema/beans     http://www.springframework.org/schema/beans/spring-beans-3.1.xsd    http://www.springframework.org/schema/mvchttp://www.springframework.org/schema/mvc/spring-mvc-3.1.xsd    http://www.springframework.org/schema/aop    http://www.springframework.org/schema/aop/spring-aop-3.1.xsd    http://www.springframework.org/schema/context     http://www.springframework.org/schema/context/spring-context-3.1.xsd    http://www.springframework.org/schema/task       http://www.springframework.org/schema/task/spring-task-3.1.xsd"><bean id="dataSource"value="com.mysql.jdbc.Driver" /><property name="url" value="jdbc:mysql://host:3005/db" /><property name="username" value="username" /><property name="password" value="password" /></bean><bean id="sqlSessionFactory" ref="dataSource" /><property name="configLocation" value="/WEB-INF/mybatis-config.xml"/><property name="mapperLocations"value="classpath*:com/xx/dao/*.xml" /><property name="typeAliasesPackage" value="com.xx.vo" /></bean><bean value="com.xx.dao" /></bean></beans>

上述指定了dataSource，同时sqlSessionFactory中引入了dataSource，configLocation中的配置如下：

<?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 alias="demo_t" type="com.xx.vo.Demo" /></typeAliases></configuration> 

?mapperLocations—emoMapper.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.xx.dao.DemoDao"><cache /><select id="getDemo" parameterType="string" resultType="Demo" >select idfrom demo_t where id = #{id}  </select></mapper>

??

VO和Dao如下：

public class Demo implements Serializable {private static final long serialVersionUID = -7271550743849359837L;private String id;public String getId() {return id;}public void setId(String id) {this.id = id;}}

?

public interface DemoDao { Demo getDemo(String id);}

?

此时配置完成只需要调用即可：

this.demoDao.getDemo(id);

?