student mgm - JDBC (Java Database Connectivity) Source Code in Java

Special : Web Developer's Collection CD-ROM
50,000+ Web Templates, Logos, Cliparts, Scripts. Order Now!

Add to Favorites Make Home Page

1238 Online

Language Categories

Source Codes Home
Project Ideas New!
Interview Questions
FAQs Home
ASP Home: ASP Source Codes; ASP Script Directory New!; ASP .Net Script Directory New!; ASP Interview Questions; ASP FAQs; ASP How Tos
C Home: C Source Codes; C Script Directory New!; C Interview Questions; C FAQs; C How Tos
C++ Home: C++ Source Codes; C++ Script Directory New!; C++ Interview Questions; C++ FAQs; C++ How Tos
Java Home: Java Source Codes; Java Directory New!; Java Interview Questions; Java FAQs; Java How Tos
JavaScript Home: JavaScript Directory New!; JavaScript Source Codes; JavaScript FAQs; JavaScript How Tos
COBOL Home: COBOL Source Codes; COBOL FAQs; COBOL How Tos
Pascal Home: Pascal Source Codes; Pascal FAQs; Pascal How Tos
PHP Script Directory New!
Python Script Directory New!
Perl & CGI Script Directory New!
Flash Script Directory New!
CFML Script Directory New!
Remotely Hosted Scripts New!
Tools & Utilities Directory New!
XML Script Directory New!
Best Programmers: Amit Mathur; Vishal Bhardwaj; Deepesh Jain
Vyom NetWork

Our Services

Get 9,000 Interview Questions & Answers in an eBook.

9500+ Pages
9000 Question & Answers
All Tech. Categories

14 MB Content

Get it now !!

Home » Java Home » JDBC (Java Database Connectivity) Home » student mgm

A D V E R T I S E M E N T

