spring与mybatis三种整合方法

<?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:p="http://www.springframework.org/schema/p"
 xmlns:context="http://www.springframework.org/schema/context"
 xmlns:mvc="http://www.springframework.org/schema/mvc"
 xsi:schemalocation="http://www.springframework.org/schema/beans 
   http://www.springframework.org/schema/beans/spring-beans-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/mvc 
   http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd">
 <!-- 自动扫描 -->
 <context:component-scan base-package="com.hua.saf" />
 <!-- 引入配置文件 -->
 <bean id="propertyconfigurer" class="org.springframework.beans.factory.config.propertyplaceholderconfigurer">
 <property name="location" value="classpath:jdbc.properties" />
 </bean>
 <bean id="datasource" class="org.apache.commons.dbcp.basicdatasource" destroy-method="close">
 <property name="driverclassname" value="${driver}" />
 <property name="url" value="${url}" />
 <property name="username" value="${username}" />
 <property name="password" value="${password}" />
 <!-- 初始化连接大小 -->
 <property name="initialsize" value="${initialsize}" />
 <!-- 连接池最大数量 -->
 <property name="maxactive" value="${maxactive}" />
 <!-- 连接池最大空闲 -->
 <property name="maxidle" value="${maxidle}" />
 <!-- 连接池最小空闲 -->
 <property name="minidle" value="${minidle}" />
 <!-- 获取连接最大等待时间 -->
 <property name="maxwait" value="${maxwait}" />
 </bean>
 <!-- spring和mybatis完美整合，不需要mybatis的配置映射文件 -->
 <bean id="sqlsessionfactory" class="org.mybatis.spring.sqlsessionfactorybean">
 <property name="datasource" ref="datasource" />
 <!-- 自动扫描mapping.xml文件，**表示迭代查找 -->
 <property name="mapperlocations" value="classpath:com/hua/saf/**/*.xml" />
 </bean>
 <!-- dao接口所在包名，spring会自动查找其下的类 ,包下的类需要使用@mapperscan注解,否则容器注入会失败 -->
 <bean class="org.mybatis.spring.mapper.mapperscannerconfigurer">
 <property name="basepackage" value="com.hua.saf.*" />
 <property name="sqlsessionfactorybeanname" value="sqlsessionfactory" />
 </bean>
 <!-- (事务管理)transaction manager, use jtatransactionmanager for global tx -->
 <bean id="transactionmanager" class="org.springframework.jdbc.datasource.datasourcetransactionmanager">
 <property name="datasource" ref="datasource" />
 </bean> 
</beans>

<?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，namespace的值习惯上设置成包名+sql映射文件名，这样就能够保证namespace的值是唯一的
例如namespace="me.gacl.mapping.usermapper"就是me.gacl.mapping(包名)+usermapper(usermapper.xml文件去除后缀)
-->
<mapper namespace="com.hua.saf.dao.userdao">
　　<!-- 
　　在select标签中编写查询的sql语句， 设置select标签的id属性为getuser，id属性值必须是唯一的，不能够重复,
　　使用parametertype属性指明查询时使用的参数类型，resulttype属性指明查询返回的结果集类型
　　resulttype="com.hua.saf.user"就表示将查询结果封装成一个user类的对象返回,user类就是t_user表所对应的实体类
　　-->
　　<!-- 根据id查询得到一个user对象-->
　　<select id="getuser" parametertype="int" resulttype="com.hua.saf.pojo.user">
　　　　select * from t_user where id=#{id}
　　</select>
</mapper>

/** 
* 这里的@mapperscan就是上面所讲的mapper扫描器中所需要的配置，会自动生成代理对象。 
* 注意，接口中的方法名称要和对应的mybatis映射文件中的语句的id值一样，因为生成的 
* 动态代理，会根据这个匹配相应的sql语句执行。另外就是方法的参数和返回值也需要注 
* 意。接口中的方法如何定义，对应的mybatis映射文件就应该进行相应的定义。 
* 最后，标注中的userdao是用来作为spring的bean的id(或name)进行使用的，方便我 
* 们在service层进行注入使用。 
*/ 
@mapperscan
public interface userdao {
　　//此处的方法名必须和mapper中的映射文件中的id同名
　　//回去映射文件中通过com.hua.saf.dao.userdao.getuser,即this.getclass().getname()+".getuser"
　　public user getuser(int id);
}

