orderform.java

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

package org.tsinghua.netshop.beans;

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

public class Orderform {
    private int status;
    private int uid;
    private float total;
    private int serid;
    private int islock;
    private String remark;
    private int fid;
    private java.util.Date datetime;

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

    public boolean updateStatus() {
        return dbc.update("UPDATE orderform SET status = '" + status +
                          "' WHERE fid = '" + fid + "'");
    }

    public boolean loadByFid(int fid) throws Exception {
        ResultSet rs = dbc.select("SELECT * FROM orderform where fid= '" + fid +
                                  "'");
        if (rs.next()) {
            this.fid = rs.getInt(1);
            this.uid = rs.getInt(2);
            this.total = rs.getFloat(3);
            this.status = rs.getInt(4);
            this.remark = rs.getString(5);
            this.datetime = rs.getDate(6);
            this.islock = rs.getInt(7);
            this.serid = rs.getInt(8);
            return true;
        } else {
            System.out.println("您所查询的信息不存在");
            return false;
        }

    }

    public boolean insert() {
        java.util.Date date = new java.util.Date();
        return dbc.update("insert into orderform values('" + uid + "','" +
                          total + "','" + status + "','" + remark + "','" +
                          date.toLocaleString() + "','" + islock + "','" +
                          serid + "')");
    }

    public boolean findFidAndDatetime() {
        ResultSet rs = dbc.select("select fid, datetime from orderform WHERE (uid = '"+uid+"') AND (total = '"+total+"') AND (status = 1) ORDER BY fid DESC");
        try {
            if (rs.next()) {
                this.fid = rs.getInt(1);
                this.datetime = rs.getDate(2);
                return true;
            } else {
                System.out.println("您所查询的信息不存在");
                return false;
            }
        } catch (SQLException ex) {return false;
        }


    }

    public int getStatus() {
        return this.status;
    }

    public void setStatus(int status) {
        this.status = status;
    }

    public int getUid() {
        return this.uid;
    }

    public void setUid(int uid) {
        this.uid = uid;
    }

    public float getTotal() {
        return this.total;
    }

    public void setTotal(float total) {
        this.total = total;
    }

    public int getSerid() {
        return this.serid;
    }

    public void setSerid(int serid) {
        this.serid = serid;
    }

    public int getIslock() {
        return this.islock;
    }

    public void setIslock(int islock) {
        this.islock = islock;
    }

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

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

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

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

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

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

    /*	public static void main(String args[]){
                    try{
                            Orderform o=new Orderform();
                    o.setFid(2);
                    o.setUid(3);
                    o.setTotal(100);
                    o.setStatus(1);
                    o.setRemark("asdasd");
                    o.setIslock(1);

                    o.insert();


                            Collection c=new ArrayList();
                            c=Orderform.findByFid(1);
                            Iterator it=c.iterator();
                            while(it.hasNext()){
                                    Orderform o=(Orderform)it.next();
                                    o.setStatus(2);
                                    o.updateStatus();
                                    System.out.println(o.getTotal());
                            }
                    }catch(Exception e){System.out.println(e);}
            }*/
}