Home Tutorial Java Jdbc Insert into table using Java Swing

 
 

Insert into table using Java Swing
Posted on: June 4, 2010 at 12:00 AM
Advertisement
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

Advertisement

Related Tags for Insert into table using Java Swing:


Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Posted on: June 4, 2010

Recommend the tutorial

Advertisements Advertisements
 

 

 

DMCA.com