MyBatis之增删改查

最新推荐文章于 2025-04-07 23:31:55 发布

原创最新推荐文章于 2025-04-07 23:31:55 发布 · 253 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

收录于

Java

增删改查

1、编写接口

package com.erdan.mapper;

import com.erdan.pojo.User;

import java.util.List;

// 操作用户的接口类
public interface UserMapper {

    //查询全部用户
    List<User> getUserList();

    //根据ID查询用户
    User getUserById(int id);

    //insert一个用户
    int addUser(User user);

    //修改用户
    int updateUser(User user);

    int deleteUser(int id);

}

2、配置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">
<!-- 原来我们都是编写具体的执行sql -->
<mapper namespace="com.erdan.mapper.UserMapper">

    <select id="getUserList" resultType="com.erdan.pojo.User">
        select * from mybatis.user
    </select>

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

    <!--对象中的属性可以直接取到-->
    <insert id="addUser" parameterType="com.erdan.pojo.User">
        insert into mybatis.user (id,name,pwd) values (#{id},#{name},#{pwd})
    </insert>

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

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

3、运行测试

import com.erdan.mapper.UserMapper;
import com.erdan.pojo.User;
import com.erdan.utils.MyBatisUtils;
import org.apache.ibatis.session.SqlSession;

public class Test {
    public static void main(String[] args) {
        SqlSession session = MyBatisUtils.getSession();
        UserMapper mapper = session.getMapper(UserMapper.class);

        int resu = mapper.deleteUser(5);

        if (resu>0){
            System.out.println("删除成功");
        }

        //提交事务 最重要 否则 数据库不会发生改变
        session.commit();

        session.close();
    }
}