在JAVA中连接MySQL数据库(例子)

/*
 * @(#)MySQLTest.java 
 * Copyright 2005 cfzq, Inc. All rights reserved.
 * @author      Fane
 * @version     1.0, 17/01/05
 * @since       JDK1.4.0
 */
import java.sql.*;
 
public class MySQLTest
{
 public static void main(String[] args)
 {
  try
  {
   //外部类访问内部类时，需特别指定
   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
 {
  //连接的参数
  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 rs=null;
  
  //在构造方法里加载驱动
  public MySQLConn()
  {
   try
   {
    Class.forName(mySQLDriver);
   }
   catch(Exception e)
   {
    System.out.println(e.getMessage());
   }
  }
  
  //执行sqlString,返回数据集
  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; 
  }
  
 } 
}