Java串連Oracle

標籤：style   blog   io   color   ar   os   java   for   sp   

import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;import java.sql.ResultSet;import java.sql.Statement;public class DB {    private static Connection con = null;    private static Statement sql = null;    private static ResultSet rs = null;    public static void main(String[] args) throws SQLException {       int no;       String dep;       String sal;       try {           con = dbConn("snpw1", "welcome1");           if (con == null) {              System.out.print("串連失敗");              System.exit(0);           }           sql = con.createStatement();           rs = sql.executeQuery("select empid, deptid, salary from oracle_employee");           System.out.println("工號" + "            " + "部門號" + "             "+ "薪水");           while (rs.next()) {              no = rs.getInt(1);              dep = rs.getString(2);              sal = rs.getString(3);              System.out.println(no + "         " + dep + "         " + sal);           }       } catch (Exception e) {           e.printStackTrace();        } finally {           con.close();       }    }    public static Connection dbConn(String name, String pass) {        Connection c = null;        try {            Class.forName("oracle.jdbc.driver.OracleDriver");        } catch (ClassNotFoundException e) {            e.printStackTrace();        }        try {            c = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", name, pass);        } catch (SQLException e) {            e.printStackTrace();        }        return c;     }}

注意：要匯入JDBC驅動，滑鼠右鍵JRE System Libray->Build Path->Configure Build Path->Add External JARs，然後選擇要匯入的JDBC驅動包就可以了。

Java串連Oracle