DbTable

package DatabasePackage;

import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.ResultSet;
import javax.swing.JButton;
import javax.swing.JFrame;
import static javax.swing.JFrame.EXIT_ON_CLOSE;
import javax.swing.JLabel;
import javax.swing.JPasswordField;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JTextField;
import javax.swing.ListSelectionModel;
import javax.swing.event.ListSelectionEvent;
import javax.swing.event.ListSelectionListener;
import javax.swing.table.DefaultTableModel;

/**
 *
 * @author Richard Thomas
 */
public class DbTable extends JFrame implements ActionListener , ListSelectionListener{

    JLabel namelbl,agelbl,usrlbl,pwdlbl,msg;
    JTextField nametf,agetf,usrtf,pwdtf;
    JButton save,update,deletebtn,clearbtn;
    JPasswordField pswdfld;
    JTable table;
    JScrollPane sp;

    MysqlDbConnection mysql = new MysqlDbConnection();
    ResultSet rs;

    public DbTable() {
        namelbl = new JLabel("Name:");
        namelbl.setBounds(50,50,100,25);

        nametf = new JTextField();
        nametf.setBounds(150,50,300,25);

        agelbl = new JLabel("Age:");
        agelbl.setBounds(50,100,100,25);

        agetf = new JTextField();
        agetf.setBounds(150,100,300,25);

        usrlbl = new JLabel("Username:");
        usrlbl.setBounds(50,150,100,25);

        usrtf = new JTextField();
        usrtf.setBounds(150,150,300,25);

        pwdlbl = new JLabel("Password:");
        pwdlbl.setBounds(50,200,100,25);

        pwdtf = new JTextField();
        pwdtf.setBounds(150,200,300,25);

        save = new JButton("Save");
        save.setBounds(150,250,75,25);
        save.addActionListener(this);

        update = new JButton("Update");
        update.setBounds(225,250,75,25);
        update.addActionListener(this);

        deletebtn = new JButton("Delete");
        deletebtn.setBounds(300,250,75,25);
        deletebtn.addActionListener(this);

        clearbtn = new JButton("clear");
        clearbtn.setBounds(375,250,75,25);
        clearbtn.addActionListener(this);

        msg = new JLabel();
        msg.setBounds(100,300,200,30);



        table = new JTable();
        populateTable();
        table.setCellSelectionEnabled(true);
        table.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
        table.getSelectionModel().addListSelectionListener(this);

        sp = new JScrollPane(table);
        sp.setBounds(150,400,400,200);


        add(namelbl);
        add(nametf);
        add(agelbl);
        add(agetf);
        add(usrlbl);
        add(usrtf);
        add(pwdlbl);
        add(pwdtf);
        add(save);
        add(update);
        add(deletebtn);
        add(clearbtn);
        add(msg);
        add(sp);


        setSize(800,800);
        setLayout(null);
        setVisible(true);
        setDefaultCloseOperation(EXIT_ON_CLOSE);
        setTitle("Database Test");
    }

    private void populateTable(){
        String query1 ="select * from usrdetails";
        rs = mysql.retrive(query1);
        DefaultTableModel model = new DefaultTableModel(new String[] {"ID","Name","Age","Username","Password"},0);

        try {
            while(rs.next()){
                String id = rs.getString("ID");
                String mn = rs.getString("Name");
                String age = rs.getString("Age");
                String usr = rs.getString("Username");
                String pwd = rs.getString("Password");
                model.addRow(new Object[] {id,mn,age,usr,pwd});
            }
        } catch (Exception ex) {
            System.out.println(ex);
        }
        table.setModel(model);
    }

    public static void main(String[] args) {
        new DbTable();
    }

    @Override
    public void actionPerformed(ActionEvent e) {
        String str;
        if(e.getSource()==save||e.getSource()==update||e.getSource()==deletebtn){
            if(e.getSource()==save){
                str = "insert into usrdetails values (0,'"+nametf.getText()+"',"+agetf.getText()+",'"+usrtf.getText()+"','"+pwdtf.getText()+"')";
            }
            else if(e.getSource()==update){
                str ="update usrdetails set Name = '"+nametf.getText()+"',Age ="+agetf.getText()+",Username ='"+usrtf.getText()+"',Password ='"+pwdtf.getText()+"' where ID ="+table.getValueAt(table.getSelectedRow(), 0);
            }
            else{
                str ="delete * from usrdetails where ID ="+table.getValueAt(table.getSelectedRow(), 0);
            }
            mysql.Insert(str);
//            populateTable();
        }
        else if(e.getSource()==clearbtn){
            nametf.setText("");
            agetf.setText("");
            usrtf.setText("");
            pwdtf.setText("");
        }

    }

    @Override
    public void valueChanged(ListSelectionEvent e) {
        if(!e.getValueIsAdjusting()){

            String str = "select * from usrdetails where ID ="+table.getValueAt(table.getSelectedRow(), 0);
            rs = mysql.retrive(str);
            try {
                while(rs.next()){
                    nametf.setText(rs.getString("Name"));
                    agetf.setText(rs.getString("Age"));
                    usrtf.setText(rs.getString("Username"));
                    pwdtf.setText(rs.getString("Password"));
                }
            } catch (Exception ex) {
                System.out.println(ex);
            }

        }

    }

}