Mybatis和spring整合

新建web工程

工程目录

加入jar包

jar包列表

项目代码

//#User.javapackage com.lee.domain;public class User {private int userid;private String name;private String password;private int money;public int getUserid() {return userid;}public void setUserid(int userid) {this.userid = userid;}public String getPassword() {return password;}public void setPassword(String password) {this.password = password;}public int getMoney() {return money;}public void setMoney(int money) {this.money = money;}public String getName() {return name;}public void setName(String name) {this.name = name;}}

//#UserMapper.java,Mybatis封装的mapper代理接口package com.lee.mapper;import java.util.List;import com.lee.domain.User;public interface UserMapper {public User selectUserById(int id);public void deleteUser(int id);public void addUser(User user);public List<User> selectUserByName(String name);}

//#UserMapper.xml,Mybatis的映射文件<?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.lee.mapper.UserMapper"><!-- 通过id查询user -->   <select id="selectUserById" parameterType="int" resultType="com.lee.domain.User">    select * from user where userid = #{value}  </select>    <!-- 通过id删除user -->  <select id="deleteUser" parameterType="int">    delete from user where userid = #{value}  </select>    <!-- 新增一条user记录 -->  <select id="addUser" parameterType="com.lee.domain.User">    insert into user (userid,name,password,money) values(#{userid},#{name},#{password},#{money})  </select>    <!-- 通过那么查询一个user的list集合 -->  <select id="selectUserByName" parameterType="String" resultType="com.lee.domain.User">    select * from user where name = #{value}  </select></mapper>

//#Mybatis核心配置文件<?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>  <!-- 原始加载mapper，一条条的写 -->    <!-- <mapper resource="domain/UserMapper.xml"/> -->        <!-- 批量扫描，指定mapper接口的包名    规定，mapper接口名和mapper.xml名必须一致且在同一目录中    规范前提是，使用mapper代理，这里的任务是批量引入mapper.xml    spring的加载器帮助完成了此功能，并且实例化mapper.java     -->     <!-- <package name="com.lee.mapper"/> -->  </mappers></configuration>

//#log4j配置文件# Global logging configurationlog4j.rootLogger=debug, stdout# MyBatis logging configuration...log4j.logger.org.mybatis.example.BlogMapper=TRACE# Console output...log4j.appender.stdout=org.apache.log4j.ConsoleAppenderlog4j.appender.stdout.layout=org.apache.log4j.PatternLayoutlog4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n

//#db.propertiesjdbc.driver=com.mysql.jdbc.Driverjdbc.url=jdbc:mysql:///sunjdbc.username=rootjdbc.password=sunshine

//#ApplicationContext.xml，spring的核心配置文件<?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:tx="http://www.springframework.org/schema/tx"      xmlns:context="http://www.springframework.org/schema/context"      xmlns:aop="http://www.springframework.org/schema/aop"      xsi:schemaLocation="http://www.springframework.org/schema/beans                     http://www.springframework.org/schema/beans/spring-beans-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.xsd                         http://www.springframework.org/schema/tx                    http://www.springframework.org/schema/tx/spring-tx-3.2.xsd"> <!-- 加载db.proterties配置文件，读取内容 --><context:property-placeholder location="classpath:db.properties"/><!-- 数据源配置 --><!-- 配置c3p0 --><bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"><property name="driverClass" value="${jdbc.driver}"/><property name="jdbcUrl" value="${jdbc.url}" /><property name="user" value="${jdbc.username}" /><property name="password" value="${jdbc.password}" /></bean> <!-- 配置dbcp --> <!-- <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"> <property name="driverClassName" value="${jdbc.driver}"/><property name="url" value="${jdbc.url}" /><property name="username" value="${jdbc.username}" /><property name="password" value="${jdbc.password}" /> </bean>  --><!-- sqlSessionFactory --><bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"><!-- 加载mybatis的配置文件 --><property name="configLocation" value="classpath:SqlMapConfig.xml"/><!-- 指定数据源 --> <property name="dataSource" ref="dataSource"/></bean><!-- 配置mapper，同原始开发的dao，实现类由Mybatis实现了MapperFactoryBean可以根据接口生成代理对象此种方式需要配置n个mapper，比较繁琐 --> <!-- <bean id="userMapper" class="org.mybatis.spring.mapper.MapperFactoryBean">指定哪一个mapper接口需要它代理 <property name="mapperInterface" value="com.lee.mapper.UserMapper"/> 指定sqlSessionFactory，内部通过此操作数据 <property name="sqlSessionFactory" ref="sqlSessionFactory"/></bean>--><!-- mapper批量扫描实例化 ,使用这个扫描器，必须要遵守mapper.java和mapper.xml命名一致且在同一包中，这里的扫描器同时完成了Mybatis配置文件中加载mapper.xml的任务，这里自动扫描出来后，mapper的bean的id为mapper类名（首字母小写）--><bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"><!-- 指定扫描的包 ，如果要扫描多个包，在后面加上“，包全路径名”--><property name="basePackage" value="com.lee.mapper"/><property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/></bean></beans>

//#测试类package com.lee.mapper;import org.junit.Before;import org.junit.Test;import org.springframework.context.ApplicationContext;import org.springframework.context.support.ClassPathXmlApplicationContext;import com.lee.domain.User;public class UserMapperTest {private ApplicationContext applicationContext;@Beforepublic void getContext(){applicationContext = new ClassPathXmlApplicationContext("classpath:ApplicationContext.xml");}@Testpublic void testSelectUserById() {UserMapper userMapper = (UserMapper) applicationContext.getBean("userMapper");User user = userMapper.selectUserById(1);System.out.println(user);}}