Common Database Operation 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 );