📄 bookrank_0002ejsp_jsp.java
字号:
import java.sql.*;
import java.util.*;
import java.text.SimpleDateFormat;
import java.util.Date ;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.jsp.*;
import org.apache.jasper.runtime.*;
public class BookRank_0002ejsp_jsp extends HttpJspBase {
static {
}
public BookRank_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=GBK");
pageContext = _jspxFactory.getPageContext(this, request, response,
"", true, 8192, true);
application = pageContext.getServletContext();
config = pageContext.getServletConfig();
session = pageContext.getSession();
out = pageContext.getOut();
// HTML // begin [file="/BookRank.jsp";from=(0,48);to=(1,0)]
out.write("\r\n");
// end
// HTML // begin [file="/BookRank.jsp";from=(1,30);to=(2,0)]
out.write("\r\n");
// end
// HTML // begin [file="/BookRank.jsp";from=(2,31);to=(3,0)]
out.write("\r\n");
// end
// HTML // begin [file="/BookRank.jsp";from=(3,62);to=(8,0)]
out.write("\r\n<html>\r\n<body background=\"images\\\\book1.jpg\">\r\n<table border=1 cellspacing=\"1\" cellpadding=\"1\" bordercolor=\"blue\">\r\n<tr><td>书名</td><td>作者</td><td>出版社</td><td><font size=\"3\" color=\"#977923\"><b>会员价</b></font></td><td><font size=\"3\" color=\"#086306\"><b>销售数量</b></font></td><td>详细</td><tr>\r\n");
// end
// begin [file="/BookRank.jsp";from=(8,2);to=(28,0)]
String sql="select * from book order by sale_number desc";
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ;
Connection con=DriverManager.getConnection("jdbc:odbc:Shopping");
Statement st=con.createStatement();
ResultSet rs=st.executeQuery(sql);
while(rs.next()){
int book_ID=rs.getInt("book_ID") ;
//String book_type=rs.getString("book_type") ;
String book_name=rs.getString("book_name") ;
//session.setAttribute("bookname",book_name);
String author=rs.getString("author") ;
String publishing_house=rs.getString("publishing_house") ;
//String description=rs.getString("description") ;
//Date startTime=rs.getDate("startTime") ;
//float value=(float)rs.getDouble("value") ;
float T_value=(float)rs.getDouble("T_value") ;
float vip_value=(float)rs.getDouble("vip_value") ;
int sale_number=rs.getInt("sale_number") ;
// end
// HTML // begin [file="/BookRank.jsp";from=(28,2);to=(29,45)]
out.write("\r\n<tr><td><font size=\"3\" color=\"blue\"><a href=\"");
// end
// begin [file="/BookRank.jsp";from=(29,48);to=(29,72)]
out.print(request.getContextPath());
// end
// HTML // begin [file="/BookRank.jsp";from=(29,74);to=(29,100)]
out.write("/bookdetails.jsp?bookname=");
// end
// begin [file="/BookRank.jsp";from=(29,103);to=(29,112)]
out.print(book_name);
// end
// HTML // begin [file="/BookRank.jsp";from=(29,114);to=(29,146)]
out.write("\" name=\"show\" target=\"right\"><b>");
// end
// begin [file="/BookRank.jsp";from=(29,149);to=(29,158)]
out.print(book_name);
// end
// HTML // begin [file="/BookRank.jsp";from=(29,160);to=(30,4)]
out.write("</b></a></font></td>\r\n<td>");
// end
// begin [file="/BookRank.jsp";from=(30,7);to=(30,13)]
out.print(author);
// end
// HTML // begin [file="/BookRank.jsp";from=(30,15);to=(30,24)]
out.write("</td><td>");
// end
// begin [file="/BookRank.jsp";from=(30,27);to=(30,43)]
out.print(publishing_house);
// end
// HTML // begin [file="/BookRank.jsp";from=(30,45);to=(30,54)]
out.write("</td><td>");
// end
// begin [file="/BookRank.jsp";from=(30,57);to=(30,66)]
out.print(vip_value);
// end
// HTML // begin [file="/BookRank.jsp";from=(30,68);to=(30,77)]
out.write("</td><td>");
// end
// begin [file="/BookRank.jsp";from=(30,80);to=(30,91)]
out.print(sale_number);
// end
// HTML // begin [file="/BookRank.jsp";from=(30,93);to=(31,18)]
out.write("</td>\r\n<td><form action=\"");
// end
// begin [file="/BookRank.jsp";from=(31,21);to=(31,45)]
out.print(request.getContextPath());
// end
// HTML // begin [file="/BookRank.jsp";from=(31,47);to=(31,73)]
out.write("/bookdetails.jsp?bookname=");
// end
// begin [file="/BookRank.jsp";from=(31,76);to=(31,85)]
out.print(book_name);
// end
// HTML // begin [file="/BookRank.jsp";from=(31,87);to=(32,0)]
out.write("\" method=\"post\"><input type=\"image\" src=\"images\\\\view.gif\" name=\"view\"></form></td></tr>\r\n");
// end
// begin [file="/BookRank.jsp";from=(32,2);to=(32,44)]
request.setAttribute("t_show",book_name) ;
// end
// HTML // begin [file="/BookRank.jsp";from=(32,46);to=(33,0)]
out.write("\r\n");
// end
// begin [file="/BookRank.jsp";from=(33,2);to=(33,3)]
}
// end
// HTML // begin [file="/BookRank.jsp";from=(33,5);to=(34,0)]
out.write("\r\n");
// end
// begin [file="/BookRank.jsp";from=(34,2);to=(36,0)]
}
catch(Exception e){System.out.println("ktyu"+e.getMessage() ) ;}
// end
// HTML // begin [file="/BookRank.jsp";from=(36,2);to=(40,0)]
out.write("\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 + -