- sbfqmq
- 等级: 初级会员
- 性别:
- 文章: 9
- 积分: 60
- 来自: 西安
|
接下来是调用持久层的用于测试的Servlet:
1.调用直接HibernateAPI分页的Servlet:
java 代码
- package com.ligang.web.servlet;
-
- import java.io.IOException;
- import java.util.List;
-
- import javax.servlet.RequestDispatcher;
- import javax.servlet.ServletException;
- import javax.servlet.http.HttpServlet;
- import javax.servlet.http.HttpServletRequest;
- import javax.servlet.http.HttpServletResponse;
-
- import com.ligang.persistence.IProduceDao;
- import com.ligang.persistence.imp.ProduceDaoImp;
- import com.ligang.service.Page;
-
- public class ProduceServlet extends HttpServlet {
-
- @Override
- public void doGet(HttpServletRequest req, HttpServletResponse resp)
- throws ServletException, IOException {
- this.doPost(req, resp);
- }
- private static IProduceDao dao = new ProduceDaoImp();
-
- public final static int pageSize = 10;
-
- @Override
- public void doPost(HttpServletRequest req, HttpServletResponse resp)
- throws ServletException, IOException {
- String pageInfo = req.getParameter("page");
- long start=System.currentTimeMillis();
- int page = 1;
- if (pageInfo != null) {
- page = Integer.parseInt(pageInfo);
- }
- if (page < 1) {
- page = 1;
- }
- Page temp = new Page(this.dao.getTotalRecordCount(), this.pageSize,
- page);
- req.setAttribute("page", temp);
- List ps = this.dao.getSubProduce(temp.getIndex(), pageSize);
- req.setAttribute("produces", ps);
- long end = System.currentTimeMillis();
- req.setAttribute("second", (end-start));
- RequestDispatcher rd = req.getRequestDispatcher("produce.jsp");
-
- rd.forward(req, resp);
- }
-
- }
2.调用使用Top关键字分页的存储过程Servlet:
java 代码
- package com.ligang.web.servlet;
-
- import java.io.IOException;
- import java.util.List;
-
- import javax.servlet.RequestDispatcher;
- import javax.servlet.ServletException;
- import javax.servlet.http.HttpServlet;
- import javax.servlet.http.HttpServletRequest;
- import javax.servlet.http.HttpServletResponse;
-
- import com.ligang.persistence.IProduceDao;
- import com.ligang.persistence.imp.ProduceDaoSQLServerProcedureImp;
- import com.ligang.service.Page;
-
- public class SqlServerProcedureServlet extends HttpServlet {
- public final static int pageSize = 10;
- @Override
- public void doGet(HttpServletRequest req, HttpServletResponse resp)
- throws ServletException, IOException {
- this.doPost(req, resp);
- }
- @Override
- public void doPost(HttpServletRequest req, HttpServletResponse resp)
- throws ServletException, IOException {
- String pageInfo = req.getParameter("page");
- long start=System.currentTimeMillis();
- int page = 1;
- if (pageInfo != null) {
- page = Integer.parseInt(pageInfo);
- }
- if (page < 1) {
- page = 1;
- }
- Page temp = new Page(this.dao.getTotalRecordCount(), this.pageSize,
- page);
- req.setAttribute("page", temp);
- List ps = this.dao.getSubProduce(temp.getIndex(), pageSize);
- req.setAttribute("produces", ps);
- long end = System.currentTimeMillis();
- req.setAttribute("second", (end-start));
- RequestDispatcher rd = req.getRequestDispatcher("procedureProduce.jsp");
-
- rd.forward(req, resp);
- }
- private static IProduceDao dao = new ProduceDaoSQLServerProcedureImp();
- }
3.调用RowNumber分页的Servlet:
java 代码
- package com.ligang.web.servlet;
-
- import java.io.IOException;
- import java.io.PrintWriter;
- import java.util.List;
-
- import javax.servlet.RequestDispatcher;
- import javax.servlet.ServletException;
- import javax.servlet.http.HttpServlet;
- import javax.servlet.http.HttpServletRequest;
- import javax.servlet.http.HttpServletResponse;
-
- import com.ligang.persistence.IProduceDao;
- import com.ligang.persistence.imp.ProduceDaoSQLImp;
- import com.ligang.persistence.imp.ProduceDaoSQLServerProcedureImp;
- import com.ligang.service.Page;
-
- public class SQLServerRowNumberProduceServlet extends HttpServlet {
-
- public final static int pageSize = 10;
- @Override
- public void doGet(HttpServletRequest req, HttpServletResponse resp)
- throws ServletException, IOException {
- this.doPost(req, resp);
- }
- @Override
- public void doPost(HttpServletRequest req, HttpServletResponse resp)
- throws ServletException, IOException {
- String pageInfo = req.getParameter("page");
- long start=System.currentTimeMillis();
- int page = 1;
- if (pageInfo != null) {
- page = Integer.parseInt(pageInfo);
- }
- if (page < 1) {
- page = 1;
- }
- Page temp = new Page(this.dao.getTotalRecordCount(), this.pageSize,
- page);
- req.setAttribute("page", temp);
- List ps = this.dao.getSubProduce(temp.getIndex(), pageSize);
- req.setAttribute("produces", ps);
- long end = System.currentTimeMillis();
- req.setAttribute("second", (end-start));
- RequestDispatcher rd = req.getRequestDispatcher("rowNumberProduce.jsp");
-
- rd.forward(req, resp);
- }
- private static IProduceDao dao = new ProduceDaoSQLImp();
-
- }
web.xml:
xml 代码
- <!---->xml version="1.0" encoding="UTF-8"?>
- <web-app xmlns="http://java.sun.com/xml/ns/j2ee"
- xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" version="2.4"
- xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">
- <servlet>
- <servlet-name>produceservlet-name>
- <servlet-class>
- com.ligang.web.servlet.ProduceServlet
- servlet-class>
- servlet>
- <servlet-mapping>
- <servlet-name>produceservlet-name>
- <url-pattern>/produceurl-pattern>
- servlet-mapping>
- <servlet>
- <servlet-name>operatorProduceservlet-name>
- <servlet-class>
- com.ligang.web.servlet.OperateProduceServlet
- servlet-class>
- servlet>
- <servlet-mapping>
- <servlet-name>operatorProduceservlet-name>
- <url-pattern>/produceOperatorurl-pattern>
- servlet-mapping>
- <servlet>
- <servlet-name>procedureservlet-name>
- <servlet-class>com.ligang.web.servlet.SqlServerProcedureServletservlet-class>
- servlet>
- <servlet-mapping>
- <servlet-name>procedureservlet-name>
- <url-pattern>/procedureurl-pattern>
- servlet-mapping>
- <servlet>
- <servlet-name>SQLServerRowNumberProduceServletservlet-name>
- <servlet-class>com.ligang.web.servlet.SQLServerRowNumberProduceServletservlet-class>
- servlet>
-
- <servlet-mapping>
- <servlet-name>SQLServerRowNumberProduceServletservlet-name>
- <url-pattern>/rowNumberProduceurl-pattern>
- servlet-mapping>
-
-
- <welcome-file-list>
- <welcome-file>index.jspwelcome-file>
- welcome-file-list>
- web-app>
-
用于显示结果的Jsp页面:procedureProduce.jsp
JSP代码
- <%@ page language="java" pageEncoding="utf-8"%>
- <%@page import="com.ligang.service.Page"%>
- <%@taglib uri="/WEB-INF/c-rt.tld" prefix="c"%>
- <%@taglib uri="/WEB-INF/page.tld" prefix="page"%>
- <html>
- <head>
- <title>proceduretitle>
- head>
- <body>
-
- <page:page action="procedure"
- page="<%=(Page) request.getAttribute("page")%>" param="page" />
-
-
- <c:out value="${second}">c:out>
- <hr>
- <table border="1" width="50%">
- <thead>
- <td>
- picture
- td>
- <td>
- name
- td>
- <td>
- price
- td>
- <td>
- operator
- td>
- thead>
- <c:if test="${!empty produces}">
- <c:forEach var="elem" items="${produces}" >
- <tr>
- <td>
- <a href="${elem.path}" target="_blank"><img
- src="${elem.path}" border="0"/>
- a>
- td>
- <td>
- <jsp:getProperty property="name" name="elem" />
- td>
- <td>
- <jsp:getProperty property="price" name="elem" />
- td>
- <td>
- <a
- href="produceOperator?id=${elem.id}&page=<%=((Page) request.getAttribute("page")).getCurrentPage()%>">deletea>
- td>
- tr>
- c:forEach>
- c:if>
- table>
- <hr>
- <page:iteratorPage page="<%=(Page) request.getAttribute("page")%>"
- action="procedure" param="page" />
- body>
- html>
produce.jsp
jsp代码
- <%@ page language="java" pageEncoding="utf-8"%>
- <%@page import="com.ligang.service.Page"%>
- <%@page import="java.util.Enumeration"%>
- <%@taglib uri="/WEB-INF/c-rt.tld" prefix="c"%>
- <%@taglib uri="/WEB-INF/page.tld" prefix="hello"%>
- <html>
- <head>
- <title>cursortitle>
- head>
- <body>
-
- <hello:page action="produce"
- page="<%=(Page) request.getAttribute("page")%>" param="page" />
-
-
- <c:out value="${second}">c:out>
- <hr>
- <table border="1" width="50%">
- <thead>
- <td>
- picture
- td>
- <td>
- name
- td>
- <td>
- price
- td>
- <td>
- operator
- td>
- thead>
- <c:if test="${!empty produces}">
- <c:forEach var="elem" items="${produces}" >
- <tr>
- <td>
- <a href="${elem.path}" target="_blank"><img
- src="${elem.path}" border="0"/>
- a>
- td>
- <td>
- <jsp:getP
</di>
声明:ITeye文章版权属于作者,受法律保护。没有作者书面许可不得转载。
|
返回顶楼 |
|
|