67,513
社区成员
发帖
与我相关
我的任务
分享
Security.addProvider(new oracle.security.pki.OraclePKIProvider());
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
String url = "jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCPS)(HOST=172.16.13.38)(PORT=2484))(CONNECT_DATA=(SERVICE_NAME=AML))(SECURITY= (SSL_SERVER_CERT_DN=\"CN=duzh,OU=dd,C=US\")))";
Properties props = new Properties();
props.setProperty("user", "scott");
props.setProperty("password", "tiger");
props.setProperty("javax.net.ssl.trustStore", "D:/client_wallet/cwallet.sso");
props.setProperty("javax.net.ssl.trustStoreType", "SSO");
props.setProperty("javax.net.ssl.keyStore", "D:/client_wallet/cwallet.sso");
props.setProperty("javax.net.ssl.keyStoreType", "SSO");
Connection conn = DriverManager.getConnection(url, props);
System.out.println("+++++ connect success! +++++");
Statement st = conn.createStatement();
ResultSet rs = st.executeQuery("select * from all_users");
System.out.println("sql> select * from all_users");
String userName = null;
while (rs.next()) {
userName = rs.getString("username");
System.out.println(" user:" + userName);
}
rs.close();
st.close();
conn.close();
System.out.println("+++++ connect closed! +++++");
} catch (Exception e) {
e.printStackTrace();
}