1.url方式(连接数据库并执行一个查询):
public static void main(String[] args) throws ClassNotFoundException, SQLException {
Statement statement;
ResultSet rs;
Connection conn;
String sql;
/**
db.driveName=oracle.jdbc.driver.OracleDriver
db.username=user
db.pwd=pwd
db.url=jdbc:oracle:thin:@****:1521:ywxx
*/
String userName = PropertiesUtil.getString("db.username");
String userPwd = PropertiesUtil.getString("db.pwd");
Class.forName(PropertiesUtil.getString("db.driveName"));
String dbURL = PropertiesUtil.getString("db.url");
conn = DriverManager.getConnection(dbURL, userName, userPwd);
statement = conn.createStatement();
sql = "select AA from task;";
String aa;
rs = statement.executeQuery(sql);
while (rs.next()) {
aa = rs.getString("AA");
System.out.println(aa);
}
rs.close();
conn.close();
}
2.tns需要根据名称去查找对应的信息,所以要配置一个查找路径(连接数据库并执行一个存储过程):
public static void main(String[] args) throws ClassNotFoundException, SQLException, IllegalAccessException, InstantiationException {/**db.driveName=oracle.jdbc.driver.OracleDriverdb.username=userdb.pwd=pwddb.tns=orcl*/String userName = PropertiesUtil.getString("db.username");String userPwd = PropertiesUtil.getString("db.pwd");String dbURL = "jdbc:oracle:thin:@" + PropertiesUtil.getString("db.tns");Class.forName(PropertiesUtil.getString("db.driveName"));Connection conn;CallableStatement callableStatement;System.setProperty(".tns_admin", System.getenv("ORACLE_HOME") + File.separator + "NETWORK" + File.separator + "ADMIN");System.out.println(System.getProperty(".tns_admin"));Class.forName("oracle.jdbc.driver.OracleDriver");conn = DriverManager.getConnection(dbURL, userName, userPwd);callableStatement = conn.prepareCall("{call pro_name}");callableStatement.execute();callableStatement.close();conn.close();}