newopen.java

检化验管理系统

package com.snsoft.site.jspbean;

import com.jl.zys.dbaccess.*;
import java.sql.*;
import java.util.*;

public class newopen {
//  private Connection con;
//  private PreparedStatement smt;
//  private ResultSet rs;

//----------------------------------------------------------------

    public String[] selectLei(String sign) throws  Exception {
      String sql="";
      String colname="";
      String not = "n";
      MyResultSet rs = null;
      ArrayList queslist = new ArrayList();

      try {
        //con = DbFactory.getConnection();
        if(sign.equals("all")){
          sql = "select tablename from mulu";
        }else{
          sql = "select tablename from mulu where duka = '" + not + "'";
        }
        //smt = con.prepareStatement(sql);
        //rs = smt.executeQuery();
        rs = DbAccess.querySqlOption(sql);
        while(rs.next()){
          colname = rs.getString("tablename");
          queslist.add(colname);
        }
      }
      catch (SQLException ex) {
        ex.printStackTrace();
      }
      finally {
        try {
          if (rs != null) rs.close();
        }
        catch (SQLException ex) {}
      }
      String[] rs0 = {""};
      return (String[])queslist.toArray(rs0);
    }

//----------------------------------------------------------------------

  public synchronized String[] look(String lei) throws  Exception {
    String numid = lei.substring(0,6);
    String tablename = lei.substring(6,lei.length());
    MyResultSet rs = null;
    //MyResultSet rs1 = null;
    ResultSetMetaData rsmd = null;
    ArrayList queslist = new ArrayList();

    try {
      //con = DbFactory.getConnection();
      String strSQL2 = "SELECT * FROM "+tablename+" where numid = '"+numid+"'" ;
      //smt = con.prepareStatement(strSQL2);
      //rs = smt.executeQuery();
      //rs = DbAccess.querySqlOption(strSQL2);
      //rsmd = smt.getMetaData();
      rs = DbAccess.querySqlOption(strSQL2);
      rsmd = rs.getMetaData();
      if(rsmd!=null && rs.next()){
        int count  = rsmd.getColumnCount();
        for(int i=2; i<=count;i++){
          String name="";
          String name0= rsmd.getColumnName(i);
          name += rsmd.getColumnName(i) + "@@";
          name += rs.getString(""+name0+"");
          queslist.add(name);
          //System.out.print(name);
        }
      }
    }
    catch (Exception e) {
      e.printStackTrace();
    }
    finally {
      try {
        if (rs != null) rs.close();
      }
      catch (SQLException ex) {}
    }
    String[] rs2 = {""};
    return (String[]) queslist.toArray(rs2);
  }


//----------------------------------------------------------------------
//  public String ConvertGBK(String str){
//    String strReturn="";
//    try{
//      strReturn=new String(str.getBytes("ISO-8859-1"),"GBK");
//    }catch(Exception ex){
//      System.out.println("TestBean.ConvertGBK():ex="+ex.toString());
//    }
//    finally{
//      return strReturn;
//    }
//  }

//---------------------------------------------------------------------

  public String[] split(String str, String d){
   String oldstr=str;
   String dstr = d;
   int k=0;
   int n=0;
   ArrayList mysplitarraylist=new ArrayList();
   if(oldstr.indexOf(dstr)!=-1){
     while(oldstr.indexOf(dstr)!=-1){
       k=oldstr.indexOf(dstr);
       mysplitarraylist.add(n,oldstr.substring(0,k));
       oldstr=oldstr.substring(k+dstr.length(),oldstr.length());
       n++;
     }
     mysplitarraylist.add(n,oldstr);//n有问题，不用＋＋了
   }else{
     mysplitarraylist.add(0,oldstr);
   }
   String [] myresultarray=new String[n];
   return (String [])mysplitarraylist.toArray(myresultarray);
 }

}