orderbean.java

一个简单实用的网上书城,可当作原型使用

        package czm;
        import java.sql.*;
        public class OrderBean {
                private static String strDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
                private static String strDBUrl = "jdbc:odbc:bookstore";
                private Connection conn =null;
                private ResultSet rs = null;
                private java.lang.String bookinfo = null;
                private java.lang.String oderprice = null;
                private java.lang.String orderDate = null;
                private int orderID1;
               private int numm=0;
                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;

            private Connection conn1;

            private ResultSet rs1;

                public OrderBean(){
                        try {
                                Class.forName(strDBDriver );
                        }
                        catch(java.lang.ClassNotFoundException e){
                                System.err.println("OrderBean ():" + e.getMessage());
                        }
                }


        /**
         * 返回定单的总价。
         */
        public java.lang.String getOrderprice() {
                        return oderprice;
        }

        /**
         *返回定单的日期 。
         */
        public java.lang.String getOrderDate() {
                        orderDate = new java.util.Date().toString();
                        return orderDate;
        }

        /**
         * 返回定单的ID号。
         */
        public int getOrderID() {
                        return orderID1;
        }

        /**
         * 返回定单的备注信息。
         */
        public java.lang.String getMemo() {
                        return orderRem;
        }
       
        /**
         * 返回接收者的地址
         */
        public java.lang.String getReceiverAddress() {
                return receiverAddress;
        }

        /**
         * 返回接收者的姓名。
         */
        public java.lang.String getReceiverName() {
                        return receiverName;
        }

        /**
         * 返回接收者的邮政编码。
         */
        public java.lang.String getReceiverZip() {
                        return receiverZip;
        }

        /**
         * 获得用户ID。
         */
        public java.lang.String getUserID() {
                        return userID;
        }

        /**
         * 给图书信息赋值。
         */
        public void setBookinfo(java.lang.String newBookinfo) throws ClassNotFoundException {
                        bookinfo = newBookinfo;
                        numm=0;
                      // createNewOrder();

                       
                        int fromIndex = 0;
                        int tmpIndex = 0;
                        int tmpEnd = 0;
                        String strSql = null;
                        try{   
                                Class.forName(strDBDriver);
                                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("BuyerBean.getLogontimes():" + e.getMessage());
                        }
        }

        /**
         *给定单的总价赋值。
         * @param newOderprice Java.lang.String
         */
        public void setOrderprice(java.lang.String newOderprice) {
                        oderprice = newOderprice;
        }

        /**
         * 给定单的备注赋值。
         */
        public void setMemo(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 systemP() {
                System.out.println(""+numm);
        }

        /**
         * 给接收者的邮政编码代码赋值。
         */
        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();
                                String strSqlT = "select * from orderInfo ";
                                rs=stmt.executeQuery(strSqlT);
                                 while (rs.next()){
                                    numm++;

                               }
                                numm=numm+1;
                                strSql = "insert into orderInfo(orderID,memberID,receiverName,receiverAddress,receiverZip,orderRem,orderPrice,Orderdate) values("+numm+",'" +getUserID() + "','" + getReceiverName() + "','"+ getReceiverAddress() + "','"+ getReceiverZip() + "','" + getMemo() + "','"+ getOrderprice() + " ','" +getOrderDate() + "')";
                               int i= stmt.executeUpdate(strSql);
                                rs.close();
                                stmt.close();
                                conn.close();
                                conn1 = DriverManager.getConnection(strDBUrl);
                                Statement stmt1 = conn.createStatement();
                                strSql = "select * from  orderInfo where memberID = '"+ getUserID() + "' and receiverName = '" + getReceiverName() + "' and receiverAddress =  '" + getReceiverAddress() +"' and receiverZip =  '"  + getReceiverZip() +"' and orderRem = '" + getMemo() + "' and orderPrice =' " + getOrderprice() +"'  and Orderdate  = '"+ getOrderDate() + "'" ;
                                orderID1 =0;
                                rs1 = stmt.executeQuery(strSql);
                                //orderID1 = rs.getInt("orderID");
                               while (rs.next()){
                                    orderID1++;

                               }
                                orderID1=orderID1+1;

                        rs1.close();
                        stmt1.close();
                        conn1.close();

                }
                catch(SQLException e){
                        System.err.println("BuyerBean.getLogontimes():" + e.getMessage());
                }
        }
         public ResultSet getOrderInfo(){
                   try{  
                       String strA="select * from orderdetail";
                       conn=DriverManager.getConnection(strDBUrl);
                       Statement stmt=conn.createStatement();
                       rs=stmt.executeQuery(strA);
                   }catch(Exception ex){}
                   return rs;
        }
          public ResultSet getOrderXinagXiInfo(){
                   try{  
                       String strA="select * from orderInfo";
                       conn=DriverManager.getConnection(strDBUrl);
                       Statement stmt=conn.createStatement();
                       rs=stmt.executeQuery(strA);
                   }catch(Exception ex){}
                   return rs;
        }
 }