jdbc

本文講解如何實作存取oracle資料庫。 Import librarie(s) import java.sql.*; Class 設定Connection為連線後產生之連線物件。 public class oracleDB { public Connection conn null; } Connect 實例化oracleDB物件後，透過此設定Connection。 //Connect func public boolean CONNECT_ORACLE() { // Load the JDBC driver String driverName "oracle.jdbc.driver.OracleDriver"; try { Class.forName(driverName); // Create a connection to the database String serverName "xx.xx.xx.xx"; String portNumber "1521"; // fill in your database port (ex:1521) String sid "mysid"; String url "jdbc:oracle:thin:@" + serverName + ":" + portNumber + ":" + sid; String username "myUserName"; String password "myPassword"; // set the connection object conn DriverManager.getConnection(url, username, password); System.out.println("Database connected."); return true; } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); return false; } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); return false; } } Implement the DML in Java 實作DML，這邊使用SELECT簡易示範。 透過上方connect 連線成功後，將connection參數傳入設計的指令。 這邊示範獲取table欄位後回傳ArrayList 。 範例資料庫table設計如下： COL1 COL2 COL3 test1 aaa bbb test2 ccc ddd public ArrayList SELECT_TABLE(Connection conn, String TABLENAME) throws SQLException{ Statement stmt conn.createStatement(); String SELECT_STAT "SELECT * FROM " + TABLENAME; ResultSet rows stmt.executeQuery(SELECT_STAT); ArrayList rows_db new ArrayList(); int count0; while (rows.next()) { // Assume we have 7 columns in this table String dataArr new String; String colStr ""; count+1; for(int i0;i

jdbc

[Java] 透過JDBC操作oracle資料庫

Headline