goods.java

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

package org.tsinghua.netshop.beans;

import java.util.*;
import org.tsinghua.netshop.beans.DBConnection;
import java.sql.*;
import java.util.Date;


public class Goods {
    public static DBConnection cn = new DBConnection("localhost", "netshop");

    private int id;
    private float freight;
    private String ppic;
    private String pname;
    private String pid;
    private String remark;
    private float price;
    private Date datetime;
    private int isopen;
    private String xremark;
    private String spec;
    private int iscommend;
    private int buyNumber;



    public void setbuyNumber(int buyNumber) {
        this.buyNumber = buyNumber;
    }

    public int getbuyNumber() {
        return buyNumber;
    }

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

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

    public float getFreight() {
        return this.freight;
    }

    public void setFreight(float freight) {
        this.freight = freight;
    }

    public String getPpic() {
        return this.ppic;
    }

    public void setPpic(String ppic) {
        this.ppic = ppic;
    }

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

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

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

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

    public String getRemark() {
        return this.remark;
    }

    public void setRemark(String remark) {
        this.remark = remark;
    }

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

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

    public Date getDatetime() {
        return this.datetime;
    }

    public void setDatetime(Date datetime) {
        this.datetime = datetime;
    }

    public int getIsopen() {
        return this.isopen;
    }

    public void setIsopen(int isopen) {
        this.isopen = isopen;
    }

    public String getXremark() {
        return this.xremark;
    }

    public void setXremark(String xremark) {
        this.xremark = xremark;
    }

    public String getSpec() {
        return this.spec;
    }

    public void setSpec(String spec) {
        this.spec = spec;
    }

    public int getIscommend() {
        return this.iscommend;
    }

    public void setIscommend(int iscommend) {
        this.iscommend = iscommend;
    }


    public boolean insert() {
        return cn.update("insert into goods values('" + pid + "','" + pname +
                         "'," + price + "," + freight + ",'" + ppic + "','" +
                         remark + "','" + spec + "','" + xremark + "','" +
                         datetime + "','" + iscommend + "','" + isopen + "')");
    }

    public boolean update() {
        return cn.update("update goods set pname='" + pname + "',price=" +
                         price + ",freight=" + freight + ",ppic='" + ppic +
                         "',remark='" + remark + "',spec='" + spec +
                         "',xremark='" + xremark + "',datetime='" +
                         datetime.toLocaleString() + "',iscommend=" + iscommend +
                         ",isopen=" + isopen + " where pid='" + this.pid + "'");
    }

    public void loadByPid(String pid) {
        ResultSet rs = cn.select("select * from goods where pid='" + pid + "'");
        try {
            if (rs.next()) {
                this.id = rs.getInt(1);
                this.pid = rs.getString(2);
                this.pname = rs.getString(3);
                this.price = rs.getFloat(4);
                this.freight = rs.getFloat(5);
                this.ppic = rs.getString(6);
                this.remark = rs.getString(7);
                this.spec = rs.getString(8);
                this.xremark = rs.getString(9);
                this.datetime = rs.getDate(10);
                this.iscommend = rs.getInt(11);
                this.isopen = rs.getInt(12);
            } else {
                throw new Exception("没有这样的产品--" + pid);
            }
        } catch (SQLException ex) {
        } catch (Exception ex) {
        }
    }

    public static Collection findAllPid() throws Exception {
        Vector v = new Vector();
        ResultSet rs = cn.select("select pid from goods ");
        while (rs.next()) {
            String pid = rs.getString(1);
            v.add(pid);
        }
        return v;
    }

    public static ArrayList findAll() throws Exception {
        ResultSet rs = cn.select("SELECT * FROM goods order by id");
        ArrayList a = new ArrayList();
        while (rs.next()) {
            Goods g = new Goods();
            g.setId(rs.getInt(1));
            g.setPid(rs.getString(2));
            g.setPname(rs.getString(3));
            g.setPrice(rs.getFloat(4));
            g.setFreight(rs.getFloat(5));
            g.setPpic(rs.getString(6));
            g.setRemark(rs.getString(7));
            g.setSpec(rs.getString(8));
            g.setXremark(rs.getString(9));
            g.setDatetime(rs.getDate(10));
            g.setIscommend(rs.getInt(11));
            g.setIsopen(rs.getInt(12));
            a.add(g);
        }
        return a;
    }

    public static ArrayList findIsopen() {
        ResultSet rs = cn.select(
                "SELECT * FROM goods WHERE (isopen = '1') order by id");
        ArrayList a = new ArrayList();
        try {
            while (rs.next()) {
                Goods g = new Goods();
                g.setId(rs.getInt(1));
                g.setPid(rs.getString(2));
                g.setPname(rs.getString(3));
                g.setPrice(rs.getFloat(4));
                g.setFreight(rs.getFloat(5));
                g.setPpic(rs.getString(6));
                g.setRemark(rs.getString(7));
                g.setSpec(rs.getString(8));
                g.setXremark(rs.getString(9));
                g.setDatetime(rs.getDate(10));
                g.setIscommend(rs.getInt(11));
                g.setIsopen(rs.getInt(12));
                a.add(g);
            }
        } catch (SQLException ex) {
        }
        return a;

    }

    /*	public static void main(String args[])throws Exception{
                  Collection c=new ArrayList();
                  c=Goods.findAll();
          Goods g=new Goods();
          g.loadByPid("0001");
          System.out.println(g.getPname());
          g.setPname("qqwer");
          g.setPid("vvv");
          g.insert();
          //System.out.println(g.findAllPid());

          //g.insert();
          //g.update();
          //g.loadByPid("2");
      }*/
}