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

 

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

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值