📄 d_jsp.java
字号:
package org.apache.jsp;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.jsp.*;
import java.sql.*;
import java.lang.Math.*;
public final class d_jsp extends org.apache.jasper.runtime.HttpJspBase
implements org.apache.jasper.runtime.JspSourceDependent {
ResultSet rs1 = null;
ResultSet rs2 = null;
ResultSet rsTmp = null;
String m_type = "";
String m_key="";
String sql1 = "";
String sql2 = "";
int PageSize = 10;
int Page = 1;
int totalPage = 1;
private static java.util.Vector _jspx_dependants;
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;
try {
_jspxFactory = JspFactory.getDefaultFactory();
response.setContentType("text/html;charset=GBK");
pageContext = _jspxFactory.getPageContext(this, request, response,
null, true, 8192, true);
application = pageContext.getServletContext();
config = pageContext.getServletConfig();
session = pageContext.getSession();
out = pageContext.getOut();
_jspx_out = out;
out.write("\r\n\r\n\r\n\r\n");
bookshop.Conn conn = null;
synchronized (pageContext) {
conn = (bookshop.Conn) pageContext.getAttribute("conn", PageContext.PAGE_SCOPE);
if (conn == null){
conn = new bookshop.Conn();
pageContext.setAttribute("conn", conn, PageContext.PAGE_SCOPE);
}
}
out.write('\r');
out.write('\n');
bookshop.Show rstogbk = null;
synchronized (pageContext) {
rstogbk = (bookshop.Show) pageContext.getAttribute("rstogbk", PageContext.PAGE_SCOPE);
if (rstogbk == null){
rstogbk = new bookshop.Show();
pageContext.setAttribute("rstogbk", rstogbk, PageContext.PAGE_SCOPE);
}
}
out.write('\r');
out.write('\n');
out.write("\r\n<html>\r\n<head>\r\n\t<title>网上书店</title>\r\n\t<Link rel=\"stylesheet\" type=\"text/css\" href=\"style.css\">\r\n</head>\r\n<body TEXT=\"#000000\" BGCOLOR=\"#3300FF\" BACKGROUND=\"b01.jpg\">\r\n<Center>\r\n\r\n");
request.setCharacterEncoding("gb2312");
m_type = request.getParameter("m_type");
m_key = request.getParameter("m_key");
if(m_type==null || m_type.equals("")) {
m_type = "计算机";
}
sql1 = "Select * From book1";
sql2 = "Select * From book2 where category='"+m_type+"'";
System.out.println(sql2);
if(m_key==null||m_key.equals("")){
sql2=sql2;
}
else{
sql2+="and name='"+m_key+"'";
}
rs1 = conn.executeQuery( sql1 );
rs2 = conn.executeQuery( sql2 );
out.write("\r\n<h1>网上书店</h1>\r\n<form action=\"d.jsp\" method=\"post\">\r\n\t请选择类别：\r\n\t<Select name=\"m_type\">\r\n\t");
while(rs1.next()){
String type=rs1.getString(2);
out.write("\r\n\t\t<option value=");
out.print(type );
out.write('>');
out.print(type );
out.write("</option>\r\n ");
}
out.write("\r\n\t</Select>\r\n\t请输入书籍名:\r\n\t<Input type=\"text\" name=\"m_key\">\r\n\t<Input type=\"Submit\" Value=\"查看\">\r\n\r\n</form>\r\n</Center>\r\n");
rsTmp = conn.executeQuery("select count(id) as countid from book2");
rsTmp.next();
totalPage = (int) Math.floor( rsTmp.getInt("countid") / 10 ) + 1;
if(totalPage == 0) totalPage = 1;
PageSize = 10;
if(request.getParameter("Page")==null || request.getParameter("Page").equals(""))
Page = 1;
else
Page = Integer.parseInt(request.getParameter("Page"));
if(Page < 1) Page = 1;
if(Page > totalPage) Page = totalPage;
// 下面调用在RsToGbk中的ShowOnePage方法
// ShowOnePage( ResultSet, 页数, 每页记录数)
out.println( rstogbk.ShowOnePage(rs2, Page, PageSize) );
out.write("\r\n<form Action=\"d.jsp\" Method=\"GET\" name=form1>\r\n<Center>\r\n");
if(Page != 1) {
out.println("<A HREF=d.jsp?Page=1>第一页</A>");
out.println("<A HREF=d.jsp?Page=" + (Page-1) + ">上一页</A>");
}
if(Page != totalPage) {
out.println("<A HREF=d.jsp?Page=" + (Page+1) + ">下一页</A>");
out.println("<A HREF=d.jsp?Page=" + totalPage + ">最后一页</A>");
}
out.write("\r\n <p>输入页数：<input TYPE=\"TEXT\" Name=\"Page\" SIZE=\"3\"> 页数:<font COLOR=\"Red\">");
out.print(Page);
out.write('/');
out.print(totalPage);
out.write("</font> \r\n </p>\r\n</form>\r\n</Center>\r\n</div>\r\n</body>\r\n</html>");
} catch (Throwable t) {
if (!(t instanceof SkipPageException)){
out = _jspx_out;
if (out != null && out.getBufferSize() != 0)
out.clearBuffer();
if (pageContext != null) pageContext.handlePageException(t);
}
} finally {
if (_jspxFactory != null) _jspxFactory.releasePageContext(pageContext);
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -