Management

import java.awt.BorderLayout;
import java.awt.EventQueue;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

import javax.swing.JFrame;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.border.EmptyBorder;

import net.proteanit.sql.DbUtils;

import javax.swing.JTable;
import javax.swing.JScrollPane;
import javax.swing.JButton;
import javax.swing.JTextField;
import java.awt.Font;
import javax.swing.SwingConstants;
import javax.swing.JRadioButton;
import javax.swing.JComboBox;
import javax.swing.ButtonGroup;
import java.awt.event.ActionListener;
import java.awt.event.ActionEvent;
import javax.swing.DefaultComboBoxModel;
import java.awt.event.MouseAdapter;
import java.awt.event.MouseEvent;
import javax.swing.JLabel;

public class Management extends JFrame {

    private JPanel contentPane;
    private JTable dataTable;
    Connection conn=null;
    PreparedStatement pst =null;
    ResultSet rs=null;
    private JTextField nameTF;
    private JTextField emailTF;
    private JTextField usernameTF;
    private JTextField passField;
    private JTextField ageTF;
    private JTextField heightTF;
    private JComboBox addressCB;
    private JButton btnAdd;
    private JButton btnUpdate;
    private JButton btnDelete;

    private JTextField contactTF;
    private JRadioButton rdbtnFemale,rdbtnMale;
    private String v="";
    private String combo="";
    private int E_ID =0;
    private final ButtonGroup buttonGroup = new ButtonGroup();
    /**
     * Launch the application.
     */
    public static void main(String[] args) {
        EventQueue.invokeLater(new Runnable() {
            public void run() {
                try {
                    Management frame = new Management();
                    frame.setVisible(true);
                } catch (Exception e) {
                    e.printStackTrace();
                }
            }
        });
    }

    /**
     * Create the frame.
     */
    public Management() {
        setTitle("Management");
        design();
        conn =SQLConnection.ConnecrDb();
        loadTable();
    }
    private void loadTable() {
        try {
            String query ="Select E_ID, E_Name,E_Mail,E_Username,E_Age,E_Contact,E_Gender,E_Height,E_Adress FROM Employee";
            pst=conn.prepareStatement(query);
            rs=pst.executeQuery();
            dataTable.setModel(DbUtils.resultSetToTableModel(rs));
            pst.close();
            rs.close();

        }
        catch(Exception e) {
            e.printStackTrace();
        }
    }

    private void addData () {
        try {
            String query ="INSERT INTO Employee (E_Name,E_Mail,E_Username,E_Password,E_Age,E_Contact,E_Gender,E_Height,E_Adress) VALUE(?,?,?,?,?,?,?,?,?)";

            pst =conn.prepareStatement(query);
            pst.setString(1, nameTF.getText());
            pst.setString(2, emailTF.getText());

            pst.setString(3, usernameTF.getText());
            pst.setString(4, passField.getText());
            pst.setString(5, ageTF.getText());
            pst.setString(6, contactTF.getText());
            if(rdbtnMale.isSelected()) {
                 v =rdbtnMale.getText().toString();
            }else if(rdbtnFemale.isSelected()) {
                 v=rdbtnFemale.getText().toString();
            }else {
                JOptionPane.showMessageDialog(null, "Select Gender");
            }

            pst.setString(7, String.valueOf(v) );
            pst.setString(8, heightTF.getText());
            pst.setString(9, addressCB.getSelectedItem().toString());
            pst.execute();
            pst.close();
            JOptionPane.showMessageDialog(null, "New Info Added");
            loadTable();
        }
        catch(Exception e){
            e.printStackTrace();
        }

    }

    private void loadToField() {
        try {
            int row= dataTable.getSelectedRow();
            String ID=(dataTable.getModel().getValueAt(row, 0)).toString();
            String query ="Select * FROM Employee WHERE E_ID= '" +ID+ "'";
            pst =conn.prepareStatement(query);
            rs = pst.executeQuery();
            while(rs.next())
            {
                E_ID =rs.getInt("E_ID");

                nameTF.setText(rs.getString("E_Name"));
                emailTF.setText(rs.getString("E_Mail"));
            usernameTF.setText(rs.getString("E_Username"));
                passField.setText(rs.getString("E_Password"));
                ageTF.setText(rs.getString("E_Age"));
                contactTF.setText(rs.getString("E_Contact"));
                v=rs.getString("E_Gender");
                if(v.equals("Male")) {
                    rdbtnMale.setSelected(true);
                    rdbtnFemale.setSelected(false);
                }else if(v.equals("Female"))
                {
                    rdbtnFemale.setSelected(true);
                    rdbtnMale.setSelected(false);
                }else {
                    System.out.println("");
                }
                heightTF.setText(rs.getString("E_Height"));

                combo = rs.getString("E_Adress");

                if(combo.equals("Dhaka")) {
                    addressCB.setSelectedItem("Dhaka");
                }else if(combo.equals("Rajshahi"))
                {
                    addressCB.setSelectedItem("Rajshahi");
                }
                else if(combo.equals("Barishal"))
                {
                    addressCB.setSelectedItem("Barishal");
                }else if(combo.equals("Sylhet"))
                {
                    addressCB.setSelectedItem("Sylhet");
                }else {
                    System.out.println("");
                }




            }
            pst.close();
            rs.close();

        }
        catch(Exception e) {
            e.printStackTrace();
        }
    }

    private void updateData() {
        try {
            String query ="UPDATE Employee SET E_Name = '"+nameTF.getText() +"',E_Mail='"+emailTF.getText()+
                    "',E_Username= '"+usernameTF.getText()+"',E_Password ='"+passField.getText()+
                    "',E_Age ='"+ageTF.getText()+"',E_Contact ='"+contactTF.getText()+
                    "',E_Gender ='"+v+"',E_Height ='"+heightTF.getText()+"',E_Adress ='"+ addressCB.getSelectedItem().toString()+"'WHERE E_ID ='"+E_ID+"'";


                pst = conn.prepareStatement(query);
                pst.execute();

            JOptionPane.showMessageDialog(null, "Data updated Successfully");
            pst.close();
            loadTable();
        }
        catch(Exception e){
            e.printStackTrace();

        }
    }
    private void deleteData() {
        try {

            int action =JOptionPane.showConfirmDialog(null, "Are You Sure To Delete?","Delete",JOptionPane.YES_NO_CANCEL_OPTION);
            if (action ==0) {
                String query ="DELETE FROM Employee WHERE E_ID ='"+ E_ID + "'";
                pst = conn.prepareStatement(query);
                pst.execute();
                JOptionPane.showMessageDialog(null, "Data Deleted Successfully");
                pst.close();
                loadTable();
            }
        }catch(Exception e) {
            e.printStackTrace();

        }
    }