@service("userservice")
public class userserviceimpl implements iuserservice {
@resource
private userdao userdao;
　　public user getuser(int id) {
　　　　return userdao.getuser(id);
　　}
}

<?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:p="http://www.springframework.org/schema/p"
 xmlns:context="http://www.springframework.org/schema/context"
 xmlns:mvc="http://www.springframework.org/schema/mvc"
 xsi:schemalocation="http://www.springframework.org/schema/beans 
   http://www.springframework.org/schema/beans/spring-beans-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/mvc 
   http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd">
 <!-- 自动扫描 -->
 <context:component-scan base-package="com.hua.saf" />
 <!-- 引入配置文件 -->
 <bean id="propertyconfigurer" class="org.springframework.beans.factory.config.propertyplaceholderconfigurer">
 <property name="location" value="classpath:jdbc.properties" />
 </bean>
 <bean id="datasource" class="org.apache.commons.dbcp.basicdatasource" destroy-method="close">
 <property name="driverclassname" value="${driver}" />
 <property name="url" value="${url}" />
 <property name="username" value="${username}" />
 <property name="password" value="${password}" />
 <!-- 初始化连接大小 -->
 <property name="initialsize" value="${initialsize}" />
 <!-- 连接池最大数量 -->
 <property name="maxactive" value="${maxactive}" />
 <!-- 连接池最大空闲 -->
 <property name="maxidle" value="${maxidle}" />
 <!-- 连接池最小空闲 -->
 <property name="minidle" value="${minidle}" />
 <!-- 获取连接最大等待时间 -->
 <property name="maxwait" value="${maxwait}" />
 </bean>
 <!-- spring和mybatis完美整合，不需要mybatis的配置映射文件 -->
 <bean id="sqlsessionfactory" class="org.mybatis.spring.sqlsessionfactorybean">
 <property name="datasource" ref="datasource" />
 <property name="configlocation" value="classpath:sqlmapconfig.xml"/>
 <!-- 自动扫描mapping.xml文件，**表示迭代查找,也可在sqlmapconfig.xml中单独指定xml文件-->
 <property name="mapperlocations" value="classpath:com/hua/saf/**/*.xml" />
 </bean>
 <!-- mybatis spring sqlsessiontemplate,使用时直接让spring注入即可 -->
 <bean id="sqlsessiontemplate" class="org.mybatis.spring.sqlsessiontemplate">
 <constructor-arg index="0" ref="sqlsessionfactory"></constructor-arg>
 </bean>
 <!-- (事务管理)transaction manager, use jtatransactionmanager for global tx -->
 <bean id="transactionmanager" class="org.springframework.jdbc.datasource.datasourcetransactionmanager">
 <property name="datasource" ref="datasource" />
 </bean>
</beans>

<?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 type="com.hua.saf.pojo.user" alias="user" />
 </typealiases>
</configuration>

public class user {
 private int id;
 private string username;
 private string password;
 private int age;
 public int getid() {
 return id;
 }
 public void setid(int id) {
 this.id = id;
 }
 public string getusername() {
 return username;
 }
 public void setusername(string username) {
 this.username = username;
 }
 public string getpassword() {
 return password;
 }
 public void setpassword(string password) {
 this.password = password;
 }
 public int getage() {
 return age;
 }
 public void setage(int age) {
 this.age = age;
 }
}

@repository
public class userdao{
 @resource
 private sqlsessiontemplate sqlsessiontemplate;
 public user getuser(int id) {
 return sqlsessiontemplate.selectone(this.getclass().getname() + ".getuser", 1);
 } 
}

