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

来源：互联网发布：linux acl mask 编辑：程序博客网时间：2024/06/08 03:07

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

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;@Testpublic 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();}}}@Testpublic 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();}}}}

0 0