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
}
}
}
}
