jggrid的java实现

package com.servlet; import java.io.IOException; import java.sql.ResultSet; import java.sql.SQLException; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import com.dao.Dao4Mysql; public class JqGridServlet extends HttpServlet { private static final long serialVersionUID = 132383828833L; @Override public void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { Dao4Mysql dao = new Dao4Mysql(); String query2 = "SELECT a.id, a.invdate, b.name, a.amount,a.tax,a.total,a.note FROM invheader a,"+ " clients b WHERE a.client_id=b.client_id "; ResultSet result = dao.query(query2); StringBuffer bf = new StringBuffer(); //为了简便page等参数直接定死了，没有通过前台传值过来 bf.append("{"); bf.append("\"page\":1,"); bf.append("\"total\":1,"); bf.append("\"records\":20,"); bf.append("\"rows\":["); StringBuffer bf2 = new StringBuffer(); try { while(result.next()){ bf2.append("{"); bf2.append("\"id:\":\""+result.getString("id")+"\","); bf2.append("\"cell\":["); bf2.append("\""+result.getString("id")+"\","); bf2.append("\""+result.getString("invdate")+"\","); bf2.append("\""+result.getString("name")+"\","); bf2.append("\""+result.getString("amount")+"\","); bf2.append("\""+result.getString("tax")+"\","); bf2.append("\""+result.getString("total")+"\","); if(result.getString("note")==null){ bf2.append("null"); }else{ bf2.append("\""+result.getString("note")+"\""); } bf2.append("]"); bf2.append("},"); } } catch (SQLException e) { e.printStackTrace(); } String aa = bf2.toString(); if(aa!=null && !"".equals(aa)){ aa = aa.substring(0,aa.length()-1); bf.append(aa); } bf.append("]"); bf.append("}"); System.out.println(bf.toString()); resp.getWriter().write(bf.toString()); } @Override public void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { doGet(req,resp); } }