order_query_bean.java

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

package ksnb;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import java.sql.*;
public class order_query_bean {

    private Statement st;
    private ResultSet rs;
    Collection c=new ArrayList();
    Collection u=new ArrayList();
    SQL_execute exe = new SQL_execute();

    String Name;  //会员账户名
    String Product_id;//商品ID
    String r_info_id; //订单ID
    String Price;//商品单价
    String Quantity;//购买数量
    String Payment;//支付方式
    String send_State;//送货方式
    String Status;    //订单状态
    String r_Name;   //发货人姓名
    String R_Address;  //发货人地址
    String R_tel;//发货人电话　
    String Note;  //留言
    String Date_time;//下订单时间

    public order_query_bean() {
    }

    public Collection fg_query(HttpServletRequest request, HttpServletResponse response)
    {
        System.out.println("你已提交到orderquery_bean");
        String Account=request.getParameter("Account");
        r_info_id=request.getParameter("r_info_id");
        Date_time=request.getParameter("Date_time");
        String sql=null;
        if(r_info_id.length()>0)
        {
            //sql="select * from shop_order_main main inner join Shop_order_r_info info on main.r_info_id=info.order_id where info.id='"+r_info_id+"'";

        }
        else
        {
            sql="select distinct r_info_id,Date_time from R_info_id where name='"+Account+"' and Date_time like'%"+Date_time+"%'";
            //sql = "select * from shop_order_main main inner join Shop_order_r_info info on main.r_info_id=info.order_id where main.name='"+Account+"' and info.Date_time like'%"+Date_time+"%'";

        }
        System.out.println("你输入的查询语句是："+sql);
        try
        {
            rs=exe.query(sql);
            while (rs.next()) { //此处必须使用while，使用if，只以可读取一条记录

                r_info_id=rs.getString("r_info_id");
                c.add(r_info_id);
                Date_time=rs.getString("Date_time");
                c.add(Date_time);
                c.add(r_info_id);
                //c.add(Date_time);
               /* Name=rs.getString("Name");

                r_info_id=rs.getString("r_info_id");
                c.add(r_info_id);

                Product_id=rs.getString("Product_id");
                c.add(Product_id);



            Price=rs.getString("Price");
            c.add(Price);


            Quantity=rs.getString("Quantity");
            //c.add(Quantity);



            Payment=rs.getString("Payment");
           // c.add(Payment);

            send_State=rs.getString("send_State");
            //c.add(send_State);


            Status=rs.getString("Status");
            c.add(Status);


            r_Name=rs.getString("r_Name");
            //c.add(r_Name);

            R_Address=rs.getString("R_Address");
            //c.add(R_Address);

            R_tel=rs.getString("R_tel");
            //c.add(R_tel);

            Note=rs.getString("Note");
           // c.add(Note);

            Date_time=rs.getString("Date_time");
            //c.add(Date_time);  */
            }
        }
        catch(Exception e)
        {}
        return c;
    }

    public Collection ordershop(HttpServletRequest request, HttpServletResponse response)
    {
         r_info_id=request.getParameter("r_info_id");
         Name=request.getParameter("Account");
         r_info_id= r_info_id.trim();
         String sql="select * from shop_order_main where r_info_id='"+ r_info_id+"' and Name='"+Name+"'";
          System.out.println(sql);
         //select * from shop_order_main main inner join Shop_product_info info on main.product_id=info.id

        try{
            rs=exe.query(sql);
            System.out.println(sql);
            while (rs.next()){ //此处必须使用while，使用if，只以可读取一条记录
                Product_id = rs.getString("Product_id");
                c.add(Product_id);

                Price = rs.getString("Price");
                c.add(Price);

                Quantity = rs.getString("Quantity");
                c.add(Quantity);

                String order_state=rs.getString("Order_State");
                c.add(order_state);

                Payment = rs.getString("Payment");
                c.add(Payment);

                send_State = rs.getString("send_State");
                c.add(send_State);
            }
        }
        catch(Exception e)
        {
            this.close();
        }
        return c;
    }
    public Collection bg_orderid(HttpServletRequest request, HttpServletResponse response)
    {
        System.out.println("你已提交到orderquery_bean");
        String Account=request.getParameter("Account");
        //r_info_id=request.getParameter("r_info_id");
        Date_time=request.getParameter("Date_time");
        Status=request.getParameter("Status");
        String sql=null;

        sql="select distinct r_info_id,Date_time from R_info_id where name like'%"+Account+"%' and Date_time like'%"+Date_time+"%' and Status='"+Status+"'";
        System.out.println("你输入的查询语句是："+sql);
        try
        {
            rs = exe.query(sql);
            while (rs.next())
            { //此处必须使用while，使用if，只以可读取一条记录

                r_info_id = rs.getString("r_info_id");
                c.add(r_info_id);
                Date_time = rs.getString("Date_time");
                c.add(Date_time);
                c.add(r_info_id);
            }
        }
        catch(Exception e){}
        return c;
    }

    float x;
    float y;
    float rr;
    static float zh;
    public Collection bg_orderquery(String orderid)
    {
         zh=0.0f;
         String sql="select * from shop_order_main where r_info_id='"+ orderid+"'";
         try{
             rs=exe.query(sql);
             System.out.println(sql);
             while (rs.next()){
                 x=0;
                 y=0;
                 rr=0;

                 Product_id = rs.getString("Product_id");
                 c.add(Product_id);

                 Price = rs.getString("Price");
                 c.add(Price);

                 Quantity = rs.getString("Quantity");
                 c.add(Quantity);

                 x=Float.parseFloat(Price);
                 y=Float.parseFloat(Quantity);
                 rr=x*y;
                 String xj=String.valueOf(rr);
                 c.add(xj);

                 String order_state=rs.getString("Order_State");
                 c.add(order_state);

                 Payment = rs.getString("Payment");
                 c.add(Payment);

                 send_State = rs.getString("send_State");
                 c.add(send_State);


                 zh+=rr;  //计算总额　　放入到隐藏域
                 String he=String.valueOf(zh);
                 c.add(he);
             }
         }
         catch(Exception e)      {             this.close();         }
         return c;
     }
     public Collection Accountmessage(String orderid)
     {
         System.out.println("你使用的是订单号查询Account");
         String sql="select * from Shop_order_r_info where order_id='"+orderid+"'";
         System.out.println("ACCount"+sql);

         int x=0;
        try {
            rs=exe.query(sql);
            while (rs.next()) {
                System.out.println("你212121使用的是订单号查询");
                String order_id=rs.getString("Order_id");

                Name = rs.getString("R_Name");
                u.add(Name);

                String sex=rs.getString("Sex");
                u.add(sex);

                String R_Address=rs.getString("R_Address");
                u.add(R_Address);

                String phone=rs.getString("Phone");
                u.add(phone);

                String Email=rs.getString("Email");
                u.add(Email);

                String postcode=rs.getString("Post_code");
                u.add(postcode);

                String R_Tel=rs.getString("R_Tel");
                u.add(R_Tel);

                String Date_time=rs.getString("Date_time");
                u.add(Date_time);

                Status=rs.getString("Status");
                u.add(Status);

                u.add(order_id);
                u.add(order_id);
                System.out.println(order_id);
                System.out.println("你使21212121212444用的是订单号查询");

            }
        } catch (SQLException ex) {
            this.close();
        }
        return u;
     }
    public void close()
    {
        exe.close();
    }
}