栏目分类:
子分类:
返回
名师互学网用户登录
快速导航关闭
当前搜索
当前分类
子分类
实用工具
热门搜索
名师互学网 > IT > 软件开发 > 后端开发 > Java

Mybatis实现CRUD

Java 更新时间: 发布时间: IT归档 最新发布 模块sitemap 名妆网 法律咨询 聚返吧 英语巴士网 伯小乐 网商动力

Mybatis实现CRUD

一、沿用上一篇博客“编写一个Mybatis程序”的项目 二、namespace

namespace中的包名要和Dao/mapper接口的包名一致!

三、根据ID查询用户 3.1、UserDao接口
//根据ID查询用户
    User getUserById(int id);
3.2、UserMapper.xml

        select * from mybatis.user where id = #{id}
    
3.3、UserDaoTest测试类
@Test
    public void getUserById(){
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        UserDao mapper = sqlSession.getMapper(UserDao.class);
        User user = mapper.getUserById(1);
        System.out.println(user);
        sqlSession.close();
    }
四、增加用户 4.1、UserDao接口
//增加一个用户
    int addUser(User user);
4.2、UserMapper.xml
    
        insert into mybatis.user(id , name , pwd)values (#{id} , #{name} , #{pwd})
    
4.3、UserDaoTest测试类
    //增删改需要提交事务
    @Test
    public void addUser(){
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        UserDao mapper = sqlSession.getMapper(UserDao.class);
        int i = mapper.addUser(new User(4, "杨过", "124567"));
        System.out.println("成功插入:" + i + "条数据");
        //提交事务
        sqlSession.commit();
        sqlSession.close();
    }
五、修改用户 5.1、UserDao接口
    //修改用户
    int updateUser(User user);
5.2、UserMapper.xml
   
        update mybatis.user set name = #{name} , pwd = #{pwd} where id = #{id};
    
5.3、UserDaoTest测试类
    @Test
    public void updateUser(){
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        UserDao mapper = sqlSession.getMapper(UserDao.class);
        int i = mapper.updateUser(new User(4, "黄桃", "133455"));
        System.out.println("成功修改:" + i + "条数据");
        //提交事务
        sqlSession.commit();
        sqlSession.close();
    }
六、删除用户 6.1、UserDao接口
    //删除用户
    int deleteUser(int id);
6.2、UserMapper.xml
    
        delete from mybatis.user where id = #{id};
    
6.3、UserDaoTest测试类
    @Test
    public void deleteUser(){
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        UserDao mapper = sqlSession.getMapper(UserDao.class);
        int i = mapper.deleteUser(4);
        System.out.println("成功删除:" + i + "条数据");
        sqlSession.commit();
        sqlSession.close();
    }
七、总体代码 7.1、UserDao接口
package com.massimo.dao;

import com.massimo.pojo.User;

import java.util.List;

public interface UserDao {
    //查询全部用户
    List getUserList();

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

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

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

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

7.2、UserMapper.xml




    
        select * from mybatis.user where id = #{id}
    


    
        insert into mybatis.user(id , name , pwd)values (#{id} , #{name} , #{pwd})
    

    
        update mybatis.user set name = #{name} , pwd = #{pwd} where id = #{id};
    


    
        delete from mybatis.user where id = #{id};
    

7.3、UserDaoTest测试类
package com.massimo.dao;

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

        import java.util.List;

public class UserDaoTest {
    @Test
    public void test(){
        //第一步:获得sqlSession对象
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        UserDao mapper = sqlSession.getMapper(UserDao.class);
        List userList = mapper.getUserList();

        for (User user : userList) {
            System.out.println(user);
        }
        //关闭sqlSession
        sqlSession.close();
    }

    @Test
    public void getUserById(){
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        UserDao mapper = sqlSession.getMapper(UserDao.class);
        User user = mapper.getUserById(1);
        System.out.println(user);
        sqlSession.close();
    }

    //增删改需要提交事务
    @Test
    public void addUser(){
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        UserDao mapper = sqlSession.getMapper(UserDao.class);
        int i = mapper.addUser(new User(4, "杨过", "124567"));
        System.out.println("成功插入:" + i + "条数据");
        //提交事务
        sqlSession.commit();
        sqlSession.close();
    }

    @Test
    public void updateUser(){
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        UserDaomapper = sqlSession.getMapper(UserDao.class);
        int i = mapper.updateUser(new User(4, "黄桃", "133455"));
        System.out.println("成功修改:" + i + "条数据");
        //提交事务
        sqlSession.commit();
        sqlSession.close();
    }

    @Test
    public void deleteUser(){
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        UserDao mapper = sqlSession.getMapper(UserDao.class);
        int i = mapper.deleteUser(4);
        System.out.println("成功删除:" + i + "条数据");
        sqlSession.commit();
        sqlSession.close();
    }
}

转载请注明:文章转载自 www.mshxw.com
本文地址:https://www.mshxw.com/it/952870.html
我们一直用心在做
关于我们 文章归档 网站地图 联系我们

版权所有 (c)2021-2022 MSHXW.COM

ICP备案号:晋ICP备2021003244-6号