gongwanglaijiezhangmodel.java~1~

用java写的仓库管理

package cangku;

import java.util.ArrayList;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.ParameterMetaData;

public class GongWangLaiJieZhangModel {
    private String 供应商编号;
    private String 供应商全称;
    private int 金额小计;
    private long 欠款记账;
    private int 付款合计;
    DBcon odb=new DBcon();
    private Connection conn=null;

    public String get供应商编号() {
        return 供应商编号;
    }

    public String get供应商全称() {
        return 供应商全称;
    }

    public int get金额小计() {
        return 金额小计;
    }

    public long get欠款记账() {
        return 欠款记账;
    }

    public int get付款合计() {
        return 付款合计;
    }

    public void set供应商编号(String 供应商编号) {
        this.供应商编号 = 供应商编号;
    }

    public void set供应商全称(String 供应商全称) {
        this.供应商全称 = 供应商全称;
    }

    public void set金额小计(int 金额小计) {
        this.金额小计 = 金额小计;
    }

    public void set欠款记账(long 欠款记账) {
        this.欠款记账 = 欠款记账;
    }

    public void set付款合计(int 付款合计) {
        this.付款合计 = 付款合计;
    }
    public ArrayList Select(){
        ArrayList lis=new ArrayList();
        String sql="select  供应商编号,供应商全称,金额小计,欠款记账,付款合计  from 供应商结款表 where 供应商全称='"+供应商全称+"'";
        conn=odb.getConn();
        try {
            Statement tmt=conn.createStatement();
            ResultSet rs=tmt.executeQuery(sql);
            while(rs.next()){
                GongWangLaiJieZhangModel mode=new GongWangLaiJieZhangModel();
                mode.供应商编号=rs.getString(1);
                mode.供应商全称=rs.getString(2);
                mode.金额小计=rs.getInt(3);
                mode.欠款记账=rs.getInt(4);
                mode.付款合计=rs.getInt(5);
                lis.add(mode);
            }
            rs.close();
            tmt.close();
            conn.close();
        } catch (java.sql.SQLException ex) {
            System.out.println("ex:"+ex.getMessage());
        }
        return lis;
    }
}