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

建3141

　　/*** JDBCTest.java* 编译脚本cd/cd D:/JavaHome/tempd:javac JDBCTest.javajava  JDBCTestpause*/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 databaseconnection = DriverManager.getConnection(URL, "scott", "tiger");// Obtain a statement objectstatement = connection.createStatement();// Execute the SQLString 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 otherscatch( 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}}}}