package com.miniproj;
import java.awt.*;

import java.awt.event.*;
public class AddResult implements ActionListener{

Frame f;
Label l1,l2,l3,l4,l5;
TextField t1,t2,t3,t4,t5;
Button b1,b2;
AddResult()
{
 f=new Frame("Add Result");
 l1=new Label("Enter ID");
 l2=new Label("Enter Name");
 l3=new Label("Enter Subj1 Marks");
 l4=new Label("Enter Subj2 Marks");
 l5=new Label("Enter Subj3 Marks");
 b1=new Button("Submit");
 b2=new Button("Reset");
 
 
 f.setLayout(new FlowLayout());
 f.add(l1);f.add(t1);
 f.add(l2);f.add(t2);
 f.add(l3);f.add(t3);
 f.add(l4);f.add(t4);
 f.add(l5);f.add(t5);
 f.add(b1);f.add(b2);
 b1.addActionListener(this);
 b2.addActionListener(this);
 f.setSize(500,300);
 f.setVisible(true);
 
 
 
}
 public static void main(String[] args) {
  new AddResult();
  
  
  
 }
 @Override
 public void actionPerformed(ActionEvent e) {
  
  if(e.getSource()==b1)
  {
   f.dispose();
   DBConnect d=new DBConnect();
   Integer marks1=Integer.parseInt(t3.getText());
   Integer marks2=Integer.parseInt(t4.getText());
   Integer marks3=Integer.parseInt(t5.getText());
   String query="insert into result_table values('"+t1.getText()+"','"+t2.getText()+"',"+marks1+","+marks2+","+marks3+")";
   System.out.println("Out of Main");
   int i=d.s.executeUpdate(query);
   System.out.println(i);
   AdminPage page=new AdminPage();
  }
  
  else if(e.getSource()==b2)
  {
   f.dispose();
   DBConnect d=new DBConnect();
   
   System.out.println("Out of Main");
   ShowResult show_result=new ShowResult();
  }
  else if(e.getSource()==b3)
  {
   f.dispose();
   System.out.println("Out of Main");
   Register reg=new Register();
  }
 }

}