Maven + Oracle XE + Sample App

<dependency>
    <groupid>com.oracle</groupid>
    <artifactid>ojdbc6</artifactid>
    <version>11.2.0.3</version>
</dependency>
...
<repositories>
    <repository>
      <id>codelds</id>
      <url>https://code.lds.org/nexus/content/groups/main-repo</url>
    </repository>
  </repositories>



public class OracleSample {

    public static final String DBURL = "jdbc:oracle:thin:@localhost:1521:XE";
    public static final String DBUSER = "rtpmodern";
    public static final String DBPASS = "P@ssw0rd";

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

        // Load Oracle JDBC Driver
        DriverManager.registerDriver(new oracle.jdbc.driver.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 HIREDATE FROM EMP");

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

Comments

Popular posts from this blog

Simple Invoice Creation With Jasper Report

Dynamic Image in Jasper Report

Auto Increment Oracle Table Id Mapping With JPA Entity