Spring+SpringMVC+Mybatis框架整合例子(SSM) 学习笔记

UserMapping.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.my.dao.IUserDao">
<!-- type 对应到pojo类的路径,数据库的column name映射到对应的字段上 -->
 <resultMap id="BaseResultMap" type="com.my.pojo.User" >
    <id column="id" property="id" jdbcType="INTEGER" />
    <result column="user_name" property="userName" jdbcType="VARCHAR" />
    <result column="password" property="password" jdbcType="VARCHAR" />
    <result column="age" property="age" jdbcType="INTEGER" />
  </resultMap>
  <sql id="Base_Column_List" >
    id, user_name, password, age
  </sql>
  <!-- id 和IUserDao 里面方法名一模一样 -->
  <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.Integer" >
    select 
    <include refid="Base_Column_List" />
    from user_t
    where id = #{id,jdbcType=INTEGER}
  </select>
</mapper>

spring-mybatis.xml

<!-- 自动扫描 -->  
    <context:component-scan base-package="com.my" />  

<!-- 自动扫描mapping.xml文件 -->  
        <property name="mapperLocations" value="classpath:com/my/mapping/*.xml"></property>  

<!-- DAO接口所在包名，Spring会自动查找其下的类 -->  
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">  
        <property name="basePackage" value="com.my.dao" />  
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>  
    </bean>  

spring.xml

<!-- 自动扫描该包，使SpringMVC认为包下用了@controller注解的类是控制器 -->
<context:component-scan base-package="com.my.controller" />