NewClientRegistration.java

import java.awt.Image;
import java.io.File;
import java.io.FileInputStream;
import java.io.ByteArrayOutputStream;
import java.io.IOException;
import javax.swing.filechooser.FileNameExtensionFilter;
import java.sql.*;
import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.*;
import javax.swing.border.Border;
import java.awt.BorderLayout;
import java.awt.Font;
import java.awt.Color;
import javax.swing.JOptionPane;
import java.awt.Cursor;
import java.awt.event.*;
import java.awt.event.WindowListener;
import java.awt.event.WindowAdapter;


public class NewClientRegistration extends JFrame implements ActionListener
{
	JPanel p1,panel;
	JLabel l1,l2,l3,l4,l5,l6,l7,l8,l9,l10,l11,l12,l13,l14,l15,l16;
	JTextField t1,t2,t3,t4,t5,t6,t7,t8,t9;
	JPasswordField pass;
	JComboBox<String> gender,Ttype,TID,plan;
	FileInputStream fis;
	String filename = null;
	byte[] person_image = null;
	JFileChooser filechooser;
	JButton b1,b2,b3;
	Border border;
	Connection con;
   
	NewClientRegistration()
	{
		setTitle("New Client Registration");
		MyConnection my = new MyConnection();
	    con = my.Connect();
		setTitle("New Registration");
		p1 = new JPanel();
		p1.setLayout(null);
		p1.setBackground(Color.gray);
		p1.setBounds(0,0,650,50);
		panel = new JPanel();
		panel.setLayout(null);
		panel.setBackground(Color.white);
		panel.setBounds(0,51,650,750);
		l1 = new JLabel("New Client Registration");
		l1.setFont(new Font("arial",Font.BOLD,18));
		l1.setForeground(Color.white);
		l1.setBounds(170,15,220,30);
		l2 = new JLabel("Customer ID:");
		l2.setFont(new Font("arial",Font.BOLD,14));
		l2.setBounds(15,55,145,30);
		t1 = new JTextField();
		t1.setBounds(130,55,200,30);
		l3 = new JLabel("Name:");
		l3.setFont(new Font("arial",Font.BOLD,14));
		l3.setBounds(15,95,145,30);
		t2 = new JTextField();
		t2.setBounds(130,95,200,30);
		l4 = new JLabel("Gender:");
		l4.setFont(new Font("arial",Font.BOLD,14));
		l4.setBounds(15,145,145,30);
		gender = new JComboBox<>();
		gender.addItem("Male");
		gender.addItem("Female");
		gender.setBounds(130,145,200,30);
		l5 = new JLabel("DOB:");
		l5.setFont(new Font("arial",Font.BOLD,14));
		l5.setBounds(15,195,145,30);
		t3 = new JTextField();
		t3.setBounds(130,195,200,30);
		l6 = new JLabel("Mail:");
		l6.setFont(new Font("arial",Font.BOLD,14));
		l6.setBounds(15,245,145,30);
		t4 = new JTextField();
		t4.setBounds(130,245,200,30);
		l7 = new JLabel("Phone No.:");
		l7.setFont(new Font("arial",Font.BOLD,14));
		l7.setBounds(15,295,145,30);
		t5 = new JTextField();
		t5.setBounds(130,295,200,30);
		l8 = new JLabel("Height:");
		l8.setFont(new Font("arial",Font.BOLD,14));
		l8.setBounds(15,345,145,30);
		t6 = new JTextField();
		t6.setBounds(130,345,200,30);
		l9 = new JLabel("Weight:");
		l9.setFont(new Font("arial",Font.BOLD,14));
		l9.setBounds(15,395,145,30);
		t7 = new JTextField();
		t7.setBounds(130,395,200,30);
		l10 = new JLabel("Address:");
		l10.setFont(new Font("arial",Font.BOLD,14));
		l10.setBounds(15,445,145,30);
		t8 = new JTextField();
		t8.setBounds(130,445,200,30);
		l11 = new JLabel("Trainer Type");
		l11.setFont(new Font("arial",Font.BOLD,14));
		l11.setBounds(15,495,145,30);
		Ttype = new JComboBox<>();
		Ttype.addItem("Public");
		Ttype.addItem("Personal");
		Ttype.setBounds(130,495,200,30);
		l12 = new JLabel("Trainern ID:");
		l12.setBounds(15,545,145,30);
		TID = new JComboBox<>();
		TID.setBounds(130,545,200,30);
		l13 = new JLabel("Trainer Name:");
		l13.setBounds(15,595,145,30);
		t9 = new JTextField();
		t9.setBounds(130,595,200,30);
		l14 = new JLabel("Preffered Plan:");
		l14.setBounds(15,645,145,30);
		plan = new JComboBox<>();
		plan.addItem("1-Month");
		plan.addItem("3-Months");
		plan.addItem("5-Months");
		plan.addItem("6-Months");
		plan.addItem("1-Year");
		plan.setBounds(130,645,200,30);
		l15 = new JLabel("Image:");
		l15.setBounds(400,95,145,30);
		l16 = new JLabel();
		l16.setBounds(470,55,141,126);
		b1 = new JButton("Register");
		b1.setBounds(360,245,100,30);
		b1.addActionListener(this);
		b2 = new JButton("Clear");
		b2.setBounds(470,245,80,30);
		b2.addActionListener(this);
		b3 =  new JButton("Browse");
		b3.setBounds(470,195,80,30);
		b3.addActionListener(this);
		add(p1);
		add(panel);
		p1.add(l1);
		panel.add(l2);
		panel.add(t1);
		panel.add(l3);
		panel.add(t2);
		panel.add(l4);
		panel.add(gender);
		panel.add(l5);
		panel.add(t3);
		panel.add(l6);
		panel.add(t4);
		panel.add(l7);
		panel.add(t5);
		panel.add(l8);
		panel.add(t6);
		panel.add(l9);
		panel.add(t7);
		panel.add(l10);
		panel.add(t8);
		panel.add(l11);
		panel.add(Ttype);
		panel.add(l12);
		panel.add(TID);
		panel.add(l13);
		panel.add(t9);
		panel.add(l14);
		panel.add(plan);
		panel.add(l15);
		panel.add(l16);
		panel.add(b1);
		panel.add(b2);
		panel.add(b3);
		setSize(650,800);
		setVisible(true);
		setLayout(null);
		setLocationRelativeTo(null);
		addWindowListener(new WindowAdapter()
		{
			public void windowClosing(WindowEvent e)
			{
				dispose();
			}
		});
		setvalues();
	}
	public void actionPerformed(ActionEvent e)
	{
		if(e.getSource() == b1)
		{
			String id = t1.getText();
			String name = t2.getText();
			String G = gender.getSelectedItem().toString();
			String db = t3.getText();
			String mail = t4.getText();
			String PH = t5.getText();
			String H = t6.getText();
			String W = t7.getText();
			String addr = t8.getText();
			String t = Ttype.getSelectedItem().toString();
			String Tid = TID.getSelectedItem().toString();
			String pp = plan.getSelectedItem().toString();
			PreparedStatement st;
			String query = "INSERT INTO NEWCLIENT (Customer_ID, Name, Gender, DOB, EmailId, Phoneno, Height, Weight, Address, TrainerType, TrainerID, PrefferredPlan, Image) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?)";
			try
			{
				st = con.prepareStatement(query);
				st.setString(1,id);
				st.setString(2,name);
				st.setString(3,G);
				st.setString(4,db);
				st.setString(5,mail);
				st.setString(6,PH);
				st.setString(7,H);
				st.setString(8,W);
				st.setString(9,addr);
				st.setString(10,t);
				st.setString(11,Tid);
				st.setString(12,pp);
				st.setBytes(13,person_image);
				if(st.executeUpdate()>0)
				{
					JOptionPane.showMessageDialog(null,"New Client Added");
					this.dispose();
				}
			}
			catch(SQLException ex)
			{
				Logger.getLogger(NewClientRegistration.class.getName()).log(Level.SEVERE,null,ex);
			}
		}
		if(e.getSource() == b2)
		{
			t1.setText("");
			t2.setText("");
			t3.setText("");
			t4.setText("");
			t5.setText("");
			t6.setText("");
			t7.setText("");
			t8.setText("");
			l16.setIcon(null);
		}
		if(e.getSource() == b3)
		{
			JFileChooser chooser = new JFileChooser();
			chooser.showOpenDialog(null);
			File f = chooser.getSelectedFile();
        
			filename =f.getAbsolutePath();
			ImageIcon imageIcon = new ImageIcon(new ImageIcon(filename).getImage().getScaledInstance(l16.getWidth(), l16.getHeight(), Image.SCALE_SMOOTH));
			l16.setIcon(imageIcon);
			try {

				File image = new File(filename);
				FileInputStream fis = new FileInputStream (image);
				ByteArrayOutputStream bos= new ByteArrayOutputStream();
				byte[] buf = new byte[1024];

				for(int readNum; (readNum=fis.read(buf))!=-1; ){

					bos.write(buf,0,readNum);
				}
				person_image=bos.toByteArray();
			}
			catch(Exception ew){
            JOptionPane.showMessageDialog(null,ew);

			}
			
		}
	}
	public void setvalues()
   {
	   try
	   {
		   PreparedStatement pst;
		   ResultSet rss;
		   String qry = "SELECT TRAINER_ID FROM NEWTRAINER";
		   pst = con.prepareStatement(qry);
		   rss = pst.executeQuery();
		   while(rss.next())
		   {
			   TID.addItem(rss.getString("TRAINER_ID"));
		   }
	   }
	   catch(Exception e)
	   {
		   JOptionPane.showMessageDialog(null,e);
	   }
	   
   }
	
	public static void main(String args[])
	{
		new NewClientRegistration();
	}
}