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（DemoMapper.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);
?