Access the JavaBean of MySQL

Import java. SQL .*;
/**
* <P> JavaBean on the logon page <p>
* @ Author datuo
*
*/
Public class DB
{
Connection connect = NULL;
Resultset rs = NULL;
 
Public dB ()
{
Try
{
Class. forname ("org. gjt. Mm. MySQL. Driver"). newinstance (); // you can specify the driver type.
}
Catch (exception E)
{
System. Out. println ("AAA ");
E. printstacktrace ();
}
}
 
/**
* Method for executing a query statement
* @ Param SQL string SQL statement
* @ Return resultset object
*/
Public resultset executequery (string SQL)
{
Try {
/**
* Establish a connection with the database server
*/
Connect = drivermanager. getconnection ("JDBC: mysql: // localhost/test", "root", "XXXXXXXX ");
Statement stmt = connect. createstatement (resultset. type_scroll_insensitive, resultset. concur_read_only );
Rs = stmt.exe cutequery (SQL );
}
Catch (exception E)
{

}
Return Rs;
}
 
/**
* Method for executing add, delete, and modify statements
* @ Param SQL
* @ Return int
*/
Public int executeupdate (string SQL)
{
Int result = 0;
Try {
Connect = drivermanager. getconnection ("JDBC: mysql: // localhost/test ");
Statement stmt = connect. createstatement ();
Result = stmt.exe cuteupdate (SQL );
}
Catch (sqlexception ex)
{
System. Err. println (ex. getmessage ());
}
Return result;
}
 
/**
* Method for disabling database connection
*
*/
Public void close ()
{
If (connect! = NULL)
{
Try {
Connect. Close ();
Connect = NULL;
}
Catch (sqlexception ex)
{
System. Err. println (ex. getmessage ());
}
}
}