Inserts records into the Access/SQL table using Swing Components

Home	»	Java	»	Advance Java	»	Java Database Connectivity	»	Inserts records-GUI

This example inserts records into the Access table 'SchoolClasses' on the hard disk, using classes of java.sql and java.awt and more packages with Grapchical User Interface.

•  A JDBC-ODBC bridge driver is loaded
•  A Connection to the database is made, using getConnection method()
•  Using the Connection object, SQL's 'Insert into' statement is sent to the database
•  A message is printed on the command line indicating the command was successful
•  Minimal exception handling is done

To build these concepts and skill, a 'SchoolClasses' table will be used as a working model. This table will be created in an Access database i.e. the SchoolDemo.mdb database will hold a 'SchoolClasses' table. The structure of the table will be as described below:

Database Name SchoolDemo.mdb Table Name SchoolClasses Primary Key Admission_No

The table structure will be as follows:

Diagram 22.20 M.S Access table 'SchoolClasses'

Since the 'SchoolClasses' table has been created and populated with upto 13-14 Test records, focus now shifts to the creation of the UI in Java. The UI will be created using Java 'Swing' objects.

The Following block of code creates the UI described using Java Swing Components.

/* =========================================================== File Name : InsertsRecords.java WebSite : http://javaproglang.blogspot.in/ Facebook : https://www.facebook.com/AdvanceJavaProgramming Twitter ID : https://twitter.com/AdvanceJava Created By : Bintu Chaudhary =========================================================== */ //*************************************************************************** /* InsertsRecords.java in M.S. Access - Created by Bintu Chaudhary */ //*************************************************************************** import java.awt.*; import java.net.*; import java.io.*; import java.sql.*; import javax.swing.*; import java.awt.event.*; import java.awt.print.*; import java.awt.geom.*; import javax.swing.event.*; import javax.swing.table.*; import javax.swing.border.*; import java.util.Calendar; import javax.swing.colorchooser.*; import javax.swing.tree.*; import javax.swing.text.html.*; import javax.swing.text.html.HTMLDocument; //__________________________________________________________________________________ /* Start the InsertsRecords Class */ //----------------------------------------------------------------------------------- public class InsertsRecords extends JPanel implements ActionListener,FocusListener,ItemListener { Connection conn; Statement stmt,stmtdel; ResultSet rs; String url; int nrows,reply,response,stmtval,flag; Border border; Color c1=new Color(255,146,34); Color c2=new Color(251,254,120);//yellow Color c3=new Color(140,140,255);//Sky blue Color c4=new Color(120,120,230); Color c5=new Color(190,190,240); Color c6=new Color(147,255,174);//Light Green Font f1=new Font("Times New Roman",Font.BOLD,40); Font f2=new Font("Times New Roman",Font.BOLD,14); Font f3=new Font("Times New Roman",Font.BOLD,18); Font f4=new Font("Times New Roman",Font.BOLD,12); Font f5=new Font("Times New Roman",Font.BOLD,11); Font f6=new Font("COMIC SANS MS",Font.BOLD,22); Font fp=new Font("Times New Roman",Font.BOLD,45); Font fp1=new Font("COMIC SANS SERIF",Font.BOLD,30); Calendar calendar=Calendar.getInstance(); String showdate=String.valueOf(calendar.get(Calendar.DATE)); String showmonth=String.valueOf(calendar.get(Calendar.MONTH)); String showyear=String.valueOf(calendar.get(Calendar.YEAR)); JTextField txt_curr_date; JComboBox chclas,chsex,chcategory; JLabel lblinsrcds,clas,reg,rollno,sname,fname,mname,category,studob,sex,city,state,lblhobby,address,phoneno,mobno; JTextField txtreg,txtrollno,txtname,txtfname,txtmname,txtcate,txtdate,txtmonth,txtyear,txtcity,txtstate,txtphone,txtmob,txtclass,txtsex; JTextArea taddress; JCheckBox hob1,hob2,hob3,hob4,hob5,hob6; String classval,regval,rollnoval,nameval,fnameval,mnameval,cateval,dateval,monthval,yearval,dobval,sexval,addval,cityval,stateval,phoneval,mobval; String sql_sixth,sql_seventh,sql_eigth,sql_nineth,sql_tenth,sql_eleth,sql_twlth,sql_alcls,sql_alcls6; JButton new_save,new_cancel,btn_exit; public InsertsRecords() { setBackground(c5); JLabel khl=new JLabel("Inserting Records"); setLayout(null); khl.setBounds(350,8,350,30); khl.setFont(f6); add(khl); chclas=new JComboBox(); chcategory=new JComboBox(); chsex=new JComboBox(); clas=new JLabel("Class"); reg=new JLabel("Reg. No."); rollno=new JLabel("RollNo"); sname=new JLabel("Name"); fname=new JLabel("Father's Name"); mname=new JLabel("Mother's Name"); category=new JLabel("Category"); studob=new JLabel("Date of Birth(DD/MM/YY)"); sex=new JLabel("Sex"); address=new JLabel("Address"); city=new JLabel("City"); state=new JLabel("State"); phoneno=new JLabel("Phone No"); mobno=new JLabel("Mobile No"); new_save=new JButton("Save"); new_cancel=new JButton("Cancel"); btn_exit=new JButton("Exit"); new_save.setBackground(c5); new_cancel.setBackground(c5); btn_exit.setBackground(c5); //Create the Objects of TextFields & JComboBox txtreg=new JTextField(10); txtrollno=new JTextField(10); txtfname=new JTextField(10); txtname=new JTextField(10); txtfname=new JTextField(10); txtmname=new JTextField(10); chclas.addItem("Select Class"); chclas.addItem("6th"); chclas.addItem("7th"); chclas.addItem("8th"); chclas.addItem("9th"); chclas.addItem("10th"); chclas.addItem("11th"); chclas.addItem("12th"); txtdate=new JTextField(2); txtmonth=new JTextField(2); txtyear=new JTextField(4); chcategory.addItem("Select Category"); chcategory.addItem("SC(R & O)"); chcategory.addItem("SC(M & B)"); chcategory.addItem("OBC"); chcategory.addItem("Gen"); chsex.addItem("Select Sex"); chsex.addItem("Male"); chsex.addItem("Female"); taddress=new JTextArea(6,50); txtcity=new JTextField(10); txtstate=new JTextField(10); txtphone=new JTextField(10); txtmob=new JTextField(10); //These JTextFields are Free for JComboBoxes txtclass=new JTextField(10); txtsex=new JTextField(10); txtcate=new JTextField(10); /* txt_curr_date=new JTextField(10); txt_curr_date.setBackground(c5); showdate=showdate+"/"+showmonth+"/"+showyear; txt_curr_date.setText( showdate); txt_curr_date.setEditable(false); txt_curr_date.setFont(f2); txt_curr_date.setBounds(700,10,60,30); add(txt_curr_date); */ //Apply setBounds Methods clas.setBounds(30,65,100,30); sname.setBounds(30,100,100,30); fname.setBounds(30,135,100,30); mname.setBounds(30,170,100,30); reg.setBounds(430,100,100,30); rollno.setBounds(430,135,100,30); category.setBounds(30,205,100,30); studob.setBounds(30,240,170,30); sex.setBounds(30,265,110,30); address.setBounds(30,310,100,30); city.setBounds(30,360,100,30); state.setBounds(430,360,100,30); phoneno.setBounds(30,395,100,30); mobno.setBounds(430,395,100,30); chclas.setBounds(230,65,120,30); txtname.setBounds(230,100,170,30); txtfname.setBounds(230,135,170,30); txtmname.setBounds(230,170,170,30); txtreg.setBounds(530,100,100,30); txtrollno.setBounds(530,135,100,30); chcategory.setBounds(230,205,120,30); txtdate.setBounds(230,240,50,30); txtmonth.setBounds(280,240,50,30); txtyear.setBounds(331,240,70,30); chsex.setBounds(230,275,120,30); taddress.setBounds(230,310,170,40); txtcity.setBounds(230,360,170,30); txtstate.setBounds(530,360,170,30); txtphone.setBounds(230,395,170,30); txtmob.setBounds(530,395,170,30); new_save.setMnemonic(KeyEvent.VK_S); new_cancel.setMnemonic(KeyEvent.VK_C); new_save.setBounds(250,470,100,30); new_cancel.setBounds(350,470,100,30); btn_exit.setBounds(450,470,100,30); border=new BevelBorder(BevelBorder.LOWERED); txtreg.setBorder(border); txtrollno.setBorder(border); txtname.setBorder(border); txtfname.setBorder(border); txtmname.setBorder(border); txtdate.setBorder(border); txtmonth.setBorder(border); txtyear.setBorder(border); taddress.setBorder(border); txtcity.setBorder(border); txtstate.setBorder(border); txtphone.setBorder(border); txtmob.setBorder(border); chclas.addItemListener(this); chcategory.addItemListener(this); chsex.addItemListener(this); chclas.setBackground(c5); txtreg.setBackground(c5); txtrollno.setBackground(c5); txtname.setBackground(c5); txtfname.setBackground(c5); txtmname.setBackground(c5); chcategory.setBackground(c5); txtdate.setBackground(c5); txtmonth.setBackground(c5); txtyear.setBackground(c5); chsex.setBackground(c5); taddress.setBackground(c5); txtcity.setBackground(c5); txtstate.setBackground(c5); txtphone.setBackground(c5); txtmob.setBackground(c5); clas.setFont(f2); reg.setFont(f2); rollno.setFont(f2); sname.setFont(f2); fname.setFont(f2); mname.setFont(f2); category.setFont(f2); studob.setFont(f2); sex.setFont(f2); address.setFont(f2); city.setFont(f2); state.setFont(f2); phoneno.setFont(f2); mobno.setFont(f2); txtreg.setFont(f4); txtrollno.setFont(f4); txtname.setFont(f4); txtfname.setFont(f4); txtmname.setFont(f4); txtdate.setFont(f4); txtmonth.setFont(f4); txtyear.setFont(f4); taddress.setFont(f4); txtcity.setFont(f4); txtstate.setFont(f4); txtphone.setFont(f4); txtmob.setFont(f4); add(clas); add(chclas); add(reg); add(txtreg); add(rollno); add(txtrollno); add(sname); add(txtname); add(fname); add(txtfname); add(mname); add(txtmname); add(category);add(chcategory); add(studob); add(txtdate); add(txtmonth);add(txtyear); add(sex); add(chsex); add(address); add(taddress); add(city); add(txtcity); add(state); add(txtstate); add(phoneno); add(txtphone); add(mobno); add(txtmob); add(new_save);add(new_cancel); add(btn_exit); new_save.addActionListener(this); new_cancel.addActionListener(this); btn_exit.addActionListener(this); new_save.setToolTipText("Save the Record"); new_cancel.setToolTipText("Cancel"); btn_exit.setToolTipText("Exit"); new_save.setMnemonic('s'); new_cancel.setMnemonic('c'); btn_exit.setMnemonic('x'); chclas.addFocusListener(this); txtreg.addFocusListener(this); txtrollno.addFocusListener(this); txtname.addFocusListener(this); txtfname.addFocusListener(this); txtmname.addFocusListener(this); chcategory.addFocusListener(this); txtdate.addFocusListener(this); txtmonth.addFocusListener(this); txtyear.addFocusListener(this); chsex.addFocusListener(this); taddress.addFocusListener(this); txtcity.addFocusListener(this); txtstate.addFocusListener(this); txtphone.addFocusListener(this); txtmob.addFocusListener(this); } public void itemStateChanged(ItemEvent it) { if(it.getSource()==chclas) { String strcls=(String)it.getItem(); txtclass.setText(strcls); } if(it.getSource()==chsex) { String strsex=(String)it.getItem(); txtsex.setText(strsex); } if(it.getSource()==chcategory) { String strcate=(String)it.getItem(); txtcate.setText(strcate); } } public void focusGained(FocusEvent fe) { fe.getComponent().setBackground(Color.yellow); } public void focusLost(FocusEvent fe) { fe.getComponent().setBackground(Color.white); } public void actionPerformed(ActionEvent ae) { if(ae.getSource()==new_save) { applyRcrd(); flag=1; } if(ae.getSource()==new_cancel) { clsAllFlds(); } if(ae.getSource()==btn_exit) { reply=JOptionPane.showConfirmDialog(null,"Do you Quit the Application ?"); if(reply==JOptionPane.YES_OPTION) { clsAllFlds(); System.exit(0); } if(reply==JOptionPane.NO_OPTION) { return; } } } public void clsAllFlds() { txtreg.setText(""); txtrollno.setText(""); txtname.setText(""); txtfname.setText(""); txtmname.setText(""); txtdate.setText(""); txtmonth.setText(""); txtyear.setText(""); taddress.setText(""); txtcity.setText(""); txtstate.setText(""); txtphone.setText(""); txtmob.setText(""); } public void applyRcrd() { String strchclasval=txtclass.getText(); String strsix ="6th"; String strseven ="7th"; String streight ="8th"; String strnine ="9th"; String strten ="10th"; String strele ="11th"; String strtwl ="12th"; getStudentValForInsert(); if(classval.length()==0) { JOptionPane.showMessageDialog(null,"Please Select a Class !!!","Note",2); chclas.requestFocus(); return; } if(nameval.length()==0) { JOptionPane.showMessageDialog(null,"Student Name Cannot Be Blank!!!","Note",2); txtname.requestFocus(); return; } try { int regno=Integer.parseInt(regval); String regno2=String.valueOf(regno); if(regno2.length()==0) { JOptionPane.showMessageDialog(null,"Registration No Cannot Be Blank!!!","Note",2); txtreg.requestFocus(); return; } } catch(NumberFormatException e) { JOptionPane.showMessageDialog(null,"Invalid "+regval+" Registration No.!!!","Note",2); txtreg.requestFocus(); return; } try { int rollno=Integer.parseInt(rollnoval); String rollno2=String.valueOf(rollno); if(rollnoval.length()==0) { JOptionPane.showMessageDialog(null,"RollNo Cannot Be Blank!!!","Note",2); txtrollno.requestFocus(); return; } } catch(NumberFormatException e) { JOptionPane.showMessageDialog(null,"Invalid "+rollnoval+" RollNo.!!!","Note",2); txtrollno.requestFocus(); return; } if(fnameval.length()==0) { JOptionPane.showMessageDialog(null,"Father's Name Cannot Be Blank!!!","Note",2); txtfname.requestFocus(); return; } if(mnameval.length()==0) { JOptionPane.showMessageDialog(null,"Mother's Name Cannot Be Blank!!!","Note",2); txtmname.requestFocus(); return; } if(dateval.length()==0) { JOptionPane.showMessageDialog(null,"Date Cannot Be Blank!!!","Note",2); txtdate.requestFocus(); return; } try { String checkdateval=txtdate.getText(); int intcheckdate=Integer.parseInt(checkdateval); if((intcheckdate>31) || (intcheckdate<1)) { JOptionPane.showMessageDialog(null,"Date Cannot Be Greater than 31 or Less than 1 !!!","Note",2); txtdate.requestFocus(); txtdate.setForeground(Color.red); return; } String checkmonthval=txtmonth.getText(); int intcheckmonth=Integer.parseInt(checkmonthval); if((intcheckmonth>12) || (intcheckmonth<1)) { JOptionPane.showMessageDialog(null,"Month Cannot Be Greater than 12 or Less than 1 !!!","Note",2); txtmonth.requestFocus(); txtmonth.setForeground(Color.red); return; } String checkyearval=txtyear.getText(); int intcheckyear=Integer.parseInt(checkyearval); if((intcheckyear>2005) || (intcheckyear<1950)) { JOptionPane.showMessageDialog(null,"Date Cannot Be Greater than 2005 or Less than 1985 !!!","Note",2); txtyear.requestFocus(); txtyear.setForeground(Color.red); return; } } catch(NumberFormatException nu) { JOptionPane.showMessageDialog(null,"Invalid Date Format","Note",2); } if(monthval.length()==0) { JOptionPane.showMessageDialog(null,"Month Cannot Be Blank!!!","Note",2); txtmonth.requestFocus(); return; } if(yearval.length()==0) { JOptionPane.showMessageDialog(null,"Year Name Cannot Be Blank!!!","Note",2); txtyear.requestFocus(); return; } if(sexval.length()==0) { JOptionPane.showMessageDialog(null,"Please Select a Sex !!!","Note",2); chclas.requestFocus(); return; } if(addval.length()==0) { JOptionPane.showMessageDialog(null,"Address Name Cannot Be Blank!!!","Note",2); taddress.requestFocus(); return; } if(cityval.length()==0) { JOptionPane.showMessageDialog(null,"City Name Cannot Be Blank!!!","Note",2); txtcity.requestFocus(); return; } if(strchclasval.equalsIgnoreCase(strchclasval)) { SaveRcrds(); } } public void getStudentValForInsert() { classval=txtclass.getText(); regval=txtreg.getText(); rollnoval=txtrollno.getText(); nameval=txtname.getText(); fnameval=txtfname.getText(); mnameval=txtmname.getText(); cateval=txtcate.getText(); dateval=txtdate.getText(); monthval=txtmonth.getText(); yearval=txtyear.getText(); dobval=dateval+"/"+monthval+"/"+yearval; sexval=txtsex.getText(); addval=taddress.getText(); cityval=txtcity.getText(); stateval=txtstate.getText(); phoneval=txtphone.getText(); mobval=txtmob.getText(); } //_____________________________________________________________________________________________________________ /* Below Method Used for Inserts Records Into Database of School */ //------------------------------------------------------------------------------------------------------------- public void SaveRcrds() { int int_regval=Integer.parseInt(regval); String dup_reg="Select Admission_No From SchoolClasses Where Admission_No="+int_regval; try { rs=stmt.executeQuery(dup_reg); if(rs.next()==true) { JOptionPane.showMessageDialog(null,"Registration No. "+int_regval+" is already Exists!!! \n Please Try Another Registration No.","Note",2); txtreg.requestFocus(); } else { sql_alcls="Insert into SchoolClasses"+"(Class,Admission_No,Roll_No,Name,Father_Name,Mother_Name,Category,DOB,Sex,Address,City,State,Phone_No,Mobile_No)"+"Values('"+classval+"','"+regval+"','"+rollnoval+"','"+nameval+"','"+fnameval+"','"+mnameval+"','"+cateval+"','"+dobval+"','"+sexval+"','"+addval+"','"+cityval+"','"+stateval+"','"+phoneval+"','"+mobval+"')"; if(flag==1) { reply=JOptionPane.showConfirmDialog(null,"Do you Want Save this Record"); if(reply==JOptionPane.YES_OPTION) { nrows=stmt.executeUpdate(sql_alcls); JOptionPane.showMessageDialog(null,"Registration No "+ regval+" - RollNO "+rollnoval+" of "+nameval+" Successfully Inserted"); //clsAllFlds(); } if(reply==JOptionPane.NO_OPTION) { clsAllFlds(); return; } } } } catch(Exception e) { System.out.println(e.getMessage()); } } //__________________________________________________________________________________ /* METHOD FOR PERSISTENT.ONE-TIME CONNECTION THROUGHOUT THE COMPLETE OPERATION */ //---------------------------------------------------------------------------------- public void connection() { url="jdbc:odbc:SchoolDemo"; try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); conn=DriverManager.getConnection(url); stmt=conn.createStatement(); System.out.println("Successfully Connection"); } catch(SQLException se) { System.out.println("ERROR:"+se); } catch(ClassNotFoundException cnf) { System.out.println("ERROR:"+cnf); } } //________________________________________________________________________________________ /* MAIN CLASS */ //---------------------------------------------------------------------------------------- public static void main(String args[]) { InsertsRecords fr=new InsertsRecords(); fr.connection(); JFrame frm=new JFrame("Inserts Records"); frm.setContentPane(fr); frm.setSize(800,600); frm.setVisible(true); frm.setResizable(false); } } /* END OF THE MAIN CLASS */ //*************************************************************************** /* InsertsRecords.java Created by Bintu Chaudhary */ //***************************************************************************

