Connect to the JavaBean package MySQl of mysql;
Import java. SQL .*;
Public class MySqlCon
{
Private String DbName = "";
Private String pass = "";
Private String url = "";
Private Connection con = null;
Private Statement stmt = null;
Private ResultSet rs = null;
Public MySqlCon ()
{
}
Public void setDbName (String name)
{
This. DbName = name;
}
Public void setPass (String pass)
{
This. pass = pass;
}
Public void bucket Con ()
{
Try
{
Class. forName ("org. gjt. mm. mysql. Driver"). newInstance ();
Url = "jdbc: mysql: // localhost/" + DbName + "? User = root & password = "+ pass +" & useUnicode = true & characterEncoding = gb2312 ";
Con = DriverManager. getConnection (url );
Stmt = con. createStatement (ResultSet. TYPE_SCROLL_SENSITIVE, ResultSet. CONCUR_UPDATABLE );
}
Catch (Exception e)
{
}
}
Public ResultSet selectLog (String SQL)
{
Try
{
Bucket Con ();
Rs = stmt.exe cuteQuery (SQL );
}
Catch (Exception e)
{
System. out. println (e. toString ());
}
Return rs;
}
Public void updateLog (String SQL)
{
Try
{
Bucket Con ();
Stmt.exe cuteUpdate (SQL );
}
Catch (Exception e)
{
}
}
Public void close ()
{
Try
{
Con. close ();
Stmt. close ();
}
Catch (SQLException e)
{
}
}
}