loan.java

jsp开发的固定资产管理系统

/**
 *  Title  pams
 *  @author: dzc
 *  Company: hust
 *  Copyright: Copyright (c) 2005
 *  @version 1.0
 *  Date  :   2006-04
 *  Filename:Asset.java
 **/

package pams.asset;

import pams.database.DBConnect;
import pams.system.Log;
import pams.util.*;

import java.sql.*;
import java.util.*;

public class Loan {

	public String AssetID, LoanDept, LoanName, MangleStatus, Remark;

	public java.sql.Date LoanDate, ReturnDate;

	public int LoanNO, LoanNum;

	public Loan() {
	};

	public String getAssetID() {
		return AssetID;
	}

	public void setAssetID(String s) {
		this.AssetID = s;
	}

	public String getLoanDept() {
		return LoanDept;
	}

	public void setLoanDept(String s) {
		this.LoanDept = s;
	}

	public String getLoanName() {
		return LoanName;
	}

	public void setLoanName(String s) {
		this.LoanName = s;
	}

	public String getMangleStatus() {
		return MangleStatus;
	}

	public void setMangleStatus(String s) {
		this.MangleStatus = s;
	}
	
	public String getRemark() {
		return Remark;
	}

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

	public String getLoanDate() {
		if (this.LoanDate != null)
			return DataConvert.sqlDateToStr(LoanDate);
		else
			return "";
	}

	public void setLoanDate(String strBir) {
		if (strBir != null)
			this.LoanDate = DataConvert.StrTosqlDate(strBir);
		else
			this.LoanDate = null;
	}

	public String getReturnDate() {
		if (this.ReturnDate != null)
			return DataConvert.sqlDateToStr(ReturnDate);
		else
			return "";
	}

	public void setReturnDate(String strBir) {
		if (strBir != null)
			this.ReturnDate = DataConvert.StrTosqlDate(strBir);
		else
			this.ReturnDate = null;
	}

	public String getLoanNO() {
		return DataConvert.IntToStr(LoanNO);
	}

	public void setLoanNO(int i) {
		this.LoanNO = i;
	}

	public String getLoanNum() {
		return DataConvert.IntToStr(LoanNum);
	}

	public void setLoanNum(int i) {
		this.LoanNum = i;
	}

	/*
	 * Find Loan by No
	 */
	public static Loan FindByNO(String _LoanNO) {
		DBConnect dbc = null;
		Loan loan = new Loan();
		try {
			dbc = new DBConnect();
			dbc.prepareStatement("SELECT * FROM loan WHERE LoanNO = ?");
			dbc.setInt(1, DataConvert.StrToInt(_LoanNO));
			ResultSet rs = dbc.executeQuery();
			if (rs.next()) {
				loan.setLoanNO(rs.getInt("LoanNO"));
				loan.setAssetID(rs.getString("AssetID"));
				loan.setLoanDate(rs.getString("LoanDate"));
				loan.setLoanDept(rs.getString("LoanDept"));
				loan.setLoanName(rs.getString("LoanName"));
				loan.setLoanNum(rs.getInt("LoanNum"));
				loan.setReturnDate(rs.getString("ReturnDate"));
				loan.setMangleStatus(rs.getString("MangleStatus"));
				loan.setRemark(rs.getString("Remark"));
			} else {
				loan = null;
			}
		} catch (Exception e) {
			System.err.println(e);
		} finally {
			try {
				dbc.close();
			} catch (Exception e) {
				e.printStackTrace();
				loan = null;
			}
		}
		return loan;
	}

	/*
	 * Add Loan
	 */
	public static String Add(String _AssetID, String _LoanDate, String _LoanDept,
			String _LoanName, String _LoanNum, String _Remark,String _UserName) {
		DBConnect dbc = null;
		try {
			dbc = new DBConnect();
			dbc
					.prepareStatement("INSERT INTO loan (AssetID,LoanDate,LoanDept,LoanName,LoanNum,"
							+ "Remark) VALUES (?,?,?,?,?,?)");
			dbc.setString(1, _AssetID);
			dbc.setDate(2, DataConvert.StrTosqlDate(_LoanDate));
			dbc.setString(3, _LoanDept);
			dbc.setString(4, _LoanName);
			dbc.setInt(5, DataConvert.StrToInt(_LoanNum));
			dbc.setString(6, _Remark);
			dbc.executeUpdate();
			Log.Add(_UserName, "loan", "Add");
			dbc.close();
			return "1";

		} catch (Exception e) {
			System.err.println(e);
			return e.toString();
		}
	}

	/*
	 * Return
	 */
	public static String Return(String _LoanNO, String _ReturnDate,String _MangleStatus,String _UserName) {
		DBConnect dbc = null;
		try {
			dbc = new DBConnect();
			dbc.prepareStatement("UPDATE loan SET ReturnDate=?,MangleStatus=? WHERE LoanNO=?");
			dbc.setDate(1, DataConvert.StrTosqlDate(_ReturnDate));
			dbc.setString(2, _MangleStatus);
			dbc.setInt(3, DataConvert.StrToInt(_LoanNO));
			dbc.executeUpdate();
			Log.Add(_UserName, "loan", "Modify");
			dbc.close();
			return "1";
		} catch (Exception e) {
			e.printStackTrace();
			return e.toString();
		}
	}
	
	/*
	 * Delete loan
	 */
	public static String Delete(String _LoanNO,String _UserName) {
		try {
			DBConnect dbc = new DBConnect();
			dbc.prepareStatement("DELETE FROM loan WHERE LoanNO=?");
			dbc.setInt(1, DataConvert.StrToInt(_LoanNO));
			dbc.executeUpdate();
			Log.Add(_UserName, "loan", "Delete");
			dbc.close();
			return "1";
		} catch (Exception e) {
			e.printStackTrace();
			return e.toString();
		}
	}

	/*
	 * List All Loan
	 */
	public static Vector ListAll() {
		DBConnect dbc = null;
		Vector LoanVector = new Vector();

		String strSQL = "SELECT * FROM loan ORDER BY AssetID,LoanDate ASC";

		try {
			dbc = new DBConnect();
			dbc.prepareStatement(strSQL);
			ResultSet rs = dbc.executeQuery();
			while (rs.next()) {
				Loan loan = new Loan();
				loan.setLoanNO(rs.getInt("LoanNO"));
				loan.setAssetID(rs.getString("AssetID"));
				loan.setLoanDate(rs.getString("LoanDate"));
				loan.setLoanDept(rs.getString("LoanDept"));
				loan.setLoanName(rs.getString("LoanName"));
				loan.setLoanNum(rs.getInt("LoanNum"));
				loan.setReturnDate(rs.getString("ReturnDate"));
				loan.setMangleStatus(rs.getString("MangleStatus"));
				loan.setRemark(rs.getString("Remark"));
				LoanVector.add(loan);
			}
		} catch (Exception e) {
			System.err.println(e);
		} finally {
			try {
				dbc.close();
			} catch (Exception e) {
				e.printStackTrace();
			}
		}
		return LoanVector;
	}

}