student_java_db

This is java GUI program for student management application

  p3.setLayout(cl);

/* Panel p4=new Panel();
 Label l11=new Label("ENTERROLLNO");

 p4.add(l11);
 p4.add(tf_entername);
 p4.add(but_entername);
 add(p4);
 add(p1);
 add(p2);
 add(p3);
*/
  String arg=e.getActionCommand();
  if(e.getSource() instanceof Button)
   if("FIND".equals(arg))
   try
    {
     Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
     Connection   
con=DriverManager.getConnection("jdbc:odbc:stu","","");
     sqlstr="select * from  stu1 where ROLLNO="+
tf_entername.getText()+"";
     st=con.createStatement();
     ResultSet rs;
     rs= st.executeQuery(sqlstr);


    while(rs.next())
     {
      Panel a1=new Panel();
      l1=new Label("",Label.LEFT);
      l2=new Label("",Label.LEFT);
        l1.setFont(font18);
         l2.setFont(font18);
       a1.setLayout(gl);

      Panel a2=new Panel();
      l3=new Label("",Label.LEFT);
      l3.setFont(font18);
      a2.setLayout(gl);

      Panel a3=new Panel();
      l4=new Label("",Label.LEFT);
      l5=new Label("",Label.LEFT);
      l6=new Label("",Label.LEFT);
      l7=new Label("",Label.LEFT);
      l8=new Label("",Label.LEFT);
      l4.setFont(font18);

       l5.setFont(font18);

       l6.setFont(font18);

       l7.setFont(font18);

        l8.setFont(font18);
       a3.setLayout(cl);

      l1.setText(rs.getString("NAME"));
      l2.setText(""+rs.getInt("ROLLNO"));
      l3.setText(rs.getString("COLG"));
      l4.setText(""+rs.getInt("SUB1"));
      l5.setText(""+rs.getInt("SUB2"));
      l6.setText(""+rs.getInt("SUB3"));
      l7.setText(""+rs.getInt("SUB4"));
      l8.setText(""+rs.getInt("SUB5"));

     a1.add(l1);
     a1.add(l2);

     a2.add(l3);


     a3.add(l4);
     a3.add(l5);
     a3.add(l6);
     a3.add(l7);
     a3.add(l8);

     add(p1);
     add(a1);

     add(p2);
     add(a2);

     add(p3);
     add(a3);
     show();
     }
   }
   catch(ClassNotFoundException se)
   {

 tf_entername.setText("Error : " + se.toString());
   }

    catch(SQLException se)
    {
    tf_entername.setText("Error : " + se.toString());
    }
 }

public void windowClosed(WindowEvent we){}
public void windowDeiconified(WindowEvent we){}
public void windowIconified(WindowEvent we){}
public void windowActivated(WindowEvent we){}
public void windowDeactivated(WindowEvent we){}
public void windowOpened(WindowEvent we){}

public void windowClosing(WindowEvent we)
 {
  while(x>0 && y>0)
  {
  setSize(x,y);
  x=x-d;
  y=y-d;
  show();
  }
 dispose();

}
}


//class which help in storing records in the database
class student extends Frame implements ActionListener,WindowListener

{
public static student st;
TextField tf_name=new TextField(20);
TextField tf_rollno=new TextField(20);
TextField tf_colg=new TextField(20);
TextField tf_marks=new TextField(20);
TextField tf_sub1=new TextField(4);
TextField tf_sub2=new TextField(4);
TextField tf_sub3=new TextField(4);
TextField tf_sub4=new TextField(4);
TextField tf_sub5=new TextField(4);


Label l2=new Label("ROLLNO");
Label l1=new Label("NAME");
Label l3=new Label("MARKS");
Label l4=new Label("COLG");
Label l5=new Label("MARK SHEET");
Label l6=new Label("SUB1");
Label l7=new Label("SUB2");
Label l8=new Label("SUB3");
Label l9=new Label("SUB4");
Label l10=new Label("SUB5");
Button but_add=new Button("ADD");
Button but_edit=new Button("EDIT");
Button but_find=new Button("FIND");
Button but_delete=new Button("DELETE");
Button but_cancel=new Button("CANCEL");
Button ok=new Button("OK");
Dialog dlg;
Label msg;
int x,y,d;

public student()
{
super("palce");
addWindowListener(this);
setLayout(new GridLayout(6,1));
setBackground(Color.yellow);
setVisible(true);
addmenu();
x=550;
y=450;
d=12;
setSize(x,y);
show();
}


void addmenu()
{
//GridLayout gl=new GridLayout();
Panel p1=new Panel();
p1.add(l1);
p1.add(tf_name);

p1.add(l2);
p1.add(tf_rollno);

Panel p2=new Panel();
p2.add(l5);
Panel p3=new Panel();
p3.add(but_add);
p3.add(but_find);
p3.add(but_cancel);
p3.add(but_edit);
p3.add(but_delete);



Panel p4=new Panel();
//p4.add(l3);
p4.add(l6);
p4.add(l7);
p4.add(l8);
p4.add(l9);
p4.add(l10);

Panel p8=new Panel();
p8.add(tf_sub1);
p8.add(tf_sub2);
p8.add(tf_sub3);
p8.add(tf_sub4);
p8.add(tf_sub5);

Panel p5=new Panel();
p5.add(l4);
p5.add(tf_colg);

add(p2);
add(p1);
add(p5);
add(p4);
add(p8);
add(p3);
but_add.addActionListener(this);
but_cancel.addActionListener(this);
but_find.addActionListener(this);
but_delete.addActionListener(this);
but_edit.addActionListener(this);
 ok.addActionListener(this);
//Dialog for confirmation

	 dlg=new Dialog(this,"Inventory Management System",false);
	 dlg.setLayout(new GridLayout(2,1));
	 dlg.setSize(100,100);
	 dlg.setLocation(200,100);
	 ok.setSize(50,50);
	 msg=new Label("Record Updated");
	 dlg.add(msg);
	 dlg.add(ok);



}
public void actionPerformed(ActionEvent e)
{
String arg=e.getActionCommand();
//ADDBUTTON
if(e.getSource() instanceof Button)
 if("ADD".equals(arg))
  try
  {
  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  Connection con=DriverManager.getConnection("jdbc:odbc:stu","","");
  Statement st;

  String sqlStr;
  sqlStr="insert into
stu1(NAME,ROLLNO,COLG,SUB1,SUB2,SUB3,SUB4,SUB5)values('"+tf_name.getText()
+"',"+tf_rollno.getText()+",'"+tf_colg.getText()+"',"+tf_sub1.getText()+",<BR>+tf_sub2.getText()+","+tf_sub3.getText()+","+tf_sub4.getText()+","+tf_sub
5.getText()+")";
  st=con.createStatement();
  st.executeUpdate(sqlStr);
 }
 catch(ClassNotFoundException se)
 {
   // tf_name.setText("Error : " + se.toString());
     msg.setText("ERROR");
   dlg.show();
 }
 catch(SQLException se)
 {
  //  tf_name.setText("Error : " + se.toString());
  msg.setText("ENTER TEXTFIELD");
   dlg.show();
}

//OK button

	if ( e.getSource() instanceof Button)
        if ("OK".equals(arg))
        { dlg.dispose();
        }
 //CANCEL
  if(e.getSource() instanceof Button)
   if("CANCEL".equals(arg))

    {
    tf_name.setText("");
    tf_rollno.setText("");
    tf_colg.setText("");
    tf_sub1.setText("");
    tf_sub2.setText("");
    tf_sub3.setText("");
    tf_sub4.setText("");
     tf_sub5.setText("");
     }
  //FIND
   if(e.getSource() instanceof Button)
    if("FIND".equals(arg))
     try
      {
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  Connection con=DriverManager.getConnection("jdbc:odbc:stu","","");
  Statement st;
  String sqlstr;
  sqlstr="select * from stu1 where ROLLNO ="+tf_rollno.getText()+"";
  st=con.createStatement();
  ResultSet rs;
  rs=st.executeQuery(sqlstr);
  rs.next();
  tf_name.setText(""+rs.getString("NAME"));
  tf_colg.setText(""+rs.getString("COLG"));
  tf_sub1.setText(""+rs.getInt("SUB1"));
  tf_sub2.setText(""+rs.getInt("SUB2"));
  tf_sub3.setText(""+rs.getInt("SUB3"));
  tf_sub4.setText(""+rs.getInt("SUB4"));
  tf_sub5.setText(""+rs.getInt("SUB5"));
  }
 catch(ClassNotFoundException se)
 {
  msg.setText("RECORD NOT FOUND");
   dlg.show();

//  tf_name.setText("Error : " + se.toString());
 }
 catch(SQLException se)
 {
  msg.setText("RECORD NOT FOUND");
   dlg.show();
  //tf_name.setText("Error : " + se.toString());
 }
 //DELETE
 if(e.getSource() instanceof Button)
  if("DELETE".equals(arg))
  try
   {
         Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  Connection con=DriverManager.getConnection("jdbc:odbc:stu","","");
   Statement st;
   String sqlstr;
  sqlstr="delete * from stu1 where ROLLNO="+tf_rollno.getText()+"";
   st=con.createStatement();
   st.executeUpdate(sqlstr);
   tf_name.setText("");
   tf_colg.setText("");
   tf_sub1.setText("");
   tf_sub2.setText("");
   tf_sub3.setText("");
   tf_sub4.setText("");
   tf_sub5.setText("");

   tf_rollno.setText("");
   msg.setText("RECORD DELETED");
   dlg.show();

 }
  catch(ClassNotFoundException se)
 {
    tf_name.setText("Error : " + se.toString());
 }
 catch(SQLException se)
 {
    tf_name.setText("Error : " + se.toString());
 }

//EDIT
if(e.getSource() instanceof Button)
 if("EDIT".equals(arg))
  try
   {
  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  Connection con=DriverManager.getConnection("jdbc:odbc:stu","","");
   Statement st;
   String sqlstr;
   sqlstr="update stu1 set
NAME='"+tf_name.getText()+"',SUB1="+tf_sub1.getText()+",SUB2="+tf_sub2.get
Text()+",SUB3="+tf_sub3.getText()+",SUB4="+tf_sub4.getText()+",SUB5="+tf_s
ub5.getText()+",COLG='"+tf_colg.getText()+"' where
ROLLNO="+tf_rollno.getText();
st=con.createStatement();
st.executeUpdate(sqlstr);
   msg.setText("RECORD UPDATED");
   dlg.show();
  }
 catch(ClassNotFoundException se)
 {

  tf_name.setText("Error : " + se.toString());
 }
 catch(SQLException se)
 {

  tf_name.setText("Error : " + se.toString());
 }
   }
public void windowClosed(WindowEvent we){}
public void windowDeiconified(WindowEvent we){}
public void windowIconified(WindowEvent we){}
public void windowActivated(WindowEvent we){}
public void windowDeactivated(WindowEvent we){}
public void windowOpened(WindowEvent we){}
public void windowClosing(WindowEvent we)
 {
  while(x>0 && y>0)
  {
  setSize(x,y);
  x=x-d;
  y=y-d;
  show();
  }
 dispose();
 }

}