MyBatis实现增删改查

这里一定要注意的是：增删改都需要提交事务才可以生效

import com.caoyuqi.dao.UserDao;
import com.caoyuqi.model.User;
import com.caoyuqi.utils.MybatisUtils;
import org.apache.ibatis.session.SqlSession;
import org.junit.Test;

import java.util.List;

public class UserTest {
    @Test
    public void testQuery() {
        SqlSession mapping = MybatisUtils.getSession();
        UserDao mapper = mapping.getMapper(UserDao.class);
        List<User> allUser = mapper.getAllUser();
        for (User user :
                allUser) {
            System.out.println(user);
        }

    }

    @Test
    public void GetUserById() {
        SqlSession session = MybatisUtils.getSession();
        UserDao mapper = session.getMapper(UserDao.class);
        User user = mapper.QueryUserById(2);
        System.out.println(user);
        session.close();

    }

    @Test
    public void insertInto() {
        SqlSession session = MybatisUtils.getSession();
        UserDao mapper = session.getMapper(UserDao.class);
        int result = mapper.InsertIntoUser(new User(7, "刘德华", "123"));
        if (result > 0) {
            System.out.println("插入成功");
        }
        session.commit();

        session.close();

    }

    @Test
    public void updateUser() {
        SqlSession session = MybatisUtils.getSession();
        UserDao mapper = session.getMapper(UserDao.class);
        int zhangxueyou = mapper.updateUser(new User(7, "张学友", "12345"));
        if (zhangxueyou > 0) {
            System.out.println("更新成功");
        }
        session.commit();
        session.close();
    }

    @Test
    public void deleteUser()
    {
        SqlSession session = MybatisUtils.getSession();
        UserDao mapper = session.getMapper(UserDao.class);
        mapper.deleteUser(1);
        session.commit();
        session.close();
    }
}

开始和结尾都一样，都需要获取session再通过session获取mapper

package com.caoyuqi.dao;

import com.caoyuqi.model.User;

import java.util.List;

public interface UserDao {
    List<User> getAllUser();
    User QueryUserById(int id);
    int InsertIntoUser(User user);
    int updateUser(User user);
    void deleteUser(int id);
}

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.caoyuqi.dao.UserDao">
    <update id="updateUser" parameterType="com.caoyuqi.model.User">
        update user.man set username=#{username},pwd =#{pwd} where id =#{id};
    </update>
    <delete id="deleteUser" parameterType="int">
        delete  from user.man where id = #{id}
    </delete>

    <select id="QueryUserById"  resultType="com.caoyuqi.model.User" parameterType="int">
        select * from user.man where id = #{id};
    </select>
    <select id="getAllUser" resultType="com.caoyuqi.model.User">
        select * from User.man;
    </select>
    <insert id="InsertIntoUser" parameterType="com.caoyuqi.model.User">
        insert into man(id,username,pwd) values (#{id},#{username},#{pwd})
    </insert>
</mapper>

以上便实现了最基础的crud