通用數(shù)據(jù)庫操作BEAN

字號:

通用數(shù)據(jù)庫操作BEAN
    package pkgCDB;
    import Java.text.*;
    import java.util.*;
    import java.sql.*;
    public class clsCDB
    {
    String sDBDriver = "";
       String sConnStr = "";
       String sHint = "";
       ResultSet rs = null;
       Connection conn = null;
       Statement stmt = null;
     public String getHint()
     {
    return sHint;
       }
     public void setDBDriver(String s)
     {
      sDBDriver = "" + s;
       }
     public String getDBDriver()
     {
      return sDBDriver;
       }
     public String getConnStr()
     {
      return sConnStr;
       }
     public void setConnStr(String s)
     {
      sConnStr = "" + s;
       }
     public ResultSet getResultSet()
     {
      return rs;
       }
     //Initialize the database
     public boolean Initialization(String dbDrive,String dbConn)
       {
      sDBDriver = dbDrive;
      sConnStr = dbConn;
    return Initialization();
       }
     public boolean Initialization()
     {
    try
      {
      Class.forName(sDBDriver);
      sHint = "Initialization sucessfully";      
      return true;
    }
    catch(java.lang.ClassNotFoundException e) {
    sHint = "Initialization : " + e.getMessage();
      return false;
    }
       }
    //A common function perhaps usable
     public String chkStr(String inStr)
       {
      StringBuffer result = new StringBuffer( "");
      char cc;
      if (inStr != null)
     {
      for (int i = 0; i < inStr.length(); i++)
      {
      cc = inStr.charAt(i);
      if (cc == ´\´´)
        {
        result.append(´\´´);
      }
      result.append(cc);
      }
    }