Java初学者笔记：JDBC连接Oracle数据库

/** * JDBCTest.java * 编译脚本 cd/ cd D:/JavaHome/temp d: javac JDBCTest.java java JDBCTest pause */ import java.sql.*; // WindowsXP使用JDBC连接Oracle10g数据库 // Oracle10g 客户端安装在: "D:/OraClient10g" public class JDBCTest { public static void main(String args[ ]) { Connection connection = null; Statement statement = null; try { // Load the JDBC Driver // 必须在系统环境变量 CLASSPATH 添加 "D:/OraClient10g/jdbc/lib/classes12.zip" String DBDRIVER = "oracle.jdbc.driver.OracleDriver"; // 找到 "D:/OraClient10g/NETWORK/ADMIN/tnsnames.ora" 文件, 将 (DESCRIPTION=...)拷贝到下面 String URL = "jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = mine)(PORT = 1521)) )(CONNECT_DATA =(SID = cheung)(SERVER = DEDICATED)))"; Class.forName(DBDRIVER).newInstance(); // Connect to the database connection = DriverManager.getConnection(URL, "scott", "tiger"); // Obtain a statement object statement = connection.createStatement(); // Execute the SQL String sql = "select * from JDBC_TEST"; ResultSet rs = statement.executeQuery(sql); while (rs.next()) { System.out.println(rs.getString(1)); // 列的索引: 1-based } rs.close(); } // Don't try this at home, catch SQLException and all others catch( Exception e ) { e.printStackTrace(); } finally { // Time to close everthing up. if( statement != null ) { try { statement.close(); } catch( SQLException e ){ } // nothing we can do } if( connection != null ) { try { connection.close(); } catch( SQLException e ){ } // nothing we can do } } } }