DeleteDetails.java

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

public class DeleteDetails extends JFrame implements ActionListener{
	JButton back;
	String username;
	DeleteDetails(String username){
		this.username=username;
		setBounds(365,160,870,625);
		getContentPane().setBackground(Color.WHITE);
		setLayout(null);
		
		JLabel lblusername = new JLabel("Username");
		lblusername.setBounds(30, 50, 150, 25);
		add(lblusername);
		
		JLabel labelusername = new JLabel();
		labelusername.setBounds(220, 50, 150, 25);
		add(labelusername);
		
		JLabel lblid = new JLabel("Id");
		lblid.setBounds(30, 110, 150, 25);
		add(lblid);
		
		JLabel labelid = new JLabel();
		labelid.setBounds(220, 110, 150, 25);
		add(labelid);
		
		JLabel lblnumber = new JLabel("Number");
		lblnumber.setBounds(30, 170, 150, 25);
		add(lblnumber);
		
		JLabel labelnumber = new JLabel();
		labelnumber.setBounds(220, 170, 150, 25);
		add(labelnumber);
		
		JLabel lblname = new JLabel("Name");
		lblname.setBounds(30, 230, 150, 25);
		add(lblname);
		
		JLabel labelname = new JLabel();
		labelname.setBounds(220, 230, 150, 25);
		add(labelname);
		
		JLabel lblgender = new JLabel("Gender");
		lblgender.setBounds(30, 290, 150, 25);
		add(lblgender);
		
		JLabel labelgender = new JLabel();
		labelgender.setBounds(220, 290, 150, 25);
		add(labelgender);
		
		JLabel lblcountry = new JLabel("Country");
		lblcountry.setBounds(500, 50, 150, 25);
		add(lblcountry);
		
		JLabel labelcountry = new JLabel();
		labelcountry.setBounds(690, 50, 150, 25);
		add(labelcountry);
		
		JLabel lbladdress = new JLabel("Address");
		lbladdress.setBounds(500, 110, 150, 25);
		add(lbladdress);
		
		JLabel labeladdress = new JLabel();
		labeladdress.setBounds(690, 110, 150, 25);
		add(labeladdress);
		
		JLabel lblphone = new JLabel("Phone");
		lblphone.setBounds(500, 170, 150, 25);
		add(lblphone);
		
		JLabel labelphone = new JLabel();
		labelphone.setBounds(690, 170, 150, 25);
		add(labelphone);
		
		JLabel lblemail = new JLabel("Email");
		lblemail.setBounds(500, 230, 150, 25);
		add(lblemail);
		
		JLabel labelemail = new JLabel();
		labelemail.setBounds(690, 230, 150, 25);
		add(labelemail);
		
		back= new JButton("Delete");
		back.setBackground(Color.BLACK);
		back.setForeground(Color.WHITE);
		back.setBounds(350,350,100,25);
		back.addActionListener(this);
		add(back);
		
		ImageIcon i1 = new ImageIcon(ClassLoader.getSystemResource("icons/viewall.jpg"));
		Image i2= i1.getImage().getScaledInstance(600, 200, Image.SCALE_DEFAULT);
		ImageIcon i3 = new ImageIcon(i2);
		JLabel image = new JLabel(i3);
		image.setBounds(5, 0, 70, 70);
		add(image);
		
		ImageIcon i4 = new ImageIcon(ClassLoader.getSystemResource("icons/viewall.jpg"));
		Image i5= i4.getImage().getScaledInstance(600, 200, Image.SCALE_DEFAULT);
		ImageIcon i6 = new ImageIcon(i5);
		JLabel image2 = new JLabel(i3);
		image2.setBounds(600,400,600,200);
		add(image2);
		
		try {
			Conn conn= new Conn();
		    String query ="select * from customer where username= '"+username+"' ";
		    ResultSet rs = conn.s.executeQuery(query);
		    while(rs.next()) {
		    	labelusername.setText(rs.getString("username"));
		    	labelid.setText(rs.getString("id"));
		    	labelnumber.setText(rs.getString("number"));
		    	labelname.setText(rs.getString("name"));
		    	labelgender.setText(rs.getString("gender"));
		    	labelcountry.setText(rs.getString("country"));
		    	labeladdress.setText(rs.getString("address"));
		    	labelphone.setText(rs.getString("phone"));
		    	labelemail.setText(rs.getString("email"));
		    	
		    }
		}catch(Exception e) {
			e.printStackTrace();
		}
		
		setVisible(true);
	}
	public void actionPerformed(ActionEvent ae) {
		try {
			Conn c= new Conn();
			c.s.executeUpdate("delete from account where username= '"+username+"'");
			c.s.executeUpdate("delete from customer where username= '"+username+"'");
			c.s.executeUpdate("delete from bookpackage where username= '"+username+"'");
			c.s.executeUpdate("delete from bookhotel where username= '"+username+"'");
			
			JOptionPane.showMessageDialog(null,"Data Deleted Successfully");
			System.exit(0);
		}catch(Exception e) {
			e.printStackTrace();
		}
	}

	public static void main(String[] args) {
		new DeleteDetails("");

	}

}