order_query.java

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

package ksnb;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.Connection;

public class order_query extends HttpServlet {
    private static final String CONTENT_TYPE = "text/html; charset=GBK";
    private Statement st;
    private ResultSet rs;
    private Connection con;
    Collection c;
    Collection u;
    String r_info_id;
    //Initialize global variables
    public void init() throws ServletException {
    }

    //Process the HTTP Post request
    public void doPost(HttpServletRequest request, HttpServletResponse response) throws
            ServletException, IOException {
        response.setContentType(CONTENT_TYPE);

        order_query_bean order=new order_query_bean();
        String button=request.getParameter("button");
        System.out.println(button);


        if(button.equals("FG"))
        {
           r_info_id=request.getParameter("r_info_id");
            System.out.println("此表单由前台会员提交");
             if(r_info_id.length()>0)
             {
               c=order.ordershop(request,response);
               request.setAttribute("cc", c);
               RequestDispatcher rd = request.getRequestDispatcher("FG_orderprint.jsp"); //实行转发
               rd.forward(request, response);

             }
             else{
                 c = order.fg_query(request, response);
                 request.setAttribute("cc", c);
                 RequestDispatcher rd = request.getRequestDispatcher("FG_ordershow.jsp"); //实行转发
                 rd.forward(request, response);
             }
        }
        if(button.equals("FG_orderid"))
        {
            System.out.println("你好");
            c=order.ordershop(request,response);
            System.out.println("你好");
            request.setAttribute("cc", c);
            RequestDispatcher rd = request.getRequestDispatcher("FG_orderprint.jsp"); //实行转发
            rd.forward(request, response);
        }
        if(button.equals("BG"))
        {
             r_info_id=request.getParameter("r_info_id");
             if(r_info_id.length()>0)
             {
               System.out.println("你使用的是订单号查询");
               c=order.bg_orderquery(r_info_id);
               u=order.Accountmessage(r_info_id);
               request.setAttribute("cc",c);
               request.setAttribute("uu",u);
               RequestDispatcher rd = request.getRequestDispatcher("BG_ordershow.jsp"); //实行转发
               rd.forward(request, response);
             }
             else
             {
                 c = order.bg_orderid(request, response);
                 request.setAttribute("cc", c);
                 RequestDispatcher rd = request.getRequestDispatcher("BG_orderidshow.jsp"); //实行转发
                 rd.forward(request, response);
             }
        }
        order.close();


    }

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