Database Operation in java swing

Database Connectivity in Java Swing.

(CRUD OPERATIONS)

import java.awt.BorderLayout;

import java.awt.EventQueue;

import javax.swing.JFrame;

import javax.swing.JPanel;

import javax.swing.border.EmptyBorder;

import javax.swing.JLabel;

import javax.swing.JTextField;

import java.awt.Choice;

import java.awt.Color;

import javax.swing.JButton;

import java.awt.event.ActionListener;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

import java.sql.Statement;

import java.awt.event.ActionEvent;

public class Register extends JFrame {

            private JPanel contentPane;

            private JTextField textField1;

            private JTextField textField2;

            private JTextField textField3;

            /**

             * Launch the application.

             */

            public static void main(String[] args) {

                        EventQueue.invokeLater(new Runnable() {

                                    public void run() {

                                                try {

                                                            Register frame = new Register();

                                                            frame.setVisible(true);

                                                } catch (Exception e) {

                                                            e.printStackTrace();

                                                }

                                    }

                        });

            }

            /**

             * Create the frame.

             */

            public Register() {

                        setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

                        setBounds(100, 100, 450, 300);

                        contentPane = new JPanel();

                        contentPane.setBackground(Color.ORANGE);

                        contentPane.setForeground(Color.CYAN);

                        contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));

                        setContentPane(contentPane);

                        contentPane.setLayout(null);

                       

                        JLabel lblRegistration = new JLabel("REGISTRATION");

                        lblRegistration.setBounds(168, 11, 113, 14);

                        contentPane.add(lblRegistration);

                       

                        JLabel lblName = new JLabel("Name");

                        lblName.setBounds(30, 41, 46, 14);

                        contentPane.add(lblName);

                       

                        JLabel lblEnrollment = new JLabel("Enrollment No");

                        lblEnrollment.setBounds(30, 80, 81, 14);

                        contentPane.add(lblEnrollment);

                       

                        JLabel lblDept = new JLabel("Department");

                        lblDept.setBounds(33, 122, 78, 14);

                        contentPane.add(lblDept);

                       

                        textField1 = new JTextField();

                        textField1.setBounds(111, 38, 227, 20);

                        contentPane.add(textField1);

                        textField1.setColumns(10);

                       

                        textField2 = new JTextField();

                        textField2.setBounds(111, 77, 227, 20);

                        contentPane.add(textField2);

                        textField2.setColumns(10);

                       

                        textField3 = new JTextField();

                        textField3.setBounds(111, 119, 154, 20);                      

contentPane.add(textField3);

                        textField3.setColumns(10);

                       

                        JButton btnRegister = new JButton("Register");

                        btnRegister.addActionListener(new ActionListener() {

                                    public void actionPerformed(ActionEvent e) {

                                                Connection con = null;

                                                try {

                                                            Class.forName("com.mysql.jdbc.Driver");

                                                } catch (ClassNotFoundException e1) {

                                                            // TODO Auto-generated catch block

                                                            e1.printStackTrace();

                                                }

try {

con = DriverManager.getConnection("jdbc:mysql://localhost/demo","root","");

System.out.println("Connection Successful!!");

Statement st = null;

st =con.createStatement();

int res=st.executeUpdate("insert into register(name,enrollment,department) values('"+textField1.getText()+"','"+textField2.getText()+"','"+textField3.getText()+"')");                         

System.out.println("Data inserted!!");

                                                           

String sql ="UPDATE register SET name='"+textField1.getText()+"',enrollment='"+textField2.getText()+"',department='"+textField3.getText()+"'where id = 2";

st.executeUpdate(sql);

System.out.println("Data updated!!");

                                                           

String sql="DELETE from register where id=1";

st.executeUpdate(sql);

System.out.println("Data Deleted!!");

} catch (SQLException e1) {

// TODO Auto-generated catch block

e1.printStackTrace();

}                                 

}

});

btnRegister.setBounds(176, 174, 89, 23);

contentPane.add(btnRegister);

            }

}

OUTPUT