Mybatis学习笔记

Mybatis CRUD
我们只需要操作Usermapper接口和Usermapper.xml

Usermapper接口

public interface Usermapper {
    List<user> getUserlist();
    user getUserById(int id);
    int addUser(user u);
    int update(user u);
    int deleteuser(int id);
}

还有一种万能的写法int addUser2(Map<String,object> map)
Map<字段名,object> map
sql语句传入的参数就写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">
<mapper namespace="com.feng.dao.Usermapper">
    <select id="getUserlist" resultType="com.pojo.user">
        select * from mybatis.user;
    </select>
    <select id="getUserById" parameterType="int" resultType="com.pojo.user">
        select * from mybatis.user where id = #{id};
    </select>
    <insert id="addUser" parameterType="com.pojo.user">
        insert into mybatis.user (id,name,passwd) values (#{id},#{name},#{passwd});
    </insert>
    <update id="update" parameterType="com.pojo.user" >
        update mybatis.user set name =#{name},passwd=#{passwd} where id = #{id};
    </update>
    <delete id="deleteuser" parameterType="int">
        delete  from mybatis.user where id = #{id};
    </delete>

</mapper>

测试单元

@Test
    //增加用户
    public void addUser(){
        //通过我们写的工具类来获取产品sqlsession
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        Usermapper mapper = sqlSession.getMapper(Usermapper.class);
        mapper.addUser(new user(5,"小李","888888"));
        //提交事务
        sqlSession.commit();
        sqlSession.close();

    }
    @Test
    //更新用户
    public void update(){
        //通过我们写的工具类来获取产品sqlsession
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        Usermapper mapper = sqlSession.getMapper(Usermapper.class);
        mapper.update(new user(5,"老王","66666666"));
        //提交事务
        sqlSession.commit();
        sqlSession.close();

    }
    @Test
    //删除用户
    public void deleteuser(){
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        Usermapper mapper = sqlSession.getMapper(Usermapper.class);
        mapper.deleteuser(5);
        sqlSession.commit();
        sqlSession.close();
    }

CRUD注意事项:
1.增删改查必须要提交事务，不然无法生效；
2.namespace绑定包名必须用".“不能用”";
3.增删改查的标签需要对应;
4.resouces绑定需要用路径,不用"."

注解开发
适用于简单的CRUD，不适合用在复杂的CRUD当中；
具体步骤如下:
1.在接口中写入SQL语句，并且用对应的注解符号标记

2.在Configer.xml配置文件中绑定接口,<"mappers><"mapper class=“XXX.XXX.XXX”/><"mappers/>
3.测试