/*
  /lib/ojdbc6.jar
*/

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import javax.swing.JOptionPane;
import oracle.jdbc.pool.OracleDataSource;

public class OracleConnection{

    public static void main(String[] args) {
        // TODO code application logic here
        String query = "SQLQuery";
        ExecuteSQLQuery(query);

    }

    public static void ExecuteSQLQuery(String query) {
        Statement st;
        Connection con = conncetion();
        try {
            st = con.createStatement();
            if (st.executeUpdate(query) == 1) {
            }
        } catch (SQLException ex) {
            JOptionPane.showMessageDialog(null, "Məntiqi səhv var \n" + ex);
        }
    }

    public static Connection conncetion() {
        try {
            Class.forName("oracle.jdbc.driver.OracleDriver");
            String connString = "jdbc:oracle:thin:@127.0.0.1:1521/XE";
            OracleDataSource ods = new OracleDataSource();

            ods.setURL(connString);
            ods.setUser("sys");
            ods.setPassword("Pass");
            Connection con = ods.getConnection();
            return con;
        } catch (Exception e) {
            e.printStackTrace();
            return null;
        }
    }
}