Save Code in Java Project

Example : How to Stop Blank/Empty data or records from being saved in an Oracle 10g/11g database.

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

----------------------  Text box  ------------------------ 
          
          String TxtName = jTextField1.getText();

     //   if(TxtName.equals("")) or if(TxtName.length()==0) or if(TxtName.hashCode()==0 ) 
          or if(TxtName !=null && TxtName.equals(""))    
    
    if(TxtName.isEmpty()) 
     {        
            showMessageDialog(null,"Plese Enter Your Name");
            jTextField1.grabFocus();
            return;
     }

    if(jTextField1.getText().isEmpty()) 
     {        
            showMessageDialog(null,"Plese Enter Your Name");
            jTextField1.grabFocus();
            return;
     }

----------------------  Date Time box  ------------------------    
        
    if(jXDatePicker1.getDate()==null)
      {
            showMessageDialog(null,"Please Select Any Date");
            jXDatePicker1.requestFocus();
            return;
      }

----------------------  Radio button  ------------------------        
        
    if(!jRadioButton1Male.isSelected())
      {
            showMessageDialog(null,"Please Select Any Gender");
            jRadioButton1Male.grabFocus();
            return;  
       }

     if((!jRadioButton1.isSelected())&&(!jRadioButton2.isSelected())&&(!jRadioButton3.isSelected()))
      {
           showMessageDialog(null,"Please Select Any Gender");
           jRadioButton1.grabFocus();
           return;
      }

----------------------  Check box  ------------------------

     if((!jCheckBox1Matric.isSelected())
      {
           showMessageDialog(null,"Please Select Any Gender");
           jRadioButton1Male.grabFocus();
           return;
      }

     if((!jChkRegMatric.isSelected())&&(!jChkRegInter.isSelected())&&(!jChkRegGrad.isSelected())&& 
          (!jChkRegPg.isSelected()))
      {
            showMessageDialog(null,"Please Check Choice");
            return;
      }

----------------------  Combo / Drop down box  ------------------------

     if(jComboBox1.getSelectedItem().equals("Select One"))
      {
           showMessageDialog(null,"Please Choose State");
           jCmbRegState.requestFocus();
           return;
      }
 
 Now, we can put/write Save Code further here.
}

Example : How to Save/Store data or records in an Oracle 10g/11g database [0 th Method].

Oracle 10g/11g SQL

CREATE TABLE student_register
(
    student_id NUMBER PRIMARY KEY,
    student_name VARCHAR2(100),
    password VARCHAR2(100),
    dob DATE,
    email VARCHAR2(100),
    address VARCHAR2(300),
    gender VARCHAR2(20),
    mobile NUMBER(10),
    nationality VARCHAR2(50),
    education VARCHAR2(200)
);

CREATE SEQUENCE student_seq
START WITH 1
INCREMENT BY 1;

-------------------------------------

StudentRegister.java

import java.sql.*;
import javax.swing.*;

public class StudentRegister extends javax.swing.JFrame {

    Connection conn;
    PreparedStatement pst;

    public StudentRegister() 
    {
        initComponents();
           connectDB();
    }

    public void connectDB() {
        try {
            Class.forName("oracle.jdbc.driver.OracleDriver");

            conn = DriverManager.getConnection(
                    "jdbc:oracle:thin:@localhost:1521:orcl",
                    "system",
                    "raj"
            );

            JOptionPane.showMessageDialog(this, "Oracle Connected Successfully");
        } catch (Exception e) {
            JOptionPane.showMessageDialog(this, "Connection Error: " + e);
        }
    }            

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

