Mybatis的CRUD

1、增删改必须提交事物

@Test//增删改需要提交事物
    public void addUser(){
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        int res = mapper.addUser(new User(4, "xiao", "1234567"));
        if(res>0){
            System.out.println("插入成功");
        }
        //提交事物
        sqlSession.commit();
        sqlSession.close();

<?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接口-->
<mapper namespace="com.lan.dao.UserMapper">
    <select id="getUserList" resultType="com.lan.pojo.User">
        select * from mybatis.user
    </select>
<!--    根据id查询对应的用户-->
    <select id="getUserById" parameterType="int" resultType="com.lan.pojo.User">
        select * from mybatis.user where id=#{id}
    </select>
    
    <insert id="addUser" parameterType="com.lan.pojo.User">
        insert into mybatis.user (id,name,pwd) values (#{id},#{name},#{pwd})
    </insert>

</mapper>

万能的Map：添加一个用户

values 里面的值可以随便区名字

2、模糊查询

模糊查询防止SQL注入，直接写死