日期:2014-05-16 浏览次数:20741 次
ajax2.jsp:
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>Insert title here</title> <script type="text/javascript" src="js/prototype1.6.js"></script> <script type="text/javascript"> function showEmps(){ new Ajax.Request( "empserv?t="+new Date().getTime(), { method:"post", parameters:{"name":$F("name")}, onSuccess:function(req){ var emps = req.responseText.evalJSON(); //清空table表格 clearTable(); //循环生成table列表 for(i=0;i<emps.length;i++){ var emp = emps[i]; //在table最后位置添加一行tr var tr = $("tb").insertRow($("tb").rows.length); tr.onmouseover = function(){ this.style.backgroundColor = "#00FFFF"; } tr.onmouseout = function(){ this.style.backgroundColor = "#FFFFFF"; } //添加td,显示name var name_td = tr.insertCell(tr.cells.length); name_td.innerHTML = emp.name; name_td.onclick = function(){ $("name").value = this.innerHTML; //清空table表格 clearTable(); } //添加td,显示salary var sal_td = tr.insertCell(tr.cells.length); sal_td.innerHTML = emp.salary; } } } ); } function clearTable(){ var len = $("tb").rows.length; for(i=len-1;i>=0;i--){ $("tb").deleteRow(i); } } </script> </head> <body> <input type="text" name="name" id="name" oninput="showEmps()" onkeyup="showEmps()"/> <input type="button" value="清空" onclick="clearTable()"/> <input type="button" value="查询" onclick="showEmps()"/> <hr> <table id="tb"></table> </body> </html>
EmpServlet :
package serv;
import java.io.IOException; import java.io.PrintWriter; import java.io.UnsupportedEncodingException; import java.sql.SQLException; import java.util.List;
import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse;
import net.sf.json.JSONArray;
import dao.EmployeeDAO;
public class EmpServlet extends HttpServlet{ ?public void doPost(HttpServletRequest request,HttpServletResponse response) throws IOException{ ??doGet(request,response); ?} ?public void doGet(HttpServletRequest request,HttpServletResponse response) throws IOException{ ??request.setCharacterEncoding("utf-8"); ??String name = request.getParameter("name"); ??System.out.println(name); ??response.setContentType("text/json;charset=utf-8"); ??EmployeeDAO empDAO = new EmployeeDAO(); ??try { ???List list = empDAO.findLikeName(name); ??????????? JSONArray json = JSONArray.fromObject(list); ??????????? String emps = json.toString(); ???System.out.println(emps); ???PrintWriter out = response.getWriter(); ???out.print(emps); ???out.close(); ??} catch (Exception e) { ???e.printStackTrace(); ??} ?} }
?