mybatis结合spring使用mapper代理开发

xl_echo编辑整理

百战不败，依不自称常胜，百败不颓，依能奋力前行。——这才是真正的堪称强大！！！

---

开发项目步骤：

第一步：创建工程，按照图片搭建项目架构。

第二步：导包，以下就是全部所需要的包

第三步：编写spring核心配置文件，在核心配置文件中只有三部分类容

• • 
    
• 数据库连接池
• 配置管理sqlSessionFactory
• 配置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>

</configuration>

第五步：创建实体类

package com.echo.mybatis.pojo;

import java.util.Date;

public class User {

    private Integer id;
    private String username;// 用户姓名
    private String sex;// 性别
    private Date birthday;// 生日
    private String address;// 地址

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getSex() {
        return sex;
    }

    public void setSex(String sex) {
        this.sex = sex;
    }

    public Date getBirthday() {
        return birthday;
    }

    public void setBirthday(Date birthday) {
        this.birthday = birthday;
    }

    public String getAddress() {
        return address;
    }

    public void setAddress(String address) {
        this.address = address;
    }

    @Override
    public String toString() {
        return "User [id=" + id + ", username=" + username + ", sex=" + sex + ", birthday=" + birthday + ", address="
                + address + "]";
    }

}

第六步：创建映射包，将接口和映射文件放在一起

package com.echo.mybatis.mapper;

import com.echo.mybatis.pojo.User;

public interface UserMapper {

    User selectByPrimaryKey(Integer id);

}

<?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.echo.mybatis.mapper.UserMapper" >
  <resultMap id="BaseResultMap" type="com.echo.mybatis.pojo.User" >
    <id column="id" property="id" jdbcType="INTEGER" />
    <result column="username" property="username" jdbcType="VARCHAR" />
    <result column="birthday" property="birthday" jdbcType="DATE" />
    <result column="sex" property="sex" jdbcType="CHAR" />
    <result column="address" property="address" jdbcType="VARCHAR" />
  </resultMap>
  <sql id="Base_Column_List" >
    id, username, birthday, sex, address
  </sql>
  <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.Integer" >
    select 
    <include refid="Base_Column_List" />
    from user
    where id = #{id,jdbcType=INTEGER}
  </select>
</mapper>

第七步:编写测试类

package com.echo.mybatis.test;

import java.io.IOException;
import org.junit.Before;
import org.junit.Test;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

import com.echo.mybatis.mapper.UserMapper;
import com.echo.mybatis.pojo.User;

public class UserMapperTest {

    private ApplicationContext applicationContext;

    @Before
    public void init() throws Exception {
        //初始化spring容器
        applicationContext = new ClassPathXmlApplicationContext("classpath:spring/applicationContext.xml");
    }

    @Test
    public void testInsertUser() throws IOException {

        UserMapper userMapper = (UserMapper) applicationContext.getBean("UserMapperID");
        //获得代理对象
        User user = userMapper.selectByPrimaryKey(10);

        System.out.println(user);
    }

}

项目源码：链接：​​https://pan.baidu.com/s/1SvXw0RIPIpfAb3k0aVwBjA​​ 密码：mctd