/ *
* @ (#) Mysqltest.java
* CopyRight 2005 CFZQ, Inc. All Rights Reserved.
* @Author fan
* @version 1.0, 17/01/05
* @since jdk1.4.0
* /
Import java.sql. *;
Public class mysqltest
{
Public static void main (string [] args)
{
Try
{
// When the external class accesss the internal class, special specification needs
MySQLTEST mysqltest1 = new mysqltest ();
Mysqltest.mysqlconn mysql1 = mysqltest1.new mysqlconn ();
ResultSet RS = mysql1.executeQuery ("SELECT * from T_BOOK");
While (rs.next ())
{
System.out.print (Rs.getstring ("IID") "" "
System.out.print (Rs.getstring ("SNAME") "");
System.out.print (rs.getstring ("sauThor") "");
System.out.print (Rs.getstring ("fPRICE") "");
System.out.print (Rs.getstring ("DDATE"));
}
} catch (Exception E)
{
System.out.println (E.getMessage ());
}
}
Class mysqlconn
{
// Connected parameters
Private string mysqldriver = "org.gjt.mm.mysql.driver";
Private string connurl = "JDBC: mysql: //127.0.0.1: 3306 / dbtest";
Private string username = "fane";
Private string pwd = "201";
PRIVATE CONNECTION CONN = NULL;
Private resultset = null;
/ / Load the drive in the construction method
Public mysqlconn ()
{
Try
{
Class.Forname (mysqldriver);
}
Catch (Exception E)
{
System.out.println (E.getMessage ());
}
}
// Execute Sqlstring, return to the data set
Public ResultSet ExecuteQuery (String Sqlstring)
{
RS = NULL;
Try
{
CONN = DriverManager.getConnection (Connurl, UserName, PWD);
Statement Stmt = conn.createstatement ();
RS = stmt.executeQuery (Sqlstring);
}
Catch (SQLException EX)
{
System.err.println ("Aq.executeQuery:" ex.getMessage ());
}
Return RS;
}
}
}
