java语言连接MySql,Sqlserver,Oracle

Class.forName("com.mysql.jdbc.Driver"); 
String url = "jdbc:mysql://127.0.0.1/myDatabase"; 
String user = "user"; 
String password = "password"; 
Connection conn = DriverManager.getConnection(url, user, password); 

连接 oracle 数据库，代码如下： 

Class.forName("oracle.jdbc.driver.OracleDriver"); 
String url = "jdbc:oracle:thin:@127.0.0.1:1521:myOracleSID"; 
String user = "user"; 
String password = "password"; 
Connection conn = DriverManager.getConnection(url, user, password); 

连接 MS SQL Server 数据库，代码如下： 

Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); 
String url = "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=myDbName"; 
String user = "user"; 
String password = "password"; 
Connection conn = DriverManager.getConnection(url, user, password); 


例如： 
package zte; 

import java.sql.Connection; 
import java.sql.DriverManager; 
import java.sql.ResultSet; 
import java.sql.SQLException; 
import java.sql.Statement; 


public class SQLConn 
{ 
   public static void main(String args[])  
   { 
   try { 
Class.forName("com.mysql.jdbc.Driver"); 
} catch (ClassNotFoundException e) { 
// TODO Auto-generated catch block 
e.printStackTrace(); 
} 
   String url = "jdbc:mysql://127.0.0.1/test"; 
   String user = "root"; 
   String password = "123456"; 
   try { 
Connection conn = DriverManager.getConnection(url, user, password); 
Statement  stmt = conn.createStatement(); 
ResultSet  rslt = stmt.executeQuery("SELECT * FROM book"); 

while (rslt.next()) //如果有结果，则依次输出 
      { 
          System.out.println("The list of data: " 
                            + rslt.getString(1)); // 输出第一个字段的内容 

      } 
rslt.close(); //一次关闭查询、声明、连接 
      stmt.close(); 
      conn.close(); 


} catch (SQLException e) { 
// TODO Auto-generated catch block 
e.printStackTrace(); 
} 


   } 
}