Custom Authentication in Oracle APEX

This blog will help you to connect your java program with Oracle Database.

Step 1: First we required drives which we can use to connect our Oracle database with Java. So in this example we will use ojdbc-6 driver for database connectivity.
Go to : https://www.oracle.com/database/technologies/jdbcdriver-ucp-downloads.html
and download ojdbc-6.jar file

After downloading ojdbc-6 go to your project ->Libraries->Righclick -> Add JAR/Folder


Step 2: After adding JAR file use following code to connect your java application to  oracle database.

package java_db_msaccess;

import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
public class Java_DB_Oracle extends JFrame implements ActionListener
{

    JLabel l1, l2, l3;
    JTextField tf1;
    JButton btn1;
    JPasswordField p1;

    Java_DB_Oracle()
    {
        setTitle("Login Form in Windows Form");
        setVisible(true);
        setSize(800, 800);
        setLayout(null);
        setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);


        l1 = new JLabel("Login Form in Windows Form:");
        l1.setForeground(Color.blue);
        l1.setFont(new Font("Serif", Font.BOLD, 20));

        l2 = new JLabel("Enter Email:");
        l3 = new JLabel("Enter Password:");
        tf1 = new JTextField();
        p1 = new JPasswordField();
        btn1 = new JButton("Submit");


        l1.setBounds(100, 20, 400, 30);
        l2.setBounds(80, 70, 200, 30);
        l3.setBounds(80, 110, 200, 30);
        tf1.setBounds(300, 70, 200, 30);
        p1.setBounds(300, 110, 200, 30);
        btn1.setBounds(150, 160, 100, 30);

        add(l1);
        add(l2);
        add(tf1);
        add(l3);
        add(p1);
        add(btn1);
        btn1.addActionListener(this);
    }


    public void actionPerformed(ActionEvent e)
    {
        showData();
    }

    public void showData()
    {
        JFrame f1 = new JFrame();
        JLabel l, l0;

        String str1 = tf1.getText();
        char[] p = p1.getPassword();
        String str2 = new String(p);
        try
        {
            Class.forName("oracle.jdbc.driver.OracleDriver");
           String str = "jdbc:oracle:thin:@localhost:1521:XE";
           Connection con = DriverManager.getConnection(str,"hr","hr");
            PreparedStatement ps = con.prepareStatement("select "
                    + "username from LOGIN where email=? and "
                    + "password=?");
            ps.setString(1, str1);
            ps.setString(2, str2);
            ResultSet rs = ps.executeQuery();
            if (rs.next())
            {
                f1.setVisible(true);
                f1.setSize(600, 600);
                f1.setLayout(null);
                l = new JLabel();
                l0 = new JLabel("you are succefully logged in..");
                l0.setForeground(Color.blue);
                l0.setFont(new Font("Serif", Font.BOLD, 30));
                l.setBounds(60, 50, 400, 30);
                l0.setBounds(60, 100, 400, 40);

                f1.add(l);
                f1.add(l0);
                l.setText("Welcome " + rs.getString(1));
                l.setForeground(Color.red);
                l.setFont(new Font("Serif", Font.BOLD, 30));

            } else
            {
                JOptionPane.showMessageDialog(null,
                   "Incorrect email-Id or password..Try Again with correct detail");
            }
        }
        catch (Exception ex)
        {
            System.out.println(ex);

       }
    }

    public static void main(String arr[])
    {
        new Java_DB_Oracle();
    }
} 

Step 3: After adding above code run the program.

Have a Happy Learning

Regards

Digvijaysinh Virpura