www. On IT Road .com
示例:
让我们在下面的示例中查看整个过程:
package com.onitroad.jdbc.demo; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; public class ConnectionDemo { public static void main(String[] argv) { System.out.println("-------- MySQL JDBC Connection Demo ------------"); try { // 加载JDBC驱动 // DriverManager 类将尝试加载“jdbc.drivers”系统属性中引用的驱动程序类。 Class.forName("com.mysql.jdbc.Driver"); // 对于 MySQL Connector/J,这个类的名称是 com.mysql.jdbc.Driver 。 //使用此方法,我们可以使用外部配置文件来提供连接到数据库时要使用的驱动程序类名称和驱动程序参数。 } catch (ClassNotFoundException e) { System.out.println("MySQL JDBC Driver not found !!"); return; } System.out.println("MySQL JDBC Driver Registered!"); Connection connection = null; try { // 打开数据库连接 connection = DriverManager .getConnection("jdbc:mysql://localhost:3306/JDBCDemo", "root", "password"); System.out.println("SQL Connection to database established!"); } catch (SQLException e) { System.out.println("Connection Failed! Check output console"); return; } finally { // 关闭数据库连接 try { if(connection != null) connection.close(); System.out.println("Connection closed !!"); } catch (SQLException e) { e.printStackTrace(); } } } }
输出:
-------- MySQL JDBC Connection Demo ----------- MySQL JDBC Driver Registered! SQL Connection to database established! Connection closed !!
日期:2020-09-17 00:09:49 来源:oir作者:oir