📄 page_jsp.java
字号:
package org.apache.jsp;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.jsp.*;
public final class page_jsp extends org.apache.jasper.runtime.HttpJspBase
implements org.apache.jasper.runtime.JspSourceDependent {
private static java.util.Vector _jspx_dependants;
private org.apache.jasper.runtime.ResourceInjector _jspx_resourceInjector;
public java.util.List getDependants() {
return _jspx_dependants;
}
public void _jspService(HttpServletRequest request, HttpServletResponse response)
throws java.io.IOException, ServletException {
JspFactory _jspxFactory = null;
PageContext pageContext = null;
HttpSession session = null;
ServletContext application = null;
ServletConfig config = null;
JspWriter out = null;
Object page = this;
JspWriter _jspx_out = null;
PageContext _jspx_page_context = null;
try {
_jspxFactory = JspFactory.getDefaultFactory();
response.setContentType("text/html;charset=UTF-8");
pageContext = _jspxFactory.getPageContext(this, request, response,
null, true, 8192, true);
_jspx_page_context = pageContext;
application = pageContext.getServletContext();
config = pageContext.getServletConfig();
session = pageContext.getSession();
out = pageContext.getOut();
_jspx_out = out;
String resourceInjectorClassName = config.getInitParameter("com.sun.appserv.jsp.resource.injector");
if (resourceInjectorClassName != null) {
_jspx_resourceInjector = (org.apache.jasper.runtime.ResourceInjector) Class.forName(resourceInjectorClassName).newInstance();
_jspx_resourceInjector.setContext(application);
}
out.write('\n');
out.write('\n');
//变量声明java.sql.Connection sqlCon; //数据库连接对象java.sql.Statement sqlStmt; //SQL语句对象java.sql.ResultSet sqlRst; //结果集对象java.lang.String strCon; //数据库连接字符串java.lang.String strSQL; //SQL语句int intPageSize; //一页显示的记录数int intRowCount; //记录总数int intPageCount; //总页数int intPage; //待显示页码int layer;int idlayer;idlayer=1;java.lang.String outtext;outtext="";java.lang.String strPage;int j;int i;//设置一页显示的记录数intPageSize = 2;//取得待显示页码strPage = request.getParameter("page");if(strPage==null){//表明在QueryString中没有page这一个参数，此时显示第一页数据 intPage = 1;}else{//将字符串转换成整型 intPage = java.lang.Integer.parseInt(strPage); if(intPage<1) intPage = 1;}//装载JDBC驱动程序Class.forName("org.gjt.mm.mysql.Driver").newInstance();//连接数据库sqlCon = java.sql.DriverManager.getConnection("jdbc:mysql://localhost/sample");//创建语句对象sqlStmt = sqlCon.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY);//执行SQL语句并获取结果集sqlRst = sqlStmt.executeQuery("SELECT customerid,phone FROM customer");//获取记录总数sqlRst.last();intRowCount = sqlRst.getRow();//记算总页数intPageCount = (intRowCount+intPageSize-1) / intPageSize;//调整待显示的页码if(intPage>intPageCount) intPage = intPageCount;
out.write("\n");
out.write("<html>\n");
out.write("<head>\n");
out.write(" <meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\n");
out.write("</head>\n");
out.write("<body topmargin=\"0\" leftmargin=\"0\" >\n");
out.write("<table width=\"100%\"><tr><td >\n");
out.write("页次：");
out.print(intPage);
out.write('/');
out.print(intPageCount);
out.write("页 ");
out.print(intPageSize);
out.write("条/页 \n");
out.write("</td></tr></table>\n");
out.write("<table width=\"100%\">\n");
out.write("<tr>\n");
out.write("<td width＝50%>ID</td>\n");
out.write("<td width＝50%>电话</td>\n");
out.write("</tr>\n");
if(intPageCount>0){sqlRst.absolute((intPage-1) * intPageSize + 1);i = 0;while(i<intPageSize && !sqlRst.isAfterLast()){String id = sqlRst.getString(1);String phone = sqlRst.getString(2);
out.write("\n");
out.write("<trwidth>\n");
out.write("<td width＝50%>");
out.print(id);
out.write("</td>\n");
out.write("<td width＝50%>");
out.print(phone);
out.write("</td>\n");
out.write("<tr>\n");
sqlRst.next();i++;}}
out.write("\n");
out.write("</table>\n");
if(intPage>1){
out.write("\n");
out.write("<a href=\"page.jsp?page=");
out.print(intPage-1);
out.write("\">上一页</a>\n");
}
out.write('\n');
if(intPage<intPageCount){
out.write("\n");
out.write("<a href=\"page.jsp?page=");
out.print(intPage+1);
out.write("\">下一页</a>\n");
}
out.write("\n");
out.write("</body>\n");
out.write("</html>\n");
//关闭结果集sqlRst.close();//关闭SQL语句对象sqlStmt.close();//关闭数据库sqlCon.close();
out.write('\n');
} catch (Throwable t) {
if (!(t instanceof SkipPageException)){
out = _jspx_out;
if (out != null && out.getBufferSize() != 0)
out.clearBuffer();
if (_jspx_page_context != null) _jspx_page_context.handlePageException(t);
}
} finally {
if (_jspxFactory != null) _jspxFactory.releasePageContext(_jspx_page_context);
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -