今天做了一个ajax动态查询数据库的小Demo,又重新学习了一下ajax的一些知识。在此和大家分享一下......@H_403_3@
啥都别说了,先上代码
Controller层
查询总用户数
@RequestMapping(value = "/findTotalUsers.do",method = RequestMethod.GET)
public @ResponseBody Long findTotalUsers(){
ModelAndView modelAndView = new ModelAndView();
Long sum = personService.findTotalUsers();
System.out.println(sum+"....................................");
modelAndView.addObject("sum",sum);
return sum;
}
Service层
public Long findTotalUsers() {
return personDao.findTotalUsers();
}
Dao层
public Long findTotalUsers() {
String hql = "select count(*) from Person";
return (Long) this.getSessionFactory().getCurrentSession().createQuery(hql).uniqueResult();
}
ajax代码
<script src="../js/jquery-1.8.3.min.js" type="text/javascript"></script>
<script type="text/javascript">
$(document).ready(
function ajaxRePost(url,params){
var message = "";
var options={
type:"GET",url:"${pageContext.request.contextPath}/person/findTotalUsers.do",data:{},async:false,success:function (msg) {
message=msg;
}
};
$.ajax(options);
alert(message);
// debugger;
$("#count").text(message);
return message;
}
)
</script>
结果就是在Total Users 动态查询数据库中的数据并更新........
Controller层 查询总用户数 @RequestMapping(value = "/findTotalUsers.do",method = RequestMethod.GET) public @ResponseBody Long findTotalUsers(){ ModelAndView modelAndView = new ModelAndView(); Long sum = personService.findTotalUsers(); System.out.println(sum+"...................................."); modelAndView.addObject("sum",sum); return sum; }
Service层 public Long findTotalUsers() { return personDao.findTotalUsers(); }
Dao层 public Long findTotalUsers() { String hql = "select count(*) from Person"; return (Long) this.getSessionFactory().getCurrentSession().createQuery(hql).uniqueResult(); }
ajax代码 <script src="../js/jquery-1.8.3.min.js" type="text/javascript"></script> <script type="text/javascript"> $(document).ready( function ajaxRePost(url,params){ var message = ""; var options={ type:"GET",url:"${pageContext.request.contextPath}/person/findTotalUsers.do",data:{},async:false,success:function (msg) { message=msg; } }; $.ajax(options); alert(message); // debugger; $("#count").text(message); return message; } ) </script>
结果就是在Total Users 动态查询数据库中的数据并更新........