JDBC_Driver_Connection

Java JDBC 数据库连接示例

最新推荐文章于 2022-01-08 15:44:45 发布

转载最新推荐文章于 2022-01-08 15:44:45 发布 · 138 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：https://my.oschina.net/u/2363350/blog/682130

文章标签：

#数据库 #java

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

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();
         }
     }
 }

转载于:https://my.oschina.net/u/2363350/blog/682130