Insert into table using Java Swing


 

Insert into table using Java Swing

In this section, We will insert rows into "Mysql" database using "Swing".

In this section, We will insert rows into "Mysql" database using "Swing".
INSERTION IN TABLE USING SWING
In this section, We will insert rows into "Mysql" database using "Swing".
What is Swing?
Swing is the extension to the Awt library, includes new and improved components that enhance the look and functionality of GUIs.It's components are light weight than Awt component. Swing can be used to build Standalone GUI Application as well as  Servlets and Applets. Swing is more portable and more flexible than AWT.
inswing.java
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
public class inswing implements ActionListener
{ JFrame fr;JPanel po;
  JLabel l1,l2,l4,l11,main;JTextField tf1,tf2;
  JComboBox S1,gender;GridBagConstraints gbc;
  GridBagLayout go;JButton ok,exit;
public inswing(){
fr=
new JFrame("New Record Entry");Font f=new Font("Verdana",Font.BOLD,24);
po=new JPanel();fr.getContentPane().add(po);fr.setVisible(true);
fr.setSize(1024,768);fr.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
po.setBackground(Color.orange);
go=new GridBagLayout();gbc=new GridBagConstraints();
po.setLayout(go);
main=new JLabel("NEW RECORD ENTRY");main.setFont(f);

l1=new JLabel("Student ID :");tf1=new JTextField(6);
l2=new JLabel("Student Name  :");tf2=new JTextField(20);
l4=new JLabel("Gender :");String str1[]={"Male","Female"};
gender=new JComboBox(str1);l11=new JLabel("Branch  :");
String str[]={"Computer Science","Electrical","Electrical 
    & Electronics"
,"Information Technology","Mechanical"};
S1=
new JComboBox(str);ok=new JButton("Accept");
exit=new JButton("Exit");S1.addActionListener(this);
gender.addActionListener(this);

gbc.anchor=GridBagConstraints.NORTH;gbc.gridx=5;gbc.gridy=0;
go.setConstraints(l1,gbc);po.add(main);

gbc.anchor=GridBagConstraints.WEST;gbc.gridx=5;
gbc.gridy=5;go.setConstraints(l1,gbc);po.add(l1);


gbc.anchor=GridBagConstraints.WEST;gbc.gridx=10;gbc.gridy=5;
go.setConstraints(tf1,gbc);po.add(tf1);

gbc.anchor=GridBagConstraints.WEST;gbc.gridx=5;gbc.gridy=10;
go.setConstraints(l2,gbc);po.add(l2);

gbc.anchor=GridBagConstraints.WEST;gbc.gridx=10;
gbc.gridy=10;go.setConstraints(tf2,gbc);po.add(tf2);

gbc.anchor=GridBagConstraints.WEST;gbc.gridx=
5;gbc.gridy=20;
go.setConstraints(l4,gbc);po.add(l4);

gbc.anchor=GridBagConstraints.WEST;gbc.gridx=10;
gbc.gridy=20;go.setConstraints(gender,gbc);po.add(gender);

gbc.anchor=GridBagConstraints.WEST;gbc.gridx=5;gbc.gridy=60;
go.setConstraints(l11,gbc);po.add(l11);

gbc.anchor=GridBagConstraints.WEST;gbc.gridx=
10;gbc.gridy=60;
go.setConstraints(S1,gbc);po.add(S1);

gbc.anchor=GridBagConstraints.WEST;gbc.gridx=10;gbc.gridy=90;
go.setConstraints(ok,gbc);po.add(ok);ok.addActionListener(this);

gbc.anchor=GridBagConstraints.WEST;gbc.gridx=11;gbc.gridy=90;
go.setConstraints(exit,gbc);po.add(exit);
exit.addActionListener(this);
}
public void actionPerformed(ActionEvent ev)
{if(ev.getSource()==ok)
{try{
Connection con;JLabel last =new JLabel("Data inserted successfully");
Class.forName("com.mysql.jdbc.Driver");
con=DriverManager.getConnection
(
"jdbc:mysql://192.168.10.13:3306/ankdb","root","root");
 PreparedStatement ps=con.prepareStatement
(
"Insert into studentrecord values(?,?,?,?)");
String id=tf1.getText();String sname=tf2.getText();
String br=S1.getSelectedItem().toString();
String gen=gender.getSelectedItem().toString();
ps.setString(1,id);ps.setString(2,sname);
ps.setString(3,gen);ps.setString(4,br);
ps.executeUpdate();con.close();
tf1.setText("");tf2.setText("");}
catch(Exception e){System.out.println("ERROR  "+e);}}
if(ev.getSource() == exit){fr.dispose(); }
public static void main(String a[]){
new inswing();}}

OUTPUT

Download this code

Ads