controller如下:
@RestController
public class GithubController {
@Autowired
private GitHubRepository repository;
@Autowired
private GithubEntityManager manager;
/**
* attention:用户名可能存在多个
* Details:根据用户名查询数据库
* @author chhliu
*/
@RequestMapping(value="github/get/users/{username}", method=RequestMethod.GET)
public ResultMsg<List<GitHubEntity>> getGithubByUsername(@PathVariable("username") final String username){
ResultMsg<List<GitHubEntity>> res = new ResultMsg<List<GitHubEntity>>();
try {
Assert.hasLength(username, "username must be not null!");
List<GitHubEntity> list = repository.findEntityByUserName(username);
res.setResponseObject(list);
res.setOK(true);
} catch (Exception e) {
res.setErrorMsg(e.getMessage());
res.setOK(false);
}
return res;
}
/**
* attention:id唯一
* Details:根据id查询数据库
* @author chhliu
*/
@RequestMapping(value="github/get/user/{id}", method=RequestMethod.GET)
public ResultMsg<GitHubEntity> getGithubById(@PathVariable("id") final int id){
ResultMsg<GitHubEntity> msg = new ResultMsg<GitHubEntity>();
try {
boolean isExists = repository.exists(id);
if(isExists){
GitHubEntity en = repository.findOne(id);
msg.setResponseObject(en);
msg.setOK(true);
}else{
msg.setErrorMsg("the record id is not exist!");
msg.setOK(false);
}
} catch (Exception e) {
msg.setErrorMsg(e.getMessage());
msg.setOK(false);
}
return msg;
}
/**
* attention:
* Details:查询所有的结果,并分页和排序
* @author chhliu
*/
@RequestMapping(value="github/get/users/page", method=RequestMethod.GET)
public ResultMsg<Page<GitHubEntity>> findAllGithubEntity(final int pageOffset, final int pageSize, final String orderColumn){
ResultMsg<Page<GitHubEntity>> res = new ResultMsg<Page<GitHubEntity>>();
try {
res.setResponseObject(manager.findAllGithubEntity(pageOffset, pageSiz