📄 sort_0002ejsp_jsp.java
字号:
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.jsp.*;
import org.apache.jasper.runtime.*;
public class sort_0002ejsp_jsp extends HttpJspBase {
// begin [file="/sort.jsp";from=(1,0);to=(1,60)]
// end
static {
}
public sort_0002ejsp_jsp( ) {
}
private static boolean _jspx_inited = false;
public final void _jspx_init() throws org.apache.jasper.runtime.JspException {
}
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;
String _value = null;
try {
if (_jspx_inited == false) {
synchronized (this) {
if (_jspx_inited == false) {
_jspx_init();
_jspx_inited = true;
}
}
}
_jspxFactory = JspFactory.getDefaultFactory();
response.setContentType("text/html; charset=gb2312");
pageContext = _jspxFactory.getPageContext(this, request, response,
"", true, 8192, true);
application = pageContext.getServletContext();
config = pageContext.getServletConfig();
session = pageContext.getSession();
out = pageContext.getOut();
// HTML // begin [file="/sort.jsp";from=(0,87);to=(1,0)]
out.write("\r\n");
// end
// begin [file="/sort.jsp";from=(1,0);to=(1,60)]
beans.connDB connDB = null;
boolean _jspx_specialconnDB = false;
synchronized (pageContext) {
connDB= (beans.connDB)
pageContext.getAttribute("connDB",PageContext.PAGE_SCOPE);
if ( connDB == null ) {
_jspx_specialconnDB = true;
try {
connDB = (beans.connDB) java.beans.Beans.instantiate(this.getClass().getClassLoader(), "beans.connDB");
} catch (ClassNotFoundException exc) {
throw new InstantiationException(exc.getMessage());
} catch (Exception exc) {
throw new ServletException (" Cannot create bean of class "+"beans.connDB", exc);
}
pageContext.setAttribute("connDB", connDB, PageContext.PAGE_SCOPE);
}
}
if(_jspx_specialconnDB == true) {
// end
// begin [file="/sort.jsp";from=(1,0);to=(1,60)]
}
// end
// HTML // begin [file="/sort.jsp";from=(1,60);to=(2,0)]
out.write("\r\n");
// end
// begin [file="/sort.jsp";from=(2,2);to=(4,0)]
ResultSet rs_sort=connDB.executeQuery("select * from (select top 10 * from ( select sum(number) as amount,ISBN from tb_Order_detail group by ISBN )as tab order by amount desc) o inner join tb_bookinfo b on o.ISBN=b.ISBN order by o.amount desc");
// end
// HTML // begin [file="/sort.jsp";from=(4,2);to=(18,1)]
out.write("\r\n<html>\r\n<head>\r\n<title>网上图书超市</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n<link href=\"CSS/style.css\" rel=\"stylesheet\">\r\n</head>\r\n<body>\r\n<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" background=\"Images/bg.gif\">\r\n <tr>\r\n <td>\r\n<table width=\"777\" height=\"768\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\" bgcolor=\"#FFFFFF\">\r\n <tr>\r\n <td valign=\"top\">\r\n\t");
// end
// begin [file="/sort.jsp";from=(18,1);to=(18,30)]
{
String _jspx_qStr = "";
JspRuntimeLibrary.include(request, response, "Top.jsp" + _jspx_qStr, out, false);
if ("true".equals(request.getAttribute("javax.servlet.forward.seen")))
return;
}
// end
// HTML // begin [file="/sort.jsp";from=(18,30);to=(22,3)]
out.write("\r\n\t<table width=\"100%\" height=\"330\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\r\n <tr>\r\n <td width=\"26%\" valign=\"top\">\r\n\t\t ");
// end
// begin [file="/sort.jsp";from=(22,3);to=(22,33)]
{
String _jspx_qStr = "";
JspRuntimeLibrary.include(request, response, "left.jsp" + _jspx_qStr, out, false);
if ("true".equals(request.getAttribute("javax.servlet.forward.seen")))
return;
}
// end
// HTML // begin [file="/sort.jsp";from=(22,33);to=(28,15)]
out.write(" \r\n\t\t</td>\r\n <td width=\"5\" valign=\"top\" background=\"Images/Cen_separate.gif\"></td>\r\n <td width=\"73%\" valign=\"top\"><table width=\"100%\" height=\"272\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\r\n <tr>\r\n <td height=\"52\" colspan=\"3\" background=\"Images/index_10.gif\">\r\n ");
// end
// begin [file="/sort.jsp";from=(28,15);to=(28,47)]
{
String _jspx_qStr = "";
JspRuntimeLibrary.include(request, response, "search.jsp" + _jspx_qStr, out, false);
if ("true".equals(request.getAttribute("javax.servlet.forward.seen")))
return;
}
// end
// HTML // begin [file="/sort.jsp";from=(28,47);to=(50,24)]
out.write("\r\n\t\t\t </td>\r\n </tr>\r\n <tr>\r\n <td width=\"97%\" height=\"220\" valign=\"top\">\r\n\t\t\t <table width=\"100%\" height=\"126\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\r\n\r\n\t\t\t <tr>\r\n <td valign=\"top\"><table width=\"100%\" height=\"55\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\r\n <tr>\r\n <td class=\"tableBorder_B\"><img src=\"Images/index_16.gif\" width=\"161\" height=\"48\"></td>\r\n </tr>\r\n <tr>\r\n <td width=\"86%\" height=\"100\" valign=\"top\">\r\n\t\t\t\t\t\t<table width=\"96%\" height=\"34\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\" class=\"tableBorder_B\">\r\n <tr>\r\n <td width=\"6%\" height=\"33\" align=\"center\"> </td>\r\n <td width=\"53%\" style=\"padding:5px;\">书名</td>\r\n <td width=\"31%\" style=\"padding:5px;\"> 出版社</td>\r\n <td width=\"10%\" style=\"padding:5px;\">购买</td>\r\n </tr>\r\n </table>\r\n ");
// end
// begin [file="/sort.jsp";from=(50,26);to=(54,5)]
while(rs_sort.next()){
String ISBN=rs_sort.getString("ISBN");
String BookName=rs_sort.getString("BookName");
String publisher=rs_sort.getString("publisher");
// end
// HTML // begin [file="/sort.jsp";from=(54,7);to=(58,95)]
out.write("\r\n <table width=\"96%\" height=\"21\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\" class=\"tableBorder_B\">\r\n <tr>\r\n <td width=\"6%\" align=\"center\"><img src=\"Images/greendot.gif\" width=\"11\" height=\"13\"></td>\r\n <td width=\"53%\" style=\"padding:5px;\"><a href=\"book_detail.jsp?ISBN=");
// end
// begin [file="/sort.jsp";from=(58,98);to=(58,102)]
out.print(ISBN);
// end
// HTML // begin [file="/sort.jsp";from=(58,104);to=(58,106)]
out.write("\">");
// end
// begin [file="/sort.jsp";from=(58,109);to=(58,117)]
out.print(BookName);
// end
// HTML // begin [file="/sort.jsp";from=(58,119);to=(59,65)]
out.write("</a></td>\r\n <td width=\"31%\" style=\"padding:5px;\">");
// end
// begin [file="/sort.jsp";from=(59,68);to=(59,77)]
out.print(publisher);
// end
// HTML // begin [file="/sort.jsp";from=(59,79);to=(61,7)]
out.write("</td>\r\n <td width=\"10%\" style=\"padding:5px;\">\r\n\t\t\t\t\t\t\t");
// end
// begin [file="/sort.jsp";from=(61,9);to=(61,52)]
if(session.getAttribute("UserName")!=null){
// end
// HTML // begin [file="/sort.jsp";from=(61,54);to=(62,120)]
out.write("\r\n\t\t\t\t\t\t\t<input name=\"Submit5\" type=\"submit\" class=\"btn_grey\" value=\"购买\" onClick=\"window.location.href='cart_Add.jsp?ISBN=");
// end
// begin [file="/sort.jsp";from=(62,123);to=(62,127)]
out.print(ISBN);
// end
// HTML // begin [file="/sort.jsp";from=(62,129);to=(63,7)]
out.write("'\">\r\n\t\t\t\t\t\t\t");
// end
// begin [file="/sort.jsp";from=(63,9);to=(65,8)]
}else{
out.println("请先登录");
}
// end
// HTML // begin [file="/sort.jsp";from=(65,10);to=(69,24)]
out.write("\r\n\t\t\t\t\t\t\t</td>\r\n </tr>\r\n </table>\r\n ");
// end
// begin [file="/sort.jsp";from=(69,26);to=(69,27)]
}
// end
// HTML // begin [file="/sort.jsp";from=(69,29);to=(80,6)]
out.write(" </td>\r\n </tr>\r\n </table></td>\r\n\t\t\t </tr>\r\n </table>\r\n\t\t\t\t\t </td>\r\n <td width=\"3%\" valign=\"top\"> </td>\r\n </tr>\r\n </table></td>\r\n </tr>\r\n </table>\r\n ");
// end
// begin [file="/sort.jsp";from=(80,6);to=(80,41)]
{
String _jspx_qStr = "";
JspRuntimeLibrary.include(request, response, "copyright.jsp" + _jspx_qStr, out, false);
if ("true".equals(request.getAttribute("javax.servlet.forward.seen")))
return;
}
// end
// HTML // begin [file="/sort.jsp";from=(80,41);to=(89,0)]
out.write("\r\n </td>\r\n </tr>\r\n</table>\r\n</td>\r\n </tr>\r\n</table>\r\n</body>\r\n</html>\r\n");
// end
} catch (Throwable t) {
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 + -