gongoperatormodel.java~4~

用java写的仓库管理

package cangku;

import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.PreparedStatement;
import java.util.Vector;

public class GongoperatorModel {
    private String 操作员编号;
    private String 操作员姓名;
    private String 操作员密码;
    private String 操作员级别;
    private DBcon odb=new DBcon();
    private Connection conn=null;

    public String get操作员编号() {
        return 操作员编号;
    }

    public String get操作员姓名() {
        return 操作员姓名;
    }

    public String get操作员密码() {
        return 操作员密码;
    }

    public String get操作员级别() {
        return 操作员级别;
    }

    public void set操作员编号(String 操作员编号) {
        this.操作员编号 = 操作员编号;
    }

    public void set操作员姓名(String 操作员姓名) {
        this.操作员姓名 = 操作员姓名;
    }

    public void set操作员密码(String 操作员密码) {
        this.操作员密码 = 操作员密码;
    }

    public void set操作员级别(String 操作员级别) {
        this.操作员级别 = 操作员级别;
    }

    public int operatorSelect(String[][] tabl){
        int cnt=0;
        int page=100;
        conn=odb.getConn();
        String sql="select 操作员编号,操作员姓名,操作员密码,操作员级别 from 操作员信息表";
        try {
            Statement tmt=conn.createStatement();
            ResultSet rs=tmt.executeQuery(sql);
            while(rs.next()&&cnt<page){
                tabl[cnt][0]=rs.getString(1).trim();
                tabl[cnt][1]=rs.getString(2).trim();
                tabl[cnt][2]=rs.getString(3).trim();
                tabl[cnt][3]=rs.getString(4).trim();
                cnt++;
            }
            rs.close();
            tmt.close();
            conn.close();
        } catch (java.sql.SQLException ex) {
            System.out.println("ex:"+ex.getMessage());
        }
        return cnt;
    }
    public void Autohao(){
        conn=odb.getConn();
        String sql="select substring(max(操作员编号),3,9)+1 from 操作员信息表";
        try {
            Statement tmt=conn.createStatement();
            ResultSet rs=tmt.executeQuery(sql);
            while(rs.next()){
                操作员编号=rs.getString(1);
            }
            rs.close();
            tmt.close();
            conn.close();
        } catch (java.sql.SQLException ex) {
            System.out.println("ex:"+ex.getMessage());
        }
    }
    public Vector getAllOpertion(){
        Vector vec=new Vector();
        conn=odb.getConn();
        String sqll="select 操作员编号,操作员姓名,操作员密码,操作员级别 from 操作员信息表";
        try {
           Statement tmt=conn.createStatement();
           ResultSet rs=tmt.executeQuery(sqll);
           while(rs.next()){
            GongoperatorModel mode=new GongoperatorModel();
            mode.set操作员编号(rs.getString(1));
            mode.set操作员姓名(rs.getString(2));
            mode.set操作员密码(rs.getString(3));
            mode.set操作员级别(rs.getString(4));
            vec.add(mode);
           }
        } catch (java.sql.SQLException ex) {
           System.out.println("ex:"+ex.getMessage());
        }
        return vec;
    }

}