Describe désert/Oracle/JDBC here.

== OracleSample.java ==
{{{
// Example Java Program – Oracle Database Connectivity
import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
//import java.sql.*;

public class OracleSample{

// public static final String DBURL = "jdbc:oracle:thin:@//192.168.26.21:1521/orcl.systec.com.cn";
//public static final String DBURL = "jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.26.21) (PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.26.22)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcl.systec.com.cn)))";
public static final String DBURL = "jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=rac-scan)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcl.systec.com.cn)))";
public static final String DBUSER = "system";
public static final String DBPASS = "Systec36";

public static void main(String[] args) throws SQLException {

// Load Oracle JDBC Driver
// DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
DriverManager.registerDriver(new oracle.jdbc.OracleDriver()); 

// Connect to Oracle Database
Connection con = DriverManager.getConnection(DBURL, DBUSER, DBPASS);

Statement statement = con.createStatement();

// Execute a SELECT query on Oracle Dummy DUAL Table. Useful for retrieving system values
// Enables us to retrieve values as if querying from a table
ResultSet rs = statement.executeQuery("SELECT SYSDATE FROM DUAL");

if (rs.next()) {
Date currentDate = rs.getDate(1); // get first column returned
System.out.println("Current Date from Oracle is : "+currentDate);
}
rs.close();
statement.close();
con.close();
}
}

}}}

== javac build OracleSample.java ==
javac OracleSample.java

== java run program ==
{{{
$ java -classpath "/home/oracle/instantclient_18_5/*:." OracleSample
Current Date from Oracle is : 2020-09-17
}}}