With the code below you can connect to an Oracle database using JDBC driver and fetch some data:
(you can find the libraries needed below)
import java.sql.*;
import java.util.Date;
import java.util.Properties;
public class ConnectToOracle {
static Driver driver;
static Connection conn = null;
static String driverUsed = "oracle.jdbc.driver.OracleDriver";
static String serverAddress = "jdbc:oracle:thin:nyusername/mypass@myIP:myPort:myDB";
public static void makeConnection(String svr) {
//Properties props = new Properties();
//props.put("internal_logon", "sysdba");
try {
System.out.println("Loading ... " + driverUsed);
driver = (Driver) Class.forName(driverUsed).newInstance();
System.out.println("Connecting ... " + svr);
//conn = DriverManager.getConnection(svr, props);
conn = DriverManager.getConnection(svr);
System.out.println("Ready.");
Date startDate = new Date();
Statement sqlStmt = conn.createStatement();
String theQuery;
theQuery = "select column_name, data_type " +
"from all_tab_columns " +
"where TABLE_NAME = 'S_SRV_REQ'";
System.out.println(theQuery);
ResultSet rSet = sqlStmt.executeQuery(theQuery);
int i=0;
while(rSet.next()){
System.out.println(rSet.getString("column_name"));
i++;
}
System.out.println("\n--------------");
System.out.println(i + " records");
Date endDate = new Date();
System.out.println("in " + (endDate.getTime() - startDate.getTime()) + " milliseconds");
conn.close();
}
catch (Exception e) {
e.printStackTrace();
}
}
public static void main(String[] args) {
makeConnection(serverAddress);
}
}