记得用throws SQLException抛异常并最后关闭连接
//1注册驱动
//1.1第一种方式
DriverManager.registerDriver( new com.mysql.jdbc.Driver());
//1.2第二种方式
//System.setProperty("jdbc.driver", "com.mysql.jdbc.Driver");
//2建立连接
Connection conn = (Connection) DriverManager.getConnection(
"jdbc:mysql://localhost:3306/jdbc", "root","123");
//3创建语句
Statement st = (Statement) conn.createStatement();
//4执行语句
ResultSet rSet=st.executeQuery("select *from student");
//5处理结果
while (rSet.next()) {
System.out.println(rSet.getObject(1)+"/t"+rSet.getObject(2));
}
rSet.close();
st.close();
conn.close();
