AddProject_Leader.java

/*
 * Click nbfs://nbhost/SystemFileSystem/Templates/Licenses/license-default.txt to change this license
 * Click nbfs://nbhost/SystemFileSystem/Templates/Classes/Class.java to edit this template
 */
package opensource.contribution.management;


import java.awt.*;
import javax.swing.*;
import com.toedter.calendar.JDateChooser;
import java.util.*;
import java.awt.event.*;
import java.sql.ResultSet;

public class AddProject_Leader extends JFrame implements ActionListener{
    
    Random ran = new Random();
    int number = ran.nextInt(999);
    
    JTextField  tpname,tpdesc, tplead;
    JDateChooser dcdob;
    JComboBox cbeducation;
    JLabel prId;
    JButton add, back;
    Choice Pr_Id;
    
  AddProject_Leader() {
        getContentPane().setBackground(Color.WHITE);
        setLayout(null);
        
        JLabel heading = new JLabel("Add Project Leader Detail");
        heading.setBounds(320, 30, 500, 50);
        heading.setFont(new Font("SAN_SERIF", Font.BOLD, 25));
        add(heading);
        
       
        
        JLabel labelfname = new JLabel("Project Id");
        labelfname.setBounds(50, 150, 150, 30);
        labelfname.setFont(new Font("serif", Font.PLAIN, 20));
        add(labelfname);
        
        //tpname  = new JTextField();
       // tpname.setBounds(200, 150, 150, 30);
       // add(tpname);
        
        Pr_Id = new Choice();
        Pr_Id.setBounds(200, 150, 150, 30);
        
        
        try {
            Conn c = new Conn();
            ResultSet rs = c.s.executeQuery("select * from projects");
            while(rs.next()) {
                Pr_Id.add(rs.getString("Project_Id"));
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
        add(Pr_Id);
        
        
        JLabel labelsalary = new JLabel("Name");
        labelsalary.setBounds(50, 200, 150, 30);
        labelsalary.setFont(new Font("serif", Font.PLAIN, 20));
        add(labelsalary);
        
        tpdesc = new JTextField();
        tpdesc.setBounds(200, 200, 150, 30);
        add(tpdesc);
       
 
        
        JLabel labelempId = new JLabel("Project Leader ID");
        labelempId.setBounds(50, 400, 150, 30);
        labelempId.setFont(new Font("serif", Font.PLAIN, 20));
        add(labelempId);
        
        prId = new JLabel("" + number);
        prId.setBounds(200, 400, 150, 30);
        prId.setFont(new Font("serif", Font.PLAIN, 20));
        add(prId);
        
        add = new JButton("Add Details");
        add.setBounds(250, 550, 150, 40);
        add.addActionListener(this);
        add.setBackground(Color.BLACK);
        add.setForeground(Color.WHITE);
        add(add);
        
        back = new JButton("Back");
        back.setBounds(450, 550, 150, 40);
        back.addActionListener(this);
        back.setBackground(Color.BLACK);
        back.setForeground(Color.WHITE);
        add(back);
        
        setSize(900, 700);
        setLocation(300, 50);
        setVisible(true);
    }
    
    public void actionPerformed(ActionEvent ae) {
        if (ae.getSource() == add) {
            String cid = prId.getText();
            String prid = Pr_Id.getSelectedItem();
            String cname = tpdesc.getText();
            //String crep = tplead.getText();
            //String cdob = ((JTextField) dcdob.getDateEditor().getUiComponent()).getText();
            
           // String phone = tfphone.getText();
           // String email = tfemail.getText();
           // String education = (String) cbeducation.getSelectedItem();
           // String designation = tfdesignation.getText();
           // String aadhar = tfaadhar.getText();
           // String empId = lblempId.getText();
            
            try {
                Conn conn = new Conn();
                String query = "insert into project_leader values('"+cid+"', '"+prid+"',  '"+cname+"')";
                conn.s.executeUpdate(query);
                JOptionPane.showMessageDialog(null, "Details added successfully");
                setVisible(false);
                new  AddProject_Leader().setVisible(true);
            } catch (Exception e) {
                JOptionPane.showMessageDialog(null, "Project_Id is should not assigned to more than 2 Project_Leader");
                e.printStackTrace();
            }
        } else {
            setVisible(false);
                new  ViewProjectLeader().setVisible(true);
        }
    }

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