全部分页查询
select * from tb_user limit
PageHelper.startPage(pageSize,PageNumber);
userMapper.selectByExample(null);
@Service
public class TbUserDubboServiceImpl implements TbUserDubboService{
@Autowired
private UserMapper tbUserMapper;
@Override
public List<TbUser> selectAllUserByPage(int pageSize,int pageNumber){
PageHelper.startPage(pageSize,pageNumber);
List<TbItem> list=tbUserMapper.selectByExample(null);
PageInfo<TbItem> pageInfo=new PageInfo(list);
return pageInfo.getList();
}
}
获取计数
select count(*) from tb_user
userMapper.countByExample(null);
@Service
public class TbUserDubboServiceImpl implements TbUserDubboService{
@Autowired
private UserMapper tbUserMapper;
@Override
public long selectCount(){
return tbUserMapper.countByExample(null);
}
}
根据用户名查询
select * from tb_user where username=
UserExample example=new UserExample();
example.create.Criteria().andUsernameEqualTo(username);
userMapper.selectByExample(exmaple);
@Service
public class TbUserDubboServiceImpl implements TbUserDubboService{
@Autowired
private UserMapper tbUserMapper;
@Override
public TbUser selectUserByUsername(String username){
UserExample userExample=new UserExample();
userExample.createCriteria().andUsernameEqualTo(username);
List<User> list=tbUserMapper.selectByExample(userExample);
if(null != list && list.size()>0){
return list.get(0);
}
return null;
}
}
根据主键批量修改
update tb_user set status=
userMapper.updateByPrimaryKeySelective(tbUser);
@Service
public class TbUserDubboServiceImpl implements TbUserDubboService{
@Autowired
private UserMapper tbUserMapper;
@Override
@Transactional
public TbUser updateStatusByIds(long[] ids, int status) throws DaoException{
int index=0;
for(long id : ids){
TbUser tbUser=new TbUser();
tbUser.setId(id);
tbUser.setStatus((byte)status);
tbUser.setUpdateTime(new Date());
index +=tbUserMapper.updateByPrimaryKeySelective(tbUser);
}
if(index == ids.length){
return 1;
}
throw new DaoException("批量修改失败");
}
}
新增
insert into tb_user values(
userMapper.insert(tbUser)
@Service
public class TbUserDubboServiceImpl implements TbUserDubboService{
@Autowired
private UserMapper tbUserMapper;
@Override
@Transactional
public TbUser updateStatusByIds(TbUser tbUser) throws DaoException{
int index=tbUserMapper.insert(tbUser);
if(index == 1){
return 1;
}
throw new DaoException("新增失败");
}
}