ordercon.java

用J2EE开发的网站,可以应用到图书馆,图书超市

package ksnb;
//把订单信息写入数据库的servlet
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import java.sql.*;

public class ordercon extends HttpServlet {
    private static final String CONTENT_TYPE = "text/html; charset=gb2312";
    cartinfo inser = null;
    FurnitureCart cart = null;

    CharConvert b=new CharConvert();
    //Initialize global variables
    public void init() throws ServletException {

    }

    //Process the HTTP Get request
    public void service(HttpServletRequest req, HttpServletResponse res) throws
            ServletException, IOException {
        res.setContentType(CONTENT_TYPE);
        HttpSession session=req.getSession(true);
        int item = Integer.parseInt(req.getParameter("item"));
        String name = b.convert(req.getParameter("name"));
        String address =  b.convert(req.getParameter("address"));
        String sex =  b.convert(req.getParameter("sex"));
        String tel = req.getParameter("tel");
        String phone = req.getParameter("phone");
        String email = req.getParameter("email");
        String postcode = req.getParameter("postcode"); //邮编
        String send_state =  b.convert(req.getParameter("send_state")); //送货方式
        String payment =  b.convert(req.getParameter("payment")); //支付方式
        String note =  b.convert(req.getParameter("note")); //；留言备注
        //订单ID采用年月日＋订单序号的方式
        String year=req.getParameter("year");
        String month=req.getParameter("month");
        String today=req.getParameter("date");
        String first_order=year+month+today;
        int last_order;

        String[] tmpItemid=new String[item+1];
        //String[] tmpItemtitle=new String[item+1];
        String[] tmpItemprice=new String[item+1];
        String[] tmpItemquantity=new String[item+1];
        //float  amount=0;
        String order_id;
        String username;

        try {
            // 取得系统时间
            java.util.Date utilDate = new java.util.Date();
            // 转换成数据库时间
            java.sql.Date date = new java.sql.Date(utilDate.getTime());
            inser = new cartinfo();
            last_order=inser.getId();

            order_id=first_order+last_order;//真正的订单号产生
            inser.insert_order(order_id, name, sex, address, tel, phone, email, postcode, note, date);
            //order_id = inser.getOrderid(date);//确定后的真的订单ID
            //用户名从session中提取,这里先假设一个.
            username = (String)session.getAttribute("Account");
            //获取多个商品ID，用来写入数据库用
            for (int i = 0; i < item; i++)
            {
                tmpItemid[i] = req.getParameter("id"+i);
                tmpItemprice[i]=req.getParameter("price"+i);
                tmpItemquantity[i]=req.getParameter("quantity"+i);
                //总价格
                //amount+=Float.parseFloat(tmpItemprice[i])*Integer.parseInt(tmpItemquantity[i]);

                inser.insert_order_main(username, tmpItemid[i], order_id,tmpItemprice[i], tmpItemquantity[i], payment,send_state);

            }
            inser.getClose();
            res.sendRedirect("succ.jsp?order_id="+order_id);
        }
        catch (Exception e) {
            System.out.println("异常："+e.getMessage());
        }
    }

    //Clean up resources
    public void destroy() {
    }
}