03_增删改查的实现

主要思路：

1.搭建mybatis主要框架

2.进行增删改查的实现。

步骤：①在接口中定义方法；②在UserMapper.xml中对应写sql语句；③测试。

UserDao.java

package com.geng.dao;

import com.geng.pojo.User;

import java.util.List;

public interface UserDao {
    // 查
    List<User> getUserList();

    //
    User getUserById(int i);

    // insert
    int addUser(User user);

    // update
    int updateUser(User user);

    // delete
    int deleteUser(int id);
}

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.geng.dao.UserDao">
    <select id="getUserList" resultType="com.geng.pojo.User">
        select * from mybatis.user
    </select>

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

    <insert id="addUser" parameterType="com.geng.pojo.User">
        insert into mybatis.user (id, name, pwd) values (#{id}, #{name}, #{pwd})
    </insert>

    <update id="updateUser" parameterType="com.geng.pojo.User" >
        update mybatis.user set name=#{name}, pwd=#{pwd} where id = #{id};
    </update>

    <delete id="deleteUser" parameterType="int">
        delete from mybatis.user where id = #{id}
    </delete>
</mapper>

UserDaoTest.java

package com.geng.dao;

import com.geng.pojo.User;
import com.geng.utils.MybatisUtil;
import org.apache.ibatis.session.SqlSession;
import org.junit.Test;

import java.util.List;

public class UserDaoTest {
    @Test
    public void selectTest(){
        SqlSession sqlSession = MybatisUtil.getSqlSession();
        UserDao mapper = sqlSession.getMapper(UserDao.class);
        List<User> userList = mapper.getUserList();
        for (User user : userList) {
            System.out.println(user);
        }
        sqlSession.close();
    }

    @Test
    public void selectByIdTest(){
        SqlSession sqlSession = MybatisUtil.getSqlSession();
        UserDao mapper = sqlSession.getMapper(UserDao.class);
        User user = mapper.getUserById(2);
        System.out.println(user);

        sqlSession.close();
    }

    @Test
    public void insertTest(){
        SqlSession sqlSession = MybatisUtil.getSqlSession();
        UserDao mapper = sqlSession.getMapper(UserDao.class);
        int size = mapper.addUser(new User(1, "gengsj", "11111"));
        if(size > 0){
            System.out.println("insert success");
        }
        sqlSession.commit();

        sqlSession.close();

    }

    @Test
    public void updateTest(){
        SqlSession sqlSession = MybatisUtil.getSqlSession();
        UserDao mapper = sqlSession.getMapper(UserDao.class);
        int i = mapper.updateUser(new User(1, "iamok", "343234"));
        if(i > 0){
            System.out.println("update success");
        }
        sqlSession.commit();

        sqlSession.close();
    }

    @Test
    public void deleteTest(){
        SqlSession sqlSession = MybatisUtil.getSqlSession();
        UserDao mapper = sqlSession.getMapper(UserDao.class);
        int i = mapper.deleteUser(1);
        if(i > 0){
            System.out.println("delete success");
        }
        sqlSession.commit();

        sqlSession.close();

    }
}

注意点：

增删查改需要提交事务！

bug

插入时把 insert 写成了 select！！！这里犯了两次错！！！

删除的sql语句写错了，忘掉了“from”

update语句不会写！！！

 

2021.6.5 上海漕河泾