JDBC for Oracle 簡單樣本

import java.sql.*;public class TestJDBC {public static void main(String[] args) {ResultSet rs = null;Statement stmt = null;Connection conn = null;try {Class.forName("oracle.jdbc.driver.OracleDriver");//new oracle.jdbc.driver.OracleDriver();conn = DriverManager.getConnection("jdbc:oracle:thin:@192.168.0.1:1521:SXT", "scott", "tiger");stmt = conn.createStatement();rs = stmt.executeQuery("select * from dept");while(rs.next()) {System.out.println(rs.getString("deptno"));System.out.println(rs.getInt("deptno"));}} catch (ClassNotFoundException e) {e.printStackTrace();} catch (SQLException e) {e.printStackTrace();} finally {try {if(rs != null) {rs.close();rs = null;}if(stmt != null) {stmt.close();stmt = null;}if(conn != null) {conn.close();conn = null;}} catch (SQLException e) {e.printStackTrace();}}}}