Java 连接MySql数据库

import java.sql.*;
public class JDBCTest {
public static void main(String[] args)
{
    String driver="com.mysql.jdbc.Driver";
    String url="jdbc:mysql://localhost/test";//连接到本地的Test数据库
    String user="root";//MySql 配置的用户名
    String pwd="124825";//MySql 配置时的密码
    try
    {
    	//加载驱动
    Class.forName(driver);
    //建立到MySql的连接
    Connection conn=DriverManager.getConnection(url,user,pwd);
    if(!conn.isClosed())
    	System.out.println("Succeeded connecting to the Database!");
    //执行SQL语句
    Statement stmt=conn.createStatement();
    String sql="select * from student";
    ResultSet rs= stmt.executeQuery(sql);
    System.out.println("-----------------");
    System.out.println("执行结果如下所示:");  
    System.out.println("-----------------");  
    System.out.println(" 学号" + "\t" + " 姓名");  
    System.out.println("-----------------");  
    while(rs.next())
    {
    	System.out.println(rs.getString("id") + "\t" + rs.getString("name"));
    }
    rs.close();
    conn.close();
    }
    catch(Exception ex)
    {
    	System.out.println("Error : " + ex.toString());
    }
}

}