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 }

 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 }

 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 }