Mybatis--------------------增删改查、主键返回

import com.dong.model.User;
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.After;
import org.junit.Before;
import org.junit.Test;

import java.io.IOException;
import java.io.InputStream;
import java.util.Date;
import java.util.List;

public class TestDemo {
    SqlSession sqlSession;

    @Before
    public void before() throws IOException {
        InputStream inputStream = Resources.getResourceAsStream("SqlMapConfig.xml");
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        sqlSession = sqlSessionFactory.openSession();

    }

    @After
    public void after() throws IOException {
        sqlSession.close();

    }
    //根据id查询数据
    @Test
    public void Test01(){
        User user= sqlSession.selectOne("findUserById",10);
        System.out.println(user);
    }
    //根据username模糊查询数据
    @Test
    public void Test02(){
        List<User> user = sqlSession.selectList("findUserByName", "张");
        System.out.println(user);
    }
    //增
    @Test
    public void Test03(){
        User user=new User("dong","男",new Date(),"深圳");

      int rownum = sqlSession.insert("InsertUser", user);
      sqlSession.commit();
        System.out.println("受影响的行："+rownum);
    }
    //改
    @Test
    public void Test04(){
        User user=new User();
        user.setSex("2");
     user.setId(28);
        int rownum = sqlSession.update("UpdateUser", user);
        sqlSession.commit();
        System.out.println("受影响的行："+rownum);
    }
    //删

    @Test
    public void Test05(){

        int rownum = sqlSession.delete("deleuser", 28);
        sqlSession.commit();
        System.out.println("受影响的行："+rownum);
    }

    //返回最后插入的id

    @Test
    public void Test06(){

        User user=new User("dong","男",new Date(),"深圳");

        int rownum = sqlSession.insert("InsertUser2", user);
        sqlSession.commit();
        System.out.println("id："+use