orderbean.java

网站的实例

package ebs;
import java.sql.*;
public class OrderBean{
             private static String strDBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
             private static String strDBUrl="jdbc:odbc:ebookstore";
             private Connection conn=null;
             private ResultSet Rst=null;
             private java.lang.String bookinfo=null;
             private java.lang.String orderprice=null;
             private java.lang.String orderdate=null;
             private java.lang.String orderid=null;
             private java.lang.String orderrem=null;
             private java.lang.String receiveraddress=null;
             private java.lang.String receivername=null;
             private java.lang.String receiverzip=null;
             private java.lang.String userid=null;
             
             public OrderBean(){
             	try{
             	       Class.forName(strDBDriver);
             	   }
             	catch(java.lang.ClassNotFoundException e){
             		System.err.println("OrderBean():"+e.getMessage());
             	   }
             }
             
             public static void main(String args[]){
        }
        
 public java.lang.String getOrderprice(){
 	    return orderprice;
 	   }
 
 public java.lang.String getOrderdate(){
 	  orderdate=new java.util.Date().toString();
 	  return orderdate;
 	 }
 
 public java.lang.String getOrderid(){
 	return orderid;
       }
       
public java.lang.String getOrderrem(){
	return orderrem;
       }
       
public java.lang.String getReceiveraddress(){
	return receiveraddress;
       }
       
public java.lang.String getReceivername(){
	return receivername;
       }
       
public java.lang.String getReceiverzip(){
	return receiverzip;
       }
       
public java.lang.String getUserid(){
	return userid;
       }
       
public void setBookinfo(java.lang.String newBookinfo){
               bookinfo=newBookinfo;
               createNewOrder();
               int fromIndex=0;
               int tmpIndex=0;
               int tmpEnd=0;
               String strSql=null;
               try{
                    conn=DriverManager.getConnection(strDBUrl);
                    Statement stmt=conn.createStatement();
                    while(bookinfo.indexOf(';',fromIndex)!=-1){
                    tmpEnd=bookinfo.indexOf(';',fromIndex);
                    tmpIndex=bookinfo.lastIndexOf('=',tmpEnd);
                    strSql="insert into orderdetail(orderid,bookisbn,bookcount)"+"values('"+getOrderid()+"','"+bookinfo.substring(fromIndex,tmpIndex)+"','"+bookinfo.substring(tmpIndex+1,tmpEnd)+"')";
                    stmt.executeUpdate(strSql);
               fromIndex=tmpEnd+1;
        }
        stmt.close();
        conn.close();
}
catch(SQLException e){
	System.err.println("Buyercar.getLogontimes():"+e.getMessage());
}
}

public void setOrderprice(java.lang.String newOrderprice){
	orderprice=newOrderprice;
}

public void setOrderrem(java.lang.String newOrderrem){
	orderrem=newOrderrem;
}

public void setReceiveraddress(java.lang.String newReceiveraddress){
	receiveraddress=newReceiveraddress;
}

public void setReceivername(java.lang.String newReceivername){
	receivername=newReceivername;
}

public void setReceiverzip(java.lang.String newReceiverzip){
	receiverzip=newReceiverzip;
}

public void setUserid(java.lang.String newUserid){
	userid=newUserid;
}

private void createNewOrder(){
	String strSql=null;
	try{
	      conn=DriverManager.getConnection(strDBUrl);
	      Statement stmt=conn.createStatement();
	      strSql="insert into orderinfo(userid,receivername,receiveraddress,receiverzip,orderrem,orderprice,orderdate)"+"valuse('"+getUserid()+"','"+getReceivername()+"','"+getReceiveraddress()+"','"+getReceiverzip()+"','"+getOrderrem()+"','"+getOrderprice()+"','"+getOrderdate()+"')";
	      stmt.executeUpdate(strSql);
	      strSql="select max(orderid) from orderinfo where userid='"+getUserid()+"' and receivername='"+getReceivername()+"' and receiveraddress='"+getReceiveraddress()+"' and receiverzip='"+getReceiverzip()+"' and orderrem='"+getOrderrem()+"' and orderprice='"+getOrderprice()+"' and orderdate='"+getOrderdate()+"'";
	      orderid=null; 
	      Rst=stmt.executeQuery(strSql);
	      while(Rst.next()){
	      	 orderid=Rst.getString("orderid");
	      	}
	      	Rst.close();
	      	stmt.close();
	      	conn.close();
	}
	catch(SQLException e){
		System.err.println("Buyercar.getLogontimes();"+e.getMessage());
	}
}
}