The Output of InsertsRecords table is as shown below:

Diagram 22.21 The Data Entry Screen for InsertsRecords.class.

Once the UI, (as shown in diagram 22.21), has been created it is necessary to add the functionality to the UI so that it works like any standard Window's based commerical application data entry form.

Now, you will inserts records accroding form like i inserts records as shown below diagram 22.22, First of all you will select Student Class for example '6th' Student's Name vice versa...in this form you just leave two text boxes Phone No and Mobile No because these text boxes are optional. During filling records if you insert wrong Reg.No or RollNO then this program will display waring message as shown below diagram 22.22.

Diagram 22.22 Message displayed when wrong Reg.No is entered.

Diagram 22.23 Screen asking Do you want save this record?

Diagram 22.23 Display message Record Successfully Inserted

Diagram 22.24 Display message Duplicate Record is Not Allowed!

JDBC - Working With User Interfaces - Using Swing Compoents

	Inserts records into the Access/SQL table using Swing Components
	View records from the Access table/SQL using Swing JTable
	Updates records into the Access/SQL table using Swing Components
	Deletes records from the Access/SQL table using Swing Components

JDBC - Programming:

	View records from the Access/SQL table.
	Inserts records into the Access/SQL table.
	Updates records into the Access/SQL table.
	Deletes records from the Access/SQL table.
	Drops the Access/SQL table.