update

import javax.swing.*;
import java.awt.event.*;
import java.awt.*;
import java.sql.*;

public class updateMember extends JFrame implements ActionListener
{
	private JLabel MemberNameLabel, genderLabel, ageLabel, userIdLabel, passwordLabel, addressLabel,contactLabel;
	private JTextField MemberNameTF, genderTF, ageTF, userIdTF, contactTF, addressTF;
	private JPasswordField passwordPF;
	private JButton buttonBack, buttonLogout, buttonInsert,buttonUpdate;
	private JPanel panel;
	private String userId,password,gender,MemberName,contact, address;
	private int age;
	public updateMember()
	{

		super("Gym Management System - Create New Account Window");

		this.setSize(600, 400);
		this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

		panel = new JPanel();
		panel.setLayout(null);

		MemberNameLabel = new JLabel("Enter Name : ");
		MemberNameLabel.setBounds(100,10,150,30);
		panel.add(MemberNameLabel);

		MemberNameTF = new JTextField();
		MemberNameTF.setBounds(260,10,100,30);
		panel.add(MemberNameTF);

		userIdLabel = new JLabel("Enter Member ID : ");
		userIdLabel.setBounds(100,50,150,30);
		panel.add(userIdLabel);

		userIdTF = new JTextField();
		userIdTF.setBounds(260,50,100,30);
		panel.add(userIdTF);

		ageLabel = new JLabel("Enter Member's Age : ");
		ageLabel.setBounds(100,90,150,30);
		panel.add(ageLabel);

		ageTF = new JTextField();
		ageTF.setBounds(260,90,100,30);
		panel.add(ageTF);

		genderLabel = new JLabel("Enter Member's Gender : ");
		genderLabel.setBounds(100,130,150,30);
		panel.add(genderLabel);

		genderTF = new JTextField();
		genderTF.setBounds(260,130,100,30);
		panel.add(genderTF);

		contactLabel = new JLabel("Contact Info  : ");
		contactLabel.setBounds(100,170,150,30);
		panel.add(contactLabel);

		contactTF = new JTextField();
		contactTF.setBounds(260,170,100,30);
		panel.add(contactTF);

		addressLabel = new JLabel("Enter Member's Address : ");
		addressLabel.setBounds(100,210,150,30);
		panel.add(addressLabel);

		addressTF = new JTextField();
		addressTF.setBounds(260,210,100,30);
		panel.add(addressTF);



		passwordLabel = new JLabel("Enter Password : ");
		passwordLabel.setBounds(100, 250, 150, 30);
		panel.add(passwordLabel);

		passwordPF =new JPasswordField();
		passwordPF.setBounds(260, 250, 100, 30);
		panel.add(passwordPF);

		buttonBack = new JButton("Back");
		buttonBack.setBounds(100, 300, 80, 30);
		buttonBack.addActionListener(this);
		panel.add(buttonBack);

		buttonInsert = new JButton("Insert");
		buttonInsert.setBounds(190, 300, 80, 30);
		buttonInsert.addActionListener(this);
		panel.add(buttonInsert);

		buttonLogout = new JButton("Logout");
		buttonLogout.setBounds(280, 300, 80, 30);
		buttonLogout.addActionListener(this);
		panel.add(buttonLogout);

		buttonUpdate = new JButton("Update");
		buttonUpdate.setBounds(350, 300, 80, 30);
		buttonUpdate.addActionListener(this);
		panel.add(buttonUpdate);

		this.add(panel);
	}
	public void actionPerformed(ActionEvent ae)
	{
		String buttonClicked = ae.getActionCommand();

		if(buttonClicked.equals(buttonBack.getText()))
		{

				AdminHome adh = new AdminHome(userId,password,gender,MemberName,age,contact,address);
							this.setVisible(false);
							adh.setVisible(true);

		}
		else if(buttonClicked.equals(buttonUpdate.getText()))
		{
			UpdateintoDB();
		}
		else if(buttonClicked.equals(buttonLogout.getText()))
		{
			Login l = new Login();
			l.setVisible(true);
			this.setVisible(false);
		}
	}

	private boolean validateFields(){

		if( userIdTF.getText().isEmpty() | passwordPF.getText().isEmpty() | genderTF.getText().isEmpty() | MemberNameTF.getText().isEmpty() | ageTF.getText().isEmpty() | contactTF.getText().isEmpty() |  addressTF.getText().isEmpty() ){

			JOptionPane.showMessageDialog(null, "Add Proper Information");
			return false;

		}
		return true;

	}

	public void UpdateintoDB()
	{	String update_query = "UPDATE gymdatabase SET userId = '"+userIdTF.getText()+"', password = '"+passwordPF.getText()+"',gender = '"+genderTF.getText()+"',MemberName = '"+MemberNameTF.getText()+"'age='"+ageTF.getText()+"',contact='"+contactTF.getText()+"',address='"+addressTF.getText()+"'WHERE userId = '"+userIdTF.getText()+"';";
		System.out.println(update_query);
		if (validateFields()){

			try
			{

				Class.forName("com.mysql.jdbc.Driver");
				Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/Gym", "root", "");
				Statement stm = con.createStatement();
				stm.execute(update_query);
				stm.close();
				con.close();

			}
			catch(Exception ex)
			{
				System.out.println("Exception : " +ex.getMessage());
			}
		}
	}
}