今天做了一个ajax动态查询数据库的小Demo，又重新学习了一下ajax的一些知识。在此和大家分享一下......
啥都别说了，先上代码
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 动态查询数据库中的数据并更新........
转载请注明原文地址: https://ju.6miu.com/read-1311612.html
