mybatis学习笔记(二) --- 熟悉增删查改

对上一篇的环境已经搭建好了

这次我们来熟悉一下mybatis 的增删查改

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="wuli"其实是可以随便写的,就是对这个mapper的简称,在测试的时候可以简便一点写-->
<mapper namespace = "wuli">

    <select id="getUser" parameterType="int" resultType="com.User">
        select * from user where id=#{id}
    </select>

    <select id="getAllUser" resultType="com.User">
        SELECT * FROM user
    </select>

    <insert id="addUser" parameterType="com.User">
        INSERT INTO user(name) VALUES(#{name})
    </insert>

    <update id="updateUser" parameterType="com.User">
        UPDATE user SET name=#{name} WHERE id=#{id}
    </update>

    <delete id="deleteUser" parameterType="int">
        DELETE FROM user WHERE id=#{id}
    </delete>
</mapper>

而测试类也增加了一些方法:

package com.test;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.junit.Test;

import java.io.IOException;
import java.io.Reader;
import java.util.List;

/**
 * Created by cfxd000 on 2016/10/27.
 */
public class testUser {
    @Test
    public void test1() throws IOException {
        System.out.println("test1");
        Reader reader = Resources.getResourceAsReader("config.xml");
        SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(reader);
        SqlSession session = factory.openSession(true); //自动提交

        String statement = "wuli.getUser";
        User user1 = session.selectOne(statement,1);
        System.out.println(user1);

        String stament2 = "wuli.getAllUser";
        List<User> allUser = session.selectList(stament2);
        System.out.println(allUser);

        String stament3 = "wuli.addUser";
        User user3 = new User(3,"k9999");
        int result3 = session.insert(stament3,user3);
        System.out.println(result3);

        String stament4 = "wuli.updateUser";
        User user4 = new User(1,"User:update4");
        int result4 = session.update(stament4,user4);
        System.out.println(result4);

        String stament5 = "wuli.deleteUser";
        int result5 = session.delete(stament5,2);
        System.out.println(result5);
    }
}