orderinfo.java

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

package ksnb;
//订单打印获取信息的JAVA类
import java.sql.*;
import javax.servlet.http.HttpSession.*;

public class orderinfo {
    //只在订单上反映用户的这些信息
    public   static String name;
    public   static String sex;
    public   static String tel;
    public   static String address;
    public   static String phone;
    public   static String postcode;
    public   static String note;
    public   static String datetime;
    public   static String email;
    public   static String payment;
    public   static String sendstate;

    public static String[] bookname;
    //public static float price;
    //public static int quantity;

    public  int i;
    //public static int[] id=null;
    //这里先假设有10条记录，把数组大小设置为10，应该从记录结果集获得
    public static float[] price;
    public static int[] quantity;

    Connection con;
    Statement st;
    ResultSet rs,rs1,rs2,rs3;
    conn cn;
    public orderinfo(String order_id) {
        System.out.println("order_id:"+order_id);
        String sql1="select R_name,Sex,R_address,R_tel,Phone,Email,Post_code,Note,Date_Time from shop_order_r_info where order_id='"+order_id+"'";
        String sql2="select Product_id,Price,Quantity,Payment,Send_State from shop_order_main where R_info_id='"+order_id+"'";
        String sql22="select Count(*) as count from shop_order_main where R_info_id='"+order_id+"'";
        System.out.println("sql22="+sql22);
        String sql3="";
        try{
        cn=new conn();
        con=cn.getConncetion();
        st=con.createStatement();

        //先假设一条记录，不用循环（用户名本来就是不能重复的）
        rs=st.executeQuery(sql1);
        //获得用户信息
        while(rs.next())
        {
            name= rs.getString("R_name");
            sex=rs.getString("Sex");
            tel=rs.getString("R_tel");
            phone=rs.getString("phone");
            address=rs.getString("R_address");
            email=rs.getString("Email");
            postcode=rs.getString("Post_code");
            note=rs.getString("Note");
            datetime=rs.getString("Date_Time");
        }
        rs.close();

        rs1=st.executeQuery(sql22);
        int a=0;
        while(rs1.next()){
            a=rs1.getInt("count");
        }
        rs1.close();

        System.out.println("sql2="+sql2);
        rs2=st.executeQuery(sql2);
        System.out.println("aaaaaaa");
        //获得用户所购买的商品信息
        int[] id=new int[a];//书籍id
        price=new float[a];
        quantity=new int[a];
        while(rs2.next()){
            System.out.println("a");
            id[i]=rs2.getInt("Product_id");
            System.out.println("b");
            price[i]=rs2.getFloat("Price");
            System.out.println("c");
            quantity[i]=rs2.getInt("Quantity");
            payment = rs2.getString("Payment");
            sendstate = rs2.getString("Send_State");
            i++;
        }
        rs2.close();

        //通过id获得书的名称
        System.out.println("i="+i);
        bookname=new String[a];
        for (int j=0;j<i;j++){
            sql3="select Name from Shop_Product_Info where Id="+id[j];
            System.out.println("sql3="+sql3);
            rs3=st.executeQuery(sql3);
            System.out.println("bbbbbbbb");
            while(rs3.next()){
                System.out.println(rs3.getString("Name"));
                bookname[j] = rs3.getString("Name");
            }
            System.out.println("bookname="+bookname[j]);;
            rs3.close();
        }
        System.out.println("连接成功");
       }catch(Exception e){
           System.out.println(e.getMessage()+"数据库连接失败……");
       }
    }

   public void getClose() throws connException{
       try{
           cn.conClose();
       }catch(Exception e){}
   }
   public int getRow(){
       return i;
   }
}