ordersub.java

这是一本关于高级软件工程的书籍

package org.tsinghua.netshop.beans;
import java.util.*;
import org.tsinghua.netshop.beans.*;
import java.sql.*;

public class Ordersub{
        private String pid;
        private String pname;
        private int number;
        private float price;
        private int fid;
        private int id;

        public static DBConnection dbc=new DBConnection("localhost","netshop");

    public boolean insert() {
        return dbc.update("insert into ordersub values(" + fid +",'"+ pid + "','" + pname + "','" + price + "'," + number + ")");
    }

    public static  ArrayList findByFid(int fid)throws Exception{
        ResultSet rs=dbc.select("SELECT * FROM ordersub where fid= '"+fid+"'");
        ArrayList a=new ArrayList();
        while(rs.next()){
                Ordersub o=new Ordersub();
                o.setId(rs.getInt(1));
                o.setFid(rs.getInt(2));
                o.setPid(rs.getString(3));
                o.setPname(rs.getString(4));
                o.setPrice(rs.getFloat(5));
                o.setNumber(rs.getInt(6));
                a.add(o);
        }
        return a;
    }


        public String getPid(){
                return this.pid;
        }

        public void setPid(String pid){
                 this.pid=pid;
        }

        public String getPname(){
                return this.pname;
        }

        public void setPname(String pname){
                 this.pname=pname;
        }

        public int getNumber(){
                return this.number;
        }

        public void setNumber(int number){
                 this.number=number;
        }

        public float getPrice(){
                return this.price;
        }

        public void setPrice(float price){
                 this.price=price;
        }

        public int getFid(){
                return this.fid;
        }

        public void setFid(int fid){
                 this.fid=fid;
        }

        public int getId(){
                return this.id;
        }

        public void setId(int id){
                 this.id=id;
        }

/*	public static void main(String args[]){
                try{
                        Ordersub o=new Ordersub();
                        o.setFid(1);
                        o.setPid("YPLC-7E");
                        o.setPname("sdfsadfaf");
                        o.setPrice(100.2F);
                        o.setNumber(4);
                        o.insert();
                        Collection c=new ArrayList();
                        c=Ordersub.findByFid(1);
                        Iterator it=c.iterator();
                        while(it.hasNext()){
                                Ordersub o=(Ordersub)it.next();
                                System.out.println(o.getPid());
                        }
                }catch(Exception e){System.out.println(e);}
        }*/

}