Java串連MySQL資料庫和Oracle資料庫並進行簡單的SQL操作的一次嘗試

標籤：

MySQL和Oracle的JDBC的maven dependency如下：

    <!-- mysql -->    <dependency>      <groupId>mysql</groupId>      <artifactId>mysql-connector-java</artifactId>      <version>5.1.36</version>    </dependency>    <!-- oracle -->    <dependency>            <groupId>com.oracle</groupId>            <artifactId>ojdbc7</artifactId>            <version>12.1.0.2</version>    </dependency> 

由於Oracle授權問題，Maven不提供Oracle JDBC driver，maven添加oracle jdbc依賴的方法見：http://www.cnblogs.com/wuyouwulv/p/maven_configure_oracle_jdbc.html
代碼：

import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import java.util.Date;public class SQLTest {        private static String APPENDED_DB_INFO = "?useUnicode=true&characterEncoding=UTF8&rewriteBatchedStatements=true&useLegacyDatetimeCode=false&serverTimezone=Asia/Shanghai";        public static Connection getMySQLConnection(String dbUrl, String dbUser, String dbPwd) throws ClassNotFoundException, SQLException {        // 載入磁碟機，下面的代碼為載入MySQL磁碟機        Class.forName("com.mysql.jdbc.Driver");        // 註冊MySQL磁碟機        DriverManager.registerDriver(new com.mysql.jdbc.Driver());        // 建立資料庫連接        return java.sql.DriverManager.getConnection(dbUrl, dbUser, dbPwd);    }        public static Connection getOracleConnection(String dbUrl, String dbUser, String dbPwd) throws ClassNotFoundException, SQLException {        Class.forName("oracle.jdbc.driver.OracleDriver");        return java.sql.DriverManager.getConnection(dbUrl, dbUser, dbPwd);    }        public static void main(String[] args) {        String dbUrl = "jdbc:mysql://host:port/dbname" + APPENDED_DB_INFO;        String dbUser = "mysql_username";        String dbPwd = "mysql_password";        Statement stmt = null;        ResultSet rs = null;                // 串連MySQL資料庫        try {            Connection con =  getMySQLConnection(dbUrl, dbUser, dbPwd);            stmt = con.createStatement();            rs = stmt.executeQuery("SELECT id,age,date FROM user");                        while(rs.next()) {                int product_id = rs.getInt(1);                int categories_id = rs.getInt(2);                Date date_added = rs.getDate(3);                                System.out.println(product_id + "," + categories_id + "," + date_added);            }                    } catch (ClassNotFoundException e) {            e.printStackTrace();        } catch (SQLException e) {            e.printStackTrace();        }                // 串連Oracle資料庫        dbUrl = "jdbc:oracle:thin:@host:port:dbname";        dbUser = "oracle_username";        dbPwd = "oracle_password";                try {            Connection con = getOracleConnection(dbUrl, dbUser, dbPwd);            stmt = con.createStatement();            String sql = "select name id from user";            rs = stmt.executeQuery(sql);                        while(rs.next()){                String res = rs.getString(1);                System.out.println(res);            }        } catch (ClassNotFoundException e) {            e.printStackTrace();        } catch (SQLException e) {            e.printStackTrace();        }    }}

 

Java串連MySQL資料庫和Oracle資料庫並進行簡單的SQL操作的一次嘗試