Annotation实现CRUD

# MyBatis实现注解形式的CURD

# 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);

}

1
2
3
4
5
6

【示例：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 ? "增加成功" : "增加失败");
    }
}

1
2
3
4
5
6
7
8
9
10
11
12
13

# 2、删除操作

【示例：UserMapper.java】

public interface UserMapper {

    @Delete(value = "DELETE FROM goku.g_users WHERE userid=#{userid}")
    boolean delUser(int userid);
}

1
2
3
4
5

【示例：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();
    }
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14

# 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);


}

1
2
3
4
5
6
7

【示例：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 ? "修改成功" : "修改失败");
    }
}

1
2
3
4
5
6
7
8
9
10
11
12
13

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

1
2
3
4
5
6
7
8

【示例：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();
    }
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21

编辑

#MyBatis

← XML实现CRUD 万能Map→