mybatisCRUD

最新推荐文章于 2024-07-26 12:28:02 发布

~PA~

最新推荐文章于 2024-07-26 12:28:02 发布

阅读量54

点赞数

分类专栏： mybatis 文章标签： java mybatis

本文链接：https://blog.csdn.net/qq_51549750/article/details/123164707

版权

mybatis 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

Mybatis

1、MybatisCRUD

1.1、Mapepr接口

public interface UserMapper {

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

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

    //添加用户
    int addUser(User user);
    //万能的Map
    int addUser2(Map<String,Object> map);

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

    //删除用户
    int deleteUser(int id);

    //模糊查询
    List<User> getUserLike(String value);
}

1.2、mapper.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">
<!--nameplace=绑定一个对应的Dao/Mapper接口-->
<mapper namespace="com.kuang.dao.UserMapper">
    <select id="getUserList" resultType="com.kuang.pojo.User">
        select * from  user.user
    </select>

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

    <!--模糊查询-->
    <select id="getUserLike" resultType="com.kuang.pojo.User">
        select * from user.user where name like "%"#{value}"%"
    </select>

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

    <insert id="addUser2" parameterType="map">
        insert into user.user (id,name,pwd) values (#{userid},#{userName},#{password});
    </insert>

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

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

1.3、测试类

package com.kuang.dao;

import com.kuang.pojo.User;
import com.kuang.utils.MybatisUtils;
import org.apache.ibatis.session.SqlSession;
import org.junit.Test;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

public class UserMapperTest {
    @Test
    public void getUser(){
        //第一步：获取SqlSession对象
        SqlSession sqlSession= MybatisUtils.getSqlSession();

        //方式一：getMapper 获取接口
        UserMapper userMapper =sqlSession.getMapper(UserMapper.class);
        List<User> userList= userMapper.getUserList();

        for (User user : userList) {
            System.out.println(user);
        }

        //关闭SqlSession
        sqlSession.close();
    }

    @Test
    public void getUserById(){
        SqlSession sqlSession= MybatisUtils.getSqlSession();

        UserMapper mapper=sqlSession.getMapper(UserMapper.class);
        User user=mapper.getUserById(1);
        System.out.println(user);

        sqlSession.close();
    }

    //增删改查需要提交事务
    @Test
    public void addUser(){
        SqlSession sqlSession= MybatisUtils.getSqlSession();

        UserMapper mapper=sqlSession.getMapper(UserMapper.class);
        int res=mapper.addUser(new User(4,"王五","111"));
        if(res>0){
            System.out.println("AddTrue");
        }

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

    @Test
    public void addUser2(){
        SqlSession sqlSession= MybatisUtils.getSqlSession();

        UserMapper mapper=sqlSession.getMapper(UserMapper.class);
        Map<String,Object> map=new HashMap<String,Object>();

        map.put("userid",5);
        map.put("userName","嘿嘿");
        map.put("password","222");

        mapper.addUser2(map);
        sqlSession.commit();
        sqlSession.close();
    }

    @Test
    public void updateUser(){
        SqlSession sqlSession= MybatisUtils.getSqlSession();

        UserMapper mapper=sqlSession.getMapper(UserMapper.class);
        int res=mapper.updateUser(new User(4,"嘿嘿","222"));
        if(res>0){
            System.out.println("UpdateTrue");
        }

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

    @Test
    public void deleteUser(){
        SqlSession sqlSession= MybatisUtils.getSqlSession();

        UserMapper mapper=sqlSession.getMapper(UserMapper.class);
        int res=mapper.deleteUser(4);
        if(res>0){
            System.out.println("DeleteTrue");
        }

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

    @Test
    public void getUserList(){
        SqlSession sqlSession= MybatisUtils.getSqlSession();

        UserMapper mapper=sqlSession.getMapper(UserMapper.class);
        List<User> userList=mapper.getUserLike("李");
        for (User user : userList) {
            System.out.println(user);
        }

        sqlSession.close();
    }
}