Java版Oracle客户端简易连接程序

Java版Oracle客户端简易连接程序

 

 Oracle.java

import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.PreparedStatement;public class Oracle { public static void main(String[] args) throws Exception { //String conStr = "jdbc:oracle:thin:@10.56.227.195:1521:ssp"; String conStr = "jdbc:oracle:thin:@10.56.233.95:1521:ssp"; Connection conn = getConnection(conStr); conn.setAutoCommit(false); PreparedStatement state = conn.prepareStatement("select cfg_validator_class from config"); ResultSet rs = state.executeQuery(); System.out.println("Fetched size is " +rs.getFetchSize()); rs.close(); state.close(); conn.close(); } private static Connection getConnection(String conStr) throws Exception { Class.forName("oracle.jdbc.driver.OracleDriver"); Connection conn = DriverManager.getConnection(conStr, "test002", "password"); return conn; }}

 

编译：javac Oracle.java

运行：java -cp .:/usr/nbg/admin/lib/oracle/ojdbc14.jar Oracle