oracle数据库mysql代码,Java代码链接mysql数据库和oracle数据库

非常基础的代码，导入相应数据库的驱动包，代码如下：

package com;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import org.junit.Test;

/**

* 测试连接数据库代码

*/

public class DatabaseConnection {

private String url = null;

private String user = null;

private String pwd = null;

private String sql = null;

private Connection con = null;

private PreparedStatement pre = null;

private ResultSet resultSet = null;

@Test

public void mysql() {

url = "jdbc:mysql://127.0.0.1:3306/test";

user = "root";

pwd = "123";

sql = "select * from test where id = ?";

try {

Class.forName("com.mysql.jdbc.Driver");

con = DriverManager.getConnection(url, user, pwd);

pre = con.prepareStatement(sql);

pre.setString(1, "1");

resultSet = pre.executeQuery();

while (resultSet.next()) {

System.out.println(resultSet.getString(1) + " "

+ resultSet.getString(2));

}

} catch (Exception e) {

e.printStackTrace();

} finally {

try {

if (resultSet != null) {

resultSet.close();

}

if (pre != null) {

pre.close();

}

if (con != null) {

con.close();

}

} catch (SQLException e) {

e.printStackTrace();

}

}

}

@Test

public void oracle() {

url = "jdbc:oracle:thin:@127.0.0.1:1521:ORCL";

user = "system";

pwd = "123";

sql = "SELECT * FROM TEST";

try {

Class.forName("oracle.jdbc.driver.OracleDriver");

con = DriverManager.getConnection(url, user, pwd);

pre = con.prepareStatement(sql);

resultSet = pre.executeQuery();

while (resultSet.next()) {

System.out.println(resultSet.getString(1) + " "

+ resultSet.getDate(3));

}

} catch (Exception e) {

e.printStackTrace();

} finally {

try {

if (resultSet != null) {

resultSet.close();

}

if (pre != null) {

pre.close();

}

if (con != null) {

con.close();

}

} catch (SQLException e) {

e.printStackTrace();

}

}

}

}