📄 ordersuccess_0002ejsp_jsp.java
字号:
import bookshoppingsys.*;
import java.util.Properties;
import java.util.*;
import java.sql.*;
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 OrderSuccess_0002ejsp_jsp extends HttpJspBase {
// begin [file="/common.jsp";from=(3,0);to=(3,77)]
// end
// begin [file="/common.jsp";from=(4,3);to=(10,0)]
public String convert(String s){
try{
return new String(s.getBytes("ISO-8859-1"),"GB2312");
}catch(Exception e){return null;}
}
// end
// begin [file="/OrderSuccess.jsp";from=(4,0);to=(4,77)]
// end
static {
}
public OrderSuccess_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,
"errorpage.jsp", true, 8192, true);
application = pageContext.getServletContext();
config = pageContext.getServletConfig();
session = pageContext.getSession();
out = pageContext.getOut();
// HTML // begin [file="/OrderSuccess.jsp";from=(0,48);to=(1,0)]
out.write("\r\n");
// end
// HTML // begin [file="/common.jsp";from=(0,38);to=(1,0)]
out.write("\r\n");
// end
// HTML // begin [file="/common.jsp";from=(1,37);to=(2,0)]
out.write("\r\n");
// end
// HTML // begin [file="/common.jsp";from=(2,41);to=(3,0)]
out.write("\r\n");
// end
// begin [file="/common.jsp";from=(3,0);to=(3,77)]
bookshoppingsys.BookDB bookDB = null;
boolean _jspx_specialbookDB = false;
synchronized (application) {
bookDB= (bookshoppingsys.BookDB)
pageContext.getAttribute("bookDB",PageContext.APPLICATION_SCOPE);
if ( bookDB == null ) {
_jspx_specialbookDB = true;
try {
bookDB = (bookshoppingsys.BookDB) java.beans.Beans.instantiate(this.getClass().getClassLoader(), "bookshoppingsys.BookDB");
} catch (ClassNotFoundException exc) {
throw new InstantiationException(exc.getMessage());
} catch (Exception exc) {
throw new ServletException (" Cannot create bean of class "+"bookshoppingsys.BookDB", exc);
}
pageContext.setAttribute("bookDB", bookDB, PageContext.APPLICATION_SCOPE);
}
}
if(_jspx_specialbookDB == true) {
// end
// begin [file="/common.jsp";from=(3,0);to=(3,77)]
}
// end
// HTML // begin [file="/common.jsp";from=(3,77);to=(4,0)]
out.write("\r\n");
// end
// HTML // begin [file="/common.jsp";from=(10,2);to=(12,0)]
out.write("\r\n\r\n");
// end
// HTML // begin [file="/OrderSuccess.jsp";from=(1,32);to=(2,0)]
out.write("\r\n");
// end
// HTML // begin [file="/OrderSuccess.jsp";from=(2,86);to=(4,0)]
out.write("\r\n\r\n");
// end
// begin [file="/OrderSuccess.jsp";from=(4,0);to=(4,77)]
bookshoppingsys.ShoppingCart cart = null;
boolean _jspx_specialcart = false;
synchronized (session) {
cart= (bookshoppingsys.ShoppingCart)
pageContext.getAttribute("cart",PageContext.SESSION_SCOPE);
if ( cart == null ) {
_jspx_specialcart = true;
try {
cart = (bookshoppingsys.ShoppingCart) java.beans.Beans.instantiate(this.getClass().getClassLoader(), "bookshoppingsys.ShoppingCart");
} catch (ClassNotFoundException exc) {
throw new InstantiationException(exc.getMessage());
} catch (Exception exc) {
throw new ServletException (" Cannot create bean of class "+"bookshoppingsys.ShoppingCart", exc);
}
pageContext.setAttribute("cart", cart, PageContext.SESSION_SCOPE);
}
}
if(_jspx_specialcart == true) {
// end
// begin [file="/OrderSuccess.jsp";from=(4,0);to=(4,77)]
}
// end
// HTML // begin [file="/OrderSuccess.jsp";from=(4,77);to=(7,0)]
out.write("\r\n<html>\r\n<body>\r\n");
// end
// begin [file="/OrderSuccess.jsp";from=(7,2);to=(37,0)]
String deliver_goods=(String)session.getAttribute("deliver_goods") ;
System.out.println(deliver_goods);
String payment=(String)session.getAttribute("payment");
System.out.println(payment) ;
int num = cart.getNumberOfItems();//书的数量
//System.out.println(num);
Iterator i = cart.getItems().iterator();
while (i.hasNext()) {
ShoppingCartItem item = (ShoppingCartItem)i.next();
BookDetails book = (BookDetails)item.getItem();
//-------------------获取当前时间-----------------------------------------
String date=new SimpleDateFormat("yyyy-MM-dd").format(Calendar.getInstance().getTime()); //获取系统时间并减去指定的天数
int orderID=(int)(Math.random()*10000);//产生0-1000的整数随机数
float value=(float)cart.getTotal() ;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ;
Connection con=DriverManager.getConnection("jdbc:odbc:Shopping");
Statement st=con.createStatement();
PreparedStatement ps=null;
ResultSet rs=null;
String bookname=book.getBook_name();
String sql="select book_ID from book where book_name='"+bookname+"'";
rs=st.executeQuery(sql);
while(rs.next()){
int bookid=rs.getInt(1);
String insertsql="insert into cdb_orders(orderID,username,book_ID,book_name,number,[value],[Order lead time],someway,[form of payment]) values('"+orderID+"','"+session.getAttribute("t_username")+ "','"+bookid+"','"+book.getBook_name() +"','"+item.getQuantity()+"','"+value+"','"+date+"','"+deliver_goods+"','"+payment+"')";
ps=con.prepareStatement(insertsql);
ps.executeUpdate();
out.println("恭喜您，订货成功！感谢您在本书店购书，欢迎下次光临！");
// end
// HTML // begin [file="/OrderSuccess.jsp";from=(37,2);to=(39,14)]
out.write("\r\n<br><br>\r\n<form action=\"");
// end
// begin [file="/OrderSuccess.jsp";from=(39,17);to=(39,41)]
out.print(request.getContextPath());
// end
// HTML // begin [file="/OrderSuccess.jsp";from=(39,43);to=(40,0)]
out.write("/RightBar.jsp\" method=\"post\"><input type=\"image\" src=\"images//goonbuy.gif\" value=\"继续购物\"></form>\r\n");
// end
// begin [file="/OrderSuccess.jsp";from=(40,2);to=(44,0)]
}
}catch(Exception e){System.out.println(e.getMessage() ) ;}
}
// end
// HTML // begin [file="/OrderSuccess.jsp";from=(44,2);to=(50,0)]
out.write("\r\n\r\n\r\n<form action=\"NewBook.jsp\" method=\"post\" ><input type=\"image\" src=\"images//back.gif\" value=\"查看新书\"></form>\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 + -