lendmodel.java

一个资产管理系统的源码

/*
 *LendModel.java：建立固定资产借用与归还实体类。
 *包括：与数据库进行增、删、改、查操作。
 */

package zichan;

import java.sql.*;
import java.math.*;

public class LendModel {
    public LendModel() {
        try {
            jbInit();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }

    String assetid;
    String assetname;
    String model;
    String price;
    String empno;
    String usedate;
    String retdate;
    String isreturn;
    String lender;
    String remarks;
    DBConnt dbc;
    Connection conn;
    public LendModel(String s0) {
        assetid = s0;
    }

    public void setlend(String s1, String s2, String s3, String s4, String s5) {
        empno = s1;
        usedate = s2;
        retdate = s3;
        isreturn = s4;
        remarks = s5;
        lender = Share.operator;
    }

    public void setret(String s1, String s2, String s3) {
        retdate = s1;
        isreturn = s2;
        remarks = s3;
        lender = Share.operator;
    }

    public String getAssetId() {
        return assetid;
    }

    public String getAssetName() {
        return assetname;
    }

    public String getEmpno() {
        return empno;
    }

    public String getUsedate() {
        return usedate;
    }

    public String getModel() {
        return model;
    }

    public String getPrice() {
        return price;
    }

    public String getRetdate() {
        return retdate;
    }

    public String getIsreturn() {
        return isreturn;
    }

    public String getLender() {
        return lender;
    }

    public String getRemarks() {
        return remarks;
    }

    public void insert() {
    }

    public void select() {
        String sql;
        dbc = new DBConnt();
        conn = dbc.getConnection();
        String sql = "SELECT a.assetid,rtrim(a.asset_name),rtrim(a.model),a.price,l.empno,l.usedate,l.retdate,l.isreturn,l.lender,rtrim(l.remarks) FROM asset a,lend l where a.assetid = l.assetid and a.assetid = " +
              Integer.parseInt(assetid);
        try {
            Statement stmt = conn.createStatement();
            ResultSet rset = stmt.executeQuery(sql);
            boolean b = rset.next();
            assetname = rset.getString(2);
            model = rset.getString(3);
            price = rset.getString(4);
            empno = rset.getString(5);
            usedate = rset.getString(6);
            retdate = rset.getString(7);
            isreturn = rset.getString(8);
            lender = rset.getString(9);
            remarks = rset.getString(10);
            rset.close();
            stmt.close();
            conn.close();
        } catch (java.sql.SQLException s) {
            System.out.println("exception: " + s.getMessage());
        }
    }

    public void update() {
        dbc = new DBConnt();
        conn = dbc.getConnection();
        try {
            PreparedStatement pstmt =
                    conn.prepareStatement("update lend set empno = ?,usedate = ?,retdate = ?,isreturn = ?,remarks = ?,lender = ?  where assetid = " +
                                          Integer.parseInt(assetid));
            pstmt.setInt(1, Integer.parseInt(empno));
            pstmt.setString(2, usedate);
            pstmt.setString(3, retdate);
            pstmt.setString(4, isreturn);
            pstmt.setString(5, remarks);
            pstmt.setString(6, lender);
            pstmt.execute();
            conn.commit();
            conn.close();
        } catch (java.sql.SQLException s) {
            System.out.println("exception: " + s.getMessage());
        }
    }

    public void delete() {
    }

    private void jbInit() throws Exception {
    }
}