Example : All integrated complete codes in Java.
/* NB : Add ‘ojdbc6’ or above version of the JAR file first in the ‘Project -Libraries’ folder of NetBeans IDE 8.2 */
import java.sql.*;
import javax.swing.*;
import java.text.SimpleDateFormat;
//import java.sql.Connection;
//import java.sql.PreparedStatement;
//import java.sql.Statement;
//import java.sql.ResultSet;
//import java.sql.DriverManager;
//import javax.swing.JOptionPane;
//import javax.swing.ButtonGroup;
public class UserRegistration extends javax.swing.JFrame {
/* ------------- Global Declaration ---------------*/
Connection conn = null;
PreparedStatement pst = null;
ResultSet rs = null;
ButtonGroup bgGender = new ButtonGroup();
public UserRegistration() {
initComponents();
/* ------------- Page Load Constructor ---------------*/
bgGender.add(UrfMale1);
bgGender.add(UrfFemale1);
bgGender.add(UrfRdbOther1);
UrfNat1.addItem("Indian");
UrfNat1.addItem("American");
UrfNat1.addItem("British");
UrfNat1.addItem("Australian");
UrfNat1.addItem("Canadian");
connectDB(); // Function Calling
getNextSlno(); // Function Calling
}
/* ------------- Connectivity Code with Function Creation -------------*/
public void connectDB()
{
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection(
"jdbc:oracle:thin:@localhost:1521:orcl",
"system",
"raj"
);
}
catch (Exception e)
{
JOptionPane.showMessageDialog(this, "Connection Error: " + e);
}
}
/* ----- Automatic Serial no. Increment Code with Function Creation -----*/
public void getNextSlno()
{
try
{
String sql = "SELECT NVL(MAX(SLNO5),0)+1 FROM UREG";
pst = conn.prepareStatement(sql);
rs = pst.executeQuery();
if (rs.next()) {
UrfSlno1.setText(rs.getString(1));
}
}
catch (Exception e)
{
JOptionPane.showMessageDialog(this, "Serial No Error: " + e);
}
}
/* --------- Reset/Clear/Cancel Code with Function Creation ----------*/
public void resetForm()
{
UrfSlno1.setText("");
UrfUname1.setText("");
UrfPasswd1.setText("");
UrfAddr1.setText("");
UrfDob1.setDate(null);
UrfMob1.setText("");
bgGender.clearSelection();
UrfMat1.setSelected(false);
UrfInter1.setSelected(false);
UrfGrad1.setSelected(false);
UrfPgrad1.setSelected(false);
UrfNonmat1.setSelected(false);
UrfChkOther1.setSelected(false);
UrfNat1.setSelectedIndex(0);
getNextSlno();
UrfUname1.requestFocus();
}
@SuppressWarnings("unchecked")
// <editor-fold defaultstate="collapsed" desc="Generated Code">
private void initComponents() {
// Codes Automatically Created by NetBeans IDE
jPanel1 = new javax.swing.JPanel();
jLabel1 = new javax.swing.JLabel();
UrfPasswd1 = new javax.swing.JPasswordField();
UrfMale1 = new javax.swing.JRadioButton();
UrfBtnSave = new javax.swing.JButton();
UrfUname1 = new javax.swing.JTextField();
jScrollPane1 = new javax.swing.JScrollPane();
UrfAddr1 = new javax.swing.JTextArea();
jLabel2 = new javax.swing.JLabel();
jLabel4 = new javax.swing.JLabel();
jLabel5 = new javax.swing.JLabel();
jLabel3 = new javax.swing.JLabel();
jLabel6 = new javax.swing.JLabel();
jLabel7 = new javax.swing.JLabel();
UrfMob1 = new javax.swing.JTextField();
UrfFemale1 = new javax.swing.JRadioButton();
UrfRdbOther1 = new javax.swing.JRadioButton();
UrfNat1 = new javax.swing.JComboBox<>();
UrfNonmat1 = new javax.swing.JCheckBox();
UrfMat1 = new javax.swing.JCheckBox();
UrfInter1 = new javax.swing.JCheckBox();
UrfGrad1 = new javax.swing.JCheckBox();
UrfPgrad1 = new javax.swing.JCheckBox();
UrfBtnReset = new javax.swing.JButton();
UrfBtnEdit = new javax.swing.JButton();
UrfBtnDel = new javax.swing.JButton();
UrfBtnSearch = new javax.swing.JButton();
jLabel8 = new javax.swing.JLabel();
UrfDob1 = new com.toedter.calendar.JDateChooser();
UrfBtnExit = new javax.swing.JButton();
jLabel9 = new javax.swing.JLabel();
UrfChkOther1 = new javax.swing.JCheckBox();
UrfSlno1 = new javax.swing.JTextField();
LabelSlno = new javax.swing.JLabel();
pack();
}// </editor-fold>
/* ------------- Exit Code -------------*/
private void UrfBtnExitActionPerformed(java.awt.event.ActionEvent evt) {
System.exit(0);
}
/* ------------- Save/Add New Record Code -------------*/
private void UrfBtnSaveActionPerformed(java.awt.event.ActionEvent evt) {
try
{
if (conn == null)
{
JOptionPane.showMessageDialog(this, "Database connection is null");
return;
}
String gender = "";
if (UrfMale1.isSelected())
{
gender = "Male";
}
else if (UrfFemale1.isSelected())
{
gender = "Female";
}
else if (UrfRdbOther1.isSelected())
{
gender = "Other";
}
String mat = UrfMat1.isSelected() ? "Yes" : "No";
String inter = UrfInter1.isSelected() ? "Yes" : "No";
String grad = UrfGrad1.isSelected() ? "Yes" : "No";
String pgrad = UrfPgrad1.isSelected() ? "Yes" : "No";
String nonmat = UrfNonmat1.isSelected() ? "Yes" : "No";
String other = UrfChkOther1.isSelected() ? "Yes" : "No";
if (UrfSlno1.getText().trim().equals("") ||
UrfUname1.getText().trim().equals("") ||
UrfPasswd1.getPassword().length == 0 ||
UrfAddr1.getText().trim().equals("") ||
UrfDob1.getDate() == null ||
UrfMob1.getText().trim().equals("") ||
gender.equals(""))
{
JOptionPane.showMessageDialog(this, "Please fill all required fields.");
return;
}
String sql = "INSERT INTO UREG "
+ "(SLNO5, UNAME5, PASSWORD5, ADDR5, DOB5, MOBNO5, GEN5, "
+ "MAT5, INTER5, GRAD5, PGRAD5, NONMAT5, OTHER5, NAT5) "
+ "VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
pst = conn.prepareStatement(sql);
pst.setInt(1, Integer.parseInt(UrfSlno1.getText()));
pst.setString(2, UrfUname1.getText());
pst.setString(3, new String(UrfPasswd1.getPassword()));
pst.setString(4, UrfAddr1.getText());
java.sql.Date dob =
new java.sql.Date(UrfDob1.getDate().getTime());
pst.setDate(5, dob);
pst.setString(6, UrfMob1.getText());
pst.setString(7, gender);
//pst.setString(7, gender.toString());
pst.setString(8, mat);
pst.setString(9, inter);
pst.setString(10, grad);
pst.setString(11, pgrad);
pst.setString(12, nonmat);
pst.setString(13, other);
pst.setString(14, UrfNat1.getSelectedItem().toString());
int i = pst.executeUpdate();
if (i > 0)
{
JOptionPane.showMessageDialog(this, "Record Saved Successfully");
resetForm();
}
}
catch (Exception e)
{
JOptionPane.showMessageDialog(this, "Save Error: " + e);
}
}
/* ------------- Search Code -------------*/
private void UrfBtnSearchActionPerformed(java.awt.event.ActionEvent evt) {
try
{
if (conn == null)
{
JOptionPane.showMessageDialog(this, "Database connection is null");
return;
}
if (UrfSlno1.getText().trim().equals(""))
{
JOptionPane.showMessageDialog(this, "Please enter Serial No.");
UrfSlno1.requestFocus();
return;
}
String sql = "SELECT * FROM UREG WHERE SLNO5=?";
pst = conn.prepareStatement(sql);
pst.setInt(1, Integer.parseInt(UrfSlno1.getText()));
//pst.setString(1, slno1);
rs = pst.executeQuery();
if (rs.next())
{
UrfSlno1.setText(rs.getString("SLNO5"));
UrfUname1.setText(rs.getString("UNAME5"));
UrfPasswd1.setText(rs.getString("PASSWORD5"));
UrfAddr1.setText(rs.getString("ADDR5"));
UrfDob1.setDate(rs.getDate("DOB5"));
/*java.sql.Date dob = rs.getDate("DOB5");
if (dob != null)
{
java.text.SimpleDateFormat sdf =
new java.text.SimpleDateFormat("dd-MM-yyyy");
Dob1.setText(sdf.format(dob));
}
else
{
Dob1.setText("");
}*/
UrfMob1.setText(rs.getString("MOBNO5"));
String gender = rs.getString("GEN5");
if ("Male".equalsIgnoreCase(gender))
{
UrfMale1.setSelected(true);
}
else if ("Female".equalsIgnoreCase(gender))
{
UrfFemale1.setSelected(true);
}
else if ("Other".equalsIgnoreCase(gender))
{
UrfRdbOther1.setSelected(true);
} else
{
bgGender.clearSelection();
}
UrfMat1.setSelected("Yes".equalsIgnoreCase(rs.getString("MAT5")));
UrfInter1.setSelected("Yes".equalsIgnoreCase(rs.getString("INTER5")));
UrfGrad1.setSelected("Yes".equalsIgnoreCase(rs.getString("GRAD5")));
UrfPgrad1.setSelected("Yes".equalsIgnoreCase(rs.getString("PGRAD5")));
UrfNonmat1.setSelected("Yes".equalsIgnoreCase(rs.getString("NONMAT5")));
UrfChkOther1.setSelected("Yes".equalsIgnoreCase(rs.getString("OTHER5")));
UrfNat1.setSelectedItem(rs.getString("NAT5"));
JOptionPane.showMessageDialog(this, "Record Found");
}
else
{
JOptionPane.showMessageDialog(this, "Record Not Found");
}
}
catch (Exception e)
{
JOptionPane.showMessageDialog(this, "Search Error: " + e);
e.printStackTrace();
}
}
/* ------------- Edit/Modify/Update/Change Code -------------*/
private void UrfBtnEditActionPerformed(java.awt.event.ActionEvent evt) {
try
{
if (conn == null)
{
JOptionPane.showMessageDialog(this,
"Database Connection Not Available");
return;
}
if (UrfSlno1.getText().trim().equals(""))
{
JOptionPane.showMessageDialog(this, "Please enter Serial No.");
UrfSlno1.requestFocus();
return;
}
int ans = JOptionPane.showConfirmDialog(
this,
"Do you want to update this record?",
"Update Confirmation",
JOptionPane.YES_NO_OPTION
);
if (ans != JOptionPane.YES_OPTION) {
return;
}
String gender = "";
if (UrfMale1.isSelected())
{
gender = "Male";
}
else if (UrfFemale1.isSelected())
{
gender = "Female";
}
else if (UrfRdbOther1.isSelected())
{
gender = "Other";
}
String mat = UrfMat1.isSelected() ? "Yes" : "No";
String inter = UrfInter1.isSelected() ? "Yes" : "No";
String grad = UrfGrad1.isSelected() ? "Yes" : "No";
String pgrad = UrfPgrad1.isSelected() ? "Yes" : "No";
String nonmat = UrfNonmat1.isSelected() ? "Yes" : "No";
String other = UrfChkOther1.isSelected() ? "Yes" : "No";
String sql = "UPDATE UREG SET "
+ "UNAME5=?, PASSWORD5=?, ADDR5=?, DOB5=?, MOBNO5=?, GEN5=?, "
+ "MAT5=?, INTER5=?, GRAD5=?, PGRAD5=?, NONMAT5=?, OTHER5=?, NAT5=? "
+ "WHERE SLNO5=?";
pst = conn.prepareStatement(sql);
pst.setString(1, UrfUname1.getText());
pst.setString(2, new String(UrfPasswd1.getPassword()));
pst.setString(3, UrfAddr1.getText());
java.sql.Date dob =
new java.sql.Date(UrfDob1.getDate().getTime());
pst.setDate(4, dob);
pst.setString(5, UrfMob1.getText());
pst.setString(6, gender);
pst.setString(7, mat);
pst.setString(8, inter);
pst.setString(9, grad);
pst.setString(10, pgrad);
pst.setString(11, nonmat);
pst.setString(12, other);
pst.setString(13, UrfNat1.getSelectedItem().toString());
pst.setInt(14, Integer.parseInt(UrfSlno1.getText()));
int i = pst.executeUpdate();
if (i > 0) {
JOptionPane.showMessageDialog(this, "Record Updated Successfully");
resetForm();
}
else
{
JOptionPane.showMessageDialog(this, "Record Not Found");
}
}
catch (Exception e)
{
JOptionPane.showMessageDialog(this, "Update Error: " + e);
e.printStackTrace();
}
}
/* ------------- Delete/Remove Code -------------*/
private void UrfBtnDelActionPerformed(java.awt.event.ActionEvent evt) {
try
{
if (conn == null)
{
JOptionPane.showMessageDialog(this,
"Database Connection Not Available");
return;
}
if (UrfSlno1.getText().trim().equals(""))
{
JOptionPane.showMessageDialog(this, "Please enter Serial No.");
UrfSlno1.requestFocus();
return;
}
int ans = JOptionPane.showConfirmDialog(
this,
"Do you want to delete this record?",
"Delete Confirmation",
JOptionPane.YES_NO_OPTION
);
if (ans != JOptionPane.YES_OPTION) {
return;
}
String sql = "DELETE FROM UREG WHERE SLNO5=?";
pst = conn.prepareStatement(sql);
pst.setInt(1, Integer.parseInt(UrfSlno1.getText()));
//pst.setString(1, slno1);
int i = pst.executeUpdate();
if (i > 0)
{
JOptionPane.showMessageDialog(this, "Record Deleted Successfully");
resetForm();
}
else
{
JOptionPane.showMessageDialog(this, "Record Not Found");
}
}
catch (Exception e)
{
JOptionPane.showMessageDialog(this, "Delete Error: " + e);
//e.printStackTrace();
}
}
/* ------- Reset/Cancel/Clear Code using calling of Function --------*/
private void UrfBtnResetActionPerformed(java.awt.event.ActionEvent evt) {
resetForm();
}
public static void main(String args[]) {
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new UserRegistration().setVisible(true);
}
});
}
// Variables declaration - do not modify, automatically created.
private javax.swing.JLabel LabelSlno;
private javax.swing.JTextArea UrfAddr1;
private javax.swing.JButton UrfBtnDel;
private javax.swing.JButton UrfBtnEdit;
private javax.swing.JButton UrfBtnExit;
private javax.swing.JButton UrfBtnReset;
private javax.swing.JButton UrfBtnSave;
private javax.swing.JButton UrfBtnSearch;
private javax.swing.JCheckBox UrfChkOther1;
private com.toedter.calendar.JDateChooser UrfDob1;
private javax.swing.JRadioButton UrfFemale1;
private javax.swing.JCheckBox UrfGrad1;
private javax.swing.JCheckBox UrfInter1;
private javax.swing.JRadioButton UrfMale1;
private javax.swing.JCheckBox UrfMat1;
private javax.swing.JTextField UrfMob1;
private javax.swing.JComboBox<String> UrfNat1;
private javax.swing.JCheckBox UrfNonmat1;
private javax.swing.JPasswordField UrfPasswd1;
private javax.swing.JCheckBox UrfPgrad1;
private javax.swing.JRadioButton UrfRdbOther1;
private javax.swing.JTextField UrfSlno1;
private javax.swing.JTextField UrfUname1;
private javax.swing.JLabel jLabel1;
private javax.swing.JLabel jLabel2;
private javax.swing.JLabel jLabel3;
private javax.swing.JLabel jLabel4;
private javax.swing.JLabel jLabel5;
private javax.swing.JLabel jLabel6;
private javax.swing.JLabel jLabel7;
private javax.swing.JLabel jLabel8;
private javax.swing.JLabel jLabel9;
private javax.swing.JPanel jPanel1;
private javax.swing.JScrollPane jScrollPane1;
// End of variables declaration
}
0 Comments