JDBC_Driver_Connection-优快云博客

本文提供两个Java示例程序展示如何使用JDBC加载驱动并建立数据库连接。首先介绍了加载MySQL驱动的方法，并验证加载是否成功。接着展示了如何通过DriverManager获取Connection对象，实现与MySQL数据库的有效连接。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1. Driver loading

package JavaJDBC.Chap02.Sec03;
 /**
  * Created by linux_ccmj on 16-5-10.
  */
 public class Demo1 {
     // JDBC driver name
     private static String namJDBC = "com.mysql.jdbc.Driver";
     // JDBC loading test
     public static void main(String[] args) {
         try {
             Class.forName(namJDBC);
             System.out.println("加载驱动成功！");
         } catch (ClassNotFoundException e) {
             e.printStackTrace();
             System.out.println("加载驱动失败！");
         }
      }
 }

2. Connection

package JavaJDBC.Chap02.Sec04;
  import java.sql.Connection;
 import java.sql.DriverManager;
 import java.sql.SQLException;
  /**
  * Created by linux_ccmj on 16-5-10.
  */
 public class Demo01 {
     // MySQL url address
     private static String urlJdb = "jdbc:mysql://localhost:3306/db_book";
 
     // MySQL user name
     private static String namUseDb = "root";
 
     // MySQL user password
     private static String pasUseDb = "ccmj";
 
     // MySQL driver name
     private static String namDriDb = "com.mysql.jdbc.Driver";
 
     // Test main
     public static void main(String[] args) {
         // Loading database driver
         try {
             Class.forName(namDriDb);
             System.out.println("JDBC driver is loaded successfully!");
         } catch (ClassNotFoundException e) {
             e.printStackTrace();
             System.out.println("JDBC driver is loaded unsuccessfully!");
         }
 
         // MySQL connection test
         Connection con = null;
         try {
             con = DriverManager.getConnection(urlJdb, namUseDb, pasUseDb);
             System.out.println("MySQL is connected!");
             System.out.println("Begin data operation!");
         } catch (SQLException e) {
             e.printStackTrace();
         }
         try {
             // Connection closing
             con.close();
             System.out.println("The connection is closed!");
         } catch (SQLException e) {
             e.printStackTrace();
         }
     }
 }