@service
public class userservice{
 @resource
 private userdao userdao;
 public user getuser(int id) {
 return userdao.getuser(id);
 }
}

<?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:p="http://www.springframework.org/schema/p"
 xmlns:context="http://www.springframework.org/schema/context"
 xmlns:mvc="http://www.springframework.org/schema/mvc"
 xsi:schemalocation="http://www.springframework.org/schema/beans 
   http://www.springframework.org/schema/beans/spring-beans-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/mvc 
   http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd">
 <!-- 自动扫描 -->
 <context:component-scan base-package="com.hua.saf" />
 <!-- 引入配置文件 -->
 <bean id="propertyconfigurer" class="org.springframework.beans.factory.config.propertyplaceholderconfigurer">
 <property name="location" value="classpath:jdbc.properties" />
 </bean>
 <bean id="datasource" class="org.apache.commons.dbcp.basicdatasource" destroy-method="close">
 <property name="driverclassname" value="${driver}" />
 <property name="url" value="${url}" />
 <property name="username" value="${username}" />
 <property name="password" value="${password}" />
 <!-- 初始化连接大小 -->
 <property name="initialsize" value="${initialsize}" />
 <!-- 连接池最大数量 -->
 <property name="maxactive" value="${maxactive}" />
 <!-- 连接池最大空闲 -->
 <property name="maxidle" value="${maxidle}" />
 <!-- 连接池最小空闲 -->
 <property name="minidle" value="${minidle}" />
 <!-- 获取连接最大等待时间 -->
 <property name="maxwait" value="${maxwait}" />
 </bean>
 <!-- spring和mybatis完美整合，不需要mybatis的配置映射文件 -->
 <bean id="sqlsessionfactory" class="org.mybatis.spring.sqlsessionfactorybean">
 <property name="datasource" ref="datasource" />
 <property name="configlocation" value="classpath:sqlmapconfig.xml"/>
 <!-- 自动扫描mapping.xml文件，**表示迭代查找,也可在sqlmapconfig.xml中单独指定xml文件-->
 <property name="mapperlocations" value="classpath:com/hua/saf/**/*.xml" />
 </bean>
 <!-- (事务管理)transaction manager, use jtatransactionmanager for global tx -->
 <bean id="transactionmanager" class="org.springframework.jdbc.datasource.datasourcetransactionmanager">
 <property name="datasource" ref="datasource" />
 </bean>
</beans>

<?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 type="com.hua.saf.pojo.user" alias="user" />
 </typealiases>
</configuration>

public class user {
 private int id;
 private string username;
 private string password;
 private int age;
 public int getid() {
 return id;
 }
 public void setid(int id) {
 this.id = id;
 }
 public string getusername() {
 return username;
 }
 public void setusername(string username) {
 this.username = username;
 }
 public string getpassword() {
 return password;
 }
 public void setpassword(string password) {
 this.password = password;
 }
 public int getage() {
 return age;
 }
 public void setage(int age) {
 this.age = age;
 }
}

@repository
public class userdao extends sqlsessiondaosupport{
 public user getuser(int id) {
 return this.getsqlsession().selectone(this.getclass().getname() + ".getuser", 1);
 }
　　//使用sqlsessiondaosupport必须注意，此处源码1.1.1中有自动注入，1.2中取消了自动注入，需要手工注入，侵入性强
　　//也可在spring-mybatis.xml中如下配置，但是这种有多少个dao就要配置到少个，多个dao就很麻烦。
　　//<bean id="userdao" class="com.hua.saf.dao.userdao">
　　// <property name="sqlsessionfactory" ref="sqlsessionfactory"/>
　　//</bean>
 @resource
 public void setsqlsessionfactory(sqlsessionfactory sqlsessionfactory) {
 // todo auto-generated method stub
 super.setsqlsessionfactory(sqlsessionfactory);
 }
}

@service
public class userservice{
 @resource
 private userdao userdao;
 public user getuserss(int id) {
 return userdao.getuser(1);
 }
}