        try {
            String name = txtName.getText();
            String password = new String(txtPassword.getPassword());
            String dob = txtDob.getText();
            String email = txtEmail.getText();
            String address = txtAddress.getText();
            String mobile = txtMobile.getText();
            //String nationality = txtNationality.getText();
            String nationality = cmbNationality.getSelectedItem().toString();

            String gender = "";

            if (rbMale.isSelected()) {
                gender = "Male";
            } else if (rbFemale.isSelected()) {
                gender = "Female";
            } else if (rbOther.isSelected()) {
                gender = "Other";
            }

            String education = "";

            if (cb10th.isSelected()) {
                education = education + "10th ";
            }

            if (cb12th.isSelected()) {
                education = education + "12th ";
            }

            if (cbGraduate.isSelected()) {
                education = education + "Graduate ";
            }

            if (cbPostGraduate.isSelected()) {
                education = education + "Post Graduate ";
            }

            if (name.equals("") || password.equals("") || dob.equals("") || email.equals("") || mobile.equals("")) {
                JOptionPane.showMessageDialog(this, "Please fill all required fields");
                return;
            }

            String sql = "INSERT INTO student_register "
                    + "(student_id, student_name, password, dob, email, address, gender, mobile, nationality, education) "
                    + "VALUES (student_seq.NEXTVAL, ?, ?, TO_DATE(?, 'DD-MM-YYYY'), ?, ?, ?, ?, ?, ?)";

            pst = conn.prepareStatement(sql);

            pst.setString(1, name);
            pst.setString(2, password);
            pst.setString(3, dob);
            pst.setString(4, email);
            pst.setString(5, address);
            pst.setString(6, gender);
            pst.setString(7, mobile);
            pst.setString(8, nationality);
            pst.setString(9, education);

            int i = pst.executeUpdate();

            if (i > 0) {
                JOptionPane.showMessageDialog(this, "Student Record Saved Successfully");
                resetForm();
            }

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

    private void btnResetActionPerformed(java.awt.event.ActionEvent evt) {
        resetForm();
    }

    public void resetForm() {
        txtName.setText("");
        txtPassword.setText("");
        txtDob.setText("");
        txtEmail.setText("");
        txtAddress.setText("");
        txtMobile.setText("");
        txtNationality.setText("");

        buttonGroup1.clearSelection();

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

    public static void main(String args[]) {
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                new StudentRegister().setVisible(true);
            }
        });
    }

   
}

Example : How to Save/Store data or records in an Oracle 10g/11g database [1st Method].

// Write Java-Oracle 10g/11g Connectivity Code here first properly/globally. 

