Fetching DataBase Records Using Swing in Java

Introduction

This article explains how to set up a database connection with a Swing GUI in Java. The NetBeans IDE is used to create the sample examples.

Fetching Records from Database using Swing GUI

For creating this app we need the following files:

1. Java file (SwingDatabaseApp.java)
2. SQL table (emp.sql)

1. SwingDatabaseApp.java

This Java consists of the entire logic. First of all we initialize JFrame components using a constructor then create a database connection and finally set the database value to the textfield and display it using a constructor.

2. emp.sql

For fetching records we need a database table; for that we create an "emp" table in our database.

Syntax

emp.sql

create table emp
(
uname varchar2(20), umail varchar2(30),
upass varchar2(20), ucountry varchar2(20)
);

Insert some rows

The following SQL will insert some rows in it:

1. insert into emp values ('sandeep', '[email protected]', 'welcome', 'India');

2. insert into emp values ('rahul', '[email protected]' , '123', 'India');

Now let's start creating this app. Use the following procedure to do that in the NetBeans IDE.

Step 1

Open the NetBeans IDE.

Step 2

Choose "Java" -> "Java application" as shown below.

Step 3

Type your project name as "SwingDatabaseApp" as in the following.

Step 4

Now provide the following code in the "SwingDatabaseApp.java" file.

SwingDatabaseApp.java

import javax.swing.*;

import java.awt.event.*;

import java.awt.*;

import java.sql.*;

public class SwingDatabaseApp extends JFrame {

//Initializing Components

JLabel lb, lb1, lb2, lb3, lb4;

JTextField tf1, tf2, tf3, tf4;

//Creating Constructor for initializing JFrame components

SwingDatabaseApp() {

//Providing Title

super("Fetching Student Information");

lb = new JLabel("Fetching Student Information From Database");

lb.setBounds(20, 50, 450, 20);

lb.setForeground(Color.red);

lb.setFont(new Font("Serif", Font.BOLD, 20));

setVisible(true);

setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

setSize(500, 500);

lb1 = new JLabel("U_Name:");

lb1.setBounds(50, 105, 100, 20);

tf1 = new JTextField(50);

tf1.setBounds(160, 105, 100, 20);

lb2 = new JLabel("U_Mail:");

lb2.setBounds(50, 135, 100, 20);

tf2 = new JTextField(100);

tf2.setBounds(160, 135, 200, 20);

lb3 = new JLabel("U_Pass:");

lb3.setBounds(50, 165, 100, 20);

tf3 = new JTextField(50);

tf3.setBounds(160, 165, 100, 20);

lb4 = new JLabel("U_Country:");

lb4.setBounds(50, 200, 100, 20);

tf4 = new JTextField(50);

tf4.setBounds(160, 200, 100, 20);

setLayout(null);

//Add components to the JFrame

add(lb);

add(lb1);

add(tf1);

add(lb2);

add(tf2);

add(lb3);

add(tf3);

add(lb4);

add(tf4);

//Set TextField Editable False

tf1.setEditable(false);

tf2.setEditable(false);

tf3.setEditable(false);

tf4.setEditable(false);

//Create DataBase Coonection and Fetching Records for uname='sandeep'

try {

String str = "sandeep";

Class.forName("oracle.jdbc.driver.OracleDriver");

Connection con = DriverManager.getConnection("jdbc:oracle:thin:@mcndesktop07:1521", "sandeep", "welcome");

PreparedStatement st = con.prepareStatement("select * from emp where uname=?");

st.setString(1, str);

//Excuting Query

ResultSet rs = st.executeQuery();

while (rs.next()) {

String s = rs.getString(1);

String s1 = rs.getString(2);

String s2 = rs.getString(3);

String s3 = rs.getString(4);

//Sets Records in TextFields.

tf1.setText(s);

tf2.setText(s1);

tf3.setText(s2);

tf4.setText(s3);

}

} //Create Exception Handler

catch (Exception ex) {

System.out.println(ex);

}

}

//Running Constructor

public static void main(String args[]) {

new SwingDatabaseApp();

}

}

Step 5

Now our project is ready to run. Right-click on the project menu, then choose "Run". The following output will be generated.

Step 6

Now change the uname and this time we are fetching records for "rahul".

String str = "rahul";