struts2+spring+mybatis入门教程四之配置mybatis

（1）将mybatis-3.2.0.jar,mybatis-spring-1.2.0.jar添加到web-inf/lib下，修改spring.xml，配置数据源及mybatis的SqlSessionFactoryBean。spring.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:context="http://www.springframework.org/schema/context"    xsi:schemaLocation="http://www.springframework.org/schema/beans    http://www.springframework.org/schema/beans/spring-beans-3.0.xsd    http://www.springframework.org/schema/contexthttp://www.springframework.org/schema/context/spring-context-3.0.xsd"><!-- 配置数据源 --><bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean">    <property name="jndiName" value="CT"/><property name="jndiEnvironment"><props><!-- The value of Context.PROVIDER_URL --><prop key="java.naming.provider.url">t3://localhost:9001</prop><prop key="java.naming.factory.initial">weblogic.jndi.WLInitialContextFactory</prop></props></property></bean><!-- 配置mybitas SqlSessionFactoryBean --><bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"><property name="dataSource" ref="dataSource" /><property name="configLocation" value="/WEB-INF/sqlMapConfig.xml"></property></bean> <!-- 采用注释的方式配置bean --><context:annotation-config />  <!-- 该 BeanPostProcessor 将自动对标注 @Autowired 的 Bean 进行注入 -->    <bean class="org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor"/><!-- 配置要扫描的包 --><context:component-scan base-package="com.xy6"></context:component-scan><bean id="demoAction" class="com.xy6.DemoAction" /></beans>

（2）在web-inf根目录下新建文件sqlMapConfig.xml，配置mybatis相关参数。sqlMapConfig.xml代码：

<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE configurationPUBLIC "-//mybatis.org//DTD Config 3.0//EN""http://mybatis.org/dtd/mybatis-3-config.dtd"><configuration>    <typeAliases><typeAlias alias="demoVO" type="com.xy6.DemoVO"/></typeAliases><mappers><mapper resource="com/xy6/demo.xml"/></mappers></configuration>

（3）在com.xy6包下新建mybatissql配置文件demo.xml，配置操作数据库的各种sql语句。demo.xml代码：

<?xml version="1.0" encoding="utf-8" ?><!DOCTYPE mapperPUBLIC "-//mybatis.org//DTD Mapper 3.0//EN""http://mybatis.org/dtd/mybatis-3-mapper.dtd"><mapper namespace="demo"><resultMap id="demoVO" type="demoVO"><result property="code" column="htlx" /><result property="name" column="htlxmc" /></resultMap><select id="selectByCode" resultMap="demoVO">select htlx, htlxmc from dmrefjj.tm_r_jj_htlxwhere htlx = #{code} </select> </mapper>

（4）在com.xy6下新建VO类DemoVO.java，对应sql查询出的数据表字段。DemoVO.java代码：

package com.xy6;public class DemoVO {private static final long serialVersionUID = 1L;private int code;private String name;public int getCode() {return code;}public void setCode(int code) {this.code = code;}public String getName() {return name;}public void setName(String name) {this.name = name;}public String toString(){String strTemp = "";strTemp += "code:";strTemp += this.getCode();strTemp += "\n";strTemp += "name:";strTemp += this.getName();strTemp += "\n";return strTemp;}}

（5）在com.xy6包下新建DemoDao类DemoDao.java，调用mybatis操作数据库的接口实现操作数据库。DemoDao.java代码：

package com.xy6;import java.util.List;import org.mybatis.spring.support.SqlSessionDaoSupport;public class DemoDao extends SqlSessionDaoSupport {public List<DemoVO> selectByCode(DemoVO demoVO){return getSqlSession().selectList("selectByCode", demoVO);}}

（6）修改DemoAction.java，调用DemoDao中的selectByCode方法实现读取数据库。DemoAction.java代码：

package com.xy6;import java.util.List;import org.springframework.beans.factory.annotation.Autowired;import com.opensymphony.xwork2.ActionSupport;public class DemoAction extends ActionSupport {public static final long serialVersionUID = 1L;@Autowiredprivate DemoDao demoDao;public String execute(){DemoHelper demoHelper = new DemoHelper();System.out.println("---curren year:"+demoHelper.getCurYear());DemoVO demoVO = new DemoVO();demoVO.setCode(1);List<DemoVO> listDemoVO = demoDao.selectByCode(demoVO);for(int i=0;i <listDemoVO.size(); i++){System.out.println("---i:"+listDemoVO.get(i).toString());}return "success";}}

（7）修改spring.xml，注册DemoDao实体bean。spring.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:context="http://www.springframework.org/schema/context"    xsi:schemaLocation="http://www.springframework.org/schema/beans    http://www.springframework.org/schema/beans/spring-beans-3.0.xsd    http://www.springframework.org/schema/contexthttp://www.springframework.org/schema/context/spring-context-3.0.xsd"><!-- 配置数据源 --><bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean">    <property name="jndiName" value="CT"/><property name="jndiEnvironment"><props><!-- The value of Context.PROVIDER_URL --><prop key="java.naming.provider.url">t3://localhost:9001</prop><prop key="java.naming.factory.initial">weblogic.jndi.WLInitialContextFactory</prop></props></property></bean><!-- 配置mybitas SqlSessionFactoryBean --><bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"><property name="dataSource" ref="dataSource" /><property name="configLocation" value="/WEB-INF/sqlMapConfig.xml"></property></bean> <!-- 采用注释的方式配置bean --><context:annotation-config />  <!-- 该 BeanPostProcessor 将自动对标注 @Autowired 的 Bean 进行注入 -->    <bean class="org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor"/><!-- 配置要扫描的包 --><context:component-scan base-package="com.xy6"></context:component-scan><bean id="demoAction" class="com.xy6.DemoAction" /><bean id="demoDao" class="com.xy6.DemoDao"><property name="sqlSessionFactory" ref="sqlSessionFactory"/></bean></beans>

（8）登录weblogic控制台，配置jndiName为CT的数据源。如下图：

（9）重启weblogic域服务，浏览器中访问http://localhost:9001/web/demo.action，页面显示demo.jsp，控制台输出2014及查询出的数据。如下图：

（10）至此，mybatis配置结束。