1、增加操作
【示例：UserMapper.java】
public interface UserMapper {
@Insert(value = "INSERT INTO g_users VALUE (NULL,#{username},#{userphone},#{userpassword},0,now(),now(),1)")
boolean addUser(User user);
}
【示例：UserMapperTest.java】
public class UserMapperTest {
private SqlSession sqlSession = MyBatisUtils.getSqlSession();
private UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
@Test
public void addUser() {
User user = new User("张欣", "5465432543453", "assam1314520");
boolean flag = userMapper.addUser(user);
sqlSession.commit();
System.out.println(flag ? "增加成功" : "增加失败");
}
}
2、删除操作
【示例：UserMapper.java】
public interface UserMapper {
@Delete(value = "DELETE FROM goku.g_users WHERE userid=#{userid}")
boolean delUser(int userid);
}
【示例：UserMapperTest.java】
public class UserMapperTest {
private SqlSession sqlSession = MyBatisUtils.getSqlSession();
private UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
@Test
public void delUser() {
boolean flag = userMapper.delUser(15);
//必须要提交
sqlSession.commit();
System.out.println(flag ? "删除成功" : "删除失败");
sqlSession.close();
}
}
3、修改操作
【示例：UserMapper.java】
public interface UserMapper {
@Update(value = "UPDATE g_users SET username=#{username},userphone=#{userphone},userpassword=#{userpassword},jurisdiction=#{jurisdiction},userstatus=#{userstatus} WHERE userid=#{userid}")
boolean updateUser(@Param("username") String username, @Param("userphone") String userphone, @Param("userpassword") String userpassword, @Param("jurisdiction") int jurisdiction, @Param("userstatus") int userstatus, @Param("userid") int userid);
}
【示例：UserMapperTest.java】
public class UserMapperTest {
private SqlSession sqlSession = MyBatisUtils.getSqlSession();
private UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
@Test
public void updateUser() {
boolean flag = userMapper.updateUser("测试测试测试", "1444444444", "123456", 1, 1, 5);
//必须要提交
sqlSession.commit();
System.out.println(flag ? "修改成功" : "修改失败");
}
}
4、查询操作
【示例：UserMapper.java】
public interface UserMapper {
@Select(value = "select * from goku.g_users")
List<User> getUsers();
@Select(value = "select * from goku.g_users where userid = #{userid}")
User getUser(int userid);
}
【示例：UserMapperTest.java】
public class UserMapperTest {
private SqlSession sqlSession = MyBatisUtils.getSqlSession();
private UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
@Test
public void getUsers() {
List<User> users = userMapper.getUsers();
for (User user : users) {
System.out.println(user);
}
sqlSession.close();
}
@Test
public void getUser() {
User user = userMapper.getUser(2);
System.out.println(user);
sqlSession.close();
}
}
