03-增删改查实现

List getUserList();

//根据ID查询用户

User getUserById(int id);

//增加一个用户

int addUser(User user);

//修改一个用户

int updateUser(User user);

//删除一个用户

int delUser(int id);

}

2.编写对应的mapper中的sql语句

---

代码演示

<?xml version="1.0" encoding="UTF-8" ?>

select * from mybatis.user

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};

3.测试

---

代码演示

package com.tian.dao;

import com.tian.pojo.User;

import com.tian.utils.MybatisUtils;

import org.apache.ibatis.session.SqlSession;

import org.junit.Test;

import java.util.List;

public class UserMapperTest {

@Test

public void test(){

//获得sqlsession对象

SqlSession sqlSession = MybatisUtils.getSqlSession();

//方式一：getMapper 执行sql

UserMapper userMapper = sqlSession.getMapper(UserMapper.class);

List userList = userMapper.getUserList();

for (User user : userList) {

System.out.println(user);

}

//关闭sqlsession

sqlSession.close();

}

@Test

public void getUserById(){

SqlSession sqlSession = MybatisUtils.getSqlSession();

UserMapper userMapper = sqlSession.getMapper(UserMapper.class);

User userById = userMapper.getUserById(1);

System.out.println(userById);

//关闭sqlsession

sqlSession.close();

}

//增删改需要提交事务 sqlSession.commit();

@Test

public void addUser(){

SqlSession sqlSession = MybatisUtils.getSqlSession();

UserMapper userMapper = sqlSession.getMapper(UserMapper.class);

int i = userMapper.addUser(new User(4, “哈哈”, “123456”));

System.out.println(i);

//提交事务

sqlSession.commit();

sqlSession.close();

}

@Test

public void updateUser(){

SqlSession sqlSession = MybatisUtils.getSqlSession();

UserMapper userMapper = sqlSession.getMapper(UserMapper.class);

userMapper.updateUser(new User(4,“呵呵”,“123123”));

//提交事务

sqlSession.commit();
网上学习资料一大堆，但如果学到的知识不成体系，遇到问题时只是浅尝辄止，不再深入研究，那么很难做到真正的技术提升。

需要系统化学习资料的朋友，可以戳这里获取