JAVA JDBC 连接MySQL、Oracle、SQLServer数据库

本文介绍使用JDBC连接三种常用的数据库（MySQL、Oracle、SQLServer）方法

---

MySQL

• 驱动类 com.mysql.jdbc.Driver
• 需要的Jar包 mysql_connector_java_x.xx.xx_bin.jar

代码示例：

package com.temp;
import java.sql.Connection; 
import java.sql.DriverManager; 

public class Test 
{ 
  public static void main(String[] args) 
  { 
    try 
    { 
      String driverName="com.mysql.jdbc.Driver";   
           String dbURL="jdbc:mysql://localhost:3306/world";   
           String userName="root";   
           String userPwd="root";   
      Class.forName(driverName); 
      Connection dbConn=(Connection) 
DriverManager.getConnection(dbURL,userName,userPwd);  
      System.out.println("数据库连接成功"); 
    } 
    catch (Exception e) 
    { 
      System.out.println("连接失败"); 
      e.printStackTrace(); 
    } 
  } 
} 

---

Oracle

• 驱动类 oracle.jdbc.driver.OracleDriver
• 需要的Jar包 ojdbc14.jar

代码示例：

package com.temp; 
import java.sql.Connection; 
import java.sql.DriverManager; 

public class Test 
{ 
  public static void main(String[] args) 
  { 
    try 
    { 
      String driverName="oracle.jdbc.driver.OracleDriver";   
      String dbURL="jdbc:oracle:thin:@localhost:1521:XE";   
      String userName="root";   
      String userPwd="root";   
      Class.forName(driverName); 
      Connection dbConn=(Connection) 
DriverManager.getConnection(dbURL,userName,userPwd);  
      System.out.println("数据库连接成功"); 
    } 
    catch (Exception e) 
    { 
      System.out.println("连接失败"); 
      e.printStackTrace(); 
    } 
  } 
} 

---

SQLServer

• 驱动类 com.microsoft.sqlserver.jdbc.SQLServerDriver
• 需要的Jar包 sqljdbc4.jar

代码示例：

package com.temp; 
import java.sql.*; 

public class Test 
{ 
  public static void main(String[] args) 

  { 
    String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; 
    String dbURL = "jdbc:sqlserver://localhost:1433;DatabaseName=display"; 
    String userName = "dd"; 
    String userPwd = "dd"; 

    try 
    { 
      Class.forName(driverName); 
      Connection dbConn = DriverManager.getConnection(dbURL, userName, 
userPwd); 
      System.out.println("连接数据库成功"); 
    } 

    catch (Exception e) 
    { 
      e.printStackTrace(); 
      System.out.print("连接失败"); 
    } 
  } 
} 

---