ex.java

检化验管理系统

package com.snsoft.site.jspbean;

import com.jl.zys.dbaccess.*;
import java.sql.*;
import java.util.*;
/**
 * 
 * @author Administrator
 *
 */

public class ex {
//  private Connection con;
//  private Statement smt;
//  private PreparedStatement psmt;
//  private ResultSet rs;
  String kind = "30";//30代表全部物品类别
  String goodts = "";
  String userids = "";

  public void setKind(String kind){
    this.kind = kind;
  }
  public void setGoodts(String goodts){
    this.goodts = goodts;
  }
  public void setUserids(String userids){
    this.userids =userids;
  }
  public String getUserids(){
    return userids;
  }

  public String getKind(){
    return kind;
  }

  public String getGoodts(){
    return goodts;
  }


// 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);
}
//----------------------------------------------------------------

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

      try {
        //con = DbFactory.getConnection();
        if(kind.trim().equals("30")){
          sql = "select 物品 from mulu order by 物品 DESC";
        }else{
          sql = "select 物品 from mulu where 类别 = '" + kind + "' order by 物品 DESC";
        }
        //psmt = con.prepareStatement(sql);
        //rs = psmt.executeQuery();
        rs = DbAccess.querySqlOption(sql);
        while(rs.next()){
          colname = rs.getString("物品");
          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 String[] selectGoods() throws  Exception {

      String sql="";
      String colname="";
      //String not = "n";
      MyResultSet rs = null;
      ArrayList queslist = new ArrayList();

      try {
        //con = DbFactory.getConnection();
        if(kind.trim().indexOf("shen")!=-1){
          sql = "select 物品名称 from "+userids+" where 审核级别<>'0' order by 物品名称 DESC";
        }else if(kind.indexOf("lu")!=-1){
          sql = "select 物品名称 from "+userids+" where 录入<>'n' order by 物品名称 DESC";
        }else{
            sql = "select 物品名称 from "+userids+" order by 物品名称 DESC";
        }
        //psmt = con.prepareStatement(sql);
        //rs = psmt.executeQuery();
        rs = DbAccess.querySqlOption(sql);
        //System.out.println(sql);
        while(rs.next()){
          colname = rs.getString("物品名称");
          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 String getCompany(String sign){

    String company = "";
    MyResultSet rs = null;

    try {
      //con = DbFactory.getConnection();
      //smt = con.createStatement();
      String sql= "select * from bianma where 标识 = '"+sign+"'";
      //rs = smt.executeQuery(sql);
      rs = DbAccess.querySqlOption(sql);
      while(rs.next()){
        company += rs.getString("户名");
      }
    }catch(Exception e){
      e.getMessage();
    }
    finally {
      try {
        if (rs != null) rs.close();
      }
      catch (SQLException ex) {}
    }
    return company;
  }

//  public static String toChinese(String strvalue) {
//      try {
//          if (strvalue == null) {
//              return null;
//          } else {
//              strvalue = new String (strvalue.getBytes ("ISO8859_1"), "GBK");
//              return strvalue;
//          }
//      } catch (Exception e) {
//          return null;
//      }
//  }


}