java 连接mysql数据库的步骤（一）

记得用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();