Title	student mgm
Author	arpan
Author Email	arpankumarsingh [at] yahoo.com
Description	student mgm can be used by the schools or colgs to store there student marks and check there status by there name or roll no; can be updated by adding features like checking progress or downfall in study of a student
Category	Java » JDBC (Java Database Connectivity)
Hits	493091
Code	Select and Copy the Code
import java.io.; import java.applet.; import java.awt.; import java.awt.event.; import java.sql.; public class menu extends Frame implements WindowListener,ActionListener { MenuBar mb; MenuItem student,rollnowise,namewise,allresult; public static menu m; rollnowise rw; namewise n; student st; int x,y,d; public menu() { super("menu ARPAN"); addWindowListener(this); x=y=700; d=10; setSize(x,y); setBackground(Color.orange); addMenu(); show(); } public static void main(String args[]) { m=new menu(); } void addMenu() { MenuBar mb=new MenuBar(); Menu register=new Menu("REGISTER"); Menu inquery=new Menu("INQUERY"); register.add("STUDENT"); register.add("EXIT"); inquery.add("ROLLNOWISE"); inquery.add("NAMEWISE"); mb.add(register); mb.add(inquery); setMenuBar(mb); register.addActionListener(this); inquery.addActionListener(this); } public void actionPerformed(ActionEvent ae) { String arg=ae.getActionCommand(); if(ae.getSource() instanceof Menu) if(arg.equals("EXIT")) { System.exit(0); } if(ae.getSource() instanceof Menu) if("STUDENT".equals(arg)) { st=new student(); st.show(); } if(ae.getSource() instanceof Menu) if("ROLLNOWISE".equals(arg)) { rw=new rollnowise(); rw.show(); } if(ae.getSource() instanceof Menu) if("NAMEWISE".equals(arg)) { n=new namewise(); n.show(); } } 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(); } System.out.println("mail me at [email protected]"); dispose(); System.exit(0); } } //class for name wise report class namewise extends Frame implements WindowListener,ActionListener { public static namewise nw; Label l1=new Label("NAME",Label.LEFT); Label l2=new Label("ROLLNO",Label.LEFT); Label l3=new Label("COLG",Label.LEFT); Label l4=new Label("SUB1",Label.LEFT); Label l5=new Label("SUB2",Label.LEFT); Label l6=new Label("SUB3",Label.LEFT); Label l7=new Label("SUB4",Label.LEFT); Label l8=new Label("SUB5",Label.LEFT); TextField tf_entername=new TextField(20); Button but_entername =new Button("FIND"); Button ok=new Button("OK"); Graphics g; String sqlstr; Statement st; GridLayout gl=new GridLayout(1,2); GridLayout cl=new GridLayout(1,5); Font font18=new Font("VinetaBT",Font.BOLD\|Font.ITALIC,18); int x,y,d; Dialog dlg; Label msg; public namewise() { super("NAMEWISE"); addWindowListener(this); setLayout(new GridLayout(12,1)); setBackground(Color.orange); setForeground(Color.black); addMenu(); x=550; y=450; d=100; setSize(x,y); show(); } void addMenu() { Panel p4=new Panel(); Label l11=new Label("ENTERNAME"); p4.add(l11); p4.add(tf_entername); p4.add(but_entername); add(p4); but_entername.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("NAME NOT FOUND"); dlg.add(msg); dlg.add(ok); } public void actionPerformed(ActionEvent e) { Panel p1=new Panel(); l1.setFont(font18); l2.setFont(font18); p1.setLayout(gl); p1.add(l1); p1.add(l2); g=getGraphics(); g.drawLine(40,0,40,0); Panel p2=new Panel(); l3.setFont(font18); p2.add(l3); p2.setLayout(gl); Panel p3=new Panel(); l4.setFont(font18); l5.setFont(font18); l6.setFont(font18); l7.setFont(font18); l8.setFont(font18); p3.add(l4); p3.add(l5); p3.add(l6); p3.add(l7); p3.add(l8); p3.setLayout(cl); 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 NAME='"+ 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 for rollnowise report class rollnowise extends Frame implements WindowListener,ActionListener { public static rollnowise rw; Label l1=new Label("NAME",Label.LEFT); Label l2=new Label("ROLLNO",Label.LEFT); Label l3=new Label("COLG",Label.LEFT); Label l4=new Label("SUB1",Label.LEFT); Label l5=new Label("SUB2",Label.LEFT); Label l6=new Label("SUB3",Label.LEFT); Label l7=new Label("SUB4",Label.LEFT); Label l8=new Label("SUB5",Label.LEFT); TextField tf_entername=new TextField(20); Button but_entername =new Button("FIND"); String sqlstr; Statement st; GridLayout gl=new GridLayout(1,2); GridLayout cl=new GridLayout(1,5); Font font18=new Font("VinetaBT",Font.BOLD\|Font.ITALIC,18); int x,y,d; public rollnowise() { super("ROLLNOWISE"); addWindowListener(this); setLayout(new GridLayout(12,1)); setBackground(Color.orange); setForeground(Color.black); addMenu(); x=550; y=450; d=100; setSize(x,y); show(); } void addMenu() { Panel p4=new Panel(); Label l11=new Label("ENTERROLLNO"); p4.add(l11); p4.add(tf_entername); p4.add(but_entername); add(p4); but_entername.addActionListener(this); } public void actionPerformed(ActionEvent e) { Panel p1=new Panel(); l1.setFont(font18); l2.setFont(font18); p1.setLayout(gl); p1.add(l1); p1.add(l2); l3.setFont(font18); Panel p2=new Panel(); p2.add(l3); p2.setLayout(gl); Panel p3=new Panel(); l4.setFont(font18); l5.setFont(font18); l6.setFont(font18); l7.setFont(font18); l8.setFont(font18); p3.add(l4); p3.add(l5); p3.add(l6); p3.add(l7); p3.add(l8); 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()+", "+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(); } }

Related Source Codes

Script Name Author

Sending mail Using JavaMail to Yahoo and Gmail accounts sai prasad

Simple Program in Java to Implement Multithreading Satish.K

Simple Calculator in Java Using Remote Method Invocation Satish.K

Guest Book Application Using Servlets Satish.K

String Manipulation Using Stringification Satish.K

String Manipulation Using Stringification Satish.K

Moving Ball Application Using Java Beans Satish.K

Rapid Roll game subrahmanyeswararao

Sourav Datta

Download Manager Sagar

Address Book in Java Rahul Chouhan

address book using java database connectivity(jdbc-msaccess) shekhar bansal

sun Steganography B.Rajavel

Connecting Java with MS-Access - Inserting data in Aseem

Address Book in Java Rahul Chouhan

A D V E R T I S E M E N T

Google Groups Subscribe to SourceCodesWorld - Techies Talk

Email:

Free eBook - Interview Questions: Get over 1,000 Interview Questions in an eBook for free when you join JobsAssist. Just click on the button below to join JobsAssist and you will immediately receive the Free eBook with thousands of Interview Questions in an ebook when you join.

Free Tutorials - HTML, Java, SQL, PHP, ASP, Perl, SQL Tutorials
Discuss Programming Problems and Freshers Jobs related issues here.
Discuss Final Year Project Ideas here.