📄 submit_0005forder_0002ejsp_jsp.java
字号:
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.jsp.*;
import org.apache.jasper.runtime.*;
public class submit_0005forder_0002ejsp_jsp extends HttpJspBase {
// begin [file="/submit_order.jsp";from=(2,0);to=(2,55)]
// end
static {
}
public submit_0005forder_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="/submit_order.jsp";from=(0,51);to=(1,0)]
out.write("\r\n");
// end
// HTML // begin [file="/submit_order.jsp";from=(1,47);to=(2,0)]
out.write("\r\n");
// end
// begin [file="/submit_order.jsp";from=(2,0);to=(2,55)]
book.bk workM = null;
boolean _jspx_specialworkM = false;
synchronized (pageContext) {
workM= (book.bk)
pageContext.getAttribute("workM",PageContext.PAGE_SCOPE);
if ( workM == null ) {
_jspx_specialworkM = true;
try {
workM = (book.bk) java.beans.Beans.instantiate(this.getClass().getClassLoader(), "book.bk");
} catch (ClassNotFoundException exc) {
throw new InstantiationException(exc.getMessage());
} catch (Exception exc) {
throw new ServletException (" Cannot create bean of class "+"book.bk", exc);
}
pageContext.setAttribute("workM", workM, PageContext.PAGE_SCOPE);
}
}
if(_jspx_specialworkM == true) {
// end
// begin [file="/submit_order.jsp";from=(2,0);to=(2,55)]
}
// end
// HTML // begin [file="/submit_order.jsp";from=(2,55);to=(3,0)]
out.write("\r\n");
// end
// begin [file="/submit_order.jsp";from=(3,2);to=(8,0)]
if(session.getAttribute("username")==null)
{
response.sendRedirect("login.html");
}
// end
// HTML // begin [file="/submit_order.jsp";from=(8,2);to=(9,0)]
out.write("\r\n");
// end
// begin [file="/submit_order.jsp";from=(9,2);to=(16,0)]
String tel = request.getParameter("address");
tel = new String(tel.getBytes("ISO8859-1"));
String address = request.getParameter("tel");
address = new String(address.getBytes("ISO8859-1"));
String sqlinsert="update 订单 set user_address='"+address+"',user_tel='"+tel+"' where user_name='"+session.getAttribute("username")+"'";
workM.executeQuery(sqlinsert);
// end
// HTML // begin [file="/submit_order.jsp";from=(16,2);to=(33,38)]
out.write("\r\n<html>\r\n<head>\r\n<title>[详细资料]</title>\r\n</head>\r\n\r\n<body bgcolor=\"#FFFFFF\">\r\n<div align=\"center\">\r\n<b><font color=\"Fuchsia\">订单确认</font></b>\r\n<table width=\"100%\" border=\"1\">\r\n <tr bgcolor=\"#9999FF\">\r\n <td colspan=\"2\">\r\n <div align=\"center\"><b>订单信息</b></div>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td width=\"12%\" bgcolor=\"#FFCCCC\">姓名:</td>\r\n <td width=\"88%\" bgcolor=\"#CCFFCC\">");
// end
// begin [file="/submit_order.jsp";from=(33,41);to=(33,73)]
out.print(session.getAttribute("username"));
// end
// HTML // begin [file="/submit_order.jsp";from=(33,75);to=(38,6)]
out.write("</td>\r\n </tr>\r\n <tr>\r\n <td width=\"12%\" bgcolor=\"#FFCCCC\">住址：</td>\r\n <td width=\"88%\" bgcolor=\"#CCFFCC\">\r\n ");
// end
// begin [file="/submit_order.jsp";from=(38,9);to=(38,16)]
out.print(address);
// end
// HTML // begin [file="/submit_order.jsp";from=(38,18);to=(44,0)]
out.write("\r\n </td>\r\n </tr>\r\n <tr>\r\n <td width=\"12%\" bgcolor=\"#FFCCCC\">电话:</td>\r\n <td width=\"88%\" bgcolor=\"#CCFFCC\">\r\n");
// end
// begin [file="/submit_order.jsp";from=(44,3);to=(44,6)]
out.print(tel);
// end
// HTML // begin [file="/submit_order.jsp";from=(44,8);to=(66,1)]
out.write("\r\n\r\n </td>\r\n </tr>\r\n</table>\r\n </form>\r\n <p>您选购了以下书籍：</p>\r\n <table width=\"100%\" border=\"0\" align=\"center\">\r\n <tr bgcolor=\"#FFCCCC\">\r\n <td width=\"15%\">\r\n <div align=\"center\"><font color=\"#0000FF\">购买数量</font></div>\r\n </td>\r\n <td width=\"56%\">\r\n <div align=\"center\"><font color=\"#0000FF\">书名</font></div>\r\n </td>\r\n <td width=\"13%\">\r\n <div align=\"center\"><font color=\"#0000FF\">单价（元）</font></div>\r\n </td>\r\n <td width=\"16%\">\r\n <div align=\"center\"><font color=\"#0000FF\">总价格（元）</font></div>\r\n </td>\r\n </tr>\r\n\t");
// end
// begin [file="/submit_order.jsp";from=(66,3);to=(80,1)]
//价格
double g_price,total_price;
g_price=0;
total_price=0;
//********
String sqlList="select * from 订单 where user_name='"+session.getAttribute("username")+"'";
ResultSet RSList=workM.executeQuery(sqlList);
try
{
while(RSList.next())
{
int b_num;
b_num=RSList.getInt("book_number");
// end
// HTML // begin [file="/submit_order.jsp";from=(80,3);to=(83,52)]
out.write("\r\n <tr bgcolor=\"#CCFFCC\">\r\n <td width=\"15%\">\r\n <div align=\"center\"> <font color=\"#0000FF\"> ");
// end
// begin [file="/submit_order.jsp";from=(83,55);to=(83,60)]
out.print(b_num);
// end
// HTML // begin [file="/submit_order.jsp";from=(83,62);to=(84,65)]
out.write("\r\n <input type=\"hidden\" name=\"book_number\" size=\"4\" value=");
// end
// begin [file="/submit_order.jsp";from=(84,68);to=(84,73)]
out.print(b_num);
// end
// HTML // begin [file="/submit_order.jsp";from=(84,75);to=(87,3)]
out.write(">\r\n </font></div>\r\n </td>\r\n\t ");
// end
// begin [file="/submit_order.jsp";from=(87,5);to=(92,3)]
String sqlBook="select * from 书籍信息 where id="+RSList.getInt("book_id");
ResultSet RSBook=workM.executeQuery(sqlBook);
while(RSBook.next())
{
// end
// HTML // begin [file="/submit_order.jsp";from=(92,5);to=(94,50)]
out.write("\r\n <td width=\"56%\">\r\n <div align=\"center\"><font color=\"#0000FF\">");
// end
// begin [file="/submit_order.jsp";from=(94,53);to=(94,77)]
out.print(RSBook.getString("name"));
// end
// HTML // begin [file="/submit_order.jsp";from=(94,79);to=(97,3)]
out.write("</font></div>\r\n </td>\r\n <td width=\"13%\">\r\n\t ");
// end
// begin [file="/submit_order.jsp";from=(97,5);to=(100,3)]
double price;
price=RSBook.getDouble("price");
// end
// HTML // begin [file="/submit_order.jsp";from=(100,5);to=(101,55)]
out.write("\r\n <div align=\"center\"><font color=\"#0000FF\">¥");
// end
// begin [file="/submit_order.jsp";from=(101,58);to=(101,63)]
out.print(price);
// end
// HTML // begin [file="/submit_order.jsp";from=(101,65);to=(104,55)]
out.write("</font></div>\r\n </td>\r\n <td width=\"16%\">\r\n <div align=\"center\"><font color=\"#0000FF\">¥");
// end
// begin [file="/submit_order.jsp";from=(104,58);to=(104,76)]
out.print((float)price*b_num);
// end
// HTML // begin [file="/submit_order.jsp";from=(104,78);to=(106,4)]
out.write("</font></div>\r\n </td>\r\n\t ");
// end
// begin [file="/submit_order.jsp";from=(106,6);to=(108,5)]
g_price=g_price+(double)price*b_num;
}
// end
// HTML // begin [file="/submit_order.jsp";from=(108,7);to=(110,1)]
out.write("\r\n </tr>\r\n\t");
// end
// begin [file="/submit_order.jsp";from=(110,3);to=(116,1)]
}
}
catch(Exception e)
{
}
// end
// HTML // begin [file="/submit_order.jsp";from=(116,3);to=(122,55)]
out.write("\r\n\t <tr bgcolor=\"#CCCCFF\">\r\n <td colspan=\"3\">\r\n <div align=\"center\"><font color=\"#0000FF\">书籍价格</font></div>\r\n </td>\r\n <td width=\"16%\">\r\n <div align=\"center\"><font color=\"#0000FF\">¥");
// end
// begin [file="/submit_order.jsp";from=(122,58);to=(122,72)]
out.print((float)g_price);
// end
// HTML // begin [file="/submit_order.jsp";from=(122,74);to=(139,58)]
out.write("</font></div>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td height=\"18\" colspan=\"3\" bgcolor=\"#CCCC99\"><font color=\"#0000FF\"> \r\n </font>\r\n <div align=\"center\"><font color=\"#0000FF\">运输费用</font></div>\r\n </td>\r\n <td height=\"18\" width=\"16%\" bgcolor=\"#CCCC99\">\r\n <div align=\"center\"><font color=\"#0000FF\">¥5.00</font></div>\r\n </td>\r\n </tr>\r\n <tr bgcolor=\"#66FF66\">\r\n <td colspan=\"3\">\r\n <div align=\"center\"><b><font color=\"#FF0000\">总费用</font></b></div>\r\n </td>\r\n <td width=\"16%\">\r\n <div align=\"center\"><b><font color=\"#FF0000\">¥");
// end
// begin [file="/submit_order.jsp";from=(139,61);to=(139,77)]
out.print((float)g_price+5);
// end
// HTML // begin [file="/submit_order.jsp";from=(139,79);to=(152,0)]
out.write("</font></b></div>\r\n </td>\r\n </tr>\r\n\t <tr align=\"center\">\r\n <td colspan=\"4\">\r\n <a href=\"index.jsp\">继续购书</a> |<a href=\"javascript:self.print();\">打印该页</a>\r\n </td>\r\n </tr>\r\n </table>\r\n <p> </p>\r\n</div>\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 + -