    private void design()
    {
        setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
        setBounds(100, 100, 827, 746);
        contentPane = new JPanel();
        contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));
        setContentPane(contentPane);
        contentPane.setLayout(null);

        JScrollPane scrollPane = new JScrollPane();
        scrollPane.setBounds(10, 11, 782, 152);
        contentPane.add(scrollPane);

        dataTable = new JTable();
        dataTable.addMouseListener(new MouseAdapter() {
            @Override
            public void mouseClicked(MouseEvent e) {
                loadToField();
            }

        });
        scrollPane.setViewportView(dataTable);

        nameTF = new JTextField();
        nameTF.setHorizontalAlignment(SwingConstants.CENTER);
        nameTF.setFont(new Font("Tahoma", Font.PLAIN, 13));
        nameTF.setColumns(10);
        nameTF.setBounds(116, 174, 369, 28);
        contentPane.add(nameTF);

        emailTF = new JTextField();
        emailTF.setHorizontalAlignment(SwingConstants.CENTER);
        emailTF.setFont(new Font("Tahoma", Font.PLAIN, 13));
        emailTF.setColumns(10);
        emailTF.setBounds(116, 213, 369, 28);
        contentPane.add(emailTF);

        usernameTF = new JTextField();
        usernameTF.setHorizontalAlignment(SwingConstants.CENTER);
        usernameTF.setFont(new Font("Tahoma", Font.PLAIN, 13));
        usernameTF.setColumns(10);
        usernameTF.setBounds(116, 252, 369, 28);
        contentPane.add(usernameTF);

        passField = new JTextField();
        passField.setHorizontalAlignment(SwingConstants.CENTER);
        passField.setFont(new Font("Tahoma", Font.PLAIN, 13));
        passField.setColumns(10);
        passField.setBounds(116, 292, 369, 28);
        contentPane.add(passField);

        ageTF = new JTextField();
        ageTF.setHorizontalAlignment(SwingConstants.CENTER);
        ageTF.setFont(new Font("Tahoma", Font.PLAIN, 13));
        ageTF.setColumns(10);
        ageTF.setBounds(116, 331, 204, 23);
        contentPane.add(ageTF);

        heightTF = new JTextField();
        heightTF.setHorizontalAlignment(SwingConstants.CENTER);
        heightTF.setFont(new Font("Tahoma", Font.PLAIN, 13));
        heightTF.setColumns(10);
        heightTF.setBounds(116, 445, 215, 28);
        contentPane.add(heightTF);

        rdbtnMale = new JRadioButton("Male");
        buttonGroup.add(rdbtnMale);
        rdbtnMale.setBounds(119, 415, 109, 23);
        contentPane.add(rdbtnMale);

        rdbtnFemale  = new JRadioButton("Female");
        buttonGroup.add(rdbtnFemale);
        rdbtnFemale.setBounds(259, 411, 109, 23);
        contentPane.add(rdbtnFemale);

        contactTF = new JTextField();
        contactTF.setHorizontalAlignment(SwingConstants.CENTER);
        contactTF.setFont(new Font("Tahoma", Font.PLAIN, 13));
        contactTF.setColumns(10);
        contactTF.setBounds(116, 365, 249, 28);
        contentPane.add(contactTF);

        addressCB = new JComboBox();
        addressCB.setModel(new DefaultComboBoxModel(new String[] {"Dhaka", "Rajshahi", "Sylhet", "Barishal"}));
        addressCB.setBounds(116, 484, 221, 28);
        contentPane.add(addressCB);

         btnAdd = new JButton("Add");
        btnAdd.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
        addData();
            }
        });
        btnAdd.setBounds(51, 562, 98, 33);
    getContentPane().add(btnAdd);

         btnUpdate = new JButton("Update");
         btnUpdate.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                updateData();
            }
         });
        btnUpdate.setBounds(162, 562, 98, 33);
        contentPane.add(btnUpdate);

     btnDelete = new JButton("Delete");
     btnDelete.addActionListener(new ActionListener() {
        public void actionPerformed(ActionEvent e) {
            deleteData();
        }
     });
        btnDelete.setBounds(289, 562, 98, 33);
        contentPane.add(btnDelete);

        JLabel lblNewLabel = new JLabel("Name");
        lblNewLabel.setFont(new Font("Tahoma", Font.BOLD, 14));
        lblNewLabel.setBounds(33, 174, 61, 28);
        contentPane.add(lblNewLabel);

        JLabel lblEmail = new JLabel("Email");
        lblEmail.setFont(new Font("Tahoma", Font.BOLD, 14));
        lblEmail.setBounds(33, 213, 61, 28);
        contentPane.add(lblEmail);

        JLabel lblUsername = new JLabel("Username");
        lblUsername.setFont(new Font("Tahoma", Font.BOLD, 14));
        lblUsername.setBounds(33, 252, 73, 28);
        contentPane.add(lblUsername);

        JLabel lblPassword = new JLabel("Password");
        lblPassword.setFont(new Font("Tahoma", Font.BOLD, 14));
        lblPassword.setBounds(33, 292, 73, 28);
        contentPane.add(lblPassword);

        JLabel lblAge = new JLabel("Age");
        lblAge.setFont(new Font("Tahoma", Font.BOLD, 14));
        lblAge.setBounds(33, 327, 61, 28);
        contentPane.add(lblAge);

        JLabel lblContact = new JLabel("Contact");
        lblContact.setFont(new Font("Tahoma", Font.BOLD, 14));
        lblContact.setBounds(33, 364, 61, 28);
        contentPane.add(lblContact);

        JLabel lblGender = new JLabel("Gender");
        lblGender.setFont(new Font("Tahoma", Font.BOLD, 14));
        lblGender.setBounds(33, 410, 61, 28);
        contentPane.add(lblGender);

        JLabel lblHeight = new JLabel("Height");
        lblHeight.setFont(new Font("Tahoma", Font.BOLD, 14));
        lblHeight.setBounds(33, 445, 61, 28);
        contentPane.add(lblHeight);

        JLabel lblAddress = new JLabel("Address");
        lblAddress.setFont(new Font("Tahoma", Font.BOLD, 14));
        lblAddress.setBounds(33, 484, 61, 28);
        contentPane.add(lblAddress);
    }
}