gongwanglaijiezhangmodel.java~6~

用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 int 欠款记账;
    private int 付款合计;
    DBcon odb=new DBcon();
    private Connection conn=null;

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

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

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

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

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

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

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

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

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

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