Mybatis-mapper动态代理

1.创建dao层 接口mapper

package com.chen.dao;

import com.chen.pojo.User;

import java.util.List;

public interface UserMapper {
    //根据id去查找
    User findById(Integer id);
    //添加
    int add(User user);
    //修改
    int update(User user);
    //删除
    int delete(Integer id);
    //查询所有
    List<User> findAll();
}

 2.配置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">
//namespac为 接口中的全类名
<mapper namespace="com.chen.dao.UserMapper">
//id 为 UserMapper中的方法名 parameterType可以省略
    <select id="findById" resultType="com.chen.pojo.User" parameterType="integer">
        select * from emp where id=#{id};
    </select>
    <insert id="add">
        insert into emp  values(null,#{name},#{job},#{salary});
    </insert>
    <update id="update">
        update emp set salary=salary+#{salary} where id=#{id};
    </update>
    <delete id="delete">
        delete from emp where id=#{id};
    </delete>
    <select id="findAll" resultType="com.chen.pojo.User">
        select * from emp
    </select>
</mapper> 

3.测试类

import java.io.IOException;
import java.io.InputStream;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

public class MybatisTest {
    private static SqlSessionFactory ssf=null;
    static {
        try {
            InputStream  is = Resources.getResourceAsStream("mybatis-config.xml");
            ssf=new SqlSessionFactoryBuilder().build(is);
        } catch (IOException e) {
            e.printStackTrace();
        }

    }
 @Test
//根据id查询
    public void findById(){
         SqlSession ss = ssf.openSession(true);
         UserMapper mapper = ss.getMapper(UserMapper.class);
         User byId = mapper.findById(13);
         System.out.println(byId);
     }
     @Test
//添加
    public void add(){
         SqlSession ss = ssf.openSession(true);
         UserMapper mapper = ss.getMapper(UserMapper.class);
         User user = new User();
         user.setName("小陈");
         user.setJob("程序员");
         user.setSalary(80000.0);
         int add = mapper.add(user);
         System.out.println(add);
     }
     @Test
//修改
    public void update(){
         SqlSession ss = ssf.openSession(true);
         UserMapper mapper = ss.getMapper(UserMapper.class);
         User user = new User();
         user.setSalary(6000.0);
         user.setId(20);
         int update = mapper.update(user);
         System.out.println(update);
     }
     @Test
//删除
    public void delete(){
         SqlSession ss = ssf.openSession(true);
         UserMapper mapper = ss.getMapper(UserMapper.class);
         int delete = mapper.delete(20);
         System.out.println(delete);
     }
     @Test
//查全部
    public void findAll(){
         SqlSession ss = ssf.openSession(true);
         UserMapper mapper = ss.getMapper(UserMapper.class);
         List<User> all = mapper.findAll();
         System.out.println(all);
     }
    }