📄 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,52)]
// 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=GB18030");
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,52);to=(1,0)]
out.write("\r\n");
// end
// HTML // begin [file="/submit_order.jsp";from=(1,46);to=(2,0)]
out.write("\r\n");
// end
// begin [file="/submit_order.jsp";from=(2,0);to=(2,52)]
book.bk bkId = null;
boolean _jspx_specialbkId = false;
synchronized (pageContext) {
bkId= (book.bk)
pageContext.getAttribute("bkId",PageContext.PAGE_SCOPE);
if ( bkId == null ) {
_jspx_specialbkId = true;
try {
bkId = (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("bkId", bkId, PageContext.PAGE_SCOPE);
}
}
if(_jspx_specialbkId == true) {
// end
// begin [file="/submit_order.jsp";from=(2,0);to=(2,52)]
}
// end
// HTML // begin [file="/submit_order.jsp";from=(2,52);to=(3,0)]
out.write("\r\n");
// end
// begin [file="/submit_order.jsp";from=(3,2);to=(11,0)]
/*检查客户是否通过登录，如果未经过登录检查，返回登录界面。
*验证用户是否存在，避免用户直接进入该页，以后的每张动态网
*页都要包括这一部分。*/
if(session.getAttribute("username")==null)
{
response.sendRedirect("login.html");
}
// end
// HTML // begin [file="/submit_order.jsp";from=(11,2);to=(12,0)]
out.write("\r\n");
// end
// begin [file="/submit_order.jsp";from=(12,2);to=(19,0)]
String address=request.getParameter("address");
address=new String(address.getBytes("ISO8859-1"));
String tel=request.getParameter("tel");
tel=new String(tel.getBytes("ISO8859-1"));
String sqlinsert="update 订单 set user_address='"+address+"',user_tel='"+tel+"' where user_name='"+session.getAttribute("username")+"'";
bkId.executeQuery(sqlinsert);
// end
// HTML // begin [file="/submit_order.jsp";from=(19,2);to=(37,44)]
out.write("\r\n<html>\r\n<head>\r\n<title>[详细资料]</title>\r\n</head>\r\n<body bgcolor=\"#ffffff\">\r\n <div align=\"center\">\r\n <b><font color=\"Fuchsia\">订单确认</font>\r\n </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\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=(37,47);to=(37,79)]
out.print(session.getAttribute("username"));
// end
// HTML // begin [file="/submit_order.jsp";from=(37,81);to=(41,44)]
out.write("</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=(41,47);to=(41,54)]
out.print(address);
// end
// HTML // begin [file="/submit_order.jsp";from=(41,56);to=(45,44)]
out.write("</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=(45,47);to=(45,50)]
out.print(tel);
// end
// HTML // begin [file="/submit_order.jsp";from=(45,52);to=(73,8)]
out.write("</td>\r\n </tr>\r\n </table>\r\n </form>\r\n\r\n <p>\r\n 您选购了一下书籍：\r\n </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>\r\n </div>\r\n </td>\r\n <td width=\"56%\">\r\n <div align=\"center\"><font color=\"#0000ff\">书名</font>\r\n </div>\r\n </td>\r\n <td width=\"13%\">\r\n <div align=\"center\"><font color=\"#0000ff\">单价（元）</font>\r\n </div>\r\n </td>\r\n <td width=\"16%\">\r\n <div align=\"center\"><font color=\"#0000ff\">总价格（元）</font>\r\n </div>\r\n </td>\r\n </tr>\r\n\r\n ");
// end
// begin [file="/submit_order.jsp";from=(73,10);to=(87,9)]
//价格
double g_price,total_price;
g_price=0;
total_price=0;
//********
String sqlList="select * from 订单表 where user_name='"+session.getAttribute("username")+"'";
ResultSet RSList=bkId.executeQuery(sqlList);
try
{
while(RSList.next())
{
int b_num;
b_num=RSList.getInt("book_number");
// end
// HTML // begin [file="/submit_order.jsp";from=(87,11);to=(90,55)]
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=(90,58);to=(90,63)]
out.print(b_num);
// end
// HTML // begin [file="/submit_order.jsp";from=(90,65);to=(91,67)]
out.write("\r\n <input type=\"hidden\"name=\"book_number\"size=\"4\"value=");
// end
// begin [file="/submit_order.jsp";from=(91,70);to=(91,75)]
out.print(b_num);
// end
// HTML // begin [file="/submit_order.jsp";from=(91,77);to=(95,11)]
out.write(">\r\n\t\t</font>\r\n </div>\r\n </td>\r\n ");
// end
// begin [file="/submit_order.jsp";from=(95,13);to=(100,11)]
String sqlBook="select * from 书籍信息表 where id="+RSList.getInt("book_id");
ResultSet RSBook=bkId.executeQuery(sqlBook);
while(RSBook.next())
{
// end
// HTML // begin [file="/submit_order.jsp";from=(100,13);to=(102,55)]
out.write("\r\n <td width=\"56%\">\r\n <div align=\"center\"><font color=\"#0000ff\">");
// end
// begin [file="/submit_order.jsp";from=(102,58);to=(102,82)]
out.print(RSBook.getString("name"));
// end
// HTML // begin [file="/submit_order.jsp";from=(102,84);to=(106,13)]
out.write("\r\n </font></div>\r\n </td>\r\n <td width=\"13%\">\r\n ");
// end
// begin [file="/submit_order.jsp";from=(106,15);to=(109,13)]
double price;
price=RSBook.getDouble("price");
// end
// HTML // begin [file="/submit_order.jsp";from=(109,15);to=(110,60)]
out.write("\r\n <div align=\"center\"><font color=\"#0000ff\">¥");
// end
// begin [file="/submit_order.jsp";from=(110,63);to=(110,68)]
out.print(price);
// end
// HTML // begin [file="/submit_order.jsp";from=(110,70);to=(113,59)]
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=(113,62);to=(113,80)]
out.print((float)price*b_num);
// end
// HTML // begin [file="/submit_order.jsp";from=(113,82);to=(115,10)]
out.write("</font></div>\r\n </td>\r\n ");
// end
// begin [file="/submit_order.jsp";from=(115,12);to=(117,12)]
g_price=g_price+(double)price*b_num;
}
// end
// HTML // begin [file="/submit_order.jsp";from=(117,14);to=(119,9)]
out.write("\r\n </tr>\r\n ");
// end
// begin [file="/submit_order.jsp";from=(119,11);to=(125,8)]
}
}
catch(Exception e)
{
}
// end
// HTML // begin [file="/submit_order.jsp";from=(125,10);to=(132,59)]
out.write("\r\n\r\n <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=(132,62);to=(132,76)]
out.print((float)g_price);
// end
// HTML // begin [file="/submit_order.jsp";from=(132,78);to=(149,62)]
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\"> </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\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=(149,65);to=(149,81)]
out.print((float)g_price+5);
// end
// HTML // begin [file="/submit_order.jsp";from=(149,83);to=(163,0)]
out.write("</font></b></div>\r\n </td>\r\n </tr>\r\n <tr align=\"center\">\r\n <td colspan=\"4\">\r\n <a href=\"browse.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\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 + -