前台jsp中:
<script type="text/javascript"
src="${basePath}/media/js/jquery1.6.3/jquery-1.6.3.js"></script>
<script type="text/javascript">
$(function() {
$("#load").hide();
$('#addBtn').click(
function() {
if ($.trim($('#username').val()).length == ""
|| $.trim($('#username').val()).length < 6) {
alert("姓名不能为空或不足6个字符!");
return;
}
if ($.trim($('#upassword').val()).length == ""
|| $.trim($('#upassword').val()).length < 6) {
alert("密码不能为空或不足6个字符!");
return;
}
$.ajax({
type : "POST",
url : "${basePath}/user/userManger.htm",
data : {
username : $('#username').val(),
upassword : $('#upassword').val(),
managerflag : $('#managerflag').val()
},
dataType : "text",
success : function(data, textStatus) {
if (textStatus == "success") {
alert("添加成功!");
} else {
alert("添加失败!");
}
}
});
});
$('#queryBtn').click(function() {
$("#load").show();
$.ajax({
type : "POST",
url : "${basePath}/user/queryUser.htm",
data : {
username : $('#username').val(),
managerflag : $('#managerflag').val()
},
dataType : "json",
complete : function() {
$("#load").hide();
},//AJAX请求完成时隐藏loading提示
success : function(data) {//这里的data是由请求页面返回的数据
//alert("查询成功");
clearTable();
showQueryResult(data);
},
error : function(XMLHttpRequest, textStatus, errorThrown) {
$("#show").html("error");
}
});
});
//结果显示页面
function showQueryResult(data) {
var str = "";
$(data)
.each(
function(i, item) {
str += "<tr>";
str += "<td>" + item.userid + "</td>";
str += "<td>" + item.username + "</td>";
str += "<td>" + item.ip + "</td>";
str += "<td>" + item.lastlogintime + "</td>";
str += "<td>" + item.managerflag + "</td>";
str += "<td><a href='${basePath}/user/deluser.htm?uid=${user.userid }'>删除</a></td>";
str += "</tr>";
});
//$("#show").html(str);
$("table tbody").html(str);
}
//清除数据
function clearTable() {
$("table tbody").html("");
}
});
</script>
后台:
@RequestMapping(value = "/queryUser")
public void userMangerView(HttpServletRequest request,
HttpServletResponse response) throws IOException {
System.out.println(Constant.getNowTime() + "\t"
+ this.getClass().toString() + " /user/queryUser");
String username = request.getParameter("username");
String managerflag = request.getParameter("managerflag");
System.out.println("username:" + username);
System.out.println("managerflag:" + managerflag);
String sqlWhere = "";
if (username != null && username.trim() != "") {
sqlWhere += " and username like '%" + username + "%' ";
}
if (managerflag != null && managerflag.trim() != "") {
sqlWhere += " and managerflag='" + managerflag + "' ";
}
List<Orauser> userlist = orauserService.queryListByCondition(sqlWhere);
Constant.sentDataToPageAjax(userlist, response);
}
@RequestMapping(value = "/userManger", method = RequestMethod.POST)
public ModelAndView userMangerPostView(HttpServletRequest request,
HttpServletResponse response) throws IOException {
System.out.println(Constant.getNowTime() + "\t"
+ this.getClass().toString() + " /user/userManger post");
ModelAndView mv = new ModelAndView("/user/userManger");
String username = request.getParameter("username");
String upassword = request.getParameter("upassword");
String managerflag = request.getParameter("managerflag");
Orauser orauser = new Orauser();
orauser.setIp(Constant.getLocalhostIP());
orauser.setLastlogintime(Constant.getNowTime());
orauser.setManagerflag(managerflag);
orauser.setUpassword(upassword);
orauser.setUserid(Constant.getCommonID(""));
orauser.setUsername(username);
orauserService.add(orauser);
return mv;
}
Constant.sentDataToPageAjax(userlist, response)方法:
/**
* 将list 类型转换成json格式返回页面
* @param list
* @param response
*/
public static void sentDataToPageAjax(List list,HttpServletResponse response){
PrintWriter out;
try {
out = response.getWriter();
JSONArray jsonArray = JSONArray.fromObject(list);
out.write(jsonArray.toString());
System.out.println("sentDataToPageAjax() jsonArray.toString()>>=="+jsonArray.toString());
out.flush();
out.close();
} catch (IOException e) {
e.printStackTrace();
}
}