Mybatis3+SpringMVC整合

Mybatis3+SpringMVC

项目结构+jar包

person.java

package main.bean;public class person {private int id;private String name;private int age;private String sex;//不要缺少无参构造函数public person() {super();// TODO Auto-generated constructor stub}public person(int id, String name, int age, String sex) {super();this.id = id;this.name = name;this.age = age;this.sex = sex;}public int getId() {return id;}public void setId(int id) {this.id = id;}public String getName() {return name;}public void setName(String name) {this.name = name;}public int getAge() {return age;}public void setAge(int age) {this.age = age;}public String getSex() {return sex;}public void setSex(String sex) {this.sex = sex;}@Overridepublic String toString() {return "person [id=" + id + ", name=" + name + ", age=" + age + ", sex=" + sex + "]";}}

personMapper.java(映射接口类需与对应的映射配置文件同名，否则框架加载不到。personMapper.xml)

package main.Dao;import java.util.List;import main.bean.person;public interface personMapper {//相应的方法名需与对应在xml文件中的sql语句的id相同，比如对应在personMapper.xml中的<insert id="add">int add(person p);//boolean update(person p);//boolean delete(int id);//List<person> selectPerson();}

personMapper.xml

<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "mybatis-3-mapper.dtd" >

<mapper namespace="main.Dao.personMapper"><insert id="add" parameterType="person">insert into person(name,age,sex)values(#{name},#{age},#{sex})</insert>    </mapper>

beans.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:p="http://www.springframework.org/schema/p"      xmlns:context="http://www.springframework.org/schema/context" xmlns:tx="http://www.springframework.org/schema/tx"     xmlns:mvc="http://www.springframework.org/schema/mvc"      xsi:schemaLocation="          http://www.springframework.org/schema/beans          http://www.springframework.org/schema/beans/spring-beans-4.0.xsd          http://www.springframework.org/schema/context          http://www.springframework.org/schema/context/spring-context-4.0.xsd  http://www.springframework.org/schema/tx        http://www.springframework.org/schema/tx/spring-tx-4.0.xsd        http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-3.0.xsd">     <!-- 1. 数据源 : DriverManagerDataSource -->  <bean id="dataSource"  class="org.springframework.jdbc.datasource.DriverManagerDataSource">          <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="root" />      </bean>    <!--          2. mybatis的SqlSession的工厂: SqlSessionFactoryBean         dataSource:引用数据源          typeAliasesPackage:制定映射类package,mapper.xml中可以直接使用类名作为类型别名    -->     <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">          <property name="dataSource" ref="dataSource"></property>          <property name="typeAliasesPackage" value="main.bean"></property>    </bean>     <!--          3. mybatis自动扫描加载Sql映射文件/接口 : MapperScannerConfigurer         sqlSessionFactory:引用sqlsessionfactory        basePackage:指定sql映射文件/接口所在的包（自动扫描）      -->      <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">          <property name="basePackage" value="main.Dao"></property>          <property name="sqlSessionFactory" ref="sqlSessionFactory"></property>      </bean>          <!--         4. 事务管理 : DataSourceTransactionManager dataSource:引用上面定义的数据源     -->      <bean id="txManager"          class="org.springframework.jdbc.datasource.DataSourceTransactionManager">          <property name="dataSource" ref="dataSource"></property>      </bean>        <!-- 5. 使用声明式事务           transaction-manager：引用上面定义的事务管理器       -->      <tx:annotation-driven transaction-manager="txManager" />    </beans>

test.java

 

package main.test;import org.junit.Test;import org.junit.runner.RunWith;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.test.context.ContextConfiguration;import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;import main.Dao.personMapper;import main.bean.person;//该出利用JUnit的Spring测试框架（spring-test-4.1.6.RELEASE.jar）@RunWith(SpringJUnit4ClassRunner.class)//加载配置文件。在SpringMVC+mybatis的web项目中，在web.xml中配置加载相应的projectname-config.xml即可@ContextConfiguration("/beans.xml")public class test {@Autowiredpublic personMapper mapper;@Testpublic void test(){person p = new person(1,"wangwu",26,"M");int result = mapper.add(p);System.out.println(result);}}

针对具体的SpringMVC+Mybatis的web项目，bean.xml中的配置可以写到projectname-config.xml中，然后在web.xml中加载到SpringMVC默认的分配器中。

或者参考我的简单的个人博客项目代码：https://github.com/DreamFinderHou/PersonalBlog.git