Oracle JDBC Driver 有三类: thin, OCI, oracle.sql & oracle.jdbc packages
我用第一类thin来做下第一个Demo( 如何才能安装oracle jdbc thin driver,安装oracle client端即可)
1. 首先是JDK Path, CLASSPATH 的配置
1.1. JDK Path 的配置(略),地球人都知道了
$oracle_home/jdbc/ojdbc5.jar就是thin driver class的包所在啦,还有一个类似的ojdbc6.jar,可以用java -jar ojdbc5.jar, java -jar ojdbc6.jar来查看该thin driver是否和data base version,JDK version保持兼容性,ojdbc5.jar,ojdbc6.jar只能存在一个
2. 一个小脚本:
import java.sql.*;
import oracle.jdbc.*;
import oracle.jdbc.pool.OracleDataSource;
public class JDBCVersion
{
public static void main(String[] args) throws SQLException
{
OracleDataSource ods = new OracleDataSource();
ods.setURL("jdbc:oracle:thin:hr/hr@192.168.226.157:1521:orcl");
Connection conn = ods.getConnection();
DatabaseMetaData meta = conn.getMetaData();
/*
System.out.println("JDBC Driver version is :"+meta.getDriverVersion());
System.out.println("connection status:"+conn);
*/
String tabname =new String();
Statement sqlstat = conn.createStatement();
ResultSet rs = sqlstat.executeQuery("select table_name from all_tables");
while ( rs.next())
{
tabname = rs.getString("table_name");
System.out.println("table name :"+tabname);
}
}
}
3. datasource (.getConnection) ->connection(.createStatement) ->statement(.executeQuery) ->ResultSet
参考<oracle JDBC guider> & <oracle JDBC Api refer.>