table1.java

来自「学习java 自己开发的企业管理系统,适合初学者」· Java 代码 · 共 74 行

package zhican;
import zhican.sql;
import java.sql.ResultSet;
import java.sql.*;
public class table1 {
    ResultSet res;
    String [][]tablez;
    int tablelong=0;
    public table1() {
    }
    public String[][] tableclear(){
      String [][]abc={{"","","","","","","",""},{"","","","","","","",""},{"","","","","","","",""},
                  {"","","","","","","",""},{"","","","","","","",""},{"","","","","","","",""},
                  {"","","","","","","",""},{"","","","","","","",""},{"","","","","","","",""},
                  {"","","","","","","",""},{"","","","","","","",""},{"","","","","","","",""},
                  {"","","","","","","",""},{"","","","","","","",""},{"","","","","","","",""},
                  {"","","","","","","",""},{"","","","","","","",""},{"","","","","","","",""},
                  {"","","","","","","",""},{"","","","","","","",""},{"","","","","","","",""},
                  {"","","","","","","",""},{"","","","","","","",""},{"","","","","","","",""},
                  {"","","","","","","",""},{"","","","","","","",""},{"","","","","","","",""},
                  {"","","","","","","",""},{"","","","","","","",""},{"","","","","","","",""}};
        return abc;
    }
    public String[][] tableall(){//表清空方法
        try {
            res = sql.sta.executeQuery("select 编号,名称,型号,价值,购买日期,状态,使用者,备注 from wwwgoods");
            res.last();
            tablez=new String[res.getRow()][8];
            res.beforeFirst();
            for(int i=0;res.next();i++){
                for(int j=0;j<8;j++){
                   tablez[i][j]= res.getString(j+1);
                }
                tablelong++;
            }
        } catch (SQLException ex) {
            System.out.println(ex);
        }
        for(int i=0;i<tablelong;i++){
            tablez[i][3]=tablez[i][3].substring(0,tablez[i][3].length()-2);
            tablez[i][4]=tablez[i][4].substring(0,10);
        }
        return tablez;
    }
    public String[][] tablea(String tablexxx){
        try {
            res = sql.sta.executeQuery("select 编号,名称,型号,价值,购买日期,状态,使用者,备注 from wwwgoods where 大类别='"+tablexxx+"'");
            res.last();
            int sos=res.getRow();
            if(sos==0){
                res = sql.sta.executeQuery("select 编号,名称,型号,价值,购买日期,状态,使用者,备注 from wwwgoods where 小类别='"+tablexxx+"'");
                res.last();
                sos=res.getRow();
            }
            tablez=new String[sos][8];
            res.beforeFirst();
            for(int i=0;res.next();i++){
                for(int j=0;j<8;j++){
                   tablez[i][j]= res.getString(j+1);
                }
                tablelong++;
            }
        } catch (SQLException ex) {
            System.out.println(ex);
        }
        for(int i=0;i<tablelong;i++){
            tablez[i][3]=tablez[i][3].substring(0,tablez[i][3].length()-2);
            tablez[i][4]=tablez[i][4].substring(0,10);
        }
        return tablez;
    }

}