database.java

The Project Data Base of any organization

exit13.addActionListener(this);


find13 = new JButton("Record");
find13.addActionListener(this);
label13 = new JLabel("Name      ");
label23 = new JLabel("               Registration");

text13 = new JTextField(10);
 
text23 = new JTextField(10);

c3.add(label13);

c3.add(text13);



c3.add(label23);
c3.add(text23);


c3.add(exit13);
c3.add(find13);
ahsanf2.setVisible(true);
}

//find 13                                           find 13  b13

else if( e.getSource() == find13 )
{
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 2ndses where Reg_no = '" + text23.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 );
}

text13.setText("");

text23.setText("");
		stmt.close();
		con.close();
		}
		catch(Exception ie)
		{
			System.out.println(" exception caught " + ie);
		}
}
else if( e.getSource() == b14 )
{


JFrame ahsanf2 = new JFrame("Enter To Delete In 2nd 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());




deltex14 = new JTextField(10);
dellab14 = new JLabel("    Name");
deltex24 = new JTextField(10);


dellab24 = new JLabel("           Registration #");
delete14 = new JButton("Delete");
c3.add(dellab14);
c3.add(deltex14);

c3.add(dellab24);
c3.add(deltex24);



exit14 = new JButton("Exit");
exit14.addActionListener(this);
delete14.addActionListener(this);

c3.add(delete14);
c3.add(exit14);
ahsanf2.setVisible(true);
}

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

}


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

}



else if( e.getSource() == b16 )
{
JFrame ahsanf16 = new JFrame("Enter Record In Final");

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



Container c16 = ahsanf16.getContentPane();
c16.setLayout(new FlowLayout());


label16 = new JLabel("    Name");

c16.add(label16);

text16 = new JTextField(10);
c16.add(text16);



label26 = new JLabel("        Regtration #");

c16.add(label26);

text26 = new JTextField(10);
c16.add(text26);


label36 = new JLabel("        Marks ");

c16.add(label36);
text36 = new JTextField(10);
c16.add(text36);



save16 = new JButton("Save");
c16.add(save16);
save16.addActionListener(this);


exit16 = new JButton("Exit");
c16.add(exit16);

exit16.addActionListener(this);
ahsanf16.setVisible(true);
}

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

JFrame ahsanf2 = new JFrame("select any one");

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());


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


find17 = new JButton("Record");
find17.addActionListener(this);
label17 = new JLabel("Name      ");
label27 = new JLabel("               Registration");

text17 = new JTextField(10);
 
text27 = new JTextField(10);

c3.add(label17);

c3.add(text17);



c3.add(label27);
c3.add(text27);


c3.add(exit17);
c3.add(find17);
ahsanf2.setVisible(true);
System.out.println("insert");

}


//                                                                 find17

else if( e.getSource() == find17 )
{
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 Final where Reg_no = '" + text27.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 );

	}

text17.setText("");

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


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




JFrame ahsanf2 = new JFrame("Enter To Delete In Final");

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());




deltex18 = new JTextField(10);
dellab18 = new JLabel("Name");
deltex28 = new JTextField(10);


dellab28 = new JLabel("            Registration #");
delete18 = new JButton("Delete");
c3.add(dellab18);

c3.add(deltex18);

c3.add(dellab28);
c3.add(deltex28);


exit18 = new JButton("Exit");
exit18.addActionListener(this);
delete18.addActionListener(this);

c3.add(delete18);
c3.add(exit18);
ahsanf2.setVisible(true);
}


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

}


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

}

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

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



JFrame ahsanf2 = new JFrame("Insert Record in Quizes");

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());


label20 = new JLabel("    Name");

c3.add(label20);


text20 = new JTextField(10);
c3.add(text20);


label30 = new JLabel("     Registration #");

c3.add(label30);



text30 = new JTextField(10);
c3.add(text30);

label40 = new JLabel("        Marks  ");

c3.add(label40);

text40 = new JTextField(10);
c3.add(text40);




save20 = new JButton("Save");
c3.add(save20);
save20.addActionListener(this);


exit20 = new JButton("Exit");
c3.add(exit20);

exit20.addActionListener(this);

ahsanf2.setVisible(true);
}
else if( e.getSource() == save20 )
{
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 Quiz");

Statement statement = con.createStatement();
rowadd = statement.executeUpdate("INSERT INTO Quiz VALUES( '"+text20.getText()+"',"+Integer.parseInt(text30.getText())+","+Integer.parseInt(text40.getText())+" )");

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

text20.setText(" ");

text30.setText(" ");
text40.setText(" ");

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

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


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 Assignment");

Statement statement = con.createStatement();
rowadd = statement.executeUpdate("INSERT INTO Assignment VALUES( '"+text24.getText()+"',"+Integer.parseInt(text34.getText())+","+Integer.parseInt(text44.getText())+" )");

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

text24.setText(" ");

text34.setText(" ");
text44.setText(" ");




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


}

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



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());


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


find21 = new JButton("Record");
find21.addActionListener(this);
label211 = new JLabel("Name      ");
label311 = new JLabel("               Registration");

text211 = new JTextField(10);
 
text311 = new JTextField(10);

c3.add(label211);

c3.add(text311);



c3.add(label311);
c3.add(text211);


c3.add(exit21);
c3.add(find21);




ahsanf2.setVisible(true);

}
else if( e.getSource() == find21 )
{
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 Quiz where Reg_no = '" + text211.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 );

}

text311.setText("");

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




else if( e.getSource() == exit21 )

{


System.exit(0);


}


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



JFrame ahsanf2 = new JFrame("Delete 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());

deltex22 = new JTextField(10);
dellab22 = new JLabel("   Name");
deltex32 = new JTextField(10);


dellab32 = new JLabel("            Registration #");
delete22 = new JButton("Delete");
c3.add(dellab22);
c3.add(deltex22);

c3.add(dellab32);
c3.add(deltex32);



exit22 = new JButton("Exit");
exit22.addActionListener(this);
delete22.addActionListener(this);

c3.add(delete22);
c3.add(exit22);
ahsanf2.setVisible(true);
}

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

}

else if( e.getSource() == delete22 )
{
String sql;

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

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

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

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

          stmt.close();
          conn.close();
deltex22.setText(" ");
deltex32.setText(" ");


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


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

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

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

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