UserMapper
package com.bing.dao;
import com.bing.pojo.User;
import org.apache.ibatis.annotations.*;
import java.util.List;
import java.util.Map;
public interface UserMapper {
// @Select("select * from mybatis.user")
// List getUsers();
//
// //有多个参数时候,用@Param
// @Select("select * from mybatis.user where id = #{id}")
// User getUserById(@Param("id") int id);
//引用对象不需要写@Param
@Insert("insert into mybatis.user(id,name,pwd) values (#{id},#{name},#{password})")
int addUser(User user);
// @Update("update mybatis.user set name=#{name},pwd=#{password} where id=#{id}")
// int updateUser(User user);
@Update("update mybatis.user set name=#{name},pwd=#{password} where id=#{id}")
int updateUser(User user);
@Delete("delete from user where id=#{uid}")
int deleteUser(@Param("uid") int id);
}
User
package com.bing.pojo;
import lombok.AllArgsConstructor;
import lombok.Data;
@AllArgsConstructor
public class User {
private int id;
private String name;
private String password;
// public User() {
// }
//
// public User(int id, String name, String password) {
// this.id = id;
// this.name = name;
// this.password = password;
// }
//
// public int getId() {
// return id;
// }
//
// public void setId(int id) {
// this.id = id;
// }
//
// public String getName() {
// return name;
// }
//
// public void setName(String name) {
// this.name = name;
// }
//
// public String getPassword() {
// return password;
// }
//
// public void setPassword(String password) {
// this.password = password;
// }
//
// public User(int id) {
// this.id = id;
// }
//
//
//
//
// @Override
// public String toString() {
// return "User{" +
// "id=" + id +
// ", name='" + name + ''' +
// ", pwd='" + password + ''' +
// '}';
// }
}
MybatisUtils.java
//不用手动去commit了(加上true)
SqlSession sqlession = sqlSessionFactory.openSession(true);
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;
public class MybatisUtils {
//相当于数据库连接池
private static SqlSessionFactory sqlSessionFactory;
static {
try {
String resource = "mybatis-config.xml";
InputStream inputStream = Resources.getResourceAsStream(resource);
sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
} catch (IOException e) {
e.printStackTrace();
}
}
public static SqlSession getSqlSession(){
//不用手动去commit了
SqlSession sqlession = sqlSessionFactory.openSession(true);
return sqlession;
}
}
db.properties
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
UserDaoTest
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;
public class UserDaoTest {
// static Logger logger = Logger.getLogger(UserDaoTest.class);
//
// @Test
// public void test() {
// SqlSession sqlSession = MybatisUtils.getSqlSession();
//
// UserMapper mapper = sqlSession.getMapper(UserMapper.class);
//
// List userList = mapper.getUserList();
//
// for (User user : userList) {
// System.out.println(user);
// }
// sqlSession.close();
// }
// @Test
// public void getById() {
logger.error("哈哈哈哈哈哈哈哈哈哈");
// SqlSession sqlSession = MybatisUtils.getSqlSession();
// UserMapper mapper = sqlSession.getMapper(UserMapper.class);
// User user = mapper.getUser(1);
// System.out.println(user);
// }
//
@Test
public void log4jTest(){
logger.debug("debug:进入了log4jTest");
logger.error("error:进入了log4jTest");
}
//
// @Test
// public void getUserByLimit(){
// SqlSession sqlSession = MybatisUtils.getSqlSession();
// UserMapper mapper = sqlSession.getMapper(UserMapper.class);
//
// HashMap map = new HashMap();
//
// map.put("startIndex",0);
// map.put("pageSize",2);
// List userList = mapper.getUserByLimit(map);
//
// for (User user : userList) {
// System.out.println(user);
// }
//
// sqlSession.close();
//}
@Test
public void test(){
SqlSession sqlSession = MybatisUtils.getSqlSession();
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
//mapper.addUser(new User(6, "吃不饱", "123434"));
//mapper.updateUser(new User(6,"穿不暖","12345567"));
mapper.deleteUser(1);
sqlSession.close();
}
}



