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

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

package com.chenshuyi.dbsummary;

import java.sql.Connection;
import java.sql.DriverManager;

import org.junit.Test;

import junit.framework.TestCase;

public class MySQL extends TestCase {
    
    @Test public void testConnectToMySQL()
    {
        String driver = "com.mysql.jdbc.Driver";
        String url = "jdbc:mysql://127.0.0.1:3306/chanjiayi";
        String user = "root"; 
        String password = "sa";
        try{ 
            Class.forName(driver);
             Connection conn = DriverManager.getConnection(url, user, password);
             
             if(conn != null)
             {
                 System.out.println("get Connection SUCCESS !");
             }
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
    }
}

 

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

package com.chenshuyi.dbsummary;

import java.sql.Connection;
import java.sql.DriverManager;

import org.junit.Test;


public class SQLServer {
    
    @Test public void testConnectToMySQL()
    {
        String driver = "com.mysql.jdbc.Driver";
        String url = "jdbc:sqlserver://localhost:1433;DatabaseName=mydb"; //mydb为数据库名
        String user = "sa"; 
        String password = "sa";
        try{ 
            Class.forName(driver);
             Connection conn = DriverManager.getConnection(url, user, password);
             
             if(conn != null)
             {
                 System.out.println("get Connection SUCCESS !");
             }
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
    }
}

 

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

package com.chenshuyi.dbsummary;

import java.sql.Connection;
import java.sql.DriverManager;

import org.junit.Test;


public class Oracle {
    
    @Test public void testConnectToMySQL()
    {
        String driver = "oracle.jdbc.driver.OracleDriver";
        String url = "jdbc:oracle:thin:@127.0.0.1:1521:DBSummary";
        String user = "system"; 
        String password = "sa";
        try{ 
            Class.forName(driver);
             Connection conn = DriverManager.getConnection(url, user, password);
             
             if(conn != null)
             {
                 System.out.println("GET Connection SUCCESS !");
             }
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
    }
}

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

 

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