Mybatis——删除数据

删除操作

删除同更新操作类似，在映射器接口UserMapper中定义如下方法：

package org.example.mapper;

import org.example.demo.User;

import java.util.List;

public interface UserMapper {
    int deleteUser(Integer userId);
}

在映射文件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="org.example.mapper.UserMapper">
    <delete id="deleteUser" parameterType="org.example.demo.User">
        delete from t_user where user_id = #{userId};
    </delete>
</mapper>

编写测试代码:

package org.example;

import org.apache.ibatis.session.SqlSession;
import org.example.demo.Order;
import org.example.demo.User;
import org.example.demo2.Employee;
import org.example.demo2.SalaryEmployee;
import org.example.mapper.EmployeeMapper;
import org.example.mapper.UserMapper;
import org.example.utils.MybatisUtil;

import java.util.List;

public class test {
    public static void main(String[] args) {
        test test1 = new test();
        test1.deleteUser();

    }   
 
    public void deleteUser() {
        SqlSession sqlSession = MybatisUtil.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);

        int num = mapper.deleteUser(3);
        System.out.println(num);

        sqlSession.commit();
        sqlSession.close();
    }
}

 得到结果：