Spring整合Mybatis(MapperScannerConfigurer方式)

本文主要介绍spring整合myBatis,用jar包是：spring 4.1 +  myBatis 3.2.2 + mybatis-spring 1.1。

项目的源码和jar包可以去我的资源下载 http://download.csdn.net/detail/psp0001060/9659564

一、整个项目的一个结构

二、主要整合部分

ClazzController：

package com.edwin.action;import org.junit.Before;import org.junit.Test;import org.springframework.context.ApplicationContext;import org.springframework.context.support.ClassPathXmlApplicationContext;import org.springframework.util.Assert;import com.edwin.dao.ClazzMapper;import com.edwin.model.Clazz;import com.edwin.service.ClazzService;public class ClazzController {ApplicationContext ac = null;@Beforepublic void prepar(){ac = new ClassPathXmlApplicationContext("/applicationContext.xml");ClazzMapper clazzMapper =(ClazzMapper) ac.getBean("clazzMapper");Assert.notNull(clazzMapper);}@Testpublic void testClzInsert(){ClazzService cs = (ClazzService) ac.getBean("clazzService");Clazz clz = new Clazz();//clz.setId(10);clz.setClassname("class010");cs.insert(clz);}}

clazzService：

package com.edwin.service;import javax.annotation.Resource;import org.springframework.stereotype.Service;import com.edwin.dao.ClazzMapper;import com.edwin.model.Clazz;@Service(value="clazzService")public class ClazzService {@Resource(name="clazzMapper")private ClazzMapper clazzMapper;public ClazzMapper getClazzMapper() {return clazzMapper;}public void setClazzMapper(ClazzMapper clazzMapper) {this.clazzMapper = clazzMapper;}public int insert(Clazz clz){return clazzMapper.insert(clz);}}

ClazzMapper：

package com.edwin.dao;import com.edwin.model.Clazz;public interface ClazzMapper {    int deleteByPrimaryKey(Integer id);    int insert(Clazz record);    int insertSelective(Clazz record);    Clazz selectByPrimaryKey(Integer id);    int updateByPrimaryKeySelective(Clazz record);    int updateByPrimaryKey(Clazz record);}

ClazzMapper.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.edwin.dao.ClazzMapper"><resultMap id="BaseResultMap" type="Clazz"><id column="id" property="id" jdbcType="INTEGER" /><result column="classname" property="classname" jdbcType="VARCHAR" /></resultMap><sql id="Base_Column_List">id, classname</sql><select id="selectByPrimaryKey" resultMap="BaseResultMap"parameterType="java.lang.Integer">select<include refid="Base_Column_List" />from clazzwhere id = #{id,jdbcType=INTEGER}</select><delete id="deleteByPrimaryKey" parameterType="java.lang.Integer">delete from clazzwhere id = #{id,jdbcType=INTEGER}</delete><insert id="insert" parameterType="Clazz">insert into clazz (id, classname)values (#{id,jdbcType=INTEGER}, #{classname,jdbcType=VARCHAR})</insert><insert id="insertSelective" parameterType="Clazz">insert into clazz<trim prefix="(" suffix=")" suffixOverrides=","><if test="id != null">id,</if><if test="classname != null">classname,</if></trim><trim prefix="values (" suffix=")" suffixOverrides=","><if test="id != null">#{id,jdbcType=INTEGER},</if><if test="classname != null">#{classname,jdbcType=VARCHAR},</if></trim></insert><update id="updateByPrimaryKeySelective" parameterType="Clazz">update clazz<set><if test="classname != null">classname = #{classname,jdbcType=VARCHAR},</if></set>where id = #{id,jdbcType=INTEGER}</update><update id="updateByPrimaryKey" parameterType="Clazz">update clazzset classname = #{classname,jdbcType=VARCHAR}where id = #{id,jdbcType=INTEGER}</update></mapper>

applicationContext.xml

<?xml version="1.0" encoding="UTF-8"?><beans xmlns="http://www.springframework.org/schema/beans"xmlns:tx="http://www.springframework.org/schema/tx" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xmlns:context="http://www.springframework.org/schema/context"xmlns:aop="http://www.springframework.org/schema/aop" xmlns:p="http://www.springframework.org/schema/p"xsi:schemaLocation="http://www.springframework.org/schema/beans        http://www.springframework.org/schema/beans/spring-beans-3.2.xsd       http://www.springframework.org/schema/tx        http://www.springframework.org/schema/tx/spring-tx-3.2.xsd       http://www.springframework.org/schema/context        http://www.springframework.org/schema/context/spring-context-3.2.xsd       http://www.springframework.org/schema/aop       http://www.springframework.org/schema/aop/spring-aop-3.2.xsd">              <context:component-scan base-package="com.edwin.service"></context:component-scan>  <!-- 数据源c3p0 --><bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"><property name="driverClass" value="com.mysql.jdbc.Driver" /><property name="jdbcUrl" value="jdbc:mysql://127.0.0.1:3306/mybatis" /><property name="user" value="root" /><property name="password" value="root" /><property name="maxPoolSize" value="30" /><property name="minPoolSize" value="5" /><property name="initialPoolSize" value="2" /><property name="acquireIncrement" value="2" /></bean><!-- sessionFactory 将spring和mybatis整合 --><bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"><property name="dataSource" ref="dataSource" /><property name="configLocation" value="classpath:mybatis-config.xml" /><property name="mapperLocations" value="classpath:com/edwin/mapper/*.xml" />    <!-- 加载mapper文件 --></bean><!-- dao mapping接口扫描 --><bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"><property name="basePackage" value=" com.edwin.dao" /><property name="sqlSessionFactoryBeanName" value="sqlSessionFactory" /></bean>       <!-- 事务 --><bean id="txManager"class="org.springframework.jdbc.datasource.DataSourceTransactionManager"><property name="dataSource" ref="dataSource" /></bean><tx:advice id="txAdvice" transaction-manager="txManager"><tx:attributes><tx:method name="insert*" propagation="REQUIRED" /><tx:method name="update*" propagation="REQUIRED" /><tx:method name="delete*" propagation="REQUIRED" /><tx:method name="create*" propagation="REQUIRED" /><tx:method name="find*" propagation="REQUIRED" read-only="true" /><tx:method name="get*" propagation="REQUIRED" read-only="true" /><tx:method name="*" propagation="REQUIRED" read-only="true" /></tx:attributes></tx:advice><aop:config><aop:pointcut expression="execution(* com.edwin.service.*.*(..))"id="pointCut" /><aop:advisor advice-ref="txAdvice" pointcut-ref="pointCut" /></aop:config></beans>

mybatis-config.xml

<?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.edwin.model.Clazz" alias="Clazz" /></typeAliases></configuration>