JDBC Test With Oracle

 

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class OracleTest {
public static void main(String[] args) {
try {
        String user = "user";
        String password = "pass";
        String driver = "oracle.jdbc.driver.OracleDriver";
        String url = "jdbc: oracle:thin:@192.168.11.11:1521:dbname";
        String sql = "SELECT sysdate FROM dual";
        Class.forName(driver).newInstance();
        Connection c = DriverManager.getConnection(url, user, password);
        Statement stmt = c.createStatement();
        ResultSet rs = stmt.executeQuery(sql);
        while (rs.next()) {
                 System.out.println(rs.getString(1) + user + password);
        }
       } catch (Exception e) {
                 e.printStackTrace();
    }
  }
}