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