Java JDBC links to the Oracle database, jdbcoracle
Package com. test. test;
Import java. io. FileInputStream;
Import java. io. FileNotFoundException;
Import java. io. IOException;
Import java. SQL. Connection;
Import java. SQL. DriverManager;
Import java. SQL. PreparedStatement;
Import java. SQL. ResultSet;
Import java. SQL. SQLException;
Import java. util. Properties;
/**
* Connecting to an Oracle database through Java JDBC
* @ Author Administrator
*
*/
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.exe cuteQuery ();
While (rs. next ()){
// Do the thing you do
}
Rs. close ();
Ps. close ();
}
Public static void main (String [] args) throws ClassNotFoundException,
FileNotFoundException, SQLException, IOException {
OracleJdbcTest test = new OracleJdbcTest ();
// Configuration file path
FileInputStream fs = null;
Test. init (fs );
Test. fetch ();
}
}