whm_order.java

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

package ksnb;

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.sql.*;

public class whm_order extends HttpServlet {
    private static final String CONTENT_TYPE = "text/html; charset=GB2312";
    ResultSet rs=null;
    whm_pwd_order wpo=null;
    CharConvert cc=new CharConvert();
    //Initialize global variables
    public void init() throws ServletException {

    }
    //Process the HTTP Get request
    public void service(HttpServletRequest request,
                        HttpServletResponse response) throws
            ServletException, IOException {
        response.setContentType(CONTENT_TYPE);
        String pag = request.getParameter("page");
        System.out.println("pag:"+pag);
        String page="";
        if (pag.equals("whm_order")) {
            String order_id = request.getParameter("order_id");
            String name = cc.convert(request.getParameter("name"));
            String date = request.getParameter("date");
            int status = Integer.parseInt(request.getParameter("status"));
            String sql;
            //在条件不确定的情况下，怎么样写多条件查询语句？？？？
            sql = "select * from Shop_Order_R_Info where order_id='"
                  + order_id + "' or R_name='" + name + "' or Date_Time='" +
                  date +
                  "' or Status=" + status;
           page = "whm_order_info.jsp?sql="+sql;

        }else if(pag.equals("whm_order_info"))
        {
            String id=request.getParameter("order_id");
            int status=Integer.parseInt(request.getParameter("status"));
            try{
                wpo=new whm_pwd_order();
                wpo.rework_order_status(id,status);
                page="succeed.jsp";
            }catch(Exception e){
                System.out.println(e.toString());
            }
        }
        RequestDispatcher rd = request.getRequestDispatcher(page);
        rd.forward(request, response);
    }
    public ResultSet getRs(){
        return rs;
    }
    //Clean up resources
    public void destroy() {
        wpo.getClose();
    }
}