Mybatis增删改查

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.li.mapper.UserMapper">
	<!--查-->
    <select id="getUserList" resultType="com.li.pojo.User">
        select * from test
    </select>
    <select id="getListbyId" resultType="com.li.pojo.User" parameterType="String">
        select * from test where id= #{id}
    </select>
    
    <!--增-->
    <insert id="addUser" parameterType="com.li.pojo.User">
        insert into mybatis.test(id,name,psw) values(#{id},#{name},#{psw})
    </insert>
    
    <!--删-->
    <delete id="removeUser" parameterType="com.li.pojo.User">
        delete from test where id = #{id}
    </delete>
    
    <!--改-->
    <update id="updateUser" parameterType="com.li.pojo.User">
        update test set name=#{name},psw=#{psw} where id=#{id}
    </update>
</mapper>
<!--
    int addUser(User user);
    int removeUser(String id);
    int updateUser(User user);
-->

测试

package com.li.mapper;

import com.li.pojo.User;
import com.li.utils.MybatisUtils;
import org.apache.ibatis.session.SqlSession;
import org.junit.jupiter.api.Test;

import java.util.List;

public class MapperTest {
    @Test
    public void test(){
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        List<User> userList = mapper.getUserList();
        for (User user : userList) {
            System.out.println(user);
        }
    }
    @Test
    public void byidtest(){
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        List<User> listbyId = mapper.getListbyId("01");
        System.out.println(listbyId);
    }
    @Test
    public void add(){
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        int res = mapper.addUser(new User("03", "小赵", "333"));
        if (res>0){
            System.out.println("插入成功");
            sqlSession.commit();
            sqlSession.close();
        }
    }
    @Test
    public void remove(){
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        int i = mapper.removeUser("02");
        if (i>0){
            sqlSession.commit();
            sqlSession.close();
            System.out.println("1");
        }
    }
    @Test
    public void update(){
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        int i = mapper.updateUser(new User("03","aaaa","232"));
        if (i>0){
            sqlSession.commit();
            sqlSession.close();
            System.out.println("1");
        }
    }

}