mybatis&spring整合

一、新建项目

二、导入相关jar包

三、新建一个配置文件applicationContext.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"xsi:schemaLocation="http://www.springframework.org/schema/beanshttp://www.springframework.org/schema/beans/spring-beans-3.2.xsdhttp://www.springframework.org/schema/contexthttp://www.springframework.org/schema/context/spring-context-3.2.xsdhttp://www.springframework.org/schema/txhttp://www.springframework.org/schema/tx/spring-tx-3.2.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?characterEncoding=utf8" /><property name="username" value="root" /><property name="password" value="123456" /></bean> --><bean id="dataSource"class="org.springframework.jdbc.datasource.DriverManagerDataSource"><property name="driverClassName" value="oracle.jdbc.driver.OracleDriver" /><property name="url"value="jdbc:oracle:thin:@kuhaier1.imwork.net:1521:ORCL" /><property name="username" value="clound" /><property name="password" value="clound" /></bean><!-- 2. mybatis 的 SqlSession 的工厂: SqlSessionFactoryBean --><bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"><property name="dataSource" ref="dataSource" /><!-- <property name="typeAliasesPackage" value="com.zscs.model" /> --><property name="mapperLocations" value="com/zscs/model/*.xml" /></bean><!-- 3. mybatis 自动扫描加载 Sql 映射文件 : MapperScannerConfigurer --><bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"><property name="basePackage" value="com.zscs.dao" /><property name="sqlSessionFactory" ref="sqlSessionFactory" /></bean><!-- 4. 事务管理 : DataSourceTransactionManager --><bean id="txManager"class="org.springframework.jdbc.datasource.DataSourceTransactionManager"><property name="dataSource" ref="dataSource" /></bean><!-- 5. 使用声明式事务 --><tx:annotation-driven transaction-manager="txManager" /></beans>

四、编写数据库表对应的实体类User

package com.zscs.model;public class User {    private Long id;    private String name;    private String sex;    private String nf;    private String mouth;    private String grjj;    public Long getId() {        return id;    }    public void setId(Long id) {        this.id = id;    }    public String getName() {        return name;    }    public void setName(String name) {        this.name = name == null ? null : name.trim();    }    public String getSex() {        return sex;    }    public void setSex(String sex) {        this.sex = sex == null ? null : sex.trim();    }    public String getNf() {        return nf;    }    public void setNf(String nf) {        this.nf = nf == null ? null : nf.trim();    }    public String getMouth() {        return mouth;    }    public void setMouth(String mouth) {        this.mouth = mouth == null ? null : mouth.trim();    }    public String getGrjj() {        return grjj;    }    public void setGrjj(String grjj) {        this.grjj = grjj == null ? null : grjj.trim();    }@Overridepublic String toString() {return "User [id=" + id + ", name=" + name + ", sex=" + sex + ", nf="+ nf + ", mouth=" + mouth + ", grjj=" + grjj + "]";}}

六、编写UserMapper.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.zscs.dao.UserMapper" >  <resultMap id="BaseResultMap" type="com.zscs.model.User" >    <id column="ID" property="id" jdbcType="DECIMAL" />    <result column="NAME" property="name" jdbcType="VARCHAR" />    <result column="SEX" property="sex" jdbcType="VARCHAR" />    <result column="NF" property="nf" jdbcType="VARCHAR" />    <result column="MOUTH" property="mouth" jdbcType="VARCHAR" />    <result column="GRJJ" property="grjj" jdbcType="VARCHAR" />  </resultMap>  <sql id="Base_Column_List" >    ID, NAME, SEX, NF, MOUTH, GRJJ  </sql>  <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.Long" >    select     <include refid="Base_Column_List" />    from T_USER    where ID = #{id,jdbcType=DECIMAL}  </select>  <delete id="deleteByPrimaryKey" parameterType="java.lang.Long" >    delete from T_USER    where ID = #{id,jdbcType=DECIMAL}  </delete>  <insert id="insert" parameterType="com.zscs.model.User" >    insert into T_USER (ID, NAME, SEX,       NF, MOUTH, GRJJ)    values (#{id,jdbcType=DECIMAL}, #{name,jdbcType=VARCHAR}, #{sex,jdbcType=VARCHAR},       #{nf,jdbcType=VARCHAR}, #{mouth,jdbcType=VARCHAR}, #{grjj,jdbcType=VARCHAR})  </insert>  <insert id="insertSelective" parameterType="com.zscs.model.User" >    insert into T_USER    <trim prefix="(" suffix=")" suffixOverrides="," >      <if test="id != null" >        ID,      </if>      <if test="name != null" >        NAME,      </if>      <if test="sex != null" >        SEX,      </if>      <if test="nf != null" >        NF,      </if>      <if test="mouth != null" >        MOUTH,      </if>      <if test="grjj != null" >        GRJJ,      </if>    </trim>    <trim prefix="values (" suffix=")" suffixOverrides="," >      <if test="id != null" >        #{id,jdbcType=DECIMAL},      </if>      <if test="name != null" >        #{name,jdbcType=VARCHAR},      </if>      <if test="sex != null" >        #{sex,jdbcType=VARCHAR},      </if>      <if test="nf != null" >        #{nf,jdbcType=VARCHAR},      </if>      <if test="mouth != null" >        #{mouth,jdbcType=VARCHAR},      </if>      <if test="grjj != null" >        #{grjj,jdbcType=VARCHAR},      </if>    </trim>  </insert>  <update id="updateByPrimaryKeySelective" parameterType="com.zscs.model.User" >    update T_USER    <set >      <if test="name != null" >        NAME = #{name,jdbcType=VARCHAR},      </if>      <if test="sex != null" >        SEX = #{sex,jdbcType=VARCHAR},      </if>      <if test="nf != null" >        NF = #{nf,jdbcType=VARCHAR},      </if>      <if test="mouth != null" >        MOUTH = #{mouth,jdbcType=VARCHAR},      </if>      <if test="grjj != null" >        GRJJ = #{grjj,jdbcType=VARCHAR},      </if>    </set>    where ID = #{id,jdbcType=DECIMAL}  </update>  <update id="updateByPrimaryKey" parameterType="com.zscs.model.User" >    update T_USER    set NAME = #{name,jdbcType=VARCHAR},      SEX = #{sex,jdbcType=VARCHAR},      NF = #{nf,jdbcType=VARCHAR},      MOUTH = #{mouth,jdbcType=VARCHAR},      GRJJ = #{grjj,jdbcType=VARCHAR}    where ID = #{id,jdbcType=DECIMAL}  </update></mapper>

七、编写UserMapper.java

package com.zscs.dao;import com.zscs.model.User;public interface UserMapper {    int deleteByPrimaryKey(Long id);    int insert(User record);    int insertSelective(User record);    User selectByPrimaryKey(Long id);    int updateByPrimaryKeySelective(User record);    int updateByPrimaryKey(User record);}

八、编写测试类

package com.zscs.mytest;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 com.zscs.dao.UserMapper;import com.zscs.model.User;@RunWith(SpringJUnit4ClassRunner.class)//使用Spring的测试框架@ContextConfiguration("/applicationContext.xml") //加载配置public class TestMyBatis {@Autowiredprivate UserMapper userMapper;@Testpublic void findUser(){User user=userMapper.selectByPrimaryKey(Long.parseLong("1"));user.setName("霍建华");int i=userMapper.updateByPrimaryKey(user);System.out.println(i==1 ? "更新成功":"更新失败");user=userMapper.selectByPrimaryKey(Long.parseLong("1"));System.out.println(user);}}