java jdbc连接mysql数据库的例子

private static String sql="select top, id, name, country, dtime from gametop800 where id="com.rovio.angrybirds"";
public mysqlConnect(){ 
String dbDriver = "com.mysql.jdbc.Driver"; 
String url = "jdbc:mysql://localhost/top800"; 
String username = "root"; 
String password = ""; 
 
Statement mStatement = null; 
ResultSet mResultSet = null; 
Connection mConnection = null; 
 
String sql = "select top, id, name, country, dtime from gametop800 where top<=20"; 
 
try{
    Class.forName(dbDriver).newInstance(); 
    mConnection = DriverManager.getConnection(url, username, password); 
    mStatement = mConnection.createStatement(); 
    mResultSet = mStatement.executeQuery(sql); 
     
    try{ 
while(mResultSet.next()){ 
    System.out.print(mResultSet.getInt(1) + "t"); 
    System.out.print(mResultSet.getString(2) + "t"); 
    System.out.print(mResultSet.getString(3) + "t"); 
    System.out.println(mResultSet.getString(4)); 
} 
}catch (Exception e){ 
      System.out.println("数据库读取错误！ n" + e.getMessage()); 
} 
}catch (SQLException e){ 
    System.out.println("连接数据库错误: n" + url + "n" + e.getMessage()); 
}catch (Exception e){ 
    e.printStackTrace(); 
}finally{ 
   //mStatement.close(); 
   //mConnection.close(); 
} 
}