结构目录有红线是因为没有添加相应的pom依赖
UserMapper
package com.bing.dao;
import com.bing.pojo.User;
import java.util.List;
import java.util.Map;
public interface UserMapper {
//查询全部用户
List getUserList();
//根据id查询用户
User getUserById(int id);
//插入用户
int addUser(User user);
//修改用户
int updateUser(User user);
//删除用户
int deleteUser(int id);
}
UserMapper.xml
MybatisUtils.java
package com.bing.utils;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import java.io.IOException;
import java.io.InputStream;
//SqlSeesionFactory-->SqlSession
public class MybatisUtils {
private static SqlSessionFactory sqlSessionFactory;
static {
try {
//获取sqlSessionFactory对象
String resource = "mybatis-config.xml";
InputStream inputStream = Resources.getResourceAsStream(resource);
sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
} catch (IOException e) {
e.printStackTrace();
}
}
//获得SqlSession实例
public static SqlSession getSqlSession(){
SqlSession sqlSession = sqlSessionFactory.openSession();
return sqlSession;
//return sqlSessionFactory.openSession();
}
}
db.properties(如果mysql是8.0+,url后面应该加上时区)
driver=com.mysql.cj.jdbc.Driver url=jdbc:mysql://localhost:3306/mybatis?useSSL=false&useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC #username=root #password=123456
mybatis-config.xml(mybatis核心配置文件)
UserDaoTest(最好和dao层的Mapper和.xml同包下)
package com.bing.dao;
import com.bing.pojo.User;
import com.bing.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 UserDaoTest {
@Test
public void test() {
//获取SqlSession对象(相当于创建运行对象)
SqlSession sqlSession = MybatisUtils.getSqlSession();
//执行sql
//mapper就是一个具体的对象
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
List userList = mapper.getUserList();
for (User user : userList) {
System.out.println(user);
}
//关闭SqlSession
sqlSession.close();
}
@Test
public void getUserById() {
//获取SqlSession对象(相当于创建运行对象)
SqlSession sqlSession = MybatisUtils.getSqlSession();
//执行sql
//返回一个接口,mapper就是一个具体的对象
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 i = mapper.addUser(new User(4, "李逵", "123456"));
//就不用输出了
if (i > 0) {
System.out.println("插入成功");
}
//提交事务
sqlSession.commit();
sqlSession.close();
}
@Test
public void updateUser() {
SqlSession sqlSession = MybatisUtils.getSqlSession();
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
int i = mapper.updateUser(new User(4, "李狗蛋", "23"));
if (i > 0) {
System.out.println("更新成功");
}
sqlSession.commit();
sqlSession.close();
}
@Test
public void deleteUser(){
SqlSession sqlSession = MybatisUtils.getSqlSession();
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
int i = mapper.deleteUser(4);
if (i>0){
System.out.println("删除成功");
}
sqlSession.commit();
sqlSession.close();
}
}



