result.java

一个jsp的课程设计：电子商务网站

/*
 * result.java
 *
 * Created on 2007年11月23日, 下午8:02
 */

package cart;

import com.sun.crypto.provider.RSACipher;
import dbpack.Login;
import java.io.*;
import java.net.*;
import dbpack.dbConnect;
import java.sql.SQLException;
import javax.servlet.*;
import javax.servlet.http.*;

/**
 *
 * @author weiyunbo
 * @version
 */
public class result extends HttpServlet {
    
    /** Processes requests for both HTTP <code>GET</code> and <code>POST</code> methods.
     * @param request servlet request
     * @param response servlet response
     */
    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        response.setContentType("text/html;charset=UTF-8");
        PrintWriter out = response.getWriter();
        HttpSession session=request.getSession(true);
        java.util.Vector vect=(java.util.Vector)session.getAttribute("cartVector");
        int i=0;
        int total=0;
        dbConnect db=new dbConnect();
        String userid="";
        String foodid="";
        int money=0;
        boolean isok=true;
        try {
            for(i=0;i<vect.size();i++){
                cartInfo cat=(cartInfo)vect.get(i);
                Login lg = (Login) session.getAttribute ("login");
                userid = lg.getId ();
                total=total+Integer.parseInt(cat.getFoodprice())*Integer.parseInt(cat.getFoodnum());
            }
            db.rs=db.sat.executeQuery("select money from member where userid='"+userid+"'");
            while(db.rs.next()){
                money=Integer.parseInt(db.rs.getString("money"));
                if(money<total){
                    String error="你的金额不足，请找管理员充值";
                    session.setAttribute("error",error);
                    db.doClose();
                    isok=false;
                    //
                }
            }
            if(isok){
            for(i=0;i<vect.size();i++){
                cartInfo cat=(cartInfo)vect.get(i);
                total=total+Integer.parseInt(cat.getFoodprice())*Integer.parseInt(cat.getFoodnum());
                foodid=cat.getFoodid();
                db.sat.executeUpdate("insert into orders(userid,foodid,foodprice,foodnum) values ("+userid+","+cat.getFoodid()+","+cat.getFoodprice()+","+cat.getFoodnum()+")");
            }
            }
        } catch (NumberFormatException ex) {
            System.out.println ("错误");
            ex.printStackTrace();
        } catch (SQLException ex) {
            ex.printStackTrace();
            System.out.println ("错误");
        }
        db.doClose();
        java.util.Vector vc=new java.util.Vector();
        session.setAttribute("cartVector",vc);
        response.sendRedirect("result.jsp?total="+total+"&ok="+isok);
        out.close();
    }
    
    // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
    /** Handles the HTTP <code>GET</code> method.
     * @param request servlet request
     * @param response servlet response
     */
    protected void doGet(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        processRequest(request, response);
    }
    
    /** Handles the HTTP <code>POST</code> method.
     * @param request servlet request
     * @param response servlet response
     */
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        processRequest(request, response);
    }
    
    /** Returns a short description of the servlet.
     */
    public String getServletInfo() {
        return "Short description";
    }
    // </editor-fold>
}