2.Mybatis增删改查

在前文已经配置好mybatis环境后简单的实现增删改查
注意：增加、删除、修改需要sqlsession.commit()提交事务
1.map传递参数，在map中设置key，key和sql语句中的变量一致即可
2.对象传递参数，sql语句中可以直接取到对象属性
3.只有一个变量类型时，直接在变量中取
UserMapper.java

package com.xzf.dao;

import com.xzf.pojo.User;

import java.util.List;

public interface UserMapper {
     List<User> getUsers();
     User getUserById(int id);
     int addUser(User user);
     int updateUser(User user);
     int deleteUser(User user);
     int addUserByMap(Map<String,Object> map);

}

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">

<!--
namespace:定义这个mapper绑定的dao
id:指定mapper绑定的方法
resultType：返回类型，若是集合需写泛型对象的全限定类名
-->
<mapper namespace="com.xzf.dao.UserMapper">
    <select id="getUsers" resultType="user">
    select * from user
     </select>

    <select id="getUserById" parameterType="int" resultType="user">
    select * from user where id = #{id};
    </select>

    <insert id="addUser" parameterType="user">
        insert into user(id,name,pwd) values (#{id},#{name},#{pwd});
    </insert>
    
    <insert id="addUserByMap" parameterType="map">
        insert into user(id,name,pwd) values (#{id},#{name},#{password});
    </insert>

    <update id="updateUser" parameterType="user">
        update user set name = #{name}  where id = #{id} ;
    </update>

    <delete id="deleteUser" parameterType="user">
        delete from user where id  = #{id};
    </delete>
</mapper>

测试

import com.xzf.dao.UserMapper;
import com.xzf.pojo.User;
import com.xzf.utils.MybatisUtil;
import org.apache.ibatis.session.SqlSession;
import org.junit.Test;

import java.util.List;

public class UserMapperTest {
    SqlSession sqlSession = MybatisUtil.getSqlSession();
    UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
    @Test
    public void test1(){
        List<User> users = userMapper.getUsers();
        System.out.println(users);
    }
    @Test
    public void test2(){
        User user = userMapper.getUserById(1);
        System.out.println(user);
    }
    @Test
    public void test3(){
        User user = new User();
        user.setName("徐子丰");
        user.setId(5);
        user.setPwd("1234");
        int a = userMapper.addUser(user);
        sqlSession.commit();
        sqlSession.close();
    }

    @Test
    public void test4(){
        User user = new User();
        user.setName("徐子丰");
        user.setId(4);
        int a = userMapper.updateUser(user);
        sqlSession.commit();
        sqlSession.close();
    }
    @Test
    public void test5(){
        User user = new User();
        user.setId(4);
        int a = userMapper.deleteUser(user);
        sqlSession.commit();
        sqlSession.close();
    }
        @Test
    public void test6(){
        Map<String,Object> map = new HashMap<String, Object>();
        map.put("id",6);
        map.put("name","sss");
        map.put("password","111");
        int a = userMapper.addUserByMap(map);
        sqlSession.commit();
        sqlSession.close();
    }
}