SignupOne.java

import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import com.toedter.calendar.JDateChooser;
import java.sql.*;
import java.text.SimpleDateFormat;

public class SignupOne extends JFrame implements ActionListener {

    

    JTextField nameField, fnameField, emailField, addressField, cityField, stateField, pinField;
    JDateChooser dateChooser;
    JRadioButton male, female, married, unmarried, other;
    JButton next;

    String formNo;

    SignupOne() {
        setLayout(null);
        setTitle("NEW ACCOUNT APPLICATION - PAGE 1");

        // Generate a random 4-digit form number
        formNo = "" + Math.abs((int)(Math.random() * 9000 + 1000));

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

        JLabel personalDetails = new JLabel("Page 1: Personal Details");
        personalDetails.setFont(new Font("Raleway", Font.BOLD, 22));
        personalDetails.setBounds(290, 70, 400, 30);
        add(personalDetails);

        // Fields...
        JLabel name = new JLabel("Name:");
        name.setFont(new Font("Raleway", Font.PLAIN, 18));
        name.setBounds(100, 120, 100, 30);
        add(name);

        nameField = new JTextField();
        nameField.setBounds(300, 120, 400, 30);
        add(nameField);

        JLabel fname = new JLabel("Father's Name:");
        fname.setFont(new Font("Raleway", Font.PLAIN, 18));
        fname.setBounds(100, 170, 150, 30);
        add(fname);

        fnameField = new JTextField();
        fnameField.setBounds(300, 170, 400, 30);
        add(fnameField);

        JLabel dob = new JLabel("Date of Birth:");
        dob.setFont(new Font("Raleway", Font.PLAIN, 18));
        dob.setBounds(100, 220, 150, 30);
        add(dob);

        dateChooser = new JDateChooser();
        dateChooser.setBounds(300, 220, 400, 30);
        add(dateChooser);

        JLabel gender = new JLabel("Gender:");
        gender.setFont(new Font("Raleway", Font.PLAIN, 18));
        gender.setBounds(100, 270, 100, 30);
        add(gender);

        male = new JRadioButton("Male");
        male.setBounds(300, 270, 100, 30);
        male.setBackground(Color.WHITE);
        add(male);

        female = new JRadioButton("Female");
        female.setBounds(450, 270, 100, 30);
        female.setBackground(Color.WHITE);
        add(female);

        ButtonGroup genderGroup = new ButtonGroup();
        genderGroup.add(male);
        genderGroup.add(female);

        JLabel email = new JLabel("Email Address:");
        email.setFont(new Font("Raleway", Font.PLAIN, 18));
        email.setBounds(100, 320, 150, 30);
        add(email);

        emailField = new JTextField();
        emailField.setBounds(300, 320, 400, 30);
        add(emailField);

        JLabel marital = new JLabel("Marital Status:");
        marital.setFont(new Font("Raleway", Font.PLAIN, 18));
        marital.setBounds(100, 370, 150, 30);
        add(marital);

        married = new JRadioButton("Married");
        married.setBounds(300, 370, 100, 30);
        married.setBackground(Color.WHITE);
        add(married);

        unmarried = new JRadioButton("Unmarried");
        unmarried.setBounds(400, 370, 100, 30);
        unmarried.setBackground(Color.WHITE);
        add(unmarried);

        other = new JRadioButton("Other");
        other.setBounds(500, 370, 100, 30);
        other.setBackground(Color.WHITE);
        add(other);

        ButtonGroup maritalGroup = new ButtonGroup();
        maritalGroup.add(married);
        maritalGroup.add(unmarried);
        maritalGroup.add(other);

        JLabel address = new JLabel("Address:");
        address.setFont(new Font("Raleway", Font.PLAIN, 18));
        address.setBounds(100, 420, 150, 30);
        add(address);

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

        JLabel city = new JLabel("City:");
        city.setFont(new Font("Raleway", Font.PLAIN, 18));
        city.setBounds(100, 470, 150, 30);
        add(city);

        cityField = new JTextField();
        cityField.setBounds(300, 470, 400, 30);
        add(cityField);

        JLabel state = new JLabel("State:");
        state.setFont(new Font("Raleway", Font.PLAIN, 18));
        state.setBounds(100, 520, 150, 30);
        add(state);

        stateField = new JTextField();
        stateField.setBounds(300, 520, 400, 30);
        add(stateField);

        JLabel pin = new JLabel("Pin Code:");
        pin.setFont(new Font("Raleway", Font.PLAIN, 18));
        pin.setBounds(100, 570, 150, 30);
        add(pin);

        pinField = new JTextField();
        pinField.setBounds(300, 570, 400, 30);
        add(pinField);

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

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

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

    @Override
    public void actionPerformed(ActionEvent e) {
        try {
            String name = nameField.getText();
            String fname = fnameField.getText();
            java.util.Date selectedDate = dateChooser.getDate();
String dob = "";
if (selectedDate != null) {
    SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
    dob = sdf.format(selectedDate);
} else {
    JOptionPane.showMessageDialog(null, "Please select Date of Birth");
    return; // Exit early to avoid error
}

            String gender = male.isSelected() ? "Male" : female.isSelected() ? "Female" : "";
            String email = emailField.getText();
            String marital = married.isSelected() ? "Married" : unmarried.isSelected() ? "Unmarried" : other.isSelected() ? "Other" : "";
            String address = addressField.getText();
            String city = cityField.getText();
            String state = stateField.getText();
            String pin = pinField.getText();

            if (name.equals("") || fname.equals("") || dob.equals("") || gender.equals("") || email.equals("") || marital.equals("") || address.equals("") || city.equals("") || state.equals("") || pin.equals("")) {
                JOptionPane.showMessageDialog(null, "Please fill all fields");
            } else {
                Conn c = new Conn();
              String query = "INSERT INTO signup (formno, name, fname, dob, gender, email, marital, address, city, state, pincode) " +
               "VALUES('" + formNo + "','" + name + "','" + fname + "','" + dob + "','" + gender + "','" + email + "','" + marital + "','" + address + "','" + city + "','" + state + "','" + pin + "')";
c.s.executeUpdate(query);


                c.s.executeUpdate(query);
                JOptionPane.showMessageDialog(null, "Form Submitted");
                
                // Proceed to SignupTwo and pass form number
                setVisible(false);
                new SignupTwo(formNo);
            }

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