cart_0005forder_0002ejsp_jsp.java

网上购物系统 用JSP做的 好几十页 用jbuilder运行

import java.sql.*;
import java.util.Vector;
import beans.bookelement;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.jsp.*;
import org.apache.jasper.runtime.*;


public class cart_0005forder_0002ejsp_jsp extends HttpJspBase {

    // begin [file="/cart_order.jsp";from=(3,0);to=(3,60)]
    // end
    // begin [file="/cart_order.jsp";from=(4,0);to=(4,58)]
    // end

    static {
    }
    public cart_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="/cart_order.jsp";from=(0,100);to=(1,0)]
                out.write("\r\n");

            // end
            // HTML // begin [file="/cart_order.jsp";from=(1,36);to=(2,0)]
                out.write("\r\n");

            // end
            // HTML // begin [file="/cart_order.jsp";from=(2,37);to=(3,0)]
                out.write("\r\n");

            // end
            // begin [file="/cart_order.jsp";from=(3,0);to=(3,60)]
                beans.connDB connDB = null;
                boolean _jspx_specialconnDB  = false;
                 synchronized (pageContext) {
                    connDB= (beans.connDB)
                    pageContext.getAttribute("connDB",PageContext.PAGE_SCOPE);
                    if ( connDB == null ) {
                        _jspx_specialconnDB = true;
                        try {
                            connDB = (beans.connDB) java.beans.Beans.instantiate(this.getClass().getClassLoader(), "beans.connDB");
                        } catch (ClassNotFoundException exc) {
                             throw new InstantiationException(exc.getMessage());
                        } catch (Exception exc) {
                             throw new ServletException (" Cannot create bean of class "+"beans.connDB", exc);
                        }
                        pageContext.setAttribute("connDB", connDB, PageContext.PAGE_SCOPE);
                    }
                 } 
                if(_jspx_specialconnDB == true) {
            // end
            // begin [file="/cart_order.jsp";from=(3,0);to=(3,60)]
                }
            // end
            // HTML // begin [file="/cart_order.jsp";from=(3,60);to=(4,0)]
                out.write("\r\n");

            // end
            // begin [file="/cart_order.jsp";from=(4,0);to=(4,58)]
                beans.chStr chStr = null;
                boolean _jspx_specialchStr  = false;
                 synchronized (pageContext) {
                    chStr= (beans.chStr)
                    pageContext.getAttribute("chStr",PageContext.PAGE_SCOPE);
                    if ( chStr == null ) {
                        _jspx_specialchStr = true;
                        try {
                            chStr = (beans.chStr) java.beans.Beans.instantiate(this.getClass().getClassLoader(), "beans.chStr");
                        } catch (ClassNotFoundException exc) {
                             throw new InstantiationException(exc.getMessage());
                        } catch (Exception exc) {
                             throw new ServletException (" Cannot create bean of class "+"beans.chStr", exc);
                        }
                        pageContext.setAttribute("chStr", chStr, PageContext.PAGE_SCOPE);
                    }
                 } 
                if(_jspx_specialchStr == true) {
            // end
            // begin [file="/cart_order.jsp";from=(4,0);to=(4,58)]
                }
            // end
            // HTML // begin [file="/cart_order.jsp";from=(4,58);to=(5,0)]
                out.write("\r\n");

            // end
            // begin [file="/cart_order.jsp";from=(5,0);to=(5,30)]
                {
                    String _jspx_qStr = "";
                    JspRuntimeLibrary.include(request, response, "safe.jsp" + _jspx_qStr, out, false);
                    if ("true".equals(request.getAttribute("javax.servlet.forward.seen")))
                        return;
                }
            // end
            // HTML // begin [file="/cart_order.jsp";from=(5,30);to=(6,0)]
                out.write("\r\n");

            // end
            // begin [file="/cart_order.jsp";from=(6,2);to=(85,0)]
                
                	String username=chStr.chStr(request.getParameter("username"));
                	String truename=chStr.chStr(request.getParameter("truename"));
                	String address=chStr.chStr(request.getParameter("address"));
                	String postcode=request.getParameter("postcode");
                	String tel=request.getParameter("tel");
                	String pay=chStr.chStr(request.getParameter("pay"));
                	String carry=chStr.chStr(request.getParameter("carry"));
                	String email=request.getParameter("email");
                	String bz=chStr.chStr(request.getParameter("bz"));
                	int orderID=0;
                	//计算打折
                	float rebate=1;
                	ResultSet rs_rebate=connDB.executeQuery("select rebate from V_Member where username='"+username+"'");
                
                	if (rs_rebate.next()){
                		rebate=rs_rebate.getFloat("rebate");
                	}
                	Vector cart=(Vector)session.getAttribute("cart");
                	int number=0;
                	float price=0;
                	float sum=0;
                	float Totalsum=0;
                	String flag="True";
                	int temp=0;
                	//插入订单主表数据
                	float bnumber=cart.size();
                	String sql="insert into tb_Order(bnumber,username,truename,address,postcode,tel,email,pay,carry,rebate,bz) values("+bnumber+",'"+username+"','"+truename+"','"+address+"','"+postcode+"','"+tel+"','"+email+"','"+pay+"','"+carry+"','"+rebate+"','"+bz+"')";
                	//temp=connDB.executeUpdate_id(sql);
                        temp=connDB.executeUpdate(sql);
                	if (temp==0){
                		 flag="false";
                	}else{
                		orderID=temp;
                			//out.println("<script>alert('"+String.valueOf(orderID)+"ID号')</script>");
                	}
                	//插入订单明细表数据
                	for(int i=0;i<cart.size();i++){
                		bookelement mybookelement=(bookelement)cart.elementAt(i);
                		String ISBN=mybookelement.ISBN;
                		price=mybookelement.price*rebate;
                		number=mybookelement.number;
                		sum=price*number;
                		String str="insert into tb_order_Detail (orderID,ISBN,price,number) values("+orderID+",'"+ISBN+"',"+price+","+number+")";
                		temp=connDB.executeUpdate(str);
                		Totalsum=Totalsum+sum;
                		if (temp==0){
                		 	flag="false";
                		}
                	}
                	//更新会员信息
                	String sql_up="update tb_Member set Amount=Amount+"+Totalsum+" where username='"+username+"'";
                	temp=connDB.executeUpdate(sql_up);
                	if (temp==0){
                		 flag="false";
                	}
                	//更新会员等级
                	ResultSet rs_Amount=connDB.executeQuery("select Amount from tb_Member where username='"+username+"'");
                	if (rs_Amount.next()){
                		int Amount=0;
                		Amount=rs_Amount.getInt("Amount");
                		ResultSet rs_grade=connDB.executeQuery("select Top 1 grade,Amount from tb_rebate where Amount<="+Amount+" order by grade desc");
                		if (rs_grade.next()){
                			int grade=0;
                			grade=rs_grade.getInt("grade");
                			String sql_upgrade="update tb_Member set grade="+grade+" where username='"+username+"'";
                			temp=connDB.executeUpdate(sql_upgrade);
                			if (temp==0){
                				 flag="false";
                			}
                		}
                	}
                	if(flag.equals("false")){
                		out.println("<script language='javascript'>alert('订单无效');history.back();</script>");
                	}else{
                		session.removeAttribute("cart");
                		out.println("<script language='javascript'>alert('订单生成，请记住您的订单号["+orderID+"]');window.location.href='index.jsp';</script>");
                	}
                	connDB.close();
            // end
            // HTML // begin [file="/cart_order.jsp";from=(85,2);to=(87,0)]
                out.write("\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\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);
        }
    }
}