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 |
(); |
} |
} |
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(); |
} |
} |