{
try
{
String url="jdbc:mysql://localhost/mydb";
String user="root";
String pwd="123456";
//加載驅動,這壹句也可寫為:Class.forName("com.mysql.jdbc.Driver");
Class.forName("com.mysql.jdbc.Driver").newInstance();
//建立到MySQL的連接
Connection conn = DriverManager.getConnection(url,user, pwd);
//執行SQL語句
Statement stmt = conn.createStatement();//創建語句對象,用以執行sql語言
ResultSet rs = stmt.executeQuery("select * from student");
//處理結果集
while (rs.next())
{
String name = rs.getString("name");
System.out.println(name);
}
rs.close();//關閉數據庫
conn.close();
}
catch (Exception ex)
{
System.out.println("Error : " + ex.toString());
}
}
另外記得導入相應的jar包。。。。。。。