import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import javax.swing.border.*;
import java.sql.*;
public class DataBase extends JFrame implements ActionListener

{

 




public JTextField text1,text2;
public JButton b1,b2,b3,b4,b5,b6,b7,b8,b9,b10,b11,b12,b13,b14,b15,b16,b17,b18,b19,b20,b21,b22,b23,b24,b25,b26,b27,b28,b29,b30,b31,save11,exit11,save12,exit12,save16,exit16;
public JLabel label11,label21,label31;
public JTextField text11,text21,text31;

public JLabel label12,label22,label32;
public JTextField text12,text22,text32;
public int flag;
public JLabel label16,label26,label36;
public JTextField text16,text26,text36;

public JTextField text20,text30,text40;
public JLabel label20,label30,label40;
public JButton save20,exit20;

public JTextField text24,text34,text44;
public JLabel label24,label34,label44;
public JButton save24,exit24;

public JTextField text28,text38,text48;
public JLabel label28,label38,label48;
public JButton save28,exit28;


public JButton delete22,exit22;

public JTextField deltex22,deltex32;
public JLabel dellab22,dellab32;




public JButton delete26,exit26;

public JTextField deltex26,deltex36;
public JLabel dellab26,dellab36;

public JButton delete30,exit30;

public JTextField deltex30,deltex40;
public JLabel dellab40,dellab30;




public JButton delete9,exit9;

public JTextField deltex9,deltex19;
public JLabel dellab2,dellab1;




public JTextField text8,text18;
public JLabel label8,label18;
public JButton exit8,find8;



public JTextField text17,text27,text211,text311,text25,text35,text29,text39,deltex14,deltex24,text13,text23;
public JLabel label17,label27,label211,label311,label25,label35,label29,label39,dellab14,dellab24,label13,label23;
public JButton exit17,find17,exit21,find21,exit25,find25,exit29,find29,delete18,exit18,exit13,find13;
public JButton delete14,exit14;
public JTextField deltex18,deltex28;
public JLabel dellab18,dellab28;

public DataBase()

{
super( "DATABASE CONNECTIVITY" );


Container c = getContentPane();
c.setLayout(new GridLayout(4, 10));
b1 = new JButton( "1st SESSIONAL" );

c.add(b1);

b1.addActionListener(this);



b2 = new JButton( "2nd SESSIONAL" );
c.add(b2);
b2.addActionListener(this);

b3 = new JButton( "FINAL" );
c.add(b3);
b3.addActionListener(this);
b4 = new JButton( "QUIZES" );
c.add(b4);
b4.addActionListener(this);
b5 = new JButton( "ASSIGNMENT" );
c.add(b5);
b5.addActionListener(this);
b6 = new JButton( "ATTENDANCE" );
c.add(b6);
b6.addActionListener(this);

b7 = new JButton( "EXIT" );
c.add(b7);
b7.addActionListener(this);


setSize( 325,300 );
show();


}

