mybatis Generator 工具的使用 DML增删改
mybatis Generator 工具的使用 DML增删改
1.添加用户
点击查看代码
public static void main(String[] args) {
//添加用户
UsersService usersService = new UsersServiceImpl();
Users users = new Users();
users.setUsername("wwd");
users.setUsersex("nan");
int i = usersService.insertUsers(users);
System.out.println(i);
}
2.修改用户
点击查看代码
public int updateUsers(Users users) {
SqlSession sqlSession = MybatisUtils.getSqlSession();
UsersMapper mapper = sqlSession.getMapper(UsersMapper.class);
int i = mapper.updateByPrimaryKey(users);
sqlSession.commit();
return i;
}
3.删除用户
点击查看代码
public int deleteUsersById(int i) {
SqlSession sqlSession = MybatisUtils.getSqlSession();
UsersMapper mapper = sqlSession.getMapper(UsersMapper.class);
int i1 = mapper.deleteByPrimaryKey(i);
sqlSession.commit();
return i1;
}