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

view plaincopy to clipboardprint?

/**

* 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

}

}

}

}