 public void actionPerformed(ActionEvent e)

{
//String str = ae.getActionCommand();


if( e.getSource() == b1)
{



JFrame ahsanf = new JFrame("1st SESSIONAL");

Toolkit thekit = ahsanf.getToolkit();
Dimension a =thekit.getScreenSize();
ahsanf.setBounds(a.width/5,a.height/5,a.width/3,a.height/3);



Container c1 = ahsanf.getContentPane();
c1.setLayout(new GridLayout(4, 9));


b11 = new JButton( "INSERT RECORD" );
c1.add(b11);
b11.addActionListener(this);


b8 = new JButton( "FIND RECORD" );
c1.add(b8);
b8.addActionListener(this);

b9 = new JButton( "DELETE" );
c1.add(b9);
b9.addActionListener(this);


b10 = new JButton( "EXIT" );
c1.add(b10);
b10.addActionListener(this);



ahsanf.setVisible(true);

}


else if( e.getSource() == b11 )
{


JFrame ahsanf1 = new JFrame("Enter Record In 1st Sessional");

Toolkit thekit = ahsanf1.getToolkit();
Dimension a =thekit.getScreenSize();
ahsanf1.setBounds(a.width/6,a.height/6,a.width/4,a.height/4);



Container c11 = ahsanf1.getContentPane();
c11.setLayout(new FlowLayout());
text11 = new JTextField(10);
label11 = new JLabel("Name");

c11.add(label11);

c11.add(text11);




label21 = new JLabel("            Regtration #");

c11.add(label21);


text21 = new JTextField(10);
c11.add(text21);

label31 = new JLabel("          Marks");

c11.add(label31);


text31 = new JTextField(10);
c11.add(text31);

save11 = new JButton("Save");
c11.add(save11);
save11.addActionListener(this);


exit11 = new JButton("Exit");
c11.add(exit11);

exit11.addActionListener(this);

ahsanf1.setVisible(true);
}



else if( e.getSource() == save11 )
{
int id;
		String name;
int rowadd;
		Connection con;
		Statement stmt;
		try
		{
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		con = DriverManager.getConnection("jdbc:odbc:ahsan");
		stmt = con.createStatement();
		ResultSet rs= stmt.executeQuery(" select * from 1stses");

Statement statement = con.createStatement();
rowadd = statement.executeUpdate("INSERT INTO 1stses VALUES( '"+text11.getText()+"',"+Integer.parseInt(text21.getText())+","+Integer.parseInt(text31.getText())+" )");
		while(rs.next())
		{


		}
		stmt.close();
		con.close();
text11.setText(" ");

text21.setText(" ");
text31.setText(" ");
		



}
		catch(Exception be)
		{
			System.out.println(" exception caught " + be);
		}




}

else if( e.getSource() == exit17 )
{
System.exit(0);

}




else if( e.getSource() == exit11 )
{
System.exit(0);

}

else if( e.getSource() == exit9 )
{
System.exit(0);

}

else if( e.getSource() == save16 )
{



int id;
		String name;
int rowadd;
		Connection con;
		Statement stmt;
		try
		{
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		con = DriverManager.getConnection("jdbc:odbc:ahsan");
		stmt = con.createStatement();
		ResultSet rs= stmt.executeQuery(" select * from Final");

Statement statement = con.createStatement();
rowadd = statement.executeUpdate("INSERT INTO Final VALUES( '"+text16.getText()+"',"+Integer.parseInt(text26.getText())+","+Integer.parseInt(text36.getText())+" )");

		stmt.close();
		con.close();
text36.setText(" ");

text26.setText(" ");
text16.setText(" ");

		}
		catch(Exception be)
		{
			System.out.println(" exception caught " + be);
		}




}

else if( e.getSource() == delete9 )
{


String sql;

       try
       {
          Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
          Connection conn = DriverManager.getConnection( "jdbc:odbc:ahsan" );
          Statement stmt = conn.createStatement();

          sql = "SELECT * FROM 1stses WHERE Reg_no = '" + deltex19.getText() + "'";
          ResultSet rs = stmt.executeQuery(sql);
          rs.next();
          

          sql = "DELETE * FROM 1stses WHERE Reg_no = '" + deltex19.getText() + "'";
          stmt.executeUpdate(sql);

sql = "DELETE * FROM 1stses WHERE Name = '" + deltex9.getText() + "'";
          stmt.executeUpdate(sql);

          stmt.close();
          conn.close();
deltex9.setText(" ");
deltex19.setText(" ");


       }catch(Exception dele)
       {
          System.out.println(dele);
       }

}

else if( e.getSource() == delete14 )
{


String sql;

       try
       {
          Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
          Connection conn = DriverManager.getConnection( "jdbc:odbc:ahsan" );
          Statement stmt = conn.createStatement();

          sql = "SELECT * FROM 2ndses WHERE Reg_no = '" + deltex14.getText() + "'";
          ResultSet rs = stmt.executeQuery(sql);
          rs.next();
          

          sql = "DELETE * FROM 2ndses WHERE Reg_no = '" + deltex24.getText() + "'";
          stmt.executeUpdate(sql);

sql = "DELETE * FROM 2ndses WHERE Name = '" + deltex14.getText() + "'";
          stmt.executeUpdate(sql);

          stmt.close();
          conn.close();
deltex14.setText(" ");
deltex24.setText(" ");


       }catch(Exception dele1)
       {
          System.out.println(dele1);
       }


}


else if( e.getSource() == delete18 )
{


String sql;

       try
       {
          Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
          Connection conn = DriverManager.getConnection( "jdbc:odbc:ahsan" );
          Statement stmt = conn.createStatement();

          sql = "SELECT * FROM Final WHERE Reg_no = '" + deltex18.getText() + "'";
          ResultSet rs = stmt.executeQuery(sql);
          rs.next();
          

          sql = "DELETE * FROM Final WHERE Reg_no = '" + deltex28.getText() + "'";
          stmt.executeUpdate(sql);

sql = "DELETE * FROM Final WHERE Name = '" + deltex18.getText() + "'";
          stmt.executeUpdate(sql);

          stmt.close();
          conn.close();
deltex18.setText(" ");
deltex28.setText(" ");


       }catch(Exception dele2)
       {
          System.out.println(dele2);
       }


}







else if( e.getSource() == exit16 )
{
System.exit(0);

}

else if( e.getSource() == b8 )
{


JFrame ahsanf2 = new JFrame("Find Record ");

Toolkit thekit = ahsanf2.getToolkit();
Dimension a =thekit.getScreenSize();
ahsanf2.setBounds(a.width/6,a.height/6,a.width/4,a.height/4);



Container c3 = ahsanf2.getContentPane();
c3.setLayout(new FlowLayout());


exit8 = new JButton("Exit");
exit8.addActionListener(this);


find8 = new JButton("Record");
find8.addActionListener(this);
label8 = new JLabel("Name      ");
label18 = new JLabel("               Registration");

text8 = new JTextField(10);
 
text18 = new JTextField(10);

c3.add(label8);

c3.add(text8);



c3.add(label18);
c3.add(text18);


c3.add(exit8);
c3.add(find8);




ahsanf2.setVisible(true);



System.out.println("find record");


}
else if( e.getSource() == exit8 )
{

System.exit(0);
}
//find    find   find    find8
else if( e.getSource() == find8 )
{
JFrame ahsanf9 = new JFrame("Required Record ");

Toolkit thekit = ahsanf9.getToolkit();
Dimension a =thekit.getScreenSize();
ahsanf9.setBounds(a.width/7,a.height/7,a.width/5,a.height/5);



Container c0 = ahsanf9.getContentPane();
c0.setLayout(new FlowLayout());
JTextField find100,find108,find128;
find100 = new JTextField(10);
JLabel label100,label108,label128;
label100 = new JLabel("Name");
c0.add(label100);





c0.add(find100);





find108 = new JTextField(10);
label108 = new JLabel("          Reg #");

c0.add(label108);
c0.add(find108);

find128 = new JTextField(10);
label128 = new JLabel("Marks");
c0.add(label128);
c0.add(find128);

ahsanf9.setVisible(true);


		String name,reg,marks;
int rowadd;
		Connection con;
		Statement stmt;
		try
		{
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		con = DriverManager.getConnection("jdbc:odbc:ahsan");
		stmt = con.createStatement();

ResultSet rs = stmt.executeQuery(" select * from 1stses where Reg_no = '" + text18.getText() + "' ");
Statement statement = con.createStatement();
		while(rs.next())
		{
                     marks = rs.getString("Marks");
			
			name = rs.getString("NAME");
                         reg = rs.getString("Reg_no");

System.out.println(" Marks=" + marks + " , NAME = "+ name +   "  ,Reg_no=" + reg);

find100.setText( name );

find108.setText( reg );


find128.setText( marks );


		}

text18.setText("");

text8.setText("");
		stmt.close();
		con.close();
		}
		catch(Exception ie)
		{
			System.out.println(" exception caught " + ie);
		}
}

else if( e.getSource() == b9 )
{
JFrame ahsanf2 = new JFrame("Enter To Delete In 1st Sessional");

Toolkit thekit = ahsanf2.getToolkit();
Dimension a =thekit.getScreenSize();
ahsanf2.setBounds(a.width/6,a.height/6,a.width/4,a.height/4);



Container c3 = ahsanf2.getContentPane();
c3.setLayout(new FlowLayout());


deltex9 = new JTextField(10);
dellab1 = new JLabel("    Name");
deltex19 = new JTextField(10);


dellab2 = new JLabel("                Reg_No");
delete9 = new JButton("Delete");
c3.add(dellab1);
c3.add(deltex9);

c3.add(dellab2);

c3.add(deltex19);



exit9 = new JButton("Exit");
exit9.addActionListener(this);
delete9.addActionListener(this);

c3.add(delete9);
c3.add(exit9);
ahsanf2.setVisible(true);


}



else if( e.getSource() == b10 )
{
System.exit(0);

}



else if( e.getSource() == b12 )
{


JFrame ahsanf12 = new JFrame("To Enter Record in 2nd Sessional");

Toolkit thekit = ahsanf12.getToolkit();
Dimension a =thekit.getScreenSize();
ahsanf12.setBounds(a.width/6,a.height/6,a.width/4,a.height/4);



Container c12 = ahsanf12.getContentPane();
c12.setLayout(new FlowLayout());

label12 = new JLabel("     Name");

c12.add(label12);


text12 = new JTextField(10);
c12.add(text12);

label22 = new JLabel("     Regtration #");

c12.add(label22);



text22 = new JTextField(10);
c12.add(text22);



label32 = new JLabel("         Marks");

c12.add(label32);


text32 = new JTextField(10);
c12.add(text32);



save12 = new JButton("Save");
c12.add(save12);
save12.addActionListener(this);


exit12 = new JButton("Exit");
c12.add(exit12);

exit12.addActionListener(this);



ahsanf12.setVisible(true);

}

else if( e.getSource() == save12 )
{


int id;
		String name;
int rowadd;
		Connection con;
		Statement stmt;
		try
		{
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		con = DriverManager.getConnection("jdbc:odbc:ahsan");
		stmt = con.createStatement();
		ResultSet rs= stmt.executeQuery(" select * from 2ndses");

Statement statement = con.createStatement();
rowadd = statement.executeUpdate("INSERT INTO 2ndses VALUES( '"+text12.getText()+"',"+Integer.parseInt(text22.getText())+","+Integer.parseInt(text32.getText())+" )");

		stmt.close();
		con.close();

text12.setText(" ");

text22.setText(" ");
text32.setText(" ");




		}
		catch(Exception be)
		{
			System.out.println(" exception caught " + be);
		}


}

else if( e.getSource() == exit12 )
{
System.exit(0);
}




else if( e.getSource() == b13 )
{


JFrame ahsanf2 = new JFrame("Record Finding");

Toolkit thekit = ahsanf2.getToolkit();
Dimension a =thekit.getScreenSize();
ahsanf2.setBounds(a.width/6,a.height/6,a.width/4,a.height/4);



Container c3 = ahsanf2.getContentPane();
c3.setLayout(new FlowLayout());


exit13 = new JButton("Exit");