📄 checkorder_0002ejsp_jsp.java
字号:
import java.sql.*;
import java.util.Date ;
import java.util.Properties;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.jsp.*;
import org.apache.jasper.runtime.*;
public class CheckOrder_0002ejsp_jsp extends HttpJspBase {
// begin [file="/CheckOrder.jsp";from=(3,3);to=(9,0)]
public String convert(String s){
try{
return new String(s.getBytes("ISO-8859-1"),"GB2312");
}catch(Exception e){return null;}
}
// end
static {
}
public CheckOrder_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="/CheckOrder.jsp";from=(0,48);to=(1,0)]
out.write("\r\n");
// end
// HTML // begin [file="/CheckOrder.jsp";from=(1,46);to=(2,0)]
out.write("\r\n");
// end
// HTML // begin [file="/CheckOrder.jsp";from=(2,41);to=(3,0)]
out.write("\r\n");
// end
// HTML // begin [file="/CheckOrder.jsp";from=(9,2);to=(14,0)]
out.write("\r\n<html>\r\n<body>\r\n<table align=\"center\" background=\"images/bg1.gif\">\r\n<font size=\"4\" color=\"#abc123\">您的历史账单如下：</font>\r\n");
// end
// begin [file="/CheckOrder.jsp";from=(14,2);to=(37,0)]
String t_username=(String)session.getAttribute("t_username");
String sql="select * from cdb_orders where username='"+t_username+"'"; //
ResultSet rs;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ;
Connection con=DriverManager.getConnection("jdbc:odbc:Shopping");
Statement st=con.createStatement();
rs=st.executeQuery(sql);
if(!rs.next()){out.println("对不起，您目前还没有订单！") ;}
while(rs.next()){
int orderID=rs.getInt("orderID") ;
int book_ID=rs.getInt("book_ID") ;
String book_name=rs.getString("book_name") ;
session.setAttribute("bookname",book_name);
int number=rs.getInt("number") ;
float value=(float)rs.getDouble("value");
Date Order_lead_time=rs.getDate("Order lead time") ;
String someway=rs.getString("someway");
String form_of_payment=rs.getString("form of payment");
String estate=rs.getString("estate");
// end
// HTML // begin [file="/CheckOrder.jsp";from=(37,2);to=(38,48)]
out.write("\r\n<tr><td><font color=\"#12abcc\"><b>订单号：</b></font>");
// end
// begin [file="/CheckOrder.jsp";from=(38,51);to=(38,58)]
out.print(orderID);
// end
// HTML // begin [file="/CheckOrder.jsp";from=(38,60);to=(39,13)]
out.write("</td></tr>\r\n<tr><td>书的ID：");
// end
// begin [file="/CheckOrder.jsp";from=(39,16);to=(39,23)]
out.print(book_ID);
// end
// HTML // begin [file="/CheckOrder.jsp";from=(39,25);to=(39,37)]
out.write("</td><td>书名：");
// end
// begin [file="/CheckOrder.jsp";from=(39,40);to=(39,49)]
out.print(book_name);
// end
// HTML // begin [file="/CheckOrder.jsp";from=(39,51);to=(40,13)]
out.write("</td></tr>\r\n<tr><td>购买数量：");
// end
// begin [file="/CheckOrder.jsp";from=(40,16);to=(40,22)]
out.print(number);
// end
// HTML // begin [file="/CheckOrder.jsp";from=(40,24);to=(40,36)]
out.write("</td><td>单价：");
// end
// begin [file="/CheckOrder.jsp";from=(40,39);to=(40,44)]
out.print(value);
// end
// HTML // begin [file="/CheckOrder.jsp";from=(40,46);to=(41,13)]
out.write("</td></tr>\r\n<tr><td>购买日期：");
// end
// begin [file="/CheckOrder.jsp";from=(41,16);to=(41,31)]
out.print(Order_lead_time);
// end
// HTML // begin [file="/CheckOrder.jsp";from=(41,33);to=(42,13)]
out.write("</td></tr>\r\n<tr><td>送货方式：");
// end
// begin [file="/CheckOrder.jsp";from=(42,16);to=(42,23)]
out.print(someway);
// end
// HTML // begin [file="/CheckOrder.jsp";from=(42,25);to=(42,39)]
out.write("</td><td>付款方式：");
// end
// begin [file="/CheckOrder.jsp";from=(42,42);to=(42,57)]
out.print(form_of_payment);
// end
// HTML // begin [file="/CheckOrder.jsp";from=(42,59);to=(43,42)]
out.write("</td></tr>\r\n<tr><td>状态：<font size=\"6\" color=\"#bb12bb\">");
// end
// begin [file="/CheckOrder.jsp";from=(43,45);to=(43,51)]
out.print(estate);
// end
// HTML // begin [file="/CheckOrder.jsp";from=(43,53);to=(45,0)]
out.write("</font></td></tr>\r\n<tr><td colspan=\"4\" height=\"8\"></td></tr>\r\n");
// end
// begin [file="/CheckOrder.jsp";from=(45,2);to=(46,0)]
}
// end
// HTML // begin [file="/CheckOrder.jsp";from=(46,2);to=(47,0)]
out.write("\r\n");
// end
// begin [file="/CheckOrder.jsp";from=(47,2);to=(49,0)]
}
catch(Exception e){System.out.println(e.getMessage() ) ;}
// end
// HTML // begin [file="/CheckOrder.jsp";from=(49,2);to=(53,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 + -