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

// INSERT NEW RECORD


public class inswing implements ActionListener
{
	JFrame fr;
	JPanel po;

	JLabel l1,l2,l4,l11,main;
	JTextField tf1,tf2;

	JComboBox S1,gender;
	GridBagConstraints gbc;
	GridBagLayout go;
	JButton ok,exit;



public inswing()
{
fr=new JFrame("New Record Entry");
Font f=new Font("Verdana",Font.BOLD,24);

//fr=new JFrame();
po=new JPanel();
fr.getContentPane().add(po);
fr.setVisible(true);
fr.setSize(1024,768);

fr.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);


po.setBackground(Color.orange);
go=new GridBagLayout();
gbc=new GridBagConstraints();
po.setLayout(go);


main=new JLabel("		 NEW RECORD ENTRY	              		");
main.setFont(f);




l1=new JLabel("Student ID :");
tf1=new JTextField(6);

l2=new JLabel("Student Name  :");
tf2=new JTextField(20);

l4=new JLabel("Gender :");
String str1[]={"Male","Female"};
gender=new JComboBox(str1);


l11=new JLabel("Branch  :");
String str[]={"Computer Science","Electrical","Electrical & Electronics","Information Technology","Mechanical"};
S1=new JComboBox(str);

ok=new JButton("Accept");

exit=new JButton("Exit");

S1.addActionListener(this);


gender.addActionListener(this);


/////////////////////////////////////////

gbc.anchor=GridBagConstraints.WEST;
gbc.gridx=0;
gbc.gridy=0;
go.setConstraints(l1,gbc);
po.add(main);


//a

gbc.anchor=GridBagConstraints.WEST;
gbc.gridx=5;
gbc.gridy=5;
go.setConstraints(l1,gbc);
po.add(l1);


gbc.anchor=GridBagConstraints.WEST;
gbc.gridx=10;
gbc.gridy=5;
go.setConstraints(tf1,gbc);
po.add(tf1);


//b


gbc.anchor=GridBagConstraints.WEST;
gbc.gridx=5;
gbc.gridy=10;
go.setConstraints(l2,gbc);
po.add(l2);


gbc.anchor=GridBagConstraints.WEST;
gbc.gridx=10;
gbc.gridy=10;
go.setConstraints(tf2,gbc);
po.add(tf2);



//d

gbc.anchor=GridBagConstraints.WEST;
gbc.gridx=5;
gbc.gridy=20;
go.setConstraints(l4,gbc);
po.add(l4);


gbc.anchor=GridBagConstraints.WEST;
gbc.gridx=10;
gbc.gridy=20;
go.setConstraints(gender,gbc);
po.add(gender);

//i

gbc.anchor=GridBagConstraints.WEST;
gbc.gridx=5;
gbc.gridy=60;
go.setConstraints(l11,gbc);
po.add(l11);


gbc.anchor=GridBagConstraints.WEST;
gbc.gridx=10;
gbc.gridy=60;
go.setConstraints(S1,gbc);
po.add(S1);


//m

gbc.anchor=GridBagConstraints.WEST;
gbc.gridx=10;
gbc.gridy=90;
go.setConstraints(ok,gbc);
po.add(ok);


ok.addActionListener(this);

//n

gbc.anchor=GridBagConstraints.WEST;
gbc.gridx=11;
gbc.gridy=90;
go.setConstraints(exit,gbc);
po.add(exit);


exit.addActionListener(this);

}


public void actionPerformed(ActionEvent ev)
{

if(ev.getSource()==ok)
{

try
{
Connection con;
JLabel last =new JLabel("Data inserted successfully");
Class.forName("com.mysql.jdbc.Driver");
con=DriverManager.getConnection("jdbc:mysql://192.168.10.13:3306/ankdb","root","root");
 
PreparedStatement ps=con.prepareStatement("Insert into studentrecord values(?,?,?,?)");

String id=tf1.getText();
String sname=tf2.getText();


String br=S1.getSelectedItem().toString();
String gen=gender.getSelectedItem().toString();


ps.setString(1,id);
ps.setString(2,sname);

ps.setString(3,gen);
ps.setString(4,br);


ps.executeUpdate();
con.close();


tf1.setText("");
tf2.setText("");

}
	catch(Exception e)
	{

	System.out.println("ERROR  "+e);

	}

}

if(ev.getSource() == exit)
	{
	
	fr.dispose();
	
	}
}


	public static void main(String a[])
	{
	new inswing();

	}



}