《结合oracle数据库的分页排序jqgrid表格》由会员分享，可在线阅读，更多相关《结合oracle数据库的分页排序jqgrid表格（7页珍藏版）》请在金锄头文库上搜索。
1、结合oracle数据库的分页、排序jqgrid表格包含内容1、Servlet程序 2、JSP 页面 3、jqgrid表格图一、Servlet程序package com.lyk.servlet;import java.io.IOException;import java.io.PrintWriter;import java.sql.Connection;import java.sql.SQLException;import java.sql.Statement;import javax.mail.Session;import javax.naming.Context;import javax.n
2、aming.InitialContext;import javax.naming.NamingException;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import javax.sql.DataSource;import java.sql.ResultSet;import java.util.Array
3、List;import java.util.List;import java.util.Map;import net.sf.json.JSONArray;import net.sf.json.JSONObject;import mons.dbutils.QueryRunner;import mons.dbutils.handlers.BeanListHandler;import com.google.gson.Gson;import com.google.gson.JsonArray;import com.google.gson.JsonElement;import com.google.gs
4、on.JsonObject;import com.google.gson.JsonParser;import com.lyk.ip.Test;public class jqgridTest4 extends HttpServlet /* * The doPost method of the servlet. * * This method is called when a form has its tag value method equals to * post. * * param request * the request send by the client to the server
5、 * param response * the response send by the server to the client * throws ServletException * if an error occurred * throws IOException * if an error occurred */SuppressWarnings(unused)public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException Li
6、st rtnList = new ArrayList();String page = request.getParameter(page); / 取得当前页数String rows = request.getParameter(rows); / 取得每页显示行数rowListString sidx = request.getParameter(sidx);String sord = request.getParameter(sord);if (request.getSession().getAttribute(rows) = null) request.getSession().setAttr
7、ibute(rows, rows); else String rows2 = (String) request.getSession().getAttribute(rows);request.getSession().setAttribute(rows, rows);if (rows2.equals(rows) else page = 1;int ab = 0;int pageSize = Integer.parseInt(rows);int kaishi = (Integer.parseInt(page) - 1) * pageSize + 1;int jieshu = Integer.pa
8、rseInt(page) * pageSize + 1;try Context initContext = new InitialContext();DataSource ds = (DataSource) initContext.lookup(java:/comp/env/jdbc/oracleds2);Connection conn = ds.getConnection();Statement pstmt = conn.createStatement();ResultSet resultset = pstmt.executeQuery(select count(*) as acc from
9、 secu_t_user where userlogid like jk%);resultset.next();ab = resultset.getInt(1);resultset.close();pstmt.close();QueryRunner qr = new QueryRunner(ds);try rtnList = qr.query(select userlogid,logpassword from (select rownum myno,a.* from ( select * from secu_t_user where userlogid like jk% order by +
10、sidx+ + sord+ ) a)where myno=+ kaishi + and myno + jieshu + ,new BeanListHandler(Test.class); catch (SQLException e) e.printStackTrace();conn.close();initContext.close(); catch (Exception e) e.printStackTrace();Gson gson = new Gson();String json = gson.toJson(rtnList);JsonParser parser = new JsonPar
11、ser();JsonElement el = parser.parse(json);JsonArray jsonArray = null;if (el.isJsonArray() jsonArray = el.getAsJsonArray();int totalRecord = ab; / 总记录数(应根据数据库取得，在此只是模拟)int totalPage = totalRecord % Integer.parseInt(rows) = 0 ? totalRecord/ Integer.parseInt(rows) : totalRecord / Integer.parseInt(rows)
12、+ 1; / 计算总页数try int index = (Integer.parseInt(page) - 1) * Integer.parseInt(rows); / 开始记录数/ 以下模拟构造JSON数据对象json = total: + totalPage + , page: + page + , records: + ab + , rows: ;JsonObject jobj = (JsonObject) jsonArray.get(0);String optionName = jobj.get(userlogid).toString();String mima = jobj.get(
13、logpassword).toString();json = json + cell: + optionName + , + mima + ;for (int i = 1; i (jsonArray.size(); i+) jobj = (JsonObject) jsonArray.get(i);optionName = jobj.get(userlogid).toString();mima = jobj.get(logpassword).toString();json = json + ,cell: + optionName + , + mima + ;json = json + ;/ System.out.println(json);response.getWriter().write(json); catch (Exception e) return;二、JSP 页面% page import=java.
