點(diǎn)寬金融量化投資合集
使用JDBC鏈接Oracle
public class OracleJdbcTest {
?String driverClass = "oracle.jdbc.driver.OracleDriver";
?Connection con;
?public void init(FileInputStream fs) throws ClassNotFoundException, SQLException, FileNotFoundException, IOException{
? ?Properties props = new Properties();
? ?props.load(fs);
? ?String url = props.getProperty("db.url");
? ?String userName = props.getProperty("db.user");
? ?String password = props.getProperty("db.password");
? ?Class.forName(driverClass);
? ?con=DriverManager.getConnection(url, userName, password);
?}
?public void fetch() throws SQLException, IOException{
? ?PreparedStatement ps = con.prepareStatement("select SYSDATE from dual");
? ?ResultSet rs = ps.executeQuery();
? ?while (rs.next())
? ?{
? ? ?// do the thing you do
? ?}
? ?rs.close();
? ?ps.close();
?}
?public static void main(String[] args) {
? ?OracleJdbcTest test = new OracleJdbcTest();
? ?test.init();
? ?test.fetch();
?}}