private void jBtnRegSubmitActionPerformed(java.awt.event.ActionEvent evt) 
{
  int yn = showConfirmDialog(null,"Do You want to save the record!","Confirm 
              Save",YES_NO_OPTION);
   {
     if(yn == 0) 
      {
        String gender = " ";
        if(jRdbRegMale.isSelected())
          {
            gender="Male";
          }
        if(jRdbRegFemale.isSelected())
          {
            gender="Female";
          }
        if(jRdbRegOther.isSelected())
          {
            gender="Other";
          }
        
        String CmbState1 = (String)jCmbRegState.getSelectedItem();
        
        String ChkMatric = "";
        String ChkInter = "";
        String ChkGrad = "";
        String ChkPg = "";
        if(jChkRegMatric.isSelected())
          {
            ChkMatric="Matric";
          }
        else
          { 
            ChkMatric ="null";
          }
        if(jChkRegInter.isSelected())
          {
            ChkInter="Inter";
          }
        else
          { 
            ChkInter ="null";
          }
        if(jChkRegGrad.isSelected())
          {
            ChkGrad="Graduation";
          }
        else
          { 
            ChkGrad ="null";
          }
        if(jChkRegPg.isSelected())
          {
            ChkPg="PG";
          }
        else
          { 
            ChkPg ="null";
          }
        
        Date dd=jDtRegDob.getDate();             //import java.util.Date;
        Format xx= new SimpleDateFormat("dd-MMM-yyyy");        //import java.text.Format; & import java.text.SimpleDateFormat;
        String pp =xx.format(dd);
                 
        String TxtSlno = jTxtRegSlno.getText();
        String TxtName = jTxtRegName.getText();
        String TxtFname = jTxtRegFname.getText();
        String TxtMobile = jTxtRegMobile.getText();
        String TxtEmail = jTxtRegEmail.getText();
        String RtbAddress = jRtbRegAddress.getText();
        String TxtUname = jTxtRegUname.getText();
        String PdPsd = new String(jPdRegPsd.getPassword());
        
        try
        {
          String sql="insert into registration (REGSLNO,REGNAME,REGFNAME,REGDOB,REGGENDER,
                     REGMATRIC,REGINTER,REGGRAD,REGPG,REGMOBILE,REGEMAIL,REGSTATE,REGADDRESS,
                     REGUNAME,REGPSD)values('"+TxtSlno+"','"+TxtName+"','"+TxtFname+"','"+pp+"',
                     '"+gender+"','"+ChkMatric+"','"+ChkInter+"','"+ChkGrad+"','"+ChkPg+"',
                     '"+TxtMobile+"','"+TxtEmail+"','"+CmbState1+"','"+RtbAddress+"',
                     '"+TxtUname+"','"+PdPsd+"')";
            st=conn.createStatement();
            st.executeUpdate(sql);
            //out.println("Data Saved Successfully..");
            showMessageDialog(null, "Data Saved Successfully..");
        }
        catch(Exception e)
        {
           System.out.println(e);
        }
   }
}

Example : How to Save/Store data or records in an Oracle 10g/11g database [2nd Method].

// Write Java-Oracle 10g Connectivity Code here first properly/globally.
 
private void jBtnRegSubmitActionPerformed(java.awt.event.ActionEvent evt) 
{   
        //String TxtSlno = jTxtRegSlno.getText();
        
        String gender = " ";
        if(jRdbRegMale.isSelected())
          {
            gender="Male";
          }
        if(jRdbRegFemale.isSelected())
          {
            gender="Female";
          }
        if(jRdbRegOther.isSelected())
          {
            gender="Other";
          } 

   try
   {
            pst = conn.prepareStatement("insert into REGISTRATION values(?,?,?,?)"); 

            pst.setString(1,jTxtRegSlno.getText().toString());    //Code for java controls.
            pst.setString(2,jTxtRegName.getText().toString());
            pst.setString(3,jTxtRegFname.getText().toString());
            pst.setString(4,gender.toString());                   //Code for java variables.            


              |
              |     //Rest code is written here for other java controls 
              |

            
            int x = pst.executeUpdate();
            if(x!=0)
             {
                showMessageDialog(null,"Data saved Successfully....");
             }
    }
    catch(Exception e)
    {
            out.println(e);
    }
}

NB : During using this method of save code,all the table's fields/columns must be used or included in save code from column location 1,2,3,...(such as... values ?,?,?,? as mentioned above)   

Example : How to Save/Store data or records in an Oracle 10g/11g database [3rd Method].

// Write Java-Oracle 10g Connectivity Code here first properly/globally.
 
private void jBtnRegSubmitActionPerformed(java.awt.event.ActionEvent evt) 
{   
        //String TxtFname = jTxtRegFname.getText();
        
        String gender = " ";
        if(jRdbRegMale.isSelected())
          {
            gender="Male";
          }
        if(jRdbRegFemale.isSelected())
          {
            gender="Female";
          }
        if(jRdbRegOther.isSelected())
          {
            gender="Other";
          } 

   try
   {
            String sql= "insert into ROUGHTABLE(SLNO,NAME)values(?,?)";
            pst=conn.prepareStatement(sql);
            
            pst.setString(1,jTxtRegSlno.getText().toString());    //Code for java controls.
            pst.setString(2,jTxtRegName.getText().toString());
            //pst.setString(3,TxtFname);
            //pst.setString(4,gender);                   //Code for java variables.            


              |
              |     //Rest code is written here for other java controls 
              |
            
             pst.addBatch();
             pst.executeBatch();
             showMessageDialog(null,"Data Saved Successfully");
    }
    catch(Exception e)
    {
            out.println(e);
    }
}