Mybatis-Spring

Spring整合Mybatis：顺应下时代潮流，把这些市面上流行的东东都整一遍玩玩。要不然就变成“老古董”了。

第一步、需要导入spring jar包、Mybatis jar包、Mybatis-spring jar包；

第二步、在spring的配置文件applicationContext.xml中加入如下配置项，及其作用：

	<!-- 配置数据源 -->

<span style="white-space:pre">	</span><bean id="dataSource" destroy-method="close"
	  class="org.apache.tomcat.dbcp.dbcp.BasicDataSource">
	    <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
	    <property name="url" value="jdbc:mysql://localhost:3306/test"/>
	    <property name="username" value="root"/>
	    <property name="password" value="123456"/>
	    <property name="initialSize" value="3"/>
	</bean>
	

<span style="white-space:pre">	</span><!-- 在spring的context中注入<span style="font-family: Arial, Helvetica, sans-serif;">SqlSessionFactory，以便在后面的sql执行模板中Injection</span><span style="font-family: Arial, Helvetica, sans-serif;"> --></span>
	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
		<property name="dataSource">
			<ref bean="dataSource"/>
		</property>
		<property name="configLocation" value="classpath:Mybatis-Configuration.xml"></property>
	</bean>

<span style="white-space:pre">	</span><!-- 提供一个template来执行业务接口方法和配置的sql -->
	<bean id="baseMapper" class="org.mybatis.spring.mapper.MapperFactoryBean" abstract="true" lazy-init="true">
		<property name="sqlSessionFactory">
			<ref bean="sqlSessionFactory"/>
		</property>
	</bean>
	
	<bean id="userDao" parent="baseMapper">
		<property name="mapperInterface" value="com.cmpsky.mybatistest.dao.UserDao"></property>
	</bean>
	
	<bean id="bigUserDao" parent="baseMapper">
		<property name="mapperInterface" value="com.cmpsky.mybatistest.dao.BigUserDao"></property>
	</bean>

第三步、Mybatis的基本configure文件还是要的，只是不再在里面配置包括datasource在内的environment了：

<pre name="code" class="html"><?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>
  <mappers>
  	<!-- import UserMapper.xml -->
	<mapper resource="com/cmpsky/mybatistest/data/UserMapper.xml"/>
	<mapper resource="com/cmpsky/mybatistest/data/BigUserMapper.xml"/>
  </mappers>
</configuration>

第四步、配置具体的SQL映射文件<span style="font-family: Arial, Helvetica, sans-serif;">BigUserMapper.xml，这里是个稍微复杂点的例子</span><span style="font-family: Arial, Helvetica, sans-serif;">：</span>

<span style="font-family: Arial, Helvetica, sans-serif;"></span><pre name="code" class="html"><?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.cmpsky.mybatistest.dao.BigUserDao">
	<resultMap type="com.cmpsky.mybatistest.data.GFModel" id="gfModelMapper">
		<id property="gf_name" column="gf_name"/>
		<result property="sex" column="sex"/>
		<result property="age" column="age"/>
		<result property="bf_name" column="bf_name"/>
	</resultMap>
	
	<resultMap type="com.cmpsky.mybatistest.data.FriendsModel" id="friendsModelMapper">
		<id property="f_name" column="f_name"/>
		<result property="sex" column="sex"/>
		<result property="age" column="age"/>
		<result property="fname_to" column="fname_to"/>
	</resultMap>
	
	<resultMap type="com.cmpsky.mybatistest.data.BigUserModel" id="bigUserModelMapper">
		<constructor>
			<idArg column="username" javaType="String"/>
		</constructor>
		<result column="sex" javaType="int"/>
		<result column="age" javaType="int"/>
		<association property="gf" column="gf_name" javaType="com.cmpsky.mybatistest.data.GFModel" resultMap="gfModelMapper"/>
		<collection property="friendsList" column="f_name" ofType="com.cmpsky.mybatistest.data.FriendsModel" resultMap="friendsModelMapper"></collection>
	</resultMap>
	
	<select id="getBigUser" parameterType="com.cmpsky.mybatistest.data.UserModel" resultMap="bigUserModelMapper">  
	    select tut.username,tut.sex,tut.age,
	    tgf.gf_name,tgf.sex,tgf.age,tgf.bf_name,
	    tfs.f_name,tfs.sex,tfs.age,tfs.fname_to  
	     from t_user_test tut 
	     left join t_gf tgf on tut.username = tgf.bf_name 
	     left join t_friends tfs on tut.username = tfs.fname_to 
	     where tut.username = #{username}
	</select>
</mapper>

第五步、定义dao接口：

<pre name="code" class="java">import com.cmpsky.mybatistest.data.BigUserModel;
import com.cmpsky.mybatistest.data.UserModel;

public interface BigUserDao 
{
	BigUserModel getBigUser(UserModel user);
}

第六步、可以调用测试了：

import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;

import com.cmpsky.mybatistest.dao.BigUserDao;
import com.cmpsky.mybatistest.dao.UserDao;
import com.cmpsky.mybatistest.data.UserModel;
import com.cmpsky.mybatistest.util.ApplicationContextFactory;

@Controller
public class MybatisTestController 
{	
	@RequestMapping(value="b-s-test",params="complex")
	public String getBigUser(Model model)
	{
		BigUserDao dao = (BigUserDao)ApplicationContextFactory.getApplicationContext().getBean("bigUserDao");
		
		System.out.println(dao.getBigUser(new UserModel("lida1",1, 24)));
		
		model.addAttribute("message", "success");
		
		return "hello";
	}
}

当然，这里面牵扯到的spring-mvc知识，得是要知道的。我就不加了