Java连接Oracle、MySQL和SqlServer2008的方法

 连接之前需要导入jar包

 

Oracle：ojdbc14.jar

 

MySql:mysql-connector-java-5.1.13-bin.jar

 

SqlServer2008:sqljdbc4.jar

 

测试如下：

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


public class ConnDatabase{

	public static void connAndQuery(){
		Connection con = null;
		String oracleUrl = "jdbc:oracle:thin:@localhost:1521:orcl";// orcl 为sid
		String mySqlUrl = "jdbc:mysql://localhost/test";//test 为数据库名
		String sqlServerUrl = "jdbc:sqlserver://localhost:1433; DatabaseName=test";
		ResultSet rs = null;
		try {
			// mysql 
			Class.forName("com.mysql.jdbc.Driver");
			con = DriverManager.getConnection(mySqlUrl, "root", "lxf");
			// oracle
//			Class.forName("oracle.jdbc.driver.OracleDriver");
//			con = DriverManager.getConnection(oracleUrl, "kejoo", "lxf");
			// sqlserver2008
//			Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
//			con = DriverManager.getConnection(sqlServerUrl, "sa", "lxf");
			Statement st = con.createStatement();
			rs = st.executeQuery("select * from tb_user");
			while(rs.next()){
				System.out.println(rs.getInt("id"));
				System.out.println(rs.getString("username"));
				System.out.println(rs.getString("userpwd"));
			}
			rs.close();
		} catch (SQLException e) {
			e.printStackTrace();
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} finally {
			try {
				con.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}
	public static void main(String[] args) {
		connAndQuery();
	}
}

 以上是给每个数据库都新建了一个test数据库（除了Oracle外）其表为tb_user，字段为id,username,userpwd。

 

也可以直接打印con来检测是否已经连接数据库

 

System.out.println(con);

 

Oracle：oracle.jdbc.driver.T4CConnection@105738

 

MySql: com.mysql.jdbc.JDBC4Connection@861f24

 

SqlServer2008:ConnectionID:1

 

显示以上且不出现异常则表明连接成功