SignupTwo.java

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

public class SignupTwo extends JFrame implements ActionListener {

    String formNo;
    JComboBox<String> religionBox, categoryBox, incomeBox, educationBox, occupationBox;
    JTextField panField, aadharField;
    JRadioButton seniorYes, seniorNo, existingYes, existingNo;
    JButton next;

    public SignupTwo(String formNo) {
        this.formNo = formNo;

        setTitle("NEW ACCOUNT APPLICATION - PAGE 2");
        setLayout(null);

        JLabel formNo2 = new JLabel("APPLICATION FORM NO. " + formNo);
        formNo2.setFont(new Font("Raleway", Font.BOLD, 30));
        formNo2.setBounds(180, 20, 600, 40);
        add(formNo2);

        JLabel applicationDetails = new JLabel("Page 2: Additional Details");
        applicationDetails.setFont(new Font("Raleway", Font.BOLD, 22));
        applicationDetails.setBounds(290, 70, 400, 30);
        add(applicationDetails);

        // Religion
        JLabel religion = new JLabel("Religion:");
        religion.setFont(new Font("Raleway", Font.PLAIN, 18));
        religion.setBounds(100, 120, 150, 30);
        add(religion);

        String[] religions = {"Hindu", "Muslim", "Sikh", "Christian", "Other"};
        religionBox = new JComboBox<>(religions);
        religionBox.setBounds(300, 120, 400, 30);
        add(religionBox);

        // Category
        JLabel category = new JLabel("Category:");
        category.setFont(new Font("Raleway", Font.PLAIN, 18));
        category.setBounds(100, 170, 150, 30);
        add(category);

        String[] categories = {"General", "OBC", "SC", "ST", "Other"};
        categoryBox = new JComboBox<>(categories);
        categoryBox.setBounds(300, 170, 400, 30);
        add(categoryBox);

        // Income
        JLabel income = new JLabel("Income:");
        income.setFont(new Font("Raleway", Font.PLAIN, 18));
        income.setBounds(100, 220, 150, 30);
        add(income);

        String[] incomes = {"<1,50,000", "<2,50,000", "<5,00,000", ">5,00,000"};
        incomeBox = new JComboBox<>(incomes);
        incomeBox.setBounds(300, 220, 400, 30);
        add(incomeBox);

        // Education
        JLabel education = new JLabel("Educational Qualification:");
        education.setFont(new Font("Raleway", Font.PLAIN, 18));
        education.setBounds(100, 270, 200, 30);
        add(education);

        String[] educations = {"Non-Graduate", "Graduate", "Post-Graduate", "Doctorate", "Other"};
        educationBox = new JComboBox<>(educations);
        educationBox.setBounds(300, 270, 400, 30);
        add(educationBox);

        // Occupation
        JLabel occupation = new JLabel("Occupation:");
        occupation.setFont(new Font("Raleway", Font.PLAIN, 18));
        occupation.setBounds(100, 320, 150, 30);
        add(occupation);

        String[] occupations = {"Salaried", "Self-Employed", "Business", "Student", "Retired", "Other"};
        occupationBox = new JComboBox<>(occupations);
        occupationBox.setBounds(300, 320, 400, 30);
        add(occupationBox);

        // PAN
        JLabel pan = new JLabel("PAN Number:");
        pan.setFont(new Font("Raleway", Font.PLAIN, 18));
        pan.setBounds(100, 370, 150, 30);
        add(pan);

        panField = new JTextField();
        panField.setBounds(300, 370, 400, 30);
        add(panField);

        // Aadhar
        JLabel aadhar = new JLabel("Aadhar Number:");
        aadhar.setFont(new Font("Raleway", Font.PLAIN, 18));
        aadhar.setBounds(100, 420, 150, 30);
        add(aadhar);

        aadharField = new JTextField();
        aadharField.setBounds(300, 420, 400, 30);
        add(aadharField);

        // Senior Citizen
        JLabel senior = new JLabel("Senior Citizen:");
        senior.setFont(new Font("Raleway", Font.PLAIN, 18));
        senior.setBounds(100, 470, 150, 30);
        add(senior);

        seniorYes = new JRadioButton("Yes");
        seniorYes.setBounds(300, 470, 100, 30);
        seniorYes.setBackground(Color.WHITE);
        add(seniorYes);

        seniorNo = new JRadioButton("No");
        seniorNo.setBounds(450, 470, 100, 30);
        seniorNo.setBackground(Color.WHITE);
        add(seniorNo);

        ButtonGroup seniorGroup = new ButtonGroup();
        seniorGroup.add(seniorYes);
        seniorGroup.add(seniorNo);

        // Existing Account
        JLabel existing = new JLabel("Existing Account:");
        existing.setFont(new Font("Raleway", Font.PLAIN, 18));
        existing.setBounds(100, 520, 150, 30);
        add(existing);

        existingYes = new JRadioButton("Yes");
        existingYes.setBounds(300, 520, 100, 30);
        existingYes.setBackground(Color.WHITE);
        add(existingYes);

        existingNo = new JRadioButton("No");
        existingNo.setBounds(450, 520, 100, 30);
        existingNo.setBackground(Color.WHITE);
        add(existingNo);

        ButtonGroup existingGroup = new ButtonGroup();
        existingGroup.add(existingYes);
        existingGroup.add(existingNo);

        // Next Button
        next = new JButton("Next");
        next.setBounds(620, 600, 80, 30);
        next.addActionListener(this);
        add(next);

        getContentPane().setBackground(Color.WHITE);
        setSize(850, 720);
        setLocation(350, 10);
        setVisible(true);
    }

   
public void actionPerformed(ActionEvent e) {
    String religion = religionBox.getSelectedItem().toString();
    String category = categoryBox.getSelectedItem().toString();
    String income = incomeBox.getSelectedItem().toString();
    String education = educationBox.getSelectedItem().toString();
    String occupation = occupationBox.getSelectedItem().toString();
    String pan = panField.getText();
    String aadhar = aadharField.getText();
    String senior = seniorYes.isSelected() ? "Yes" : "No";
    String existing = existingYes.isSelected() ? "Yes" : "No";

    if (pan.equals("") || aadhar.equals("")) {
        JOptionPane.showMessageDialog(null, "Please fill all required fields");
    } else {
        try {
            Conn c = new Conn();
            String query = "INSERT INTO signuptwo VALUES('" + formNo + "','" + religion + "','" + category + "','" + income + "','" + education + "','" + occupation + "','" + pan + "','" + aadhar + "','" + senior + "','" + existing + "')";
            c.s.executeUpdate(query);
            JOptionPane.showMessageDialog(null, "Page 2 Submitted Successfully");

            // ✅ Redirect to SignupThree with formNo
            setVisible(false);
            new SignupThree(formNo);

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


    // Optional for standalone test
    public static void main(String[] args) {
        new SignupTwo("9999"); // Test form number
    }
}