database.java

The Project Data Base of any organization

Container c3 = ahsanf2.getContentPane();
c3.setLayout(new FlowLayout());
label24 = new JLabel("    Name");

c3.add(label24);


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

label34 = new JLabel("          Regtration #");

c3.add(label34);



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


label44 = new JLabel("         Marks");

c3.add(label44);
text44 = new JTextField(10);
c3.add(text44);



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


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

exit24.addActionListener(this);
ahsanf2.setVisible(true);
}
else if( e.getSource() == b25 )
{
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());


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


find25 = new JButton("Record");
find25.addActionListener(this);
label25 = new JLabel("Name      ");
label35 = new JLabel("               Registration");

text25 = new JTextField(10);
 
text35 = new JTextField(10);

c3.add(label25);

c3.add(text35);



c3.add(label35);
c3.add(text25);


c3.add(exit25);
c3.add(find25);
ahsanf2.setVisible(true);

}


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

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 Assignment where Reg_no = '" + text25.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);
			//System.out.println(" ID=" + id + " , NAME = "+ name);
		
find100.setText( name );
find108.setText( reg );
find128.setText( marks );
}

text35.setText("");

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

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

System.exit(0);

}


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

System.exit(0);

}


else if( e.getSource() == b26 )
{
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());
deltex26 = new JTextField(10);
dellab26 = new JLabel("Name");
deltex36 = new JTextField(10);


dellab36 = new JLabel("           Registration #");
delete26 = new JButton("Delete");
c3.add(dellab26);
c3.add(deltex26);

c3.add(dellab36);
c3.add(deltex36);
exit26 = new JButton("Exit");
exit26.addActionListener(this);
delete26.addActionListener(this);

c3.add(delete26);
c3.add(exit26);
ahsanf2.setVisible(true);
}
else if( e.getSource() == exit26 )
{
System.exit(0);

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

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

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

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

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

          stmt.close();
          conn.close();
deltex26.setText(" ");
deltex36.setText(" ");


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

}

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

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

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

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

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

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

          stmt.close();
          conn.close();
deltex30.setText(" ");
deltex40.setText(" ");


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



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

}



else if( e.getSource() == b28 )
{
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);



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

label28 = new JLabel("       Name");

c3.add(label28);


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

label38 = new JLabel("        Regtration #");

c3.add(label38);



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

label48 = new JLabel("            Marks");

c3.add(label48);
text48 = new JTextField(10);
c3.add(text48);
save28 = new JButton("Save");
c3.add(save28);
save28.addActionListener(this);


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

exit28.addActionListener(this);
ahsanf2.setVisible(true);
}

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

{

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

Statement statement = con.createStatement();
rowadd = statement.executeUpdate("INSERT INTO Attendance VALUES( '"+text28.getText()+"',"+Integer.parseInt(text38.getText())+","+Integer.parseInt(text48.getText())+" )");
		
		stmt.close();
		con.close();

text28.setText(" ");

text38.setText(" ");
text48.setText(" ");
		}
		catch(Exception eabe)
		{
			System.out.println(" exception caught " + eabe);
		}

}

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

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






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


find29 = new JButton("Record");
find29.addActionListener(this);
label29 = new JLabel("Name      ");
label39 = new JLabel("               Registration");

text29 = new JTextField(10);
 
text39 = new JTextField(10);

c3.add(label29);

c3.add(text39);



c3.add(label39);
c3.add(text29);


c3.add(exit29);
c3.add(find29);

ahsanf2.setVisible(true);
}
else if( e.getSource() == find29 )
{


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(5);
label128 = new JLabel("Attendance %");
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 Attendance where Reg_no = '" + text29.getText() + "' ");
Statement statement = con.createStatement();
		while(rs.next())
		{


			marks = rs.getString("Attendance");
			name = rs.getString("NAME");
                         reg = rs.getString("Reg_no");

System.out.println(" Attendance percentage =" + marks + " , NAME = "+ name +   "  ,Reg_no=" + reg);
find100.setText( name );
find108.setText( reg );
find128.setText( marks );

}

text39.setText("");

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

}





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



}


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


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());
deltex30 = new JTextField(10);
dellab30 = new JLabel("    Name");
deltex40 = new JTextField(10);


dellab40 = new JLabel("             Registration #");
delete30 = new JButton("Delete");
c3.add(dellab30);
c3.add(deltex30);

c3.add(dellab40);
c3.add(deltex40);



exit30 = new JButton("Exit");
exit30.addActionListener(this);
delete30.addActionListener(this);

c3.add(delete30);
c3.add(exit30);

ahsanf2.setVisible(true);


}



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

}




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



JFrame ahsanf1 = new JFrame("2nd SESSIONAL");

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



Container c2 = ahsanf1.getContentPane();
c2.setLayout(new GridLayout(4, 9));


b12 = new JButton( "INSERT RECORD" );
c2.add(b12);
b12.addActionListener(this);


b13 = new JButton( "FIND RECORD" );
c2.add(b13);
b13.addActionListener(this);

b14 = new JButton( "DELETE" );
c2.add(b14);
b14.addActionListener(this);


b15 = new JButton( "EXIT" );
c2.add(b15);
b15.addActionListener(this);



ahsanf1.setVisible(true);
}

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


JFrame ahsanf2 = new JFrame("FINAL");

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



Container c3 = ahsanf2.getContentPane();
c3.setLayout(new GridLayout(4,9));


b16 = new JButton( "INSERT RECORD" );
c3.add(b16);
b16.addActionListener(this);


b17 = new JButton( "FIND RECORD" );
c3.add(b17);
b17.addActionListener(this);

b18 = new JButton( "DELETE" );
c3.add(b18);
b18.addActionListener(this);


b19 = new JButton( "EXIT" );
c3.add(b19);
b19.addActionListener(this);



ahsanf2.setVisible(true);
}

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

JFrame ahsanf4 = new JFrame("QUIZES");

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



Container c4 = ahsanf4.getContentPane();
c4.setLayout(new GridLayout(4, 9));


b20 = new JButton( "INSERT RECORD" );
c4.add(b20);
b20.addActionListener(this);


b21 = new JButton( "FIND RECORD" );
c4.add(b21);
b21.addActionListener(this);

b22 = new JButton( "DELETE" );
c4.add(b22);
b22.addActionListener(this);


b23 = new JButton( "EXIT" );
c4.add(b23);
b23.addActionListener(this);
ahsanf4.setVisible(true);
}
 
  else if(e.getSource() == b5)
{





JFrame ahsanf5 = new JFrame("ASSIGNMENT");

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



Container c5 = ahsanf5.getContentPane();
c5.setLayout(new GridLayout(4, 9));


b24 = new JButton( "INSERT RECORD" );
c5.add(b24);
b24.addActionListener(this);


b25 = new JButton( "FIND RECORD" );
c5.add(b25);
b25.addActionListener(this);

b26 = new JButton( "DELETE" );
c5.add(b26);
b26.addActionListener(this);


b27 = new JButton( "EXIT" );
c5.add(b27);
b27.addActionListener(this);



ahsanf5.setVisible(true);

}
else if( e.getSource() == b6)
{
JFrame ahsanf6 = new JFrame("ATTENDANCE");

Toolkit thekit = ahsanf6.getToolkit();
Dimension a6 =thekit.getScreenSize();
ahsanf6.setBounds(a6.width/5,a6.height/5,a6.width/3,a6.height/3);
Container c6 = ahsanf6.getContentPane();
c6.setLayout(new GridLayout(4,9));


b28 = new JButton( "INSERT RECORD" );
c6.add(b28);
b28.addActionListener(this);


b29 = new JButton( "FIND RECORD" );
c6.add(b29);
b29.addActionListener(this);

b30 = new JButton( "DELETE" );
c6.add(b30);
b30.addActionListener(this);


b31 = new JButton( "EXIT" );
c6.add(b31);
b31.addActionListener(this);
ahsanf6.setVisible(true);
}

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

}

public static void main ( String [] args )

{
DataBase ahsan = new DataBase();
ahsan.addWindowListener( new WindowAdapter() {
public void windowClosing( WindowEvent e )
{
System.exit( 0 );
}
}


);  



}

}