接口UserMapper
package com.wzx.mapper;
import com.wzx.pojo.Users;
import org.apache.ibatis.annotations.Param;
import java.util.Date;
import java.util.List;
import java.util.Map;
public interface UserMapper {
//查询去拿不用户信息
List getAll();
//根据用户主键查用户
Users getById(Integer id);
//根据用户名模糊查询用户
List getByName(String name);
//用户的更新
int update(Users users);
//根据主键删除用户
int delete(Integer id);
//增加用户
int insert(Users users);
//模糊用户名和地址查询
List getByNameOrAddress(
@Param("columnName") String columnName,
@Param("columnValue") String columnValue);
//按照指定的条件进行多条件查询
List getByCondition(Users users);
//有选择的更新
int updateBySet(Users users);
//查询多个指定id的用户信息
List getByIds(Integer []arr);
//批量删除
int deleteBatch(Integer []arr);
//批量增加
int insertBatch(List list);
//查询指定日期范围内的用户
List getByBirthday(Date begin, Date end);
//入参是map
List getByMap(Map map);
//返回值是map(一行)
Map getReturnMap(Integer id);
//返回值是map(多行)
List
UserMapperxml
id, username, birthday, sex, address
测试类
package com.wzx;
import com.wzx.mapper.UserMapper;
import com.wzx.pojo.Users;
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 org.junit.After;
import org.junit.Before;
import org.junit.Test;
import java.io.IOException;
import java.io.InputStream;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.*;
public class MyTest {
SqlSession sqlSession;
UserMapper mapper;
SimpleDateFormat sf = new SimpleDateFormat("yyyy-MM-dd");
@Before
public void openSqlSession() throws IOException {
//读取核心配置文件
InputStream in = Resources.getResourceAsStream("SqlMapConfig.xml");
//创建SqlSessionFactory对象
SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(in);
//取出SqlSession对象
sqlSession = factory.openSession();
//取出动态代理的对象，完成接口中方法的调用，实则是使用xml文件中的标签的功能
mapper = sqlSession.getMapper(UserMapper.class);
}
@After
public void closeSqlSession() {
sqlSession.close();
}
@Test
public void testGetAll() {
// 就是在调用接口的方法，mybatis框架已经为我们把功能代理出来了
List list = mapper.getAll();
System.out.println(list);
list.forEach(users -> System.out.println(users));
}
@Test
public void testupdate() throws ParseException {
Users u = new Users(7, "wzx", sf.parse("2001-01-01"), "2", "asd");
int update = mapper.update(u);
System.out.println(update);
sqlSession.commit();
}
@Test
public void selectById() {
Users byId = mapper.getById(7);
System.out.println(byId);
}
@Test
public void getByName(){
List name = mapper.getByName("张");
name.forEach(users -> System.out.println(users));
}
@Test
public void delete(){
int delete = mapper.delete(7);
System.out.println(delete);
sqlSession.commit();
}
@Test
public void insert() throws ParseException {
Users users = new Users(8, "asd", sf.parse("2022-11-22"), "1", "asd");
int insert = mapper.insert(users);
System.out.println(insert);
sqlSession.commit();
}
@Test
public void testGetByCondition(){
Users users = new Users();
// users.setSex("1");
// users.setUserName("小");
// users.setAddress("南");
List list=mapper.getByCondition(users);
list.forEach(useruser -> System.out.println(useruser));
for (Users users1 : list) {
System.out.println(users1);
}
}
@Test
public void testUpdateSet(){
Users users = new Users();
users.setId(6);
users.setUserName("lla");
int update = mapper.updateBySet(users);
System.out.println(update);
sqlSession.commit();
}
@Test
public void testGetByIds(){
Integer []array={2,4,6};
List byIds = mapper.getByIds(array);
byIds.forEach(userss -> System.out.println(userss));
}
@Test
public void testDeleteBatch(){
Integer []array={2,4};
int i = mapper.deleteBatch(array);
sqlSession.commit();
System.out.println(i);
}
@Test
public void testInsertBatch() throws ParseException {
Users u1 = new Users("aa", sf.parse("2002-02-02"), "2", "朝阳1");
Users u2 = new Users("bb", sf.parse("2002-02-02"), "2", "朝阳2");
Users u3 = new Users("cc", sf.parse("2002-02-02"), "2", "朝阳3");
Users u4 = new Users("dd", sf.parse("2002-02-02"), "2", "朝阳4");
List list=new ArrayList<>();
list.add(u1);
list.add(u2);
list.add(u3);
list.add(u4);
int i = mapper.insertBatch(list);
sqlSession.commit();
System.out.println(i);
}
@Test
public void testGetBirthday() throws ParseException {
Date begin = sf.parse("1999-01-01");
Date end = sf.parse("2001-12-31");
List list = mapper.getByBirthday(begin,end);
list.forEach(userss -> System.out.println(userss));
}
@Test
public void testGetMap() throws ParseException {
Date begin=sf.parse("1999-01-01");
Date end=sf.parse("1999-12-31");
Map map = new HashMap<>() ;
map.put("birthdayBegin",begin);
map.put("birthdayEnd",end);
List list=mapper.getByMap(map);
}
@Test
public void testgetReturnMap(){
Map returnMap = mapper.getReturnMap(3);
System.out.println(returnMap);
}
@Test
public void testgetMulMap(){
List
