Java JDBC原生代码连接MySQL/SQLServer/Oracle数据库

陈树义

发布于 2022-04-29 10:35:21

1K0

发布于 2022-04-29 10:35:21

文章被收录于专栏：陈树义陈树义

1.连接MySQL数据库 驱动包：mysql-connector-java-5.1.18-bin.jar 驱动程序名：com.mysql.jdbc.Driver 连接字符串：jdbc:mysql://localhost:3306/database

 1 package com.chenshuyi.dbsummary;
 2 
 3 import java.sql.Connection;
 4 import java.sql.DriverManager;
 5 
 6 import org.junit.Test;
 7 
 8 import junit.framework.TestCase;
 9 
10 public class MySQL extends TestCase {
11     
12     @Test public void testConnectToMySQL()
13     {
14         String driver = "com.mysql.jdbc.Driver";
15         String url = "jdbc:mysql://127.0.0.1:3306/chanjiayi";
16         String user = "root"; 
17         String password = "sa";
18         try{ 
19             Class.forName(driver);
20              Connection conn = DriverManager.getConnection(url, user, password);
21              
22              if(conn != null)
23              {
24                  System.out.println("get Connection SUCCESS !");
25              }
26         }
27         catch(Exception e)
28         {
29             e.printStackTrace();
30         }
31     }
32 }

2.连接SQLServer数据库 驱动包：sqljdbc.jar 或 sqljdbc4.jar 驱动程序名：com.microsoft.jdbc.sqlserver.SQLServerDriver 连接字符串：jdbc:sqlserver://localhost:1433;DatabaseName=mydb

 1 package com.chenshuyi.dbsummary;
 2 
 3 import java.sql.Connection;
 4 import java.sql.DriverManager;
 5 
 6 import org.junit.Test;
 7 
 8 
 9 public class SQLServer {
10     
11     @Test public void testConnectToMySQL()
12     {
13         String driver = "com.mysql.jdbc.Driver";
14         String url = "jdbc:sqlserver://localhost:1433;DatabaseName=mydb"; //mydb为数据库名
15         String user = "sa"; 
16         String password = "sa";
17         try{ 
18             Class.forName(driver);
19              Connection conn = DriverManager.getConnection(url, user, password);
20              
21              if(conn != null)
22              {
23                  System.out.println("get Connection SUCCESS !");
24              }
25         }
26         catch(Exception e)
27         {
28             e.printStackTrace();
29         }
30     }
31 }

3.连接Oracle数据库 驱动包：ojdbc14.jar 驱动程序名：oracle.jdbc.driver.OracleDriver 连接字符串：jdbc:oracle:thin:@127.0.0.1:1521:DB （DB为要连接的数据库名）

 1 package com.chenshuyi.dbsummary;
 2 
 3 import java.sql.Connection;
 4 import java.sql.DriverManager;
 5 
 6 import org.junit.Test;
 7 
 8 
 9 public class Oracle {
10     
11     @Test public void testConnectToMySQL()
12     {
13         String driver = "oracle.jdbc.driver.OracleDriver";
14         String url = "jdbc:oracle:thin:@127.0.0.1:1521:DBSummary";
15         String user = "system"; 
16         String password = "sa";
17         try{ 
18             Class.forName(driver);
19              Connection conn = DriverManager.getConnection(url, user, password);
20              
21              if(conn != null)
22              {
23                  System.out.println("GET Connection SUCCESS !");
24              }
25         }
26         catch(Exception e)
27         {
28             e.printStackTrace();
29         }
30     }
31 }

注：其中ojdbc14.jar可以在oracle安装目录下找到（例如我的就在：E:\oracle\product\10.2.0\db_1\jdbc\lib）

数据库Jar包下载地址：http://pan.baidu.com/s/1jGKEEY6 　密码：okq0

本文参与腾讯云自媒体分享计划，分享自作者个人站点/博客。

原始发表：2014-04-21，如有侵权请联系 cloudcommunity@tencent.com 删除

编程算法