Search Code in Java Project

Example : How to Search or Fetch a unique record from Oracle 10g/11g and fill it into the respective boxes of Java using NetBeans 8.2?

import java.sql.*;
import java.text.SimpleDateFormat;

// Write Connectivity Code here properly/globally.

private void btnSearchActionPerformed(java.awt.event.ActionEvent evt) {

    try {
        String studentId = txtStudentId.getText();

        if(studentId.equals(""))
        {
            JOptionPane.showMessageDialog(this, "Enter Student ID");
            return;
        }

        String sql = "SELECT * FROM student_register WHERE student_id=?";

        PreparedStatement pst = conn.prepareStatement(sql);
        pst.setString(1, studentId);

        ResultSet rs = pst.executeQuery();

        if(rs.next())
        {
            txtName.setText(rs.getString("student_name"));
            txtPassword.setText(rs.getString("password"));

            Date dob = rs.getDate("dob");
            if(dob != null)
            {
                java.text.SimpleDateFormat sdf =
                        new java.text.SimpleDateFormat("dd-MM-yyyy");
                txtDob.setText(sdf.format(dob));
            }

            txtEmail.setText(rs.getString("email"));
            txtAddress.setText(rs.getString("address"));
            txtMobile.setText(rs.getString("mobile"));
            //txtNationality.setText(rs.getString("nationality"));
            cmbNationality.setSelectedItem(rs.getString("nationality"));

            String gender = rs.getString("gender");

            if("Male".equals(gender))
            {
                rbMale.setSelected(true);
            }
            else if("Female".equals(gender))
            {
                rbFemale.setSelected(true);
            }
            else if("Other".equals(gender))
            {
                rbOther.setSelected(true);
            }

            String education = rs.getString("education");

            cb10th.setSelected(false);
            cb12th.setSelected(false);
            cbGraduate.setSelected(false);
            cbPostGraduate.setSelected(false);

            if(education != null)
            {
                if(education.contains("10th"))
                {
                    cb10th.setSelected(true);
                }

                if(education.contains("12th"))
                {
                    cb12th.setSelected(true);
                }

                if(education.contains("Graduate"))
                {
                    cbGraduate.setSelected(true);
                }

                if(education.contains("Post Graduate"))
                {
                    cbPostGraduate.setSelected(true);
                }
            }

            JOptionPane.showMessageDialog(this, "Record Found");
        }
        else
        {
            JOptionPane.showMessageDialog(this, "Record Not Found");
        }

    } catch(Exception e) {
        JOptionPane.showMessageDialog(this, "Search Error: " + e);
    }
}

-------------------------  2nd Method  ------------------------------

// Write Connectivity Code here properly/globally.

private void jBtnRegSearchActionPerformed(java.awt.event.ActionEvent evt) 
{  
        String gender = "";
        String ChkMatric = "";
        String ChkInter = "";
        String ChkGrad = "";
        String ChkPg = "";
        
        try
          {            
            pst=conn.prepareStatement("select * from REGISTRATION where REGUNAME='"+
                jTxtRegUname.getText().trim()+"'");
            rs= pst.executeQuery();
            while (rs.next())
              {
                jTxtRegSlno.setText(rs.getString("REGSLNO"));
                jTxtRegName.setText(rs.getString("REGNAME"));
                jTxtRegFname.setText(rs.getString("REGFNAME"));
                 //Date pp = new SimpleDateFormat("dd-MMM-yyyy").parse(rs.getString("REGDOB"));
                jDtRegDob.setDate(new SimpleDateFormat("dd-MMM-yyyy").parse(rs.getString("REGDOB")));
                
                gender = rs.getString("REGGENDER");
                if(gender.equals("Male"))
                  {
                    jRdbRegMale.setSelected(true);
                  }
                else if (gender.equals("Female"))
                  {
                    jRdbRegFemale.setSelected(true);
                  }
                else if (gender.equals("Other"))
                  {
                    jRdbRegMale.setSelected(true);
                  }
                else 
                  {
                    jRdbRegMale.setSelected(false);
                    jRdbRegFemale.setSelected(false);
                    jRdbRegOther.setSelected(false);
                  }
                 
                ChkMatric = rs.getString("REGMATRIC");
                if (ChkMatric.equals("Matric"))
                  {
                    jChkRegMatric.setSelected(true);
                  }
                else 
                  {
                    jChkRegMatric.setSelected(false);
                  }

                ChkInter = rs.getString("REGINTER");
                if (ChkInter.equals("Inter"))
                 {
                    jChkRegInter.setSelected(true);
                 }
                else 
                 {
                    jChkRegInter.setSelected(false);
                 }

                ChkGrad = rs.getString("REGGRAD");
                if (ChkGrad.equals("Graduation"))
                 {
                    jChkRegGrad.setSelected(true);
                 }
                else 
                 {
                    jChkRegGrad.setSelected(false);
                 }

                ChkPg = rs.getString("REGPG");
                if (ChkPg.equals("PG"))
                  {
                    jChkRegPg.setSelected(true);
                  }
                else 
                  {
                    jChkRegPg.setSelected(false);
                  }

                jTxtRegMobile.setText(rs.getString("REGMOBILE"));
                jTxtRegEmail.setText(rs.getString("REGEMAIL"));
                jCmbRegState.setSelectedItem(rs.getString("REGSTATE"));
                jRtbRegAddress.setText(rs.getString("REGADDRESS"));
                jTxtRegUname.setText(rs.getString("REGUNAME"));
                jPdRegPsd.setText(rs.getString("REGPSD"));
              }            
         }
        catch(Exception e)
         {
           System.out.println(e) 
         }
}