Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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();
- }
- }
Add Comment
Please, Sign In to add comment