Oracle客户端与java_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