连接MySQL数据库的步骤
1.注册驱动(只做一次)
(1)DriverManager.registerDriver(new com.mysql.cj.jdbc.Driver());
(2)Class.forName("com.mysql.cj.jdbc.Driver");
该方法不会对具体的驱动产生依赖(即不用import驱动类),故使用较多
(3)System.setProperty("jdbc.drivers","com.mysql.cj.jdbc.Driver");
该方法可以一次注册多个驱动,如System.setProperty("jdbc.drivers","com.mysql.jdbc.Driver:com.oracle.jdbc.Driver");
多个驱动之间用:隔开
2.建立连接
String URL = "jdbc:mysql://localhost:3306/RUNOOB?useSSL=false&serverTimezone=GMT%2B8&";
String user = "root";
String password = "990506";
Connection conn = DriverManager.getConnection(URL, user, password);
URL格式:
JDBC:子协议:子名称//主机名:端口/数据库名?属性名=属性值&...
3.创建语句
Statement st = conn.createStatement();
4.执行语句
ResultSet rs = st.executeQuery("SELECT id, name, url FROM websites");
5.处理结果
while(rs.next()) {
System.out.println(rs.getObject(1) + "\t" + rs.getObject(2)
+ "\t" + rs.getObject(3) + "\t" );
}
6.释放资源
rs.close();
st.close();
conn.close();
后创建的先关闭