import java.io.IOException; import java.io.PrintWriter; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import model.Blog; import mysqljdbc.MysqlTest; @WebServlet("/LUServlet") public class LUServlet extends HttpServlet { public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("utf-8"); response.setContentType("text/html; charset=utf-8"); //获取页面的page和pagesize，拼接sql用 int page=Integer.valueOf(request.getParameter("page")); int pagesize=Integer.valueOf(request.getParameter("pagesize")); MysqlTest test=new MysqlTest(); //在拼接json字符串是传给前台一个total记录总数，ligerUI grid会自动获取该total int total=test.getTotal(); request.setAttribute("total", total); //用的mysql，查找限定条数语句用limit,从page*pagesize-pagesize开始，取pagesize条 String sql="select * from blog"; sql+=" limit "+(page*pagesize-pagesize)+","+pagesize; Blog[] blog=test.getInfo(sql,page,pagesize); //将数据拼接成json字符串 StringBuffer strbuffer=new StringBuffer(); //ligerUI grid接受的json格式是{"Rows":[],"Total":""} strbuffer.append("{\"Rows\":["); for(int i=0;i<blog.length;i++){ strbuffer.append("{\"title\":").append("\"" + blog[i].getTitle() + "\"},"); } strbuffer.replace(strbuffer.length()-1, strbuffer.length(), ""); strbuffer.append("],").append("\"Total\":").append("\""+total+"\"").append("}"); PrintWriter out=response.getWriter(); out.write(strbuffer.toString()); out.close(); } public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doGet(request,response); } }
运行结果（默认样式可以改，具体参照ligerUI API）：
