package kignbi.dong;

//import java.sql.ResultSet;
//import java.util.Vector;

public class Borrow {
	private String id;
	private String uid;
	private String bid;
	private String dt_borrow; 
	private String dt_return;      
	private int number ;                
	private int not_num;           
	private int days;
	private int state;
	private String remark;
	public Borrow()
	{}
	public String getBid() {
		return bid;
	}
	public void setBid(String bid) {
		this.bid = bid;
	}
	public int getDays() {
		return days;
	}
	public void setDays(int days) {
		this.days = days;
	}
	public String getDt_borrow() {
		return dt_borrow;
	}
	public void setDt_borrow(String dt_borrow) {
		this.dt_borrow = dt_borrow;
	}
	public String getDt_return() {
		return dt_return;
	}
	public void setDt_return(String dt_return) {
		this.dt_return = dt_return;
	}
	public int getNot_num() {
		return not_num;
	}
	public void setNot_num(int not_num) {
		this.not_num = not_num;
	}
	public int getNumber() {
		return number;
	}
	public void setNumber(int number) {
		this.number = number;
	}
	public String getRemark() {
		return remark;
	}
	public void setRemark(String remark) {
		this.remark = remark;
	}
	public String getUid() {
		return uid;
	}
	public void setUid(String uid) {
		this.uid = uid;
	}

	public int getState() {
		return state;
	}
	public void setState(int state) {
		this.state = state;
	}
	/*
	public Borrow(String uid, String bid, String dt_borrow, int number,
			int not_num){
		this.uid=uid;
		this.bid=bid;
		this.dt_borrow=dt_borrow;
		this.number=number;
		this.not_num=not_num;
		this.state=1;
		this.remark=null;
	}
	public static Vector allBorrows(DB db) throws Exception {
		Vector Borrows = new Vector();
		ResultSet rs;
		String strSql = null;

		strSql = "select * from borrow where state=1";
		rs = db.OpenSql(strSql);

		while (rs.next()) {
			Borrow borrow = new Borrow();
			borrow.setUid(rs.getString("uid"));
			borrow.setBid(rs.getString("bid"));
		    borrow.setDt_borrow(rs.getString("dt_borrow"));
			borrow.setDt_return(rs.getString("dt_return"));
            borrow.setNumber(rs.getInt("number"));
            borrow.setNot_num(rs.getInt("not_num"));
            borrow.setDays(rs.getInt("days"));
            borrow.setRemark(rs.getString("remark"));
			Borrows.add(borrow);
		}
		return Borrows;
	}
	public static Vector whoBorrows(DB db,String uid) throws Exception {
		Vector Borrows = new Vector();
		ResultSet rs;
		String strSql = null;

		strSql = "select * from borrow where state=1 and dbo.trim(uid)='"
			    +uid+"'";
		rs = db.OpenSql(strSql);

		while (rs.next()) {
			Borrow borrow = new Borrow();
			borrow.setUid(rs.getString("uid"));
			borrow.setBid(rs.getString("bid"));
		    borrow.setDt_borrow(rs.getString("dt_borrow"));
			borrow.setDt_return(rs.getString("dt_return"));
            borrow.setNumber(rs.getInt("number"));
            borrow.setNot_num(rs.getInt("not_num"));
            borrow.setDays(rs.getInt("days"));
            borrow.setRemark(rs.getString("remark"));
			Borrows.add(borrow);
		}
		return Borrows;
	}
	public static Vector whoBorrow(DB db,String uname) throws Exception {
		Vector Borrows = new Vector();
		ResultSet rs;
		String strSql = null;

		strSql = "select * from borrow t,users d where t.state=1 and dbo.trim(t.uid)="
			    +"dbo.trim(d.uid) and dbo.trim(d.uname)='"+uname+"'";
		rs = db.OpenSql(strSql);

		while (rs.next()) {
			Borrow borrow = new Borrow();
			borrow.setUid(rs.getString("uid"));
			borrow.setBid(rs.getString("bid"));
		    borrow.setDt_borrow(rs.getString("dt_borrow"));
			borrow.setDt_return(rs.getString("dt_return"));
            borrow.setNumber(rs.getInt("number"));
            borrow.setNot_num(rs.getInt("not_num"));
            borrow.setDays(rs.getInt("days"));
            borrow.setRemark(rs.getString("remark"));
			Borrows.add(borrow);
		}
		return Borrows;
	}
	
	public static boolean edit(DB db,String uid,String bid,
			String dt_return,int not_num,int days,String remark) throws Exception {
		System.out.println("editing");
		String strSql;
		String strSql2;
		strSql = "update borrow set dt_return='"+dt_return+"',not_num="
			+ not_num + ", remark=" +remark+" where dbo.trim(bid)='" +bid
			+"',and dbo.trim(uid)= '"+uid+"'";
		strSql2="update borrow set state=0 where not_num=0";
		if (db.ExecSql(strSql) == 0) {
			return false;
		} else {
			db.ExecSql(strSql2);
			System.out.print("更新借書狀態:"+strSql2+"");
			return true;
		}
	}	
	public static boolean insert(DB db,String uid, String bid, int number,int days)
	throws Exception{
		String strSql;
		strSql = "insert into  borrw(uid,bid,number ,not_number,days)"
			+"values ('"+uid+"','"+bid+"',"+number+","+number+","+days+")";
		if (db.ExecSql(strSql) == 0) {
			return false;
		} else {
			return true;
		}	
	
}
	
	public static boolean delete(DB db, String uid,String bid) throws Exception {
		String strSql;
		strSql = "delete from borrw where dbo.trim(bid)='" + bid + "' and dbo.trim(uid)='"
		+uid+"'";
		if (db.ExecSql(strSql) == 0) {
			return false;
		} else {
			return true;
		}
	}*/
	public String getId() {
		return id;
	}
	public void setId(String id) {
		this.id = id;
	}
}