easyui mysql 分页_easyui-datagrid连接数据库实现分页查询数据

package com.hanqi.web;

import java.io.IOException;

import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import com.hanqi.service.StudentService;/**

* Servlet implementation class StudentServlet*/

public classStudentServlet extends HttpServlet {private static final long serialVersionUID = 1L;/**

* @see HttpServlet#HttpServlet()*/

publicStudentServlet() {

super();//TODO Auto-generated constructor stub

}/**

* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)*/

protected voiddoGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

request.setCharacterEncoding("UTF-8");

response.setCharacterEncoding("UTF-8");

response.setContentType("text/html");

String spage=request.getParameter("page");

String srows=request.getParameter("rows");if(spage!=null&& srows!=null)

{int page=Integer.parseInt(spage);int rows=Integer.parseInt(srows);

String json=newStudentService().getPageJSON(page, rows);

response.getWriter().print(json);

}else{

response.getWriter().print("{'title':0,'rows':[]}");

}

}/**

* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)*/

protected voiddoPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {//TODO Auto-generated method stub

doGet(request, response);

}

}