Java Database Connectivity with MySQL | eclipse IDE | phpmyadmin | Advanced Java Programming

To connect Java application with the MySQL database, we need to follow below following steps.

In this example we are using phpmyadmin as the database. So we need to know following informations for the mysql database:

1) Driver class: The driver class for the mysql database is com.mysql.jdbc.Driver.

2) Connection URL: The connection URL for the mysql database is jdbc:mysql://localhost:3306/GSSSKHOKHAR where jdbc is the API, mysql is the database, localhost is the server name on which mysql is running, we may also use IP address, 3306 is the port number and GSSSKHOKHAR is the database name. 

3) Username: The default username for the mysql database is root.

4) Password: It is the password given by the user at the time of installing the mysql database. In this example, we are going to use root as the password.

Let's first create a table in the mysql database, Table name : Students

DROP TABLE IF EXISTS `Students`; CREATE TABLE `Students` ( `ID` int(50) AUTO_INCREMENT PRIMARY KEY NOT NULL, `StudentID` int(5) NOT NULL, `StudentPassword` int(5) NOT NULL, `StudentName` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL, `FatherName` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL, `ClassCode` int(2) NOT NULL DEFAULT '0' ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1; -- -- Dumping data for table `Students`

LoginSystem.java

import java.awt.*; import java.awt.event.*; import javax.swing.*; import java.sql.*; public class LoginSystem extends JFrame implements ActionListener { Button btnLogin = new Button("Login"); // Create Labels JLabel lblLoginSystem = new JLabel("Login System in Java"); JLabel lblUserName = new JLabel("User Name:"); JLabel lblPassword = new JLabel("Password:"); // Create Text Items JTextField txtUserName = new JTextField(20); JPasswordField txtPassword = new JPasswordField(20); JLabel lblResults = new JLabel(); // Constructor of the LoginSystem public LoginSystem() { super("Login System"); setLayout (null); Font font1 = new Font("Verdana", Font.BOLD, 14); Font font2 = new Font("Verdana", Font.BOLD, 16); lblLoginSystem.setBounds(200,10,200,50); add(lblLoginSystem); lblLoginSystem.setFont(font2); lblUserName.setBounds(20,80,75,25); add(lblUserName); txtUserName.setBounds(200,80,150,25); add(txtUserName); lblPassword.setBounds(20,120,75,25); add(lblPassword); txtPassword.setBounds(200,120,150,25); add(txtPassword); btnLogin.setBounds(200,180,150,25); btnLogin.setBackground(Color.orange); add(btnLogin); lblResults.setBounds(200,255,250,75); lblResults.setFont(font1); add(lblResults); // Add listeners for the buttons btnLogin.addActionListener(this); enableEvents(AWTEvent.WINDOW_EVENT_MASK); } // End of the remote class constructor LoginSystem() public void processWindowEvent(WindowEvent winEvt) { if(winEvt.getID() == WindowEvent.WINDOW_CLOSING) { setVisible(false); dispose(); System.exit(0); } } // To trap events for each buttons public void actionPerformed(ActionEvent actEvt) { if (actEvt.getSource() == btnLogin) { checkLogin(); try { Class.forName("com.mysql.cj.jdbc.Driver"); Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/GSSSKHOKHAR","root","root"); Statement stmt=conn.createStatement(); // ResultSet rs=stmt.executeQuery("Select * From Students"); int eid; String pass; eid = 4474239; pass = "4474239"; ResultSet rs=stmt.executeQuery("select * from Students where ePunjabID ='" + eid + "' and StudentPassword= '" + pass + "'"); if(rs.next()) { String stu_name = rs.getString("StudentName"); System.out.println(stu_name+"\n"); } else { System.out.println("Wrong "); } stmt.close(); conn.close(); // System.out.println("Hello"); } catch(Exception e) { System.out.println(e.getMessage()); } } } // End of actionPerformed() method public void checkLogin() { String valUserName = txtUserName.getText(); String valPassword = String.valueOf(txtPassword.getPassword()); int val; if (valUserName.equals("Bintu") && valPassword.equals("12345")) { lblResults.setForeground(Color.BLACK); lblResults.setText("Welcome : " +valUserName); } else { lblResults.setForeground(Color.RED); lblResults.setText("Wrong Authentication"); } } // LoginSystem main() method public static void main(String [] args) { // Invoke the constructor of the LoginSystem class LoginSystem objLoginSystem = new LoginSystem(); objLoginSystem.setVisible(true); objLoginSystem.setSize(600,500); } // End of main() method } // End of LoginSystem class

To connect java application with the mysql database, mysqlconnector.jar file is required to be loaded.

download the jar file mysql-connector.jar

Two ways to load the jar file:

1) Paste the mysqlconnector.jar file in jre/lib/ext folder

2) Set classpath

Output : Login Screen

Output : Wrong Authentication - Login Screen

Output : Successfully - Login Screen

Insert & Retrieve data from M.S Access/SQL table using Java Servlet Programming

Insert Picture into M.S Access/SQL table using Java

Delete records from the Access/SQL table-using Swing Components

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

This example delete record from 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 'Delete' 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 Following block of code creates the UI described using Java Swing Components.

/* =========================================================== File Name : DeleteRecords.java WebSite : http://javaproglang.blogspot.in/ Facebook : https://www.facebook.com/AdvanceJavaProgramming Twitter ID : https://twitter.com/AdvanceJava Created By : Bintu Chaudhary =========================================================== */ //*************************************************************************** /* DeleteRecords.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 UpdatesRecords Class */ //----------------------------------------------------------------------------------- public class DeleteRecords extends JPanel implements ActionListener,FocusListener { 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); JLabel lblinsrcds,clas,reg,rollno,sname,fname,mname,category,studob,sex,city,state,lblhobby,address,phoneno,mobno; JTextField txtreg,txtrollno,txtname,txtfname,txtmname,txtcate,txtdob,txtcity,txtstate,txtphone,txtmob,txtclass,txtsex; JTextArea taddress; 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 btn_search,btn_delete,btn_cancel,btn_exit; String strdel_reg,strdel_rollno,strdel_class,strdel_name,strdel_fname,strdel_mname,strdel_dob,strdel_cate,strdel_sex,strdel_address,strdel_city,strdel_state,strdel_phoneno,strdel_mobno; public DeleteRecords() { setBackground(c5); setLayout(null); JLabel lbl_delete=new JLabel("Delete Records"); lbl_delete.setBounds(350,8,350,30); lbl_delete.setFont(f6); add(lbl_delete); //JLabel Reg.No. reg=new JLabel("Registration No."); reg.setBounds(30,60,100,30); reg.setFont(f2); add(reg); //JTextField Reg.No. txtreg=new JTextField(10); txtreg.setBounds(230,60,100,30); txtreg.setBackground(c5); txtreg.setFont(f4); txtreg.addFocusListener(this); add(txtreg); //JButton Search btn_search=new JButton("Search"); btn_search.setBounds(332,60,76,30); btn_search.setBackground(c5); btn_search.setMnemonic(KeyEvent.VK_S); btn_search.setToolTipText("Search the Record"); btn_search.setMnemonic('s'); btn_search.addActionListener(this); add(btn_search); //JLabel RollNo rollno=new JLabel("RollNo"); rollno.setBounds(30,95,100,30); rollno.setFont(f2); add(rollno); //JTextField RollNo txtrollno=new JTextField(10); txtrollno.setEditable(false); txtrollno.setBounds(230,95,100,30); txtrollno.setBackground(c5); txtrollno.setFont(f4); //txtrollno.addFocusListener(this); add(txtrollno); //JLabel Class clas=new JLabel("Class"); clas.setBounds(30,130,100,30); clas.setFont(f2); add(clas); //JTextField Class txtclass=new JTextField(10); txtclass.setBounds(230,130,100,30); txtclass.setEditable(false); txtclass.setBackground(c5); txtclass.setFont(f4); add(txtclass); //JLabel Student's Name sname=new JLabel("Student's Name"); sname.setBounds(30,165,100,30); sname.setFont(f2); add(sname); //JTextField Student's Name txtname=new JTextField(10); txtname.setBounds(230,165,170,30); txtname.setEditable(false); txtname.setBackground(c5); txtname.setFont(f4); add(txtname); //JLabel Father's Name fname=new JLabel("Father's Name"); fname.setBounds(30,200,100,30); fname.setFont(f2); add(fname); //JTextField Father's Name txtfname=new JTextField(10); txtfname.setBounds(230,200,170,30); txtfname.setEditable(false); txtfname.setBackground(c5); txtfname.setFont(f4); add(txtfname); //JLabel Mother's Name mname=new JLabel("Mother's Name"); mname.setBounds(30,235,100,30); mname.setFont(f2); add(mname); //JTextField Mother's Name txtmname=new JTextField(10); txtmname.setBounds(230,235,170,30); txtmname.setEditable(false); txtmname.setBackground(c5); txtmname.setFont(f4); add(txtmname); //JLabel Category category=new JLabel("Category"); category.setBounds(30,270,170,30); category.setFont(f2); add(category); //JTextField Category txtcate=new JTextField(10); txtcate.setBounds(230,270,170,30); txtcate.setEditable(false); txtcate.setBackground(c5); txtcate.setFont(f4); add(txtcate); //JLabel Date of Birth studob=new JLabel("Date of Birth(DD/MM/YY)"); studob.setBounds(30,305,170,30); studob.setFont(f2); add(studob); //JTextFields Date of Birth txtdob=new JTextField(2); txtdob.setBounds(230,305,170,30); txtdob.setEditable(false); txtdob.setBackground(c5); txtdob.setFont(f4); add(txtdob); //JLabel Sex sex=new JLabel("Sex"); sex.setBounds(30,340,100,30); sex.setFont(f2); add(sex); //JTextField Sex txtsex=new JTextField(10); txtsex.setBounds(230,340,170,30); txtsex.setEditable(false); txtsex.setBackground(c5); txtsex.setFont(f4); add(txtsex); //JLabel Address address=new JLabel("Address"); address.setBounds(30,375,100,30); address.setFont(f2); add(address); //JTextArea Address taddress=new JTextArea(6,50); taddress.setBounds(230,375,170,40); taddress.setEditable(false); taddress.setBackground(c5); taddress.setFont(f4); add(taddress); //JLabel City city=new JLabel("City"); city.setBounds(30,425,100,30); city.setFont(f2); add(city); //JTextField City txtcity=new JTextField(10); txtcity.setBounds(230,425,170,30); txtcity.setEditable(false); txtcity.setBackground(c5); txtcity.setFont(f4); add(txtcity); //JLabel State state=new JLabel("State"); state.setBounds(430,425,100,30); state.setFont(f2); add(state); //JTextField State. txtstate=new JTextField(10); txtstate.setBounds(530,425,170,30); txtstate.setEditable(false); txtstate.setBackground(c5); txtstate.setFont(f4); add(txtstate); //JLabel Phone No. phoneno=new JLabel("Phone No"); phoneno.setBounds(30,460,100,30); phoneno.setFont(f2); add(phoneno); //JTextField Phone No. txtphone=new JTextField(10); txtphone.setBounds(230,460,170,30); txtphone.setEditable(false); txtphone.setBackground(c5); txtphone.setFont(f4); add(txtphone); //JLabel Mobile No. mobno=new JLabel("Mobile No"); mobno.setBounds(430,460,100,30); mobno.setFont(f2); add(mobno); //JTextField Mobile No. txtmob=new JTextField(10); txtmob.setBounds(530,460,170,30); txtmob.setEditable(false); txtmob.setBackground(c5); txtmob.setFont(f4); add(txtmob); //JButton Update btn_delete=new JButton("Delete"); btn_delete.setBackground(c5); btn_delete.setBounds(250,520,100,30); btn_delete.setMnemonic(KeyEvent.VK_D); btn_delete.setToolTipText("Delete the Record"); btn_delete.setMnemonic('d'); btn_delete.addActionListener(this); add(btn_delete); //JButton Cancel btn_cancel=new JButton("Cancel"); btn_cancel.setBackground(c5); btn_cancel.setBounds(350,520,100,30); btn_cancel.setMnemonic(KeyEvent.VK_C); btn_cancel.setToolTipText("Cancel"); btn_cancel.setMnemonic('c'); btn_cancel.addActionListener(this); add(btn_cancel); //JButton Exit btn_exit=new JButton("Exit"); btn_exit.setBackground(c5); btn_exit.setBounds(450,520,100,30); btn_exit.setMnemonic(KeyEvent.VK_X); btn_exit.setToolTipText("Exit"); btn_exit.setMnemonic('x'); btn_exit.addActionListener(this); add(btn_exit); } 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()==btn_search) { Search_Record(); } if(ae.getSource()==btn_delete) { String strreg=txtreg.getText(); String strrollno=txtrollno.getText(); if(strreg.length()==0) { JOptionPane.showMessageDialog(null,"Please first Search Reg.No then Delete Record !!!","Note",2); } else if(strrollno.length()==0) { JOptionPane.showMessageDialog(null,"Nothing Delete Please Try Again!!!","Note",2); } else { Delete_Record(); flag=2; } } if(ae.getSource()==btn_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 Search_Record() { String regval_search=txtreg.getText(); try { int intregval_search=Integer.parseInt(regval_search); String sql_search="SELECT * FROM SchoolClasses WHERE Admission_No="+intregval_search; rs=stmt.executeQuery(sql_search); if(rs.next()==false) { JOptionPane.showMessageDialog(null,"Registration No. " +intregval_search+ " is Not Exist!!!"); clsAllFlds(); } else { int int_addnoval=rs.getInt("Admission_No"); String str_addnoval=Integer.toString(int_addnoval); int int_rollval=rs.getInt("Roll_No"); String str_rollnoval=Integer.toString(int_rollval); String str_classval=rs.getString("Class"); String str_nameval=rs.getString("Name"); String str_fnameval=rs.getString("Father_Name"); String str_mnameval=rs.getString("Mother_Name"); String str_cateval=rs.getString("Category"); String str_dobval=rs.getString("DOB"); String str_sexval=rs.getString("Sex"); String str_addval=rs.getString("Address"); String str_cityval=rs.getString("City"); String str_stateval=rs.getString("State"); String str_phoneval=rs.getString("Phone_No"); String str_mobval=rs.getString("Mobile_No"); txtreg.setText(str_addnoval); txtrollno.setText(str_rollnoval); txtclass.setText(str_classval); txtname.setText(str_nameval); txtfname.setText(str_fnameval); txtmname.setText(str_mnameval); txtdob.setText(str_dobval); txtcate.setText(str_cateval); txtsex.setText(str_sexval); taddress.setText(str_addval); txtcity.setText(str_cityval); txtstate.setText(str_stateval); txtphone.setText(str_phoneval); txtmob.setText(str_mobval); getValueForDelete(); } } catch(SQLException se) { JOptionPane.showMessageDialog(null,"There is a Problem within Database !!!","Note",2); System.out.println(se.getMessage()); } } public void getValueForDelete() { strdel_reg =txtreg.getText(); strdel_rollno =txtrollno.getText(); strdel_class =txtclass.getText(); strdel_name =txtname.getText(); strdel_fname =txtfname.getText(); strdel_mname =txtmname.getText(); strdel_dob =txtdob.getText(); strdel_cate =txtcate.getText(); strdel_sex =txtsex.getText(); strdel_address =taddress.getText(); strdel_city =txtcity.getText(); strdel_state =txtstate.getText(); strdel_phoneno =txtphone.getText(); strdel_mobno =txtmob.getText(); } public void clsAllFlds() { txtreg.setText(""); txtrollno.setText(""); txtclass.setText(""); txtname.setText(""); txtfname.setText(""); txtmname.setText(""); txtdob.setText(""); txtcate.setText(""); txtsex.setText(""); taddress.setText(""); txtcity.setText(""); txtstate.setText(""); txtphone.setText(""); txtmob.setText(""); } public void setBackgroundColor() { txtreg.setBackground(c1); txtrollno.setBackground(c1); txtclass.setBackground(c1); txtname.setBackground(c1); txtfname.setBackground(c1); txtmname.setBackground(c1); txtdob.setBackground(c1); txtcate.setBackground(c1); txtsex.setBackground(c1); taddress.setBackground(c1); txtcity.setBackground(c1); txtstate.setBackground(c1); txtphone.setBackground(c1); txtmob.setBackground(c1); } //__________________________________________________________________________________________ /* In Real This Method allows to Modify the Student Information */ //-------------------------------------------------------------------------------------------- public void Delete_Record() { String sql_del; int int_delval; try { if(strdel_reg.length()==0) { JOptionPane.showMessageDialog(null,"Nothing to Delete Please Try Again !!!","Note",2); } else { int_delval=Integer.parseInt(strdel_reg); response=JOptionPane.showConfirmDialog(null,"Do You Really Want To Delete The Record ? "+int_delval); sql_del="DELETE FROM SchoolClasses WHERE Admission_No= "+int_delval; if(response==JOptionPane.YES_OPTION) { stmtval=stmt.executeUpdate(sql_del); if(stmtval==1) { JOptionPane.showMessageDialog(null," RECORD-DELETED...!!!","Note",2); clsAllFlds(); } } if(response==JOptionPane.NO_OPTION) { return; } } } catch(SQLException se) { JOptionPane.showMessageDialog(null,"Currently There is a Problem within Database","Note",2); System.out.println(se.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[]) { DeleteRecords fr=new DeleteRecords(); fr.connection(); JFrame frm=new JFrame("Delete Records"); frm.setContentPane(fr); frm.setSize(800,600); frm.setVisible(true); frm.setResizable(false); } } /* END OF THE MAIN CLASS */ //*************************************************************************** /* DeleteRecords.java Created by Bintu Chaudhary */ //***************************************************************************

The Output of DeleteRecords table is as shown below:

Diagram 22.34 output of DeleteRecords.class

After running DeleteRecords.class file you will see above screen just enter Reg.No/AdmissionNo into Reg.No textbox and click on 'Search' Button this will show the next screen as shown in diagram 22.35, if reg.no is exists then it will show records otherwise it will give error message that. "Registration No. ...... is Not Exist!!!"

Diagram 22.35 entering Reg.No into Reg.No JTextBox

If Reg.No 603 is Exist then it will shown below diagram 22.28. You can use Keyboard short cut to search records like 'Alt + S'. Same for Delete Record 'Alt + D'.

Diagram 22.36 Reg.No is Exist

Diagram 22.37 Warring Message "Do You Really Want To Delete The Record ? 603"

Diagram 22.38 Record Deleted Successfully

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.

Updates records from the Access/SQL table using Swing Components

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

This example updates 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 'update' 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 Following block of code creates the UI described using Java Swing Components.

/* =========================================================== File Name : UpdatesRecords.java WebSite : http://javaproglang.blogspot.in/ Facebook : https://www.facebook.com/AdvanceJavaProgramming Twitter ID : https://twitter.com/AdvanceJava Created By : Bintu Chaudhary =========================================================== */ //*************************************************************************** /* UpdatesRecords.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 UpdatesRecords Class */ //----------------------------------------------------------------------------------- public class UpdatesRecords extends JPanel implements ActionListener,FocusListener { 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); JLabel lblinsrcds,clas,reg,rollno,sname,fname,mname,category,studob,sex,city,state,lblhobby,address,phoneno,mobno; JTextField txtreg,txtrollno,txtname,txtfname,txtmname,txtcate,txtdob,txtcity,txtstate,txtphone,txtmob,txtclass,txtsex; JTextArea taddress; 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 btn_search,btn_update,btn_cancel,btn_exit; String strupd_reg,strupd_rollno,strupd_class,strupd_name,strupd_fname,strupd_mname,strupd_dob,strupd_cate,strupd_sex,strupd_address,strupd_city,strupd_state,strupd_phoneno,strupd_mobno; public UpdatesRecords() { setBackground(c5); setLayout(null); border=new BevelBorder(BevelBorder.LOWERED); JLabel lbl_update=new JLabel("Updating Records"); lbl_update.setBounds(350,8,350,30); lbl_update.setFont(f6); add(lbl_update); //JLabel Reg.No. reg=new JLabel("Registration No."); reg.setBounds(30,60,100,30); reg.setFont(f2); add(reg); //JTextField Reg.No. txtreg=new JTextField(10); txtreg.setBounds(230,60,100,30); txtreg.setBorder(border); txtreg.setBackground(c5); txtreg.setFont(f4); txtreg.addFocusListener(this); add(txtreg); //JButton Search btn_search=new JButton("Search"); btn_search.setBounds(332,60,76,30); btn_search.setBackground(c5); btn_search.setMnemonic(KeyEvent.VK_S); btn_search.setToolTipText("Search the Record"); btn_search.setMnemonic('s'); btn_search.addActionListener(this); add(btn_search); //JLabel RollNo rollno=new JLabel("RollNo"); rollno.setBounds(30,95,100,30); rollno.setFont(f2); add(rollno); //JTextField RollNo txtrollno=new JTextField(10); txtrollno.setBounds(230,95,100,30); txtrollno.setBorder(border); txtrollno.setBackground(c5); txtrollno.setFont(f4); txtrollno.addFocusListener(this); add(txtrollno); //JLabel Class clas=new JLabel("Class"); clas.setBounds(30,130,100,30); clas.setFont(f2); add(clas); //JTextField Class txtclass=new JTextField(10); txtclass.setBounds(230,130,100,30); txtclass.setBorder(border); txtclass.setBackground(c5); txtclass.setFont(f4); txtclass.addFocusListener(this); add(txtclass); //JLabel Student's Name sname=new JLabel("Student's Name"); sname.setBounds(30,165,100,30); sname.setFont(f2); add(sname); //JTextField Student's Name txtname=new JTextField(10); txtname.setBounds(230,165,170,30); txtname.setBorder(border); txtname.setBackground(c5); txtname.setFont(f4); txtname.addFocusListener(this); add(txtname); //JLabel Father's Name fname=new JLabel("Father's Name"); fname.setBounds(30,200,100,30); fname.setFont(f2); add(fname); //JTextField Father's Name txtfname=new JTextField(10); txtfname.setBounds(230,200,170,30); txtfname.setBorder(border); txtfname.setBackground(c5); txtfname.setFont(f4); txtfname.addFocusListener(this); add(txtfname); //JLabel Mother's Name mname=new JLabel("Mother's Name"); mname.setBounds(30,235,100,30); mname.setFont(f2); add(mname); //JTextField Mother's Name txtmname=new JTextField(10); txtmname.setBounds(230,235,170,30); txtmname.setBorder(border); txtmname.setBackground(c5); txtmname.setFont(f4); txtmname.addFocusListener(this); add(txtmname); //JLabel Category category=new JLabel("Category"); category.setBounds(30,270,170,30); category.setFont(f2); add(category); //JTextField Category txtcate=new JTextField(10); txtcate.setBounds(230,270,170,30); txtcate.setBorder(border); txtcate.setBackground(c5); txtcate.setFont(f4); txtcate.addFocusListener(this); add(txtcate); //JLabel Date of Birth studob=new JLabel("Date of Birth(DD/MM/YY)"); studob.setBounds(30,305,170,30); studob.setFont(f2); add(studob); //JTextFields Date of Birth txtdob=new JTextField(2); txtdob.setBounds(230,305,170,30); txtdob.setBorder(border); txtdob.setBackground(c5); txtdob.setFont(f4); txtdob.addFocusListener(this); add(txtdob); //JLabel Sex sex=new JLabel("Sex"); sex.setBounds(30,340,100,30); sex.setFont(f2); add(sex); //JTextField Sex txtsex=new JTextField(10); txtsex.setBounds(230,340,170,30); txtsex.setBorder(border); txtsex.setBackground(c5); txtsex.setFont(f4); txtsex.addFocusListener(this); add(txtsex); //JLabel Address address=new JLabel("Address"); address.setBounds(30,375,100,30); address.setFont(f2); add(address); //JTextArea Address taddress=new JTextArea(6,50); taddress.setBounds(230,375,170,40); taddress.setBorder(border); taddress.setBackground(c5); taddress.setFont(f4); taddress.addFocusListener(this); add(taddress); //JLabel City city=new JLabel("City"); city.setBounds(30,425,100,30); city.setFont(f2); add(city); //JTextField City txtcity=new JTextField(10); txtcity.setBounds(230,425,170,30); txtcity.setBorder(border); txtcity.setBackground(c5); txtcity.setFont(f4); txtcity.addFocusListener(this); add(txtcity); //JLabel State state=new JLabel("State"); state.setBounds(430,425,100,30); state.setFont(f2); add(state); //JTextField State. txtstate=new JTextField(10); txtstate.setBounds(530,425,170,30); txtstate.setBorder(border); txtstate.setBackground(c5); txtstate.setFont(f4); txtstate.addFocusListener(this); add(txtstate); //JLabel Phone No. phoneno=new JLabel("Phone No"); phoneno.setBounds(30,460,100,30); phoneno.setFont(f2); add(phoneno); //JTextField Phone No. txtphone=new JTextField(10); txtphone.setBounds(230,460,170,30); txtphone.setBorder(border); txtphone.setBackground(c5); txtphone.setFont(f4); txtphone.addFocusListener(this); add(txtphone); //JLabel Mobile No. mobno=new JLabel("Mobile No"); mobno.setBounds(430,460,100,30); mobno.setFont(f2); add(mobno); //JTextField Mobile No. txtmob=new JTextField(10); txtmob.setBounds(530,460,170,30); txtmob.setBorder(border); txtmob.setBackground(c5); txtmob.setFont(f4); txtmob.addFocusListener(this); add(txtmob); //JButton Update btn_update=new JButton("Update"); btn_update.setBackground(c5); btn_update.setBounds(250,520,100,30); btn_update.setMnemonic(KeyEvent.VK_U); btn_update.setToolTipText("Update the Record"); btn_update.setMnemonic('u'); btn_update.addActionListener(this); add(btn_update); //JButton Cancel btn_cancel=new JButton("Cancel"); btn_cancel.setBackground(c5); btn_cancel.setBounds(350,520,100,30); btn_cancel.setMnemonic(KeyEvent.VK_C); btn_cancel.setToolTipText("Cancel"); btn_cancel.setMnemonic('c'); btn_cancel.addActionListener(this); add(btn_cancel); //JButton Exit btn_exit=new JButton("Exit"); btn_exit.setBackground(c5); btn_exit.setBounds(450,520,100,30); btn_exit.setMnemonic(KeyEvent.VK_X); btn_exit.setToolTipText("Exit"); btn_exit.setMnemonic('x'); btn_exit.addActionListener(this); add(btn_exit); } 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()==btn_search) { Search_Record(); } if(ae.getSource()==btn_update) { Update_Record(); flag=2; } if(ae.getSource()==btn_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 Search_Record() { String regval_search=txtreg.getText(); try { int intregval_search=Integer.parseInt(regval_search); String sql_search="SELECT * FROM SchoolClasses WHERE Admission_No="+intregval_search; rs=stmt.executeQuery(sql_search); if(rs.next()==false) { JOptionPane.showMessageDialog(null,"Registration No. " +intregval_search+ " is Not Exist!!!"); clsAllFlds(); } else { int int_addnoval=rs.getInt("Admission_No"); String str_addnoval=Integer.toString(int_addnoval); int int_rollval=rs.getInt("Roll_No"); String str_rollnoval=Integer.toString(int_rollval); String str_classval=rs.getString("Class"); String str_nameval=rs.getString("Name"); String str_fnameval=rs.getString("Father_Name"); String str_mnameval=rs.getString("Mother_Name"); String str_cateval=rs.getString("Category"); String str_dobval=rs.getString("DOB"); String str_sexval=rs.getString("Sex"); String str_addval=rs.getString("Address"); String str_cityval=rs.getString("City"); String str_stateval=rs.getString("State"); String str_phoneval=rs.getString("Phone_No"); String str_mobval=rs.getString("Mobile_No"); txtreg.setText(str_addnoval); txtrollno.setText(str_rollnoval); txtclass.setText(str_classval); txtname.setText(str_nameval); txtfname.setText(str_fnameval); txtmname.setText(str_mnameval); txtdob.setText(str_dobval); txtcate.setText(str_cateval); txtsex.setText(str_sexval); taddress.setText(str_addval); txtcity.setText(str_cityval); txtstate.setText(str_stateval); txtphone.setText(str_phoneval); txtmob.setText(str_mobval); getValueForUpdate(); } } catch(SQLException se) { JOptionPane.showMessageDialog(null,"There is a Problem within Database !!!","Note",2); System.out.println(se.getMessage()); } } public void getValueForUpdate() { strupd_reg =txtreg.getText(); strupd_rollno =txtrollno.getText(); strupd_class =txtclass.getText(); strupd_name =txtname.getText(); strupd_fname =txtfname.getText(); strupd_mname =txtmname.getText(); strupd_dob =txtdob.getText(); strupd_cate =txtcate.getText(); strupd_sex =txtsex.getText(); strupd_address =taddress.getText(); strupd_city =txtcity.getText(); strupd_state =txtstate.getText(); strupd_phoneno =txtphone.getText(); strupd_mobno =txtmob.getText(); } public void clsAllFlds() { txtrollno.setText(""); txtclass.setText(""); txtname.setText(""); txtfname.setText(""); txtmname.setText(""); txtdob.setText(""); txtcate.setText(""); txtsex.setText(""); taddress.setText(""); txtcity.setText(""); txtstate.setText(""); txtphone.setText(""); txtmob.setText(""); } public void setBackgroundColor() { txtreg.setBackground(c1); txtrollno.setBackground(c1); txtclass.setBackground(c1); txtname.setBackground(c1); txtfname.setBackground(c1); txtmname.setBackground(c1); txtdob.setBackground(c1); txtcate.setBackground(c1); txtsex.setBackground(c1); taddress.setBackground(c1); txtcity.setBackground(c1); txtstate.setBackground(c1); txtphone.setBackground(c1); txtmob.setBackground(c1); } //__________________________________________________________________________________________ /* In Real This Method allows to Modify the Student Information */ //-------------------------------------------------------------------------------------------- public void Update_Record() { try { if(flag==2) { reply=JOptionPane.showConfirmDialog(null,"Do You Want To Modify The Record ?"); if(reply==JOptionPane.YES_OPTION) { getValueForUpdate(); PreparedStatement pre_update; pre_update=conn.prepareStatement("UPDATE SchoolClasses SET Roll_No='"+strupd_rollno+"',Name='"+strupd_name+"',Father_Name='"+strupd_fname+"',Mother_Name='"+strupd_mname+"',Category='"+strupd_cate+"',DOB='"+strupd_dob+"',Sex='"+strupd_sex+"',Address='"+strupd_address+"',City='"+strupd_city+"',State='"+strupd_state+"',Phone_No='"+strupd_phoneno+"',Mobile_No='"+strupd_mobno+"'WHERE Admission_No="+strupd_reg); pre_update.executeUpdate(); JOptionPane.showMessageDialog(null,"Successfully Update Record","Note",2); setBackgroundColor(); Search_Record(); } } if(reply==JOptionPane.NO_OPTION) { return; } } catch(SQLException e) { JOptionPane.showMessageDialog(null,"Currently There is a Problem within Update Database","Note",2); 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[]) { UpdatesRecords fr=new UpdatesRecords(); fr.connection(); JFrame frm=new JFrame("Updating Records"); frm.setContentPane(fr); frm.setSize(800,600); frm.setVisible(true); frm.setResizable(false); } } /* END OF THE MAIN CLASS */ //*************************************************************************** /* UpdatesRecords.java Created by Bintu Chaudhary */ //***************************************************************************

The Output of UpdatesRecords table is as shown below:

Diagram 22.28 The Update Record Screen for UpdatesRecords.class.

Once the UI, (as shown in diagram 22.25), 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, first of all, you will 'Search' record entering Registration No in Reg.No JTextField like '601' and then click on the 'Search' Button. If record is exist in database then it will show all records in UI fields otherwise form will show Error Message that 'Registration No. 61 is Not Exist!!!' as shown below diagram 22.26.

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

Diagram 22.30 Screen Ready for udpate record

Diagram 22.31 Screen asking Do you want update this record?

Diagram 22.32 Display message Record Successfully Updated

Diagram 22.33 Display Screen after successfully updated record

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.

View records from the Access/SQL table using Swing JTable

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

This example shows records from the Access table 'SchoolClasses' on the hard disk, using classes of java.sql and java.awt and more packages with Grapchical User Interface. This program simply use UI component of java swing like JLabel, JButton, JMenu and JTable, after view records from database in java table you can simple print the records using print() method of java.

•  A JDBC-ODBC bridge driver is loaded
•  A Connection to the database is made, using getConnection method()
•  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

/* =========================================================== File Name : ViewRecords.java WebSite : http://javaproglang.blogspot.in/ Facebook : https://www.facebook.com/AdvanceJavaProgramming Twitter ID : https://twitter.com/AdvanceJava Created By : Bintu Chaudhary =========================================================== */ //*************************************************************************** /* ViewRecords.java from 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.*; import javax.swing.colorchooser.*; import javax.swing.tree.*; import javax.swing.text.html.*; import javax.swing.text.html.HTMLDocument; //__________________________________________________________________________________ /* Start the ViewRecords Class */ //----------------------------------------------------------------------------------- class ViewRecords extends JPanel implements ActionListener { 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); JPanel pa,p1,p2; JButton btn_view,btn_exit; CardLayout cardView; String strview,strsel,strviewval; ViewRcrdClass vrd; public ViewRecords() { setBackground(c5); pa=new JPanel(); p1=new JPanel(); p2=new JPanel(); pa.setBackground(c5); p1.setBackground(c5); p2.setBackground(c5); cardView=new CardLayout(); pa.setLayout(cardView); setLayout(null); JLabel lbl_view=new JLabel("View Records"); lbl_view.setBounds(350,20,350,30); lbl_view.setFont(f6); p1.add(lbl_view); p2.setLayout(null); //JButton View Records btn_view=new JButton("View Records"); btn_view.setMnemonic(KeyEvent.VK_V); btn_view.setToolTipText("View Records"); btn_view.setMnemonic('v'); btn_view.addActionListener(this); btn_view.setBackground(c5); btn_view.setBounds(310,80,130,30); p2.add(btn_view); //JButton Exit btn_exit=new JButton("Exit"); btn_exit.setBackground(c5); btn_exit.setBounds(450,80,100,30); btn_exit.setMnemonic(KeyEvent.VK_X); btn_exit.setToolTipText("Exit"); btn_exit.setMnemonic('x'); btn_exit.addActionListener(this); p2.add(btn_exit); pa.setLayout(cardView); setLayout(new BorderLayout()); add(p1,"North"); add(p2,"Center"); } public void actionPerformed(ActionEvent ae) { if(ae.getSource()==btn_view) { vrd=new ViewRcrdClass("View Records"); vrd.setSize(800,600); vrd.setVisible(true); vrd.setLocation(50,50); vrd.setBackground(c5); } if(ae.getSource()==btn_exit) { reply=JOptionPane.showConfirmDialog(null,"Do you Quit the Application ?"); if(reply==JOptionPane.YES_OPTION) { System.exit(0); } if(reply==JOptionPane.NO_OPTION) { return; } } } //____________________________________________________________________ /* START THE ViewRcrdClass Class */ //-------------------------------------------------------------------- class ViewRcrdClass extends JFrame implements ActionListener,Printable { Container c; private Component comToBePrinted; JMenuBar mnubar; JMenu mnu_print; JMenuItem mnuitem_print,mnuitem_exit; public ViewRcrdClass(String title) { super(title); c=getContentPane(); c.setBackground(c5); mnubar=new JMenuBar(); mnubar.setBackground(c3); setJMenuBar(mnubar); mnu_print=new JMenu("Print"); mnu_print.setBackground(c3); mnu_print.setMnemonic('P'); Icon icon_print=new ImageIcon("images/printer.jpg"); mnuitem_print=new JMenuItem("Print ",icon_print); mnuitem_print.setAccelerator( KeyStroke.getKeyStroke("ctrl P")); mnuitem_print.addActionListener(this); mnuitem_print.setBackground(c5); mnu_print.addSeparator(); Icon icon_exit=new ImageIcon("images/exit.jpg"); mnuitem_exit=new JMenuItem("Exit ",icon_exit); mnuitem_exit.setAccelerator( KeyStroke.getKeyStroke("ctrl X")); mnuitem_exit.addActionListener(this); mnuitem_exit.setBackground(c5); mnubar.add(mnu_print); mnu_print.add(mnuitem_print); mnu_print.add(mnuitem_exit); //Calling the View_ClassesRecords() Method View_ClassesRecords(); } public void actionPerformed(ActionEvent ae) { if(ae.getSource()==mnuitem_print) { PrintableDocument.printComponent(this); } if(ae.getSource()==mnuitem_exit) { reply=JOptionPane.showConfirmDialog(null,"Do you Quit the Application ?"); setBackground(c5); if(reply==JOptionPane.YES_OPTION) { vrd.setVisible(false); } if(reply==JOptionPane.NO_OPTION) { return; } } } //THIS METHOD IS USED FOR PRINTING ONTO PRINTER public void printComponent(Component c) { new PrintableDocument(c).print(); } public void PrintableDocument(Component comToBePrinted) { this.comToBePrinted=comToBePrinted; } public void print() { PrinterJob printJob=PrinterJob.getPrinterJob(); printJob.setPrintable(this); if(printJob.printDialog()) try { printJob.print(); } catch(PrinterException pe) { System.out.println(pe.getMessage()); } } public int print(Graphics g,PageFormat pageFormat, int pageIndex) { if(pageIndex>0) { return(NO_SUCH_PAGE); } else { Graphics2D g2d=(Graphics2D)g; g2d.translate(pageFormat.getImageableX(),pageFormat.getImageableY()); disableDoubleBuffering(comToBePrinted); comToBePrinted.paint(g2d); enableDoubleBuffering(comToBePrinted); return(PAGE_EXISTS); } } public void disableDoubleBuffering(Component c) { RepaintManager currentManager=RepaintManager.currentManager(c); currentManager.setDoubleBufferingEnabled(false); } public void enableDoubleBuffering(Component c) { RepaintManager currentManager=RepaintManager.currentManager(c); currentManager.setDoubleBufferingEnabled(true); } //_____________________________________________________________________________ /* Call the View_ClassesRecords() Which Shows all Records of Students */ //----------------------------------------------------------------------------- public void View_ClassesRecords() { c.setLayout(new BorderLayout()); c.setBackground(c5); JPanel p1=new JPanel(); p1.setBackground(c5); JLabel schoolname=new JLabel("View Records",SwingConstants.CENTER); schoolname.setFont(f6); schoolname.setForeground(Color.black); p1.add(schoolname); c.add(p1,"North"); try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); String s="jdbc:odbc:SchoolDemo"; Connection conn1=DriverManager.getConnection(s); Statement stmt1=conn1.createStatement(); ResultSet rs1=stmt1.executeQuery("Select * From SchoolClasses"); ResultSetMetaData rsm=rs1.getMetaData(); int rows=0; while(rs1.next()) { rows=rows+1; } rs1.close(); stmt1.close(); Statement stmt2=conn.createStatement(); ResultSet rs2=stmt2.executeQuery("Select * From SchoolClasses"); final String[] colheads={"Class","Reg.No","RollNo","Name","Father's Name","Mother's Name","Category","DOB","Sex","Address"}; String data[][]=new String[rows][11]; int i=-1; while(rs2.next()) { i=i+1; for(int k=0;k<11;k++) { String str1=rs2.getString("Class"); String str2=String.valueOf(rs2.getInt("Admission_No")); String str3=String.valueOf(rs2.getInt("Roll_No")); String str4=rs2.getString("Name"); String str5=rs2.getString("Father_Name"); String str6=rs2.getString("Mother_Name"); String str7=rs2.getString("Category"); String strd=rs2.getString("DOB"); String str8=rs2.getString("Sex"); String str9=rs2.getString("Address"); //String str10=rs2.getString("City"); //String str11=rs2.getString("State"); //String str12=rs2.getString("Phone_No"); //String str13=rs2.getString("Mobile_No"); data[i][k]=str1; k=k+1; data[i][k]=str2; k=k+1; data[i][k]=str3; k=k+1; data[i][k]=str4; k=k+1; data[i][k]=str5; k=k+1; data[i][k]=str6; k=k+1; data[i][k]=str7; k=k+1; data[i][k]=strd; k=k+1; data[i][k]=str8; k=k+1; data[i][k]=str9; k=k+1; //data[i][k]=str10; k=k+1; //data[i][k]=str11; k=k+1; //data[i][k]=str12; k=k+1; //data[i][k]=str13; } } DefaultTableModel model=new DefaultTableModel(data,colheads); JTable table=new JTable(model) { public Component prepareRenderer(TableCellRenderer renderer,int row,int col) { Component comp=super.prepareRenderer(renderer,row,col); JComponent jcomp=(JComponent)comp; if(comp==jcomp) { jcomp.setToolTipText((String)getValueAt(row,col)); } return comp; } public Dimension getPreferredScrollableViewportSize() { return getPreferredSize(); } }; table.setShowGrid(true); table.setShowVerticalLines(true); table.setGridColor(Color.red); table.setBackground(c5); //table.setAutoResizeMode(JTable.AUTO_RESIZE_OFF); Dimension dim=new Dimension(20,1); table.setIntercellSpacing(new Dimension(dim)); //setRowHight(table); table.setColumnSelectionAllowed(true); table.setRowSelectionAllowed(true); JTableHeader header=table.getTableHeader(); header.setBackground(Color.pink); int v=ScrollPaneConstants.VERTICAL_SCROLLBAR_AS_NEEDED; int h=ScrollPaneConstants.HORIZONTAL_SCROLLBAR_AS_NEEDED; JScrollPane jsp=new JScrollPane(table,v,h); c.add(jsp,BorderLayout.CENTER); } catch(Exception e) { System.out.println(e.getMessage()); JOptionPane.showMessageDialog(null,"ERRROR!"); } } } /*CLOSED THE VIEW_PANEL CLASS */ //_______________________________________________________________________________ /* 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[]) { ViewRecords fr=new ViewRecords(); fr.connection(); JFrame frm=new JFrame("View Records"); frm.setContentPane(fr); frm.setSize(800,600); frm.setVisible(true); frm.setResizable(false); } } /* END OF THE MAIN CLASS */ //*************************************************************************** /* ViewRecords.java Created by Bintu Chaudhary */ //***************************************************************************


The Output of View table is as shown below:

Diagram 22.25

After running ViewRecords.class file you will see above screen just simply click on 'View Records' Button this will show the next screen as shown in diagram 22.27 in JTable.

Diagram 22.26 of ViewRecords.class in JTable

You can use print command too in java using print() method as shown in below diagram 22.28.

Diagram 22.27 using printer in JTable

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.