<div>
<h1>用户信息列表</h1>
姓名:<input type="text" id="name" value=""/> <input type="button" value="搜索" οnclick="searchStudent();" />
<hr />
<table class="gridtable">
<thead>
<tr>
<th>姓名</th>
<th>年龄</th>
<th>邮箱</th>
</tr>
</thead>
<tbody id="stbody">
<tr>
<td></td>
<td></td>
<td></td>
</tr>
</tbody>
</table>
</div>
servlet代码 根据输入的name作为参数从数据库查询数据,再转成json格式
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
IDataDao idd = new DataDaoImpl();
ObjectMapper mapper = new ObjectMapper();
String name = request.getParameter("name");
try {
List<Data> datas = idd.serchData(name);
String dataJson = mapper.writeValueAsString(datas);
response.getWriter().print(dataJson);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
ajax代码
var searchStudent = function(){
var name = $("#name").val();
var toData = {name : name};
$.ajax({
url : 'showData.do',
data : toData,
type : 'post',
dataType : 'json',
success : function(rs){
$("#stbody").empty();
$.each(rs, function(index, data) {
$("#stbody").append("<tr><td>"+data.name+"</td><td>"+data.age+"</td><td>"+data.email+"</td></tr>");
});
}
})
}