School System File

INFORMATICS
PRACTICES
A PROJECT ON
“SCHOOL SYSTEM”
Senior Secondary Examination (AISSCE – 2018-19)
Submitted By: Submitted To:
Sarthak Saurabh sir
(Roll No: _______) (Informatics Practices Teacher)

0
CERTIFICATE .
This is to certify that the project titled “SCHOOL
SYSTEM” submitted by Miss/Master
Sarthak having roll no ________ of CLASS XII
has completed this project for partial rollback in full -
fillment of the requirement for thesenior secondary
examination (AISSCE)embodies the bonafide work
done by him/her under my supervision.
Internal Supervisor External Supervisor

Signature Signature
Name : Saurabh Sir Name :
Date : Date :
ID – SHEET
Roll No : ………………………….
Name of Student : Sarthak
Address : Anisabad,
Patna
Phone No : 7979007905
Email Address : [email protected]
Supervisor : Saurabh Sir
Project Title : School System
Front End Tool : JAVA NetBeans
Back End Tool : MySQL

ACKNOWLEDGEMENT
It would be our outmost pleasure to express

our sincere thanks to our Informatics Practices
Teacher “Saurabh Sir”in providing a helping
hand in this project.
His unflagging patience, creativity and

immense knowledge that he shared with us
have proved highly beneficial to us and have
made our Project possible and successful.
Sarthak
TABLE OF CONTENTS
 Introduction
 Java Details
 Priliminary Design
 Form Layouts
 Database Design
 Implementation
 Bibliography
 Teacher Remarks
INTRODUCTION
This program is designed for the use
of SchoolManagement Systemand its
functioning Main Objective of this
project to facilitate the transactions
through use of electronic medium.
We use java netbeans 6.5 software
and Mysql to programming our
project.
What is java?
Java is a general purpose object oriented programming language . It is the first programming
language that is not tied to any particular hardware or operating system .The language is
based on the concept of an object. Java is highly derived from C++ . Most striking feature of
the language is that it is platform neutral language.
There were five primary goals in the creation of the Java language:
• It should use the object-oriented programming methodology.

• It should allow the same program to be executed on multiple operating systems.
• It should contain built-in support for using computer networks.
• It should be designed to execute code from remote sources securely.
• It should be easy to use and borrow the good parts of older object-oriented languages like
C++.
Java tools
In order to write java application or applets ,one need more than a language . The tools that
lets one to write , test , debug programs.
Java features
● Compiler and Interpreted
● Platform independent
● Simple
● Secure
● Familiar
● Portable
● Object-Oriented
● Robust
● Multithreaded
● High performance
● Distributed
● Dynamic
Compiler and Interpreted -There is a java compiler , named javac . The java compiler
takes input source code files (these files typically have the ext.java) and converts them into
compiled bytecode files.The java Interpreter known as javac can be used to execute java
application .The interpreter translates bytecode directly into program actions.
Platform independent- Java programs can be easily moved from one computer to
another, anywhere and anytime.Changes and upgradesmade in operatingsystems,
processors and system resources will not force any changes in java programs.
Simple - Java is designed to be easy for programmer to learn and use efficiently.
Secure- When we use a java compatible web browser, we can safely download java applets
without fear of virus infection. Java achieves this protection by confining a java program to
java execution environment and not allowing it access to other parts of the computer.
Familiar- It is modeled on C, C++ languages. Java code looks like C++.
Portable- Java compiler generates bytecode instructions that can be implemented on any
machine and also the size of the primitive data types are machine independent.
Object-Oriented - Java is a true object-oriented language. All program code and data
reside within objects and classes.
Robust -It provides many safeguards to ensure reliable code. It has strict compile time and
run time checking for data types. Designed as a garbage-collected language relieving the
programmers and also incorpates the concept of exception handling which captures series
errors.
Multithreaded - Java supports handling multiple tasks simultaneously which greatly

improves the interactive performance of graphical applications.
High performance- Java performance is impressive for an interpreted language , mainly

due to use of immediate bytecode . Use of multithreaded and further its architecture is also
designed to reduce overheads during runtime.
Distributed- It has ability to share both data and programs. Java applications can open and
access remote objects on internet which enables multiple programmers at multiple remote
locations to collaborate and work together on single project.
Dynamic - Java is capable of dynamically in new class libraries , methods and objects .It
supports functions written in other languages like C,C++ called as native methods.
Automatic garbage collection -One idea behind Java's automatic memory management
model is that programmers should be spared the burden of having to perform manual
memory management. In some languages the programmer allocates memory to create any
object stored on the heap and is responsible for later manually deallocating that memory to
delete any such objects. If a programmer forgets to de-allocate memory or writes code that
fails to do so in a timely fashion, a memory leak can occur: the program will consume a
potentially arbitrarily large amount of memory. In addition, if a region of memory is de-
allocated twice, the program can become unstable and may crash.
In Java, this potential problem is avoided by automatic garbage collection. The programmer
determines when objects are created and the Java runtime is responsible for managing the
objects' lifecycle. The program or other objects can reference an object by holding a
reference to it (which, from a low-level point of view, is its address on the heap). When no
references to an object remain, the Java garbage collector automatically deletes the
unreachable object, freeing memory and preventing a memory leak. Memory leaks may still
occur if a programmer's code holds a reference to an object that is no longer needed—in
other words, they can still occur but at higher conceptual levels.
Comparing Java and C++, it is possible in C++ to implement similar functionality (for
example, a memory management model for specific classes can be designed in C++ to
improve speed and lower memory fragmentation considerably), with the possibly cost of
extra development time and some application complexity. In Java, garbage collection is built
in and virtually invisible to the developer. That is, developers may have no notion of when
garbage collection will take place as it may not necessarily correlate with any actions being
explicitly performed by the code they write. Depending on intended application, this can be
beneficial or disadvantageous: the programmer is freed from performing low-level tasks but
at the same time lose the option of writing lower level code.
Java Magic: The Bytecode
Bytecode is a highly optimized set of instruction designed to be executed by the java

runtime system, which is called Java Virtual Machine and it exists only inside the computer
memory.
Java Program Java Compiler Virtual Machine
Source code Bytecode

Process of Compilation
Bytecode Java Interpreter Machine code

Virtual Machine Real Machine
Process of converting Bytecode into Machine code
Object Oriented Programming
Object Oriented Programming is an approach that provides a way of modularizing programs

by creating partitioned memory area for both data and functions that can be used as
templates for creating copies of such modules on demand.
Objects and Classes -An object is a software bundle of variables and related methods.
Objects are key to understanding object-oriented technology. Real-world objects share two
characteristics: They all have state and behavior.
Software objects are modeled after real-world objects in that they too have state and
behaviorClasses can also define class variables. A class variable contains information that is
shared by all instances of the class .A class can also declare class methods. You can invoke a
class method directly from the class, whereas you must invoke instance methods on a
particular instance.
Encapsulation - Wrapping of data and methods into a single unit is known as

encapsulation. It is the most striking feature of class. The data is not accessible to outside
world and only those methods which are wrapped in the class can access it. The insulation
of the data from direct access by the program is called data hiding.
Inheritance - Inheritance is the process by which objects of one class acquire the property
of objects of another class. Each subclass inherits state .However, subclasses are not limited
to the states and behaviors provided to them by their superclass. Subclasses can add
variables and methods to the ones they inherit from the superclass. It supports the concept
of hierarchical classification it also provides the use of reusability. .
Polymorphism - This means the ability to take more than one form. An operation may
exhibit different behaviour in different instances. The behaviour depends upon the types of
data used in the operation. It plays an important role in allowing objects having different
internal structures to share external interface.
Java SE - Java Database Connectivity (JDBC)
The Java Database Connectivity (JDBC) API is the industry standard for database-
independent connectivity between the Java programming language and a wide range of
databases – SQL databases and other tabular data sources, such as spreadsheets or flat files.
The JDBC API provides a call-level API for SQL-based database access.
JDBC technology allows you to use the Java programming language to exploit "Write Once,
Run Anywhere" capabilities for applications that require access to enterprise data. With a
JDBC technology-enabled driver, you can connect all corporate data even in a
heterogeneous environment.
Advantages of JDBC Technology :
Leverage Existing Enterprise Data
Simplified Enterprise Development
Zero Configuration for Network Computers
Driver Loads database drivers and manages the

manager connections between the application and the
driver
Driver Translates API calls into operations for a
specific data source
Connection A session between an application and a
database
Statement A SQL statement to perform a query or update
operation
Metadata Information about returned data , database
and driver
Resultset Logical set of columns and rows of data
returned by executing a statement
Driver Manager Connection Statement ResultSet
Driver
Database
Database
The JDBC architecture is based on a collection of java interfaces and classes that together enable you
to connect to data sources , to create and execute SQL statements and to retrieve and modify data in
a database.
The JDBC-ODBC Bridge –“sun.jdbc.odbc.jdbcodbcDriver”-is included with JDK and it enables Java
applications to access data through drivers written to the ODBC standard. The driver bridge is useful
for accessing data in data sources for which no pure JDBC drivers exist. The bridge works by
translating the JDBC methods into ODBC function calls.
SQL-STRUCTURED QUERY LANGUAGE

SQL is not a procedural language. It is not used to define complex processes; we can use
SQL to use commands that define and manipulate data. SQL is different from other
languages.
• SQL is very readable.
• In SQL we always issue commands.
SQL statements fall into two groups:-
● Data Defination Language (DDL) – DDL statements are used to describe the tables
and the data they contain. The subset of SQL statements used for modeling the structure
(rather than the contents) of a database or cube. The DDL gives you the ability to create,
modify, and remove databases and database objects.
● Data Manipulation Language (DML) – DML statements that are used to operate on
data in the database. These are statements that allow you to create or alter objects (such as
tables, indexes, views, and so on) in the database. The subset of SQL statements used to
retrieve and manipulate data. DML can be further divided into 2 groups:-
● Select Statements – Statements that return a set of results.
● Everything else – Statements that don’t return a set of results.
Here are some of the quries defined:-
SELECT - SQL statement used to request a selection, projection, join, query, and so on,
from a SQL Server database.
Primary key – Primary key constraints identify the column or set of columns whose values
uniquely identify a row in a table. No two rows in a table can have the same primary key
value. You cannot enter a NULL value for any column in a primary key.
Insert- The Insert logical operator inserts each row from its input into the object specified
in the Argument column. To insert the data into a relation we either specify a tuple to be
inserted or write a query.
Delete- The Delete logical operator deletes from an object rows that satisfy the optional
predicate in the Argument column. We can delete only whole tuples; we cannot delete
values on only particular attributes.
Update- The Update logical operator updates each row from its input in the object
specified in the Argument column. It provides a way of modifying existing data in a table.
SWING
SWING is a set of classes that provides powerful and flexible functionality. In addition with
several components provided by AWT, swing supplies several exciting additions, including
tabbed panes, scroll panes, trees and tables. It also changes the images as the state of any
component changes. Swing is built upon the foundation of the AWT. Swing components are
written entirely in Java and therefore are Platform-independent .Swing is also termed also
light-weight and provide pluggable look and feel.
There are 2 Swing classes that are quite important:
Jframe and Component – Jframe extends the AWT class Frame. It contains additional
features that enable it to support Swing components. JComponent extends the AWT
component and Container classes. It is the top level class for all Swing components and
provides Swing pluggable look and feel.
Here are some of the Swing component classes:
CLASS DESCRIPTION
Abstract Button Abstract super class for Swing buttons.
Button Group Encapsulates a mutually exclusive set of
buttons.
Image Icon Encapsulates an icon.
JApplet The SWING version of APPLET.
JButton The SWING push button class.
JCheckBox The SWING check box class.
JComboBox Encapsulates a combo box .
JLabels The SWING version of a label.
JRadioButton The SWING version of a radio button.
JScrollPane Encapsulates a scrollable window.
JTabbedPane Encapsulates a tabbed window.
JTextField The SWING version of Text field.
JTree Encapsulates a tree based-control.
Here are the some of the components used:
● JApplet– Applet that use SWING must be subclass of JApplet.

JApplet is rich with functionality that is not found in Applet.
● Icons – Icons are encapsulated by the Image Icon class, which paints an icon from an
image.
● JLabel – Labels are the instances of the JLabel class which extends JComponent. It can
display text or icon. These are passive controls that do not support any interaction with the
user.
● JTextFields – Text field is encapsulated by the JTextComponent class which extends

JComponent. JTextField allows you to edit one line of text.
● JButton – JButton class provides the functionality of a push button. JButton allows an
icon of string to be associated with the push button.
● JCheckBox – It is supported by the JCheckBox class. It is a control that is used to turn an

option on or off.
● JTextArea - Text area is encapsulated by the JTextComponent class which extends

JComponent. JTextArea allows you to edit multiline of text.
● JRadioButton – it is supported by the JRadioButton class. It can be configured into a

group of check boxes in which only one check box can be checked at any one time.
● JComboBox– It is provided through the JComboBox class. It normally displays one entry
and can also display a drop down list that allows a user to select a different entry.
● JScrollPane– It is a component that presents a rectangular area in which a component
may be viewed. These are implemented in Swing by JScrollPane class.
● JTree - It is a component that presents a hierarchical view of data. A user has ability to
expand individual subtrees. These are implemented in Swing by JTree class.
ADVANTAGES OF (JAVAX) SWING:
1. It provides more powerful and more flexible components possible in AWT package.
For e.g. JButton can have both image as well as text field associated with it which is
not possible in awt package.
2. Unlike AWT components SWING components are not implemented by platform-

specific code. Instead they are written entirely in java and therefore are platform
independent. Thus term lightweight is used to describe such elements.
3. Further the Swing components can provide pluggable look and feel, which means
that it is easy to substitute another appearance and behavior for an element.
PRELIMINARY
DESIGN
(User Interface)
FORM LAYOUTS
DATABASE
DESIGN
IMPLEMENTATION
LOGIN
setBounds(new java.awt.Rectangle(80, 60, 0,
0));
package Student; setCursor(new
import java.sql.*; java.awt.Cursor(java.awt.Cursor.DEFAULT_CURSO
import javax.swing.JOptionPane; R));
public class login extends javax.swing.JFrame { org.jdesktop.beansbinding.Binding binding =

Connection con; org.jdesktop.beansbinding.Bindings.createAutoBin
Statement stmt,smt1; ding(org.jdesktop.beansbinding.AutoBinding.Upda
ResultSet rs; teStrategy.READ, this,
java.util.Date dt1; org.jdesktop.beansbinding.ELProperty.create("Sch
ool Management System || www.ezindagi.in ||"),
public login() { this,
initComponents(); org.jdesktop.beansbinding.BeanProperty.create("ti
try tle"));
{ bindingGroup.addBinding(binding);
Class .forName("com.mysql.jdbc.Driver");
con = jLabel3.setFont(new java.awt.Font("Tahoma",
DriverManager.getConnection("jdbc:mysql://local 1, 18));
host:3306/studentsystem","root","root"); jLabel3.setForeground(new java.awt.Color(51,
} 0, 0));
catch(Exception e) jLabel3.setText("Password");
{
System.out.println(e.getMessage()); jLabel2.setFont(new java.awt.Font("Tahoma",
} 1, 18));
} jLabel2.setForeground(new java.awt.Color(51,
0, 0));
@SuppressWarnings("unchecked") jLabel2.setText("User Id");
// <editor-fold defaultstate="collapsed"
desc="Generated Code"> jPasswordField1.setFont(new
private void initComponents() { java.awt.Font("Tahoma", 1, 14));
bindingGroup = new jPasswordField1.setForeground(new
org.jdesktop.beansbinding.BindingGroup(); java.awt.Color(102, 0, 0));
jLabel3 = new javax.swing.JLabel(); jTextField1.setFont(new

jLabel2 = new javax.swing.JLabel(); java.awt.Font("Tahoma", 1, 12));
jPasswordField1 = new jTextField1.setForeground(new
javax.swing.JPasswordField(); java.awt.Color(102, 0, 0));
jTextField1 = new javax.swing.JTextField();
jButton1 = new javax.swing.JButton(); jButton1.setBackground(new
jLabel4 = new javax.swing.JLabel(); java.awt.Color(204, 204, 255));
jButton1.setFont(new
java.awt.Font("Tahoma", 1, 18)); // NOI18N
setDefaultCloseOperation(javax.swing.WindowCon jButton1.setForeground(new
stants.EXIT_ON_CLOSE); java.awt.Color(51, 0, 0));
setBackground(new java.awt.Color(255, 255, jButton1.setText("Login");
255));
jButton1.addActionListener(new
java.awt.event.ActionListener() { .addContainerGap(javax.swing.GroupLayout.DEFA
public void ULT_SIZE, Short.MAX_VALUE))
actionPerformed(java.awt.event.ActionEvent evt) { );
jButton1ActionPerformed(evt); layout.setVerticalGroup(
}
}); layout.createParallelGroup(javax.swing.GroupLayo
ut.Alignment.LEADING)
jLabel4.setFont(new java.awt.Font("Tahoma", .addGroup(layout.createSequentialGroup()
3, 36)); .addGap(40, 40, 40)
jLabel4.setForeground(new .addComponent(jLabel4)
java.awt.Color(102, 102, 255)); .addGap(35, 35, 35)
jLabel4.setText(" School Management
System"); .addGroup(layout.createParallelGroup(javax.swing
.GroupLayout.Alignment.TRAILING)
javax.swing.GroupLayout layout = new .addComponent(jLabel2)
javax.swing.GroupLayout(getContentPane()); .addComponent(jTextField1,
getContentPane().setLayout(layout); javax.swing.GroupLayout.PREFERRED_SIZE, 24,
layout.setHorizontalGroup( javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(39, 39, 39)
layout.createParallelGroup(javax.swing.GroupLayo
ut.Alignment.LEADING) .addGroup(layout.createParallelGroup(javax.swing
.addGroup(layout.createSequentialGroup() .GroupLayout.Alignment.TRAILING)
.addContainerGap(144, .addComponent(jLabel3)
Short.MAX_VALUE) .addComponent(jPasswordField1,
javax.swing.GroupLayout.PREFERRED_SIZE, 24,
.addGroup(layout.createParallelGroup(javax.swing javax.swing.GroupLayout.PREFERRED_SIZE))
.GroupLayout.Alignment.LEADING)
.addComponent(jLabel3) .addPreferredGap(javax.swing.LayoutStyle.Compo
.addComponent(jLabel2, nentPlacement.RELATED, 38, Short.MAX_VALUE)
javax.swing.GroupLayout.PREFERRED_SIZE, 146, .addComponent(jButton1,
javax.swing.GroupLayout.PREFERRED_SIZE)) javax.swing.GroupLayout.PREFERRED_SIZE, 53,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.Compo .addGap(32, 32, 32))
nentPlacement.RELATED) );
.addGroup(layout.createParallelGroup(javax.swing bindingGroup.bind();
.GroupLayout.Alignment.LEADING, false)
.addComponent(jPasswordField1) java.awt.Dimension screenSize =
.addComponent(jTextField1, java.awt.Toolkit.getDefaultToolkit().getScreenSize(
javax.swing.GroupLayout.PREFERRED_SIZE, 180, );
javax.swing.GroupLayout.PREFERRED_SIZE)) setBounds((screenSize.width-595)/2,
.addGap(105, 105, 105)) (screenSize.height-367)/2, 595, 367);
.addGroup(layout.createSequentialGroup() }// </editor-fold>
.addGap(178, 178, 178)
.addComponent(jButton1, private void
javax.swing.GroupLayout.PREFERRED_SIZE, 233, jButton1ActionPerformed(java.awt.event.ActionEv
javax.swing.GroupLayout.PREFERRED_SIZE) ent evt) {
.addContainerGap(168,
Short.MAX_VALUE))
.addGroup(layout.createSequentialGroup() try{
.addContainerGap() int flag=0;
.addComponent(jLabel4, String sql="Select * from login;";
javax.swing.GroupLayout.PREFERRED_SIZE, 559, smt1=con.createStatement();
javax.swing.GroupLayout.PREFERRED_SIZE) rs=smt1.executeQuery(sql);
String log=jTextField1.getText();
String pass =new }
String(jPasswordField1.getPassword()); } catch (ClassNotFoundException ex) {
while(rs.next()) {
if(log.equals(rs.getString(1)) && java.util.logging.Logger.getLogger(login.class.getN
pass.equals(rs.getString(2))) { ame()).log(java.util.logging.Level.SEVERE, null, ex);
flag=1; } catch (InstantiationException ex) {
break;
} java.util.logging.Logger.getLogger(login.class.getN
} ame()).log(java.util.logging.Level.SEVERE, null, ex);
if(flag==1) { } catch (IllegalAccessException ex) {
new menu ().setVisible(true);
dispose(); java.util.logging.Logger.getLogger(login.class.getN
} else { ame()).log(java.util.logging.Level.SEVERE, null, ex);
JOptionPane.showMessageDialog(this, } catch
"Please check user name / password", "Error (javax.swing.UnsupportedLookAndFeelException
Occured !",JOptionPane.ERROR_MESSAGE); ex) {
}
} catch(Exception ex){ java.util.logging.Logger.getLogger(login.class.getN
} ame()).log(java.util.logging.Level.SEVERE, null, ex);
}
//</editor-fold>
}
java.awt.EventQueue.invokeLater(new
Runnable() {
/**************************************** @Override
CHANGE THEME NAME : Metal , Nimbus , public void run() {
CDE/Motif , Windows , Windows Classic ....for new login().setVisible(true);
more visit (www.ezindagi.in) ! }
****************************************/ });
}
public static void main(String args[]) {
// Variables declaration - do not modify
try { private javax.swing.JButton jButton1;
for private javax.swing.JLabel jLabel2;
(javax.swing.UIManager.LookAndFeelInfo info : private javax.swing.JLabel jLabel3;
javax.swing.UIManager.getInstalledLookAndFeels() private javax.swing.JLabel jLabel4;
){ private javax.swing.JPasswordField
if ("THEME jPasswordField1;
NAME".equals(info.getName())) { private javax.swing.JTextField jTextField1;
private org.jdesktop.beansbinding.BindingGroup
javax.swing.UIManager.setLookAndFeel(info.getCl bindingGroup;
assName()); // End of variables declaration
break;
} }
MAIN MENU
jButton4.setBackground(new java.awt.
package Student; Color(204, 204, 255));
public class menu extends javax.swing.JFrame {

public menu() { java.awt.Font("Tahoma", 1, 20)); // NOI18N
initComponents(); jButton4.setForeground(new
} java.awt.Color(51, 0, 0));
jButton4.setText("Student Details
@SuppressWarnings("unchecked") Navigation");
// <editor-fold defaultstate="collapsed" jButton4.addActionListener(new
desc="Generated Code"> java.awt.event.ActionListener() {
private void initComponents() { public void
bindingGroup = new actionPerformed(java.awt.event.ActionEvent evt) {
org.jdesktop.beansbinding.BindingGroup(); jButton4ActionPerformed(evt);
}
jButton4 = new javax.swing.JButton(); });
jButton2 = new javax.swing.JButton();
jButton1 = new javax.swing.JButton(); jButton2.setBackground(new
jButton3 = new javax.swing.JButton(); java.awt.Color(204, 204, 255));
jButton6 = new javax.swing.JButton(); jButton2.setFont(new
jLabel4 = new javax.swing.JLabel(); java.awt.Font("Tahoma", 1, 20)); // NOI18N
jButton5 = new javax.swing.JButton(); jButton2.setForeground(new
java.awt.Color(51, 0, 0));
jButton2.setText("Update Student Details");
setDefaultCloseOperation(javax.swing.WindowCon jButton2.addActionListener(new
stants.EXIT_ON_CLOSE); java.awt.event.ActionListener() {
setBounds(new java.awt.Rectangle(80, 60, 0, public void
0)); actionPerformed(java.awt.event.ActionEvent evt) {
jButton2ActionPerformed(evt);
org.jdesktop.beansbinding.Binding binding = }
org.jdesktop.beansbinding.Bindings.createAutoBin });
ding(org.jdesktop.beansbinding.AutoBinding.Upda
teStrategy.READ, this, jButton1.setBackground(new
org.jdesktop.beansbinding.ELProperty.create("Sch java.awt.Color(204, 204, 255));
ool Management System || www.ezindagi.in ||"), jButton1.setFont(new
this, java.awt.Font("Tahoma", 1, 20)); // NOI18N
org.jdesktop.beansbinding.BeanProperty.create("ti jButton1.setForeground(new
tle")); java.awt.Color(51, 0, 0));
bindingGroup.addBinding(binding); jButton1.setText("Add Student Details");
java.awt.event.ActionListener() {
0
public void jButton5.setText("Student Details List");
actionPerformed(java.awt.event.ActionEvent evt) { jButton5.addActionListener(new
jButton1ActionPerformed(evt); java.awt.event.ActionListener() {
} public void
}); actionPerformed(java.awt.event.ActionEvent evt) {
jButton3.setBackground(new }
java.awt.Color(204, 204, 255)); });
java.awt.Font("Tahoma", 1, 20)); // NOI18N javax.swing.GroupLayout layout = new
jButton3.setForeground(new javax.swing.GroupLayout(getContentPane());
java.awt.Color(51, 0, 0)); getContentPane().setLayout(layout);
jButton3.setText("Delete Student Details"); layout.setHorizontalGroup(
java.awt.event.ActionListener() { layout.createParallelGroup(javax.swing.GroupLayo
public void ut.Alignment.LEADING)
actionPerformed(java.awt.event.ActionEvent evt) {
jButton3ActionPerformed(evt); .addGroup(javax.swing.GroupLayout.Alignment.TR
} AILING, layout.createSequentialGroup()
}); .addGap(94, 94, 94)
jButton6.setBackground(new .addGroup(layout.createParallelGroup(javax.swing
java.awt.Color(102, 102, 102)); .GroupLayout.Alignment.LEADING)
jButton6.setFont(new .addComponent(jButton5,
java.awt.Font("Tahoma", 1, 18)); // NOI18N javax.swing.GroupLayout.DEFAULT_SIZE, 379,
jButton6.setForeground(new Short.MAX_VALUE)
java.awt.Color(255, 255, 255)); .addComponent(jButton4,
jButton6.setText("EXIT"); javax.swing.GroupLayout.Alignment.TRAILING,
jButton6.addActionListener(new javax.swing.GroupLayout.DEFAULT_SIZE, 379,
java.awt.event.ActionListener() { Short.MAX_VALUE)
public void .addComponent(jButton3,
actionPerformed(java.awt.event.ActionEvent evt) { javax.swing.GroupLayout.DEFAULT_SIZE, 379,
jButton6ActionPerformed(evt); Short.MAX_VALUE)
} .addComponent(jButton2,
}); javax.swing.GroupLayout.DEFAULT_SIZE, 379,
Short.MAX_VALUE)
jLabel4.setFont(new java.awt.Font("Tahoma", .addComponent(jButton1,
3, 36)); javax.swing.GroupLayout.DEFAULT_SIZE, 379,
jLabel4.setForeground(new Short.MAX_VALUE))
java.awt.Color(102, 102, 255)); .addGap(53, 53, 53)
jLabel4.setText(" School Management .addComponent(jButton6,
System"); javax.swing.GroupLayout.DEFAULT_SIZE, 75,
Short.MAX_VALUE)
jButton5.setBackground(new .addGap(90, 90, 90))
java.awt.Color(204, 204, 255)); .addGroup(layout.createSequentialGroup()
jButton5.setFont(new .addGap(50, 50, 50)
java.awt.Font("Tahoma", 1, 20)); // NOI18N .addComponent(jLabel4,
jButton5.setForeground(new javax.swing.GroupLayout.PREFERRED_SIZE, 559,
java.awt.Color(51, 0, 0)); javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap(82,
Short.MAX_VALUE)) private void
); jButton4ActionPerformed(java.awt.event.ActionEv
layout.setVerticalGroup( ent evt) {
layout.createParallelGroup(javax.swing.GroupLayo new Navigation ().setVisible(true);

ut.Alignment.LEADING) dispose();
.addGroup(layout.createSequentialGroup()
.addGap(22, 22, 22) // TODO add your handling code here:
.addComponent(jLabel4) }
.addGap(27, 27, 27)
private void
.addGroup(layout.createParallelGroup(javax.swing jButton2ActionPerformed(java.awt.event.ActionEv
.GroupLayout.Alignment.LEADING) ent evt) {
new update ().setVisible(true);
.addGroup(layout.createSequentialGroup() dispose();
.addComponent(jButton1,
javax.swing.GroupLayout.PREFERRED_SIZE, 67, // TODO add your handling code here:
javax.swing.GroupLayout.PREFERRED_SIZE) }
.addGap(18, 18, 18)
.addComponent(jButton2, private void
javax.swing.GroupLayout.PREFERRED_SIZE, 67, jButton1ActionPerformed(java.awt.event.ActionEv
javax.swing.GroupLayout.PREFERRED_SIZE) ent evt) {
.addGap(18, 18, 18)
.addComponent(jButton3, new add ().setVisible(true);
javax.swing.GroupLayout.PREFERRED_SIZE, 61, dispose();
.addGap(18, 18, 18) // TODO add your handling code here:
.addComponent(jButton4, }
javax.swing.GroupLayout.PREFERRED_SIZE) private void
.addGap(18, 18, 18) jButton3ActionPerformed(java.awt.event.ActionEv
.addComponent(jButton5, ent evt) {
javax.swing.GroupLayout.PREFERRED_SIZE, 59, new delete ().setVisible(true);
javax.swing.GroupLayout.PREFERRED_SIZE)) dispose();
javax.swing.GroupLayout.DEFAULT_SIZE, 393, // TODO add your handling code here:
Short.MAX_VALUE)) }
.addGap(36, 36, 36))
); private void
jButton6ActionPerformed(java.awt.event.ActionEv
bindingGroup.bind(); ent evt) {
java.awt.Dimension screenSize = System.exit(0);

java.awt.Toolkit.getDefaultToolkit().getScreenSize( // TODO add your handling code here:
); }
setBounds((screenSize.width-707)/2,
(screenSize.height-560)/2, 707, 560);
}// </editor-fold>
private void @Override
jButton5ActionPerformed(java.awt.event.ActionEv public void run() {
ent evt) { new menu().setVisible(true);
// TODO add your handling code here: }
});
new list ().setVisible(true); }
dispose(); // Variables declaration - do not modify
private javax.swing.JButton jButton1;
} private javax.swing.JButton jButton2;
/** private javax.swing.JButton jButton4;
* @param args the command line arguments private javax.swing.JButton jButton5;
*/ private javax.swing.JButton jButton6;
public static void main(String args[]) { private javax.swing.JLabel jLabel4;
private org.jdesktop.beansbinding.BindingGroup
java.awt.EventQueue.invokeLater(new bindingGroup;
Runnable() { // End of variables declaration
}}
ADD
package Student; jTextField9 = new javax.swing.JTextField();
import java.sql.Connection; jTextField8 = new javax.swing.JTextField();
import java.sql.DriverManager; jLabel11 = new javax.swing.JLabel();
import java.sql.ResultSet; jTextField10 = new javax.swing.JTextField();
import java.sql.Statement; jSeparator1 = new javax.swing.JSeparator();
import javax.swing.JOptionPane; jLabel2 = new javax.swing.JLabel();
public class add extends javax.swing.JFrame { setTitle("School Management System ||

Connection con = null; www.ezindagi.in ||");
Statement stmt = null; setBounds(new java.awt.Rectangle(80, 60, 0,
ResultSet rs = null; 0));
public add() { org.jdesktop.beansbinding.Binding binding =

initComponents(); org.jdesktop.beansbinding.Bindings.createAutoBin
} ding(org.jdesktop.beansbinding.AutoBinding.Upda
teStrategy.READ, this,
@SuppressWarnings("unchecked") org.jdesktop.beansbinding.ELProperty.create("Sch
// <editor-fold defaultstate="collapsed" ool Management System || www.ezindagi.in ||"),
desc="Generated Code"> this,
private void initComponents() { org.jdesktop.beansbinding.BeanProperty.create("ti
bindingGroup = new tle"));
org.jdesktop.beansbinding.BindingGroup(); bindingGroup.addBinding(binding);
jLabel7 = new javax.swing.JLabel(); jLabel7.setFont(new java.awt.Font("Arial", 1,

jLabel9 = new javax.swing.JLabel(); 18));
jLabel6 = new javax.swing.JLabel(); jLabel7.setForeground(new java.awt.Color(51,
jLabel10 = new javax.swing.JLabel(); 0, 0));
jLabel5 = new javax.swing.JLabel(); jLabel7.setText("Contact No. : ");
jLabel8 = new javax.swing.JLabel();
jLabel4 = new javax.swing.JLabel(); jLabel9.setFont(new java.awt.Font("Arial", 1,
jLabel3 = new javax.swing.JLabel(); 18));
jLabel1 = new javax.swing.JLabel(); jLabel9.setForeground(new java.awt.Color(51,
jTextField1 = new javax.swing.JTextField(); 0, 0));
jTextField4 = new javax.swing.JTextField(); jLabel9.setText("Religion : ");
jTextField6 = new javax.swing.JTextField(); jLabel6.setFont(new java.awt.Font("Arial", 1,
jTextField5 = new javax.swing.JTextField(); 18));
jTextField7 = new javax.swing.JTextField(); jLabel6.setForeground(new java.awt.Color(51,
jButton4 = new javax.swing.JButton(); 0, 0));
jButton5 = new javax.swing.JButton(); jLabel6.setText("Local Address : ");
jButton3 = new javax.swing.JButton();
0
jLabel10.setFont(new java.awt.Font("Arial", 1, jTextField2.setForeground(new
18)); java.awt.Color(51, 0, 0));
jLabel10.setForeground(new
java.awt.Color(51, 0, 0)); jTextField6.setFont(new
jLabel10.setText("City / District : "); java.awt.Font("Tahoma", 1, 14));
jTextField6.setForeground(new
jLabel5.setFont(new java.awt.Font("Arial", 1, java.awt.Color(51, 0, 0));
18));
jLabel5.setForeground(new java.awt.Color(51, jTextField5.setFont(new
0, 0)); java.awt.Font("Tahoma", 1, 14));
jLabel5.setText("Father's Name : "); jTextField5.setForeground(new
jLabel8.setFont(new java.awt.Font("Arial", 1,
18)); jTextField7.setFont(new
jLabel8.setForeground(new java.awt.Color(51, java.awt.Font("Tahoma", 1, 14));
0, 0)); jTextField7.setForeground(new
jLabel8.setText("Mother's Name : "); java.awt.Color(51, 0, 0));
jLabel4.setFont(new java.awt.Font("Arial", 1, jButton4.setBackground(new

18)); java.awt.Color(204, 204, 255));
jLabel4.setForeground(new java.awt.Color(51, jButton4.setFont(new
0, 0)); java.awt.Font("Tahoma", 1, 18)); // NOI18N
jLabel4.setText("Roll No. : "); jButton4.setForeground(new
jLabel3.setFont(new java.awt.Font("Arial", 1, jButton4.setText("EXIT");
18)); jButton4.addActionListener(new
jLabel3.setForeground(new java.awt.Color(51, java.awt.event.ActionListener() {
0, 0)); public void
jLabel3.setText("Class : "); actionPerformed(java.awt.event.ActionEvent evt) {
jLabel1.setFont(new java.awt.Font("Arial", 1, }
18)); });
jLabel1.setForeground(new java.awt.Color(51,
0, 0)); jButton5.setBackground(new
jLabel1.setText("Name : "); java.awt.Color(204, 204, 255));
jTextField1.setFont(new java.awt.Font("Tahoma", 1, 18)); // NOI18N
java.awt.Font("Tahoma", 1, 14)); jButton5.setForeground(new
jTextField1.setForeground(new java.awt.Color(51, 0, 0));
java.awt.Color(51, 0, 0)); jButton5.setText("RESET");
jTextField4.setFont(new java.awt.event.ActionListener() {
java.awt.Font("Tahoma", 1, 14)); public void
jTextField4.setForeground(new actionPerformed(java.awt.event.ActionEvent evt) {
java.awt.Color(51, 0, 0)); jButton5ActionPerformed(evt);
}
jTextField2.setFont(new });
java.awt.Font("Tahoma", 1, 14));
jButton3.setBackground(new layout.setHorizontalGroup(
java.awt.Color(204, 204, 255));
jButton3.setFont(new layout.createParallelGroup(javax.swing.GroupLayo
java.awt.Font("Tahoma", 1, 18)); // NOI18N ut.Alignment.LEADING)
jButton3.setForeground(new .addGroup(layout.createSequentialGroup()
jButton3.setText("ADD"); .addGroup(layout.createParallelGroup(javax.swing
jButton3.addActionListener(new .GroupLayout.Alignment.LEADING)
public void .addGroup(layout.createSequentialGroup()
actionPerformed(java.awt.event.ActionEvent evt) { .addGap(30, 30, 30)
} .addGroup(layout.createParallelGroup(javax.swing
}); .GroupLayout.Alignment.LEADING)
jTextField3.setFont(new .addGroup(layout.createSequentialGroup()
jTextField3.setForeground(new .addGroup(layout.createParallelGroup(javax.swing
java.awt.Color(51, 0, 0)); .GroupLayout.Alignment.TRAILING)
.addComponent(jLabel7)
jTextField9.setFont(new .addComponent(jLabel9)
java.awt.Font("Tahoma", 1, 14)); .addComponent(jLabel6)
jTextField9.setForeground(new .addComponent(jLabel10)
jTextField8.setFont(new
java.awt.Font("Tahoma", 1, 14)); .addGroup(layout.createParallelGroup(javax.swing
jTextField8.setForeground(new .GroupLayout.Alignment.TRAILING)
java.awt.Color(51, 0, 0)); .addComponent(jLabel5)
jLabel11.setFont(new java.awt.Font("Arial", 1, .addComponent(jLabel4)
16)); .addComponent(jLabel3)
jLabel11.setText("ENTER ADMISSION NO."); .addComponent(jLabel1))
.addGap(5, 5, 5)))
jTextField10.setFont(new .addGap(29, 29, 29)
.addComponent(jTextField1,
jLabel2.setFont(new java.awt.Font("Tahoma", javax.swing.GroupLayout.PREFERRED_SIZE, 237,
3, 36)); javax.swing.GroupLayout.PREFERRED_SIZE)
jLabel2.setText(" School Management
System"); .addGroup(layout.createParallelGroup(javax.swing
javax.swing.GroupLayout layout = new
javax.swing.GroupLayout(getContentPane()); .addComponent(jTextField4,
getContentPane().setLayout(layout);
javax.swing.GroupLayout.PREFERRED_SIZE, 237, .addComponent(jTextField10,
javax.swing.GroupLayout.PREFERRED_SIZE) javax.swing.GroupLayout.PREFERRED_SIZE, 171,
javax.swing.GroupLayout.PREFERRED_SIZE))
javax.swing.GroupLayout.PREFERRED_SIZE, 237, .addGroup(layout.createSequentialGroup()
javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(14, 14, 14)
.addComponent(jSeparator1,
.addComponent(jTextField6, javax.swing.GroupLayout.PREFERRED_SIZE, 435,
javax.swing.GroupLayout.PREFERRED_SIZE, 237, javax.swing.GroupLayout.PREFERRED_SIZE))))
.addComponent(jTextField5, .addGap(56, 56, 56)
javax.swing.GroupLayout.PREFERRED_SIZE, 237, .addComponent(jLabel2,
javax.swing.GroupLayout.PREFERRED_SIZE) javax.swing.GroupLayout.PREFERRED_SIZE, 559,
javax.swing.GroupLayout.PREFERRED_SIZE)))
.addComponent(jTextField7, .addContainerGap(37,
javax.swing.GroupLayout.PREFERRED_SIZE, 237, Short.MAX_VALUE))
javax.swing.GroupLayout.PREFERRED_SIZE) );
layout.setVerticalGroup(
javax.swing.GroupLayout.PREFERRED_SIZE, 237, layout.createParallelGroup(javax.swing.GroupLayo
javax.swing.GroupLayout.PREFERRED_SIZE)) ut.Alignment.LEADING)
.addGap(54, 54, 54) .addGroup(layout.createSequentialGroup()
.addGap(19, 19, 19)
.addGroup(layout.createParallelGroup(javax.swing .addComponent(jLabel2)
.GroupLayout.Alignment.LEADING, false) .addGap(26, 26, 26)
javax.swing.GroupLayout.DEFAULT_SIZE, .addGroup(layout.createParallelGroup(javax.swing
javax.swing.GroupLayout.DEFAULT_SIZE, .GroupLayout.Alignment.LEADING)
Short.MAX_VALUE)
.addComponent(jButton5, .addGroup(layout.createSequentialGroup()
javax.swing.GroupLayout.DEFAULT_SIZE,
Short.MAX_VALUE) .GroupLayout.Alignment.BASELINE)
.addComponent(jButton3, .addComponent(jLabel11)
javax.swing.GroupLayout.PREFERRED_SIZE))) javax.swing.GroupLayout.PREFERRED_SIZE,
.addComponent(jTextField9, javax.swing.GroupLayout.DEFAULT_SIZE,
javax.swing.GroupLayout.PREFERRED_SIZE, 237, javax.swing.GroupLayout.PREFERRED_SIZE))
.addComponent(jTextField8, .addComponent(jSeparator1,
javax.swing.GroupLayout.PREFERRED_SIZE, 237, javax.swing.GroupLayout.PREFERRED_SIZE, 2,
javax.swing.GroupLayout.PREFERRED_SIZE))) javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(18, 18, 18)
.addGap(46, 46, 46) .addGroup(layout.createParallelGroup(javax.swing
.addComponent(jLabel11) .GroupLayout.Alignment.BASELINE)
.addGap(18, 18, 18) .addComponent(jLabel1)
javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
javax.swing.GroupLayout.DEFAULT_SIZE, .addGap(18, 18, 18)
.addGroup(layout.createParallelGroup(javax.swing
.addPreferredGap(javax.swing.LayoutStyle.Compo .GroupLayout.Alignment.BASELINE)
nentPlacement.UNRELATED) .addComponent(jLabel10)
.addGroup(layout.createParallelGroup(javax.swing javax.swing.GroupLayout.PREFERRED_SIZE,
.GroupLayout.Alignment.BASELINE) javax.swing.GroupLayout.DEFAULT_SIZE,
.addComponent(jLabel3) javax.swing.GroupLayout.PREFERRED_SIZE))
javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.PREFERRED_SIZE)) .GroupLayout.Alignment.BASELINE)
.addComponent(jLabel4) javax.swing.GroupLayout.PREFERRED_SIZE))
javax.swing.GroupLayout.PREFERRED_SIZE)) .GroupLayout.Alignment.BASELINE)
.addComponent(jLabel5) javax.swing.GroupLayout.PREFERRED_SIZE)))
javax.swing.GroupLayout.PREFERRED_SIZE, .addGroup(javax.swing.GroupLayout.Alignment.TR
javax.swing.GroupLayout.DEFAULT_SIZE, AILING, layout.createSequentialGroup()
.addGap(18, 18, 18) .addPreferredGap(javax.swing.LayoutStyle.Compo
nentPlacement.RELATED, 95, Short.MAX_VALUE)
.addGroup(layout.createParallelGroup(javax.swing .addComponent(jButton3,
.GroupLayout.Alignment.BASELINE) javax.swing.GroupLayout.PREFERRED_SIZE, 48,
.addComponent(jLabel8) javax.swing.GroupLayout.PREFERRED_SIZE)
javax.swing.GroupLayout.PREFERRED_SIZE, .addComponent(jButton5,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE, 49,
javax.swing.GroupLayout.PREFERRED_SIZE)) javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(18, 18, 18) .addGap(47, 47, 47)
.addGroup(layout.createParallelGroup(javax.swing javax.swing.GroupLayout.PREFERRED_SIZE, 49,
.GroupLayout.Alignment.BASELINE) javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel6) .addGap(73, 73, 73)))
.addComponent(jTextField6, .addGap(28, 28, 28))
javax.swing.GroupLayout.PREFERRED_SIZE, );
String uid = "root";
bindingGroup.bind(); String pwd = "root";
String url =
java.awt.Dimension screenSize = "jdbc:mysql://localhost:3306/school";
java.awt.Toolkit.getDefaultToolkit().getScreenSize(
); con= DriverManager.getConnection(url,
setBounds((screenSize.width-707)/2, uid, pwd);
(screenSize.height-560)/2, 707, 560); stmt = con.createStatement();
}// </editor-fold> String qry ="insert into
student(name,standard,rollno,fname,mname,addr
private void ess,city,religion,contact,admno)"
jButton4ActionPerformed(java.awt.event.ActionEv + "values('"+ jTextField1.getText() +
ent evt) { "',"
+ "'" +jTextField2.getText()+ "',"
new menu ().setVisible(true); + "'" + jTextField3.getText() +"',"
dispose(); + "'" + jTextField4.getText() +"',"
+ "'" + jTextField5.getText() +"',"
// TODO add your handling code here: + "'" + jTextField6.getText() +"',"
} + "'" + jTextField7.getText() +"',"
+ "'" + jTextField8.getText() +"',"
private void + "'" + jTextField9.getText() +"',"
jButton5ActionPerformed(java.awt.event.ActionEv + "'" + jTextField10.getText() +"' )" ;
ent evt) { // stmt = con.createStatement();
stmt.executeUpdate(qry);
JOptionPane.showMessageDialog(null,
jTextField1.setText(null); "Sucessfully Added Student Details :-)");
jTextField2.setText(null);
jTextField3.setText(null); stmt.close();
jTextField4.setText(null); con.close();
jTextField5.setText(null); }catch(Exception e) {
jTextField7.setText(null); JOptionPane.showMessageDialog(null,"Error
jTextField8.setText(null); Occur Not Added !");
jTextField9.setText(null); }
jTextField10.setText(null); }
// TODO add your handling code here: jTextField3.setText(null);
} jTextField4.setText(null);
private void jTextField6.setText(null);
jButton3ActionPerformed(java.awt.event.ActionEv jTextField7.setText(null);
ent evt) { jTextField8.setText(null);
int a = JOptionPane.showConfirmDialog(null, jTextField10.setText(null);
"wana add details for sure ?");
if (a==JOptionPane.YES_OPTION) {
try {
private javax.swing.JLabel jLabel4;
// TODO add your handling code here: private javax.swing.JLabel jLabel5;
} private javax.swing.JLabel jLabel6;
/** private javax.swing.JLabel jLabel8;
* @param args the command line arguments private javax.swing.JLabel jLabel9;
*/ private javax.swing.JSeparator jSeparator1;
public static void main(String args[]) { private javax.swing.JTextField jTextField1;
private javax.swing.JTextField jTextField10;
java.awt.EventQueue.invokeLater(new private javax.swing.JTextField jTextField2;
Runnable() { private javax.swing.JTextField jTextField3;
@Override private javax.swing.JTextField jTextField5;
public void run() { private javax.swing.JTextField jTextField6;
new add().setVisible(true); private javax.swing.JTextField jTextField7;
} private javax.swing.JTextField jTextField8;
}); private javax.swing.JTextField jTextField9;
} private org.jdesktop.beansbinding.BindingGroup
// Variables declaration - do not modify bindingGroup;
private javax.swing.JButton jButton3; // End of variables declaration
private javax.swing.JButton jButton4; }
LIST
public void
package Student; windowGainedFocus(java.awt.event.WindowEvent
import javax.swing.table.*; evt) {
import java.sql.*; formWindowGainedFocus(evt);
import javax.swing.JOptionPane; }
public void
public class list extends javax.swing.JFrame { windowLostFocus(java.awt.event.WindowEvent
evt) {
/** Creates new form ItemListUI */ }
public list() { });
initComponents();
} jButton2.setBackground(new
java.awt.Color(204, 204, 255));
/** This method is called from within the jButton2.setFont(new
constructor to java.awt.Font("Tahoma", 1, 11)); // NOI18N
* initialize the form. jButton2.setText("Back to Menu");
* WARNING: Do NOT modify this code. The jButton2.addActionListener(new
content of this method is java.awt.event.ActionListener() {
* always regenerated by the Form Editor. public void
*/ actionPerformed(java.awt.event.ActionEvent evt) {
@SuppressWarnings("unchecked") jButton2ActionPerformed(evt);
// <editor-fold defaultstate="collapsed" }
desc="Generated Code"> });
private void initComponents() {
bindingGroup = new jTable1.setAutoCreateRowSorter(true);
org.jdesktop.beansbinding.BindingGroup();
jTable1.setBorder(javax.swing.BorderFactory.creat
jButton2 = new javax.swing.JButton(); eBevelBorder(javax.swing.border.BevelBorder.RAI
jScrollPane1 = new javax.swing.JScrollPane(); SED));
jTable1 = new javax.swing.JTable(); jTable1.setFont(new java.awt.Font("Tahoma",
jLabel6 = new javax.swing.JLabel(); 0, 12)); // NOI18N
jTable1.setModel(new
javax.swing.table.DefaultTableModel(
setDefaultCloseOperation(javax.swing.WindowCon new Object [][] {
stants.EXIT_ON_CLOSE); {null, null, null, null, null, null},
{null, null, null, null, null, null},
org.jdesktop.beansbinding.Binding binding = {null, null, null, null, null, null},
org.jdesktop.beansbinding.Bindings.createAutoBin {null, null, null, null, null, null},
ding(org.jdesktop.beansbinding.AutoBinding.Upda {null, null, null, null, null, null},
teStrategy.READ_WRITE, this, {null, null, null, null, null, null},
org.jdesktop.beansbinding.ELProperty.create("Sch {null, null, null, null, null, null},
ool Management System || www.ezindagi.in ||"), {null, null, null, null, null, null},
this, {null, null, null, null, null, null},
org.jdesktop.beansbinding.BeanProperty.create("ti {null, null, null, null, null, null},
tle")); {null, null, null, null, null, null},
bindingGroup.addBinding(binding); {null, null, null, null, null, null},
{null, null, null, null, null, null},
addWindowFocusListener(new {null, null, null, null, null, null},
java.awt.event.WindowFocusListener() { {null, null, null, null, null, null}
}, .addGap(26, 26, 26)
new String [] { .addComponent(jScrollPane1,
"Admission No.", "Name", "Roll No", javax.swing.GroupLayout.PREFERRED_SIZE, 172,
"Class", "Mobile No.", "City" javax.swing.GroupLayout.PREFERRED_SIZE)
} .addGap(18, 18, 18)
)); .addComponent(jButton2,
jTable1.setSelectionBackground(new javax.swing.GroupLayout.PREFERRED_SIZE, 34,
java.awt.Color(204, 204, 204)); javax.swing.GroupLayout.PREFERRED_SIZE)
jScrollPane1.setViewportView(jTable1); .addContainerGap(23,
Short.MAX_VALUE))
jLabel6.setFont(new java.awt.Font("Tahoma", );
3, 36)); // NOI18N
jLabel6.setForeground(new bindingGroup.bind();
java.awt.Color(102, 102, 255));
jLabel6.setText(" School Management java.awt.Dimension screenSize =
System"); java.awt.Toolkit.getDefaultToolkit().getScreenSize(
);
javax.swing.GroupLayout layout = new setBounds((screenSize.width-699)/2,
javax.swing.GroupLayout(getContentPane()); (screenSize.height-366)/2, 699, 366);
getContentPane().setLayout(layout); }// </editor-fold>
layout.setHorizontalGroup(
private void
layout.createParallelGroup(javax.swing.GroupLayo jButton2ActionPerformed(java.awt.event.ActionEv
ut.Alignment.LEADING) ent evt) {
.addGroup(layout.createSequentialGroup() this.setVisible(false);
.addContainerGap() new menu().setVisible(true);
}
.GroupLayout.Alignment.LEADING) private void
formWindowGainedFocus(java.awt.event.Window
.addGroup(layout.createSequentialGroup() Event evt) {
.addComponent(jScrollPane1, // TODO add your handling code here:
javax.swing.GroupLayout.DEFAULT_SIZE, 663, // Before writting the followng line, you
Short.MAX_VALUE) should import the line:
.addContainerGap()) // import javax.swing.table.*; at the top of
your application
.addGroup(javax.swing.GroupLayout.Alignment.TR DefaultTableModel model =
AILING, layout.createSequentialGroup() (DefaultTableModel) jTable1.getModel();
.addComponent(jButton2, // Clear the existing table
javax.swing.GroupLayout.PREFERRED_SIZE, 150, int rows = model.getRowCount();
javax.swing.GroupLayout.PREFERRED_SIZE) if (rows > 0) {
.addGap(259, 259, 259)) for (int i = 0; i < rows; i++) {
model.removeRow(0);
.addGroup(javax.swing.GroupLayout.Alignment.TR }
AILING, layout.createSequentialGroup() }
.addComponent(jLabel6, // SQL Query
javax.swing.GroupLayout.PREFERRED_SIZE, 559, String query = "SELECT * FROM Student";
javax.swing.GroupLayout.PREFERRED_SIZE) try {
.addGap(56, 56, 56)))) // Connect to MySQL database
);
layout.setVerticalGroup( Class.forName("com.mysql.jdbc.Driver").newInsta
nce();
layout.createParallelGroup(javax.swing.GroupLayo Connection con = (Connection)
ut.Alignment.LEADING) DriverManager.getConnection("jdbc:mysql://local
.addGroup(layout.createSequentialGroup() host:3306/school","root","root");
.addContainerGap() // Create SQL statement and execute query.
.addComponent(jLabel6) Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(query);
/**
// Iterate through the result and display on * @param args the command line arguments
screen */
while (rs.next()) { public static void main(String args[]) {
String admno = rs.getString("admno"); java.awt.EventQueue.invokeLater(new
String name = rs.getString("name"); Runnable() {
String rollno = rs.getString("rollno"); public void run() {
String std = rs.getString("standard"); new list().setVisible(true);
String mobile = rs.getString("contact"); }
String city = rs.getString("city"); });
}
//System.out.println(admno + "|" + name
+ "|" + rollno + "|" + std + "|" + mobile + "|" + // Variables declaration - do not modify
city); private javax.swing.JButton jButton2;
model.addRow(new Object[] {admno, private javax.swing.JLabel jLabel6;
name, rollno, std, mobile, city}); private javax.swing.JScrollPane jScrollPane1;
} private javax.swing.JTable jTable1;
} catch (Exception e) { private org.jdesktop.beansbinding.BindingGroup
JOptionPane.showMessageDialog(this, bindingGroup;
e.getMessage()); // End of variables declaration
}
}}
}
NAVIGATION
import java.sql.*; jLabel19 = new javax.swing.JLabel();
import javax.swing.JOptionPane; jTextField10 = new javax.swing.JTextField();
public class Navigation extends javax.swing.JFrame
{
setDefaultCloseOperation(javax.swing.WindowCon
/** Creates new form PubNavUI */ stants.EXIT_ON_CLOSE);
public Navigation() { setBounds(new java.awt.Rectangle(200, 70, 0,
initComponents(); 0));
}
org.jdesktop.beansbinding.Binding binding =
/** This method is called from within the org.jdesktop.beansbinding.Bindings.createAutoBin
constructor to ding(org.jdesktop.beansbinding.AutoBinding.Upda
* initialize the form. teStrategy.READ_WRITE, this,
* WARNING: Do NOT modify this code. The org.jdesktop.beansbinding.ELProperty.create("Sch
content of this method is ool Management System || www.ezindagi.in ||"),
* always regenerated by the Form Editor. this,
*/ org.jdesktop.beansbinding.BeanProperty.create("ti
@SuppressWarnings("unchecked") tle"));
// <editor-fold defaultstate="collapsed" bindingGroup.addBinding(binding);
desc="Generated Code">
private void initComponents() { addWindowFocusListener(new
bindingGroup = new java.awt.event.WindowFocusListener() {
org.jdesktop.beansbinding.BindingGroup(); public void
windowGainedFocus(java.awt.event.WindowEvent
cmdFirst = new javax.swing.JButton(); evt) {
cmdNext = new javax.swing.JButton(); formWindowGainedFocus(evt);
cmdExit = new javax.swing.JButton(); }
cmdPrev = new javax.swing.JButton(); public void
cmdLast = new javax.swing.JButton(); windowLostFocus(java.awt.event.WindowEvent
jLabel18 = new javax.swing.JLabel(); evt) {
jLabel17 = new javax.swing.JLabel(); }
jLabel16 = new javax.swing.JLabel(); });
jLabel15 = new javax.swing.JLabel(); cmdFirst.setBackground(new
jLabel13 = new javax.swing.JLabel(); cmdFirst.setFont(new
jLabel10 = new javax.swing.JLabel(); cmdFirst.setText("First");
jTextField9 = new javax.swing.JTextField(); cmdFirst.addActionListener(new
jTextField8 = new javax.swing.JTextField(); java.awt.event.ActionListener() {
jTextField7 = new javax.swing.JTextField(); public void
jTextField6 = new javax.swing.JTextField(); actionPerformed(java.awt.event.ActionEvent evt) {
jTextField5 = new javax.swing.JTextField(); cmdFirstActionPerformed(evt);
jTextField4 = new javax.swing.JTextField(); }
jTextField3 = new javax.swing.JTextField(); });
0
cmdNext.setBackground(new
java.awt.Color(204, 204, 255)); jLabel17.setFont(new java.awt.Font("Arial", 1,
cmdNext.setFont(new 14));
java.awt.Font("Tahoma", 1, 12)); // NOI18N jLabel17.setForeground(new
cmdNext.setText("Next"); java.awt.Color(51, 0, 0));
cmdNext.addActionListener(new jLabel17.setText("Class : ");
public void jLabel16.setFont(new java.awt.Font("Arial", 1,
actionPerformed(java.awt.event.ActionEvent evt) { 14));
cmdNextActionPerformed(evt); jLabel16.setForeground(new
}); jLabel16.setText("Roll No. : ");
cmdExit.setBackground(new jLabel14.setFont(new java.awt.Font("Arial", 1,

java.awt.Color(204, 204, 255)); 14));
cmdExit.setFont(new jLabel14.setForeground(new
java.awt.Font("Tahoma", 1, 12)); // NOI18N java.awt.Color(51, 0, 0));
cmdExit.setText("Exit"); jLabel14.setText("Father's Name : ");
cmdExit.addActionListener(new
java.awt.event.ActionListener() { jLabel15.setFont(new java.awt.Font("Arial", 1,
public void 14));
actionPerformed(java.awt.event.ActionEvent evt) { jLabel15.setForeground(new
cmdExitActionPerformed(evt); java.awt.Color(51, 0, 0));
} jLabel15.setText("Mother's Name : ");
});
cmdPrev.setBackground(new 14));
java.awt.Color(204, 204, 255)); jLabel12.setForeground(new
cmdPrev.setFont(new java.awt.Color(51, 0, 0));
java.awt.Font("Tahoma", 1, 12)); // NOI18N jLabel12.setText("Local Address : ");
cmdPrev.setText("Previous");
cmdPrev.addActionListener(new jLabel13.setFont(new java.awt.Font("Arial", 1,
java.awt.event.ActionListener() { 14)); // NOI18N
public void jLabel13.setForeground(new
actionPerformed(java.awt.event.ActionEvent evt) { java.awt.Color(51, 0, 0));
cmdPrevActionPerformed(evt); jLabel13.setText("City / District : ");
}
}); jLabel11.setFont(new java.awt.Font("Arial", 1,
14));
cmdLast.setBackground(new jLabel11.setForeground(new
java.awt.Color(204, 204, 255)); java.awt.Color(51, 0, 0));
cmdLast.setFont(new jLabel11.setText("Religion : ");
cmdLast.setText("Last"); jLabel10.setFont(new java.awt.Font("Arial", 1,
cmdLast.addActionListener(new 14)); // NOI18N
java.awt.event.ActionListener() { jLabel10.setForeground(new
public void java.awt.Color(51, 0, 0));
actionPerformed(java.awt.event.ActionEvent evt) { jLabel10.setText("Contact No. : ");
cmdLastActionPerformed(evt);
} jTextField9.setFont(new
}); java.awt.Font("Tahoma", 1, 14));
jLabel18.setFont(new java.awt.Font("Arial", 1, java.awt.Color(51, 0, 0));
14));
jLabel18.setForeground(new jTextField9.setBorder(javax.swing.BorderFactory.cr
java.awt.Color(51, 0, 0)); eateEtchedBorder());
jLabel18.setText("Name : ");
jTextField8.setFont(new jTextField1.setFont(new
java.awt.Font("Tahoma", 1, 14)); java.awt.Font("Tahoma", 1, 14));
jTextField8.setForeground(new jTextField1.setForeground(new
jTextField8.setBorder(javax.swing.BorderFactory.cr jTextField1.setBorder(javax.swing.BorderFactory.cr
eateEtchedBorder()); eateEtchedBorder());
jTextField7.setFont(new jLabel19.setFont(new java.awt.Font("Arial", 1,

java.awt.Font("Tahoma", 1, 14)); 14));
jTextField7.setForeground(new jLabel19.setForeground(new
jLabel19.setText("Admission No : ");
jTextField7.setBorder(javax.swing.BorderFactory.cr
eateEtchedBorder()); jTextField10.setFont(new
jTextField6.setFont(new jTextField10.setForeground(new
java.awt.Color(51, 0, 0)); jTextField10.setBorder(javax.swing.BorderFactory.
createEtchedBorder());
eateEtchedBorder()); jLabel6.setFont(new java.awt.Font("Tahoma",
3, 36)); // NOI18N
jTextField5.setFont(new jLabel6.setForeground(new
java.awt.Font("Tahoma", 1, 14)); java.awt.Color(102, 102, 255));
jTextField5.setForeground(new jLabel6.setText(" School Management
java.awt.Color(51, 0, 0)); System");
jTextField5.setBorder(javax.swing.BorderFactory.cr javax.swing.GroupLayout layout = new

eateEtchedBorder()); javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
jTextField4.setFont(new layout.setHorizontalGroup(
jTextField4.setForeground(new layout.createParallelGroup(javax.swing.GroupLayo
java.awt.Color(51, 0, 0)); ut.Alignment.LEADING)
eateEtchedBorder()); .addGroup(layout.createParallelGroup(javax.swing
java.awt.Font("Tahoma", 1, 14)); .addGroup(layout.createSequentialGroup()
jTextField3.setForeground(new .addGap(57, 57, 57)
java.awt.Color(51, 0, 0)); .addComponent(jLabel6,
jTextField3.setBorder(javax.swing.BorderFactory.cr javax.swing.GroupLayout.PREFERRED_SIZE))
eateEtchedBorder());
jTextField2.setFont(new .addContainerGap()
jTextField2.setBorder(javax.swing.BorderFactory.cr .addGroup(layout.createSequentialGroup()
eateEtchedBorder()); .addGap(87, 87, 87)
.addComponent(cmdFirst, javax.swing.GroupLayout.PREFERRED_SIZE, 187,
javax.swing.GroupLayout.PREFERRED_SIZE, 66, javax.swing.GroupLayout.PREFERRED_SIZE)))
.addGap(28, 28, 28)
.addComponent(cmdNext, .addGroup(layout.createParallelGroup(javax.swing
javax.swing.GroupLayout.PREFERRED_SIZE, 64, .GroupLayout.Alignment.TRAILING)
javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jLabel15)
.addComponent(cmdPrev) .addComponent(jLabel13)
.addComponent(cmdLast, .addComponent(jLabel10))
javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap(javax.swing.LayoutStyle.Compo
.addGap(37, 37, 37) nentPlacement.UNRELATED)
.addComponent(cmdExit,
javax.swing.GroupLayout.PREFERRED_SIZE, 60, .addGroup(layout.createParallelGroup(javax.swing
javax.swing.GroupLayout.PREFERRED_SIZE)) .GroupLayout.Alignment.LEADING, false)
.addComponent(jTextField9)
.addGroup(layout.createSequentialGroup() .addComponent(jTextField8)
.addGroup(layout.createParallelGroup(javax.swing .addComponent(jTextField6)
.GroupLayout.Alignment.TRAILING) .addComponent(jTextField5,
.addGroup(layout.createSequentialGroup() javax.swing.GroupLayout.PREFERRED_SIZE))))))
.addGroup(layout.createParallelGroup(javax.swing .addContainerGap(javax.swing.GroupLayout.DEFA
.GroupLayout.Alignment.TRAILING) ULT_SIZE, Short.MAX_VALUE))
.addComponent(jLabel18) );
.addComponent(jLabel17) layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayo
.addComponent(jLabel14)) ut.Alignment.LEADING)
.addPreferredGap(javax.swing.LayoutStyle.Compo .addGap(11, 11, 11)
nentPlacement.UNRELATED) .addComponent(jLabel6)
.addGap(37, 37, 37)
.GroupLayout.Alignment.LEADING, false) .addGroup(layout.createParallelGroup(javax.swing
.addComponent(jTextField3) .addGap(2, 2, 2)
.addComponent(jTextField2) .addGroup(layout.createParallelGroup(javax.swing
.GroupLayout.Alignment.BASELINE)
.addComponent(jTextField1, .addComponent(jLabel19)
javax.swing.GroupLayout.PREFERRED_SIZE))) javax.swing.GroupLayout.PREFERRED_SIZE,
.addGroup(layout.createSequentialGroup() javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.Compo
.addPreferredGap(javax.swing.LayoutStyle.Compo nentPlacement.RELATED)
nentPlacement.UNRELATED)
.addComponent(jTextField10, .GroupLayout.Alignment.BASELINE)
.GroupLayout.Alignment.BASELINE) .addComponent(jTextField8,
.addComponent(jLabel17) javax.swing.GroupLayout.PREFERRED_SIZE,
.GroupLayout.Alignment.BASELINE) .addComponent(jTextField9,
.addComponent(jLabel16) javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))))
.addGroup(layout.createParallelGroup(javax.swing .addComponent(cmdPrev,
.GroupLayout.Alignment.BASELINE) javax.swing.GroupLayout.DEFAULT_SIZE, 34,
.addComponent(jLabel14) Short.MAX_VALUE)
.addComponent(jTextField4, .addComponent(cmdExit,
javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, 34,
javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
javax.swing.GroupLayout.PREFERRED_SIZE))) .addComponent(cmdLast,
javax.swing.GroupLayout.DEFAULT_SIZE, 34,
.addGroup(layout.createSequentialGroup() Short.MAX_VALUE)
.addComponent(cmdNext,
.addGroup(layout.createParallelGroup(javax.swing javax.swing.GroupLayout.DEFAULT_SIZE, 34,
.GroupLayout.Alignment.BASELINE) Short.MAX_VALUE)
.addComponent(jLabel15) .addComponent(cmdFirst,
.addComponent(jTextField5, javax.swing.GroupLayout.DEFAULT_SIZE, 34,
javax.swing.GroupLayout.PREFERRED_SIZE, Short.MAX_VALUE))
javax.swing.GroupLayout.DEFAULT_SIZE, .addGap(19, 19, 19))
javax.swing.GroupLayout.PREFERRED_SIZE)) );
.addGap(10, 10, 10)
bindingGroup.bind();
.GroupLayout.Alignment.BASELINE) java.awt.Dimension screenSize =
.addComponent(jLabel12) java.awt.Toolkit.getDefaultToolkit().getScreenSize(
.addComponent(jTextField6, );
javax.swing.GroupLayout.PREFERRED_SIZE, setBounds((screenSize.width-677)/2,
javax.swing.GroupLayout.DEFAULT_SIZE, (screenSize.height-366)/2, 677, 366);
javax.swing.GroupLayout.PREFERRED_SIZE)) }// </editor-fold>
.addGap(10, 10, 10) // Global variables
Statement stmt = null;
.addGroup(layout.createParallelGroup(javax.swing ResultSet rs = null;
.GroupLayout.Alignment.BASELINE) String SQL = "SELECT * FROM Student";
.addComponent(jLabel13) public void disable_textfields() {
javax.swing.GroupLayout.PREFERRED_SIZE, jTextField1.setEditable(false);
jTextField2.setEditable(false); JOptionPane.showMessageDialog(this,
jTextField3.setEditable(false); e.getMessage());
jTextField4.setEditable(false); }
jTextField6.setEditable(false);
jTextField7.setEditable(false); private void
jTextField8.setEditable(false); cmdNextActionPerformed(java.awt.event.ActionEv
jTextField9.setEditable(false); ent evt) {
jTextField10.setEditable(false); try {
Class.forName("com.mysql.jdbc.Driver");
} Connection con = (Connection)
private void DriverManager.getConnection("jdbc:mysql://local

cmdFirstActionPerformed(java.awt.event.ActionEv host:3306/School","root","root");
ent evt) { if (rs.next()) {
try { String admno = rs.getString("admno");
Class.forName("com.mysql.jdbc.Driver"); String name = rs.getString("name");
Connection con = (Connection) String std = rs.getString("standard");
String rollno = rs.getString("rollno");
DriverManager.getConnection("jdbc:mysql://local String fname = rs.getString("fname");
host:3306/school","root","root"); String mname = rs.getString("mname");
if (rs.first()) { String address = rs.getString("address");
String admno = rs.getString("admno"); String city = rs.getString("city");
String name = rs.getString("name"); String religion = rs.getString("religion");
String std = rs.getString("standard"); String contact = rs.getString("contact");
String rollno = rs.getString("rollno"); // Displaying the contents in respective
String fname = rs.getString("fname"); text boxes.
String mname = rs.getString("mname"); jTextField1.setText(name);
String address = rs.getString("address"); jTextField2.setText(std);
String city = rs.getString("city"); jTextField3.setText(rollno);
String religion = rs.getString("religion"); jTextField4.setText(fname);
String contact = rs.getString("contact"); jTextField5.setText(mname);
// Displaying the contents in respective jTextField6.setText(address);
text boxes. jTextField7.setText(city);
jTextField1.setText(name); jTextField8.setText(religion);
jTextField2.setText(std); jTextField9.setText(contact);
jTextField3.setText(rollno); jTextField10.setText(admno);
jTextField4.setText(fname); cmdFirst.setEnabled(true);
jTextField5.setText(mname); cmdNext.setEnabled(true);
jTextField6.setText(address); cmdPrev.setEnabled(true);
jTextField7.setText(city); cmdLast.setEnabled(true);
jTextField8.setText(religion); } else {
jTextField9.setText(contact); cmdNext.setEnabled(false);
jTextField10.setText(admno); JOptionPane.showMessageDialog(this,
cmdFirst.setEnabled(false); "You are at Last Record position", "Student",0);
cmdNext.setEnabled(true); }
cmdPrev.setEnabled(false); } catch (Exception e) {
cmdLast.setEnabled(true); JOptionPane.showMessageDialog(this,
} else { e.getMessage());
cmdFirst.setEnabled(false); }
cmdNext.setEnabled(false); }
cmdPrev.setEnabled(false);
cmdLast.setEnabled(false); private void
JOptionPane.showMessageDialog(this, cmdExitActionPerformed(java.awt.event.ActionEv
"There is no Record in Table", "Student",0); ent evt) {
} new menu ().setVisible(true);
} catch (Exception e) { dispose();
}
DriverManager.getConnection("jdbc:mysql://local
private void host:3306/School","root","root");
cmdPrevActionPerformed(java.awt.event.ActionEv if (rs.last()) {
ent evt) { String admno = rs.getString("admno");
try { String name = rs.getString("name");
Class.forName("com.mysql.jdbc.Driver"); String std = rs.getString("standard");
Connection con = (Connection) String rollno = rs.getString("rollno");
String fname = rs.getString("fname");
DriverManager.getConnection("jdbc:mysql://local String mname = rs.getString("mname");
host:3306/School","root","root"); String address = rs.getString("address");
if (rs.previous()) { String city = rs.getString("city");
String admno = rs.getString("admno"); String religion = rs.getString("religion");
String name = rs.getString("name"); String contact = rs.getString("contact");
String std = rs.getString("standard"); // Displaying the contents in respective
String rollno = rs.getString("rollno"); text boxes.
String fname = rs.getString("fname"); jTextField1.setText(name);
String mname = rs.getString("mname"); jTextField2.setText(std);
String address = rs.getString("address"); jTextField3.setText(rollno);
String city = rs.getString("city"); jTextField4.setText(fname);
String religion = rs.getString("religion"); jTextField5.setText(mname);
String contact = rs.getString("contact"); jTextField6.setText(address);
// Displaying the contents in respective jTextField7.setText(city);
text boxes. jTextField8.setText(religion);
jTextField1.setText(name); jTextField9.setText(contact);
jTextField2.setText(std); jTextField10.setText(admno);
jTextField3.setText(rollno); cmdFirst.setEnabled(true);
jTextField4.setText(fname); cmdNext.setEnabled(false);
jTextField5.setText(mname); cmdPrev.setEnabled(true);
jTextField6.setText(address); cmdLast.setEnabled(false);
jTextField7.setText(city); } else {
jTextField8.setText(religion); JOptionPane.showMessageDialog(this,
jTextField9.setText(contact); "You are Already at Last Record", "Student",0);
jTextField10.setText(admno); }
cmdFirst.setEnabled(true); } catch (Exception e) {
cmdNext.setEnabled(true); JOptionPane.showMessageDialog(this,
cmdPrev.setEnabled(true); e.getMessage());
cmdLast.setEnabled(true); }
} else { }
cmdPrev.setEnabled(false);
JOptionPane.showMessageDialog(this, private void
"You are at First Position", "Student",0); formWindowGainedFocus(java.awt.event.Window
} Event evt) {
} catch (Exception e) { disable_textfields();
JOptionPane.showMessageDialog(this, try {
e.getMessage()); // Connect to MySQL database
} // Don't forget to import the two packages
} // import java.sql.*;
// import javax.swing.JOptionPane;
private void Class.forName("com.mysql.jdbc.Driver");
cmdLastActionPerformed(java.awt.event.ActionEv Connection con = (Connection)
ent evt) {
try { DriverManager.getConnection("jdbc:mysql://local
Class.forName("com.mysql.jdbc.Driver"); host:3306/School","root","root");
Connection con = (Connection) stmt = con.createStatement();
rs = stmt.executeQuery(SQL);
if (rs.first())
{ /**
String admno = rs.getString("admno"); * @param args the command line arguments
String name = rs.getString("name"); */
String std = rs.getString("standard"); public static void main(String args[]) {
String rollno = rs.getString("rollno"); java.awt.EventQueue.invokeLater(new
String fname = rs.getString("fname"); Runnable() {
String mname = rs.getString("mname"); @Override
String address = rs.getString("address"); public void run() {
String city = rs.getString("city"); new Navigation().setVisible(true);
String religion = rs.getString("religion"); }
String contact = rs.getString("contact"); });
// Displaying the contents in respective }
text boxes.
jTextField1.setText(name); // Variables declaration - do not modify
jTextField2.setText(std); private javax.swing.JButton cmdExit;
jTextField3.setText(rollno); private javax.swing.JButton cmdFirst;
jTextField4.setText(fname); private javax.swing.JButton cmdLast;
jTextField5.setText(mname); private javax.swing.JButton cmdNext;
jTextField6.setText(address); private javax.swing.JButton cmdPrev;
jTextField7.setText(city); private javax.swing.JLabel jLabel10;
jTextField8.setText(religion); private javax.swing.JLabel jLabel11;
jTextField9.setText(contact); private javax.swing.JLabel jLabel12;
jTextField10.setText(admno); private javax.swing.JLabel jLabel13;
cmdFirst.setEnabled(false); private javax.swing.JLabel jLabel14;
cmdNext.setEnabled(true); private javax.swing.JLabel jLabel15;
cmdPrev.setEnabled(false); private javax.swing.JLabel jLabel16;
cmdLast.setEnabled(true); private javax.swing.JLabel jLabel17;
} private javax.swing.JLabel jLabel18;
else private javax.swing.JLabel jLabel19;
{ private javax.swing.JLabel jLabel6;
cmdFirst.setEnabled(false); private javax.swing.JTextField jTextField1;
cmdNext.setEnabled(false); private javax.swing.JTextField jTextField10;
cmdPrev.setEnabled(false); private javax.swing.JTextField jTextField2;
cmdLast.setEnabled(false); private javax.swing.JTextField jTextField3;
JOptionPane.showMessageDialog(this, private javax.swing.JTextField jTextField4;
"There is no Record in Table", "Student",0); private javax.swing.JTextField jTextField5;
} catch (Exception e) { private javax.swing.JTextField jTextField7;
JOptionPane.showMessageDialog(this, private javax.swing.JTextField jTextField8;
e.getMessage()); private javax.swing.JTextField jTextField9;
} private org.jdesktop.beansbinding.BindingGroup
} bindingGroup;
// End of variables declaration
}UPDATE
import java.sql.*; jTextField4 = new javax.swing.JTextField();
import javax.swing.JOptionPane; jTextField2 = new javax.swing.JTextField();
import javax.swing.DefaultListModel; jTextField1 = new javax.swing.JTextField();
public class update extends javax.swing.JFrame { jTextField6 = new javax.swing.JTextField();
/** Creates new form update */ jTextField7 = new javax.swing.JTextField();
public update() { jTextField10 = new javax.swing.JTextField();
initComponents(); jLabel19 = new javax.swing.JLabel();
} jLabel2 = new javax.swing.JLabel();
cmdExit1 = new javax.swing.JButton();
/** This method is called from within the
constructor to
* initialize the form. setDefaultCloseOperation(javax.swing.WindowCon
* WARNING: Do NOT modify this code. The stants.EXIT_ON_CLOSE);
content of this method is setBounds(new java.awt.Rectangle(200, 70, 0,
* always regenerated by the Form Editor. 0));
*/
@SuppressWarnings("unchecked") org.jdesktop.beansbinding.Binding binding =
// <editor-fold defaultstate="collapsed" org.jdesktop.beansbinding.Bindings.createAutoBin
desc="Generated Code"> ding(org.jdesktop.beansbinding.AutoBinding.Upda
private void initComponents() { teStrategy.READ_WRITE, this,
bindingGroup = new org.jdesktop.beansbinding.ELProperty.create("Sch
org.jdesktop.beansbinding.BindingGroup(); ool Management System || www.ezindagi.in ||"),
this,
cmdExit = new javax.swing.JButton(); org.jdesktop.beansbinding.BeanProperty.create("ti
jSeparator2 = new javax.swing.JSeparator(); tle"));
cmdUpdate = new javax.swing.JButton(); bindingGroup.addBinding(binding);
jScrollPane1 = new javax.swing.JScrollPane();
jList1 = new javax.swing.JList(); addWindowFocusListener(new
jLabel6 = new javax.swing.JLabel(); java.awt.event.WindowFocusListener() {
jLabel10 = new javax.swing.JLabel(); public void
jLabel11 = new javax.swing.JLabel(); windowGainedFocus(java.awt.event.WindowEvent
jLabel13 = new javax.swing.JLabel(); formWindowGainedFocus(evt);
jLabel15 = new javax.swing.JLabel(); public void
jLabel16 = new javax.swing.JLabel(); windowLostFocus(java.awt.event.WindowEvent
cmdExit.setBackground(new jLabel11.setFont(new java.awt.Font("Arial", 1,
java.awt.Color(204, 204, 255)); 14));
cmdExit.setFont(new jLabel11.setForeground(new
cmdExit.setText("Clear"); jLabel11.setText("Religion : ");
cmdExit.addActionListener(new
java.awt.event.ActionListener() { jLabel12.setFont(new java.awt.Font("Arial", 1,
public void 14));
actionPerformed(java.awt.event.ActionEvent evt) { jLabel12.setForeground(new
cmdExitActionPerformed(evt); java.awt.Color(51, 0, 0));
} jLabel12.setText("Local Address : ");
});
cmdUpdate.setBackground(new 14));
cmdUpdate.setFont(new java.awt.Color(51, 0, 0));
java.awt.Font("Tahoma", 1, 14)); jLabel13.setText("City / District : ");
cmdUpdate.setText("Update");
cmdUpdate.addActionListener(new jLabel14.setFont(new java.awt.Font("Arial", 1,
java.awt.event.ActionListener() { 14));
public void jLabel14.setForeground(new
actionPerformed(java.awt.event.ActionEvent evt) { java.awt.Color(51, 0, 0));
cmdUpdateActionPerformed(evt); jLabel14.setText("Father's Name : ");
}
}); jLabel15.setFont(new java.awt.Font("Arial", 1,
14));
jList1.setModel(new DefaultListModel()); jLabel15.setForeground(new
jList1.addMouseListener(new java.awt.Color(51, 0, 0));
java.awt.event.MouseAdapter() { jLabel15.setText("Mother's Name : ");
public void
mouseClicked(java.awt.event.MouseEvent evt) { jLabel16.setFont(new java.awt.Font("Arial", 1,
jList1MouseClicked(evt); 14));
} jLabel16.setForeground(new
}); java.awt.Color(51, 0, 0));
jScrollPane1.setViewportView(jList1); jLabel16.setText("Roll No. : ");
jLabel6.setFont(new jLabel17.setFont(new java.awt.Font("Arial", 1,

java.awt.Font("Helvetica", 1, 15)); 14));
jLabel6.setHorizontalAlignment(javax.swing.Swing java.awt.Color(51, 0, 0));
Constants.CENTER); jLabel17.setText("Class : ");
jLabel6.setText("Select a Student");
jLabel10.setFont(new java.awt.Font("Arial", 1, 14));
14)); jLabel18.setForeground(new
jLabel10.setForeground(new java.awt.Color(51, 0, 0));
java.awt.Color(51, 0, 0)); jLabel18.setText("Name : ");
jLabel10.setText("Contact No. : ");
java.awt.Font("Tahoma", 1, 14)); jTextField6.setFont(new
jTextField9.setForeground(new java.awt.Font("Tahoma", 1, 14));
java.awt.Color(51, 0, 0)); jTextField6.setForeground(new
eateEtchedBorder()); jTextField6.setBorder(javax.swing.BorderFactory.cr
java.awt.Font("Tahoma", 1, 14)); jTextField5.setFont(new
jTextField3.setForeground(new java.awt.Font("Tahoma", 1, 14));
eateEtchedBorder()); jTextField5.setBorder(javax.swing.BorderFactory.cr
java.awt.Font("Tahoma", 1, 14)); jTextField7.setForeground(new
jTextField4.setBorder(javax.swing.BorderFactory.cr eateEtchedBorder());
jTextField2.setFont(new java.awt.Font("Tahoma", 1, 14));
eateEtchedBorder()); jTextField10.setBorder(javax.swing.BorderFactory.
createEtchedBorder());
java.awt.Font("Tahoma", 1, 14)); jLabel19.setFont(new java.awt.Font("Arial", 1,
jTextField1.setForeground(new 14));
jTextField1.setBorder(javax.swing.BorderFactory.cr jLabel19.setText("Admission No : ");
jLabel2.setFont(new java.awt.Font("Tahoma",
jTextField8.setFont(new 3, 36)); // NOI18N
java.awt.Font("Tahoma", 1, 14)); jLabel2.setForeground(new
java.awt.Color(51, 0, 0)); jLabel2.setText(" School Management
System");
cmdExit1.setBackground(new .addComponent(jLabel6,
java.awt.Color(204, 204, 255)); javax.swing.GroupLayout.PREFERRED_SIZE, 140,
cmdExit1.setFont(new javax.swing.GroupLayout.PREFERRED_SIZE)))
java.awt.Font("Tahoma", 1, 14)); // NOI18N .addGap(34, 34, 34)
cmdExit1.setText("Exit");
cmdExit1.addActionListener(new .addGroup(layout.createParallelGroup(javax.swing
java.awt.event.ActionListener() { .GroupLayout.Alignment.TRAILING)
public void
actionPerformed(java.awt.event.ActionEvent evt) { .addGroup(layout.createSequentialGroup()
cmdExit1ActionPerformed(evt);
} .addGroup(layout.createParallelGroup(javax.swing
}); .GroupLayout.Alignment.TRAILING)
javax.swing.GroupLayout layout = new .addComponent(jLabel17)
javax.swing.GroupLayout(getContentPane()); .addComponent(jLabel16)
getContentPane().setLayout(layout); .addComponent(jLabel14)
layout.setHorizontalGroup( .addComponent(jLabel15)
layout.createParallelGroup(javax.swing.GroupLayo .addComponent(jLabel13)
ut.Alignment.LEADING) .addComponent(jLabel11)
.addGroup(layout.createSequentialGroup() .addComponent(jLabel10))
.addGap(25, 25, 25)
.addComponent(jLabel2, .addPreferredGap(javax.swing.LayoutStyle.Compo
javax.swing.GroupLayout.PREFERRED_SIZE, 559, nentPlacement.UNRELATED)
.addContainerGap(46, .addGroup(layout.createParallelGroup(javax.swing
Short.MAX_VALUE)) .GroupLayout.Alignment.LEADING, false)
.addGroup(javax.swing.GroupLayout.Alignment.TR .addComponent(jTextField8)
AILING, layout.createSequentialGroup() .addComponent(jTextField7)
.addContainerGap(37, Short.MAX_VALUE) .addComponent(jTextField6)
.addGroup(layout.createSequentialGroup() .addComponent(jTextField3)
.addGroup(layout.createParallelGroup(javax.swing .addComponent(jTextField1,
.GroupLayout.Alignment.LEADING) javax.swing.GroupLayout.PREFERRED_SIZE, 187,
javax.swing.GroupLayout.PREFERRED_SIZE)))
.addGap(15, 15, 15) .addGroup(layout.createSequentialGroup()
.addComponent(jScrollPane1, .addComponent(jLabel19)
javax.swing.GroupLayout.PREFERRED_SIZE)) .addPreferredGap(javax.swing.LayoutStyle.Compo
nentPlacement.UNRELATED)
.addGroup(layout.createSequentialGroup() .addComponent(jTextField10,
.addGap(32, 32, 32) javax.swing.GroupLayout.PREFERRED_SIZE, 187,
javax.swing.GroupLayout.PREFERRED_SIZE))))
javax.swing.GroupLayout.PREFERRED_SIZE) .GroupLayout.Alignment.BASELINE)
.addGroup(javax.swing.GroupLayout.Alignment.TR .addComponent(jTextField1,
AILING, layout.createSequentialGroup() javax.swing.GroupLayout.PREFERRED_SIZE,
.addPreferredGap(javax.swing.LayoutStyle.Compo javax.swing.GroupLayout.PREFERRED_SIZE))
nentPlacement.RELATED, 110, .addGap(10, 10, 10)
.addComponent(cmdUpdate, .addGroup(layout.createParallelGroup(javax.swing
javax.swing.GroupLayout.PREFERRED_SIZE, 116, .GroupLayout.Alignment.BASELINE)
javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jLabel17)
.addGap(27, 27, 27) .addComponent(jTextField2,
.addComponent(cmdExit, javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.PREFERRED_SIZE, 97, javax.swing.GroupLayout.DEFAULT_SIZE,
javax.swing.GroupLayout.PREFERRED_SIZE) javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(29, 29, 29) .addGap(10, 10, 10)
.addComponent(cmdExit1,
javax.swing.GroupLayout.PREFERRED_SIZE) .GroupLayout.Alignment.BASELINE)
.addGap(113, 113, 113))) .addComponent(jLabel16)
.addGap(23, 23, 23)) .addComponent(jTextField3,
); javax.swing.GroupLayout.PREFERRED_SIZE,
layout.setVerticalGroup( javax.swing.GroupLayout.DEFAULT_SIZE,
layout.createParallelGroup(javax.swing.GroupLayo .addGap(10, 10, 10)
.addGroup(layout.createSequentialGroup() .addGroup(layout.createParallelGroup(javax.swing
.addContainerGap() .GroupLayout.Alignment.BASELINE)
.addComponent(jLabel2) .addComponent(jLabel14)
.addGap(26, 26, 26) .addComponent(jTextField4,
.GroupLayout.Alignment.LEADING) javax.swing.GroupLayout.DEFAULT_SIZE,
.addGroup(layout.createSequentialGroup() .addGap(10, 10, 10)
.addGroup(layout.createParallelGroup(javax.swing .addGroup(layout.createParallelGroup(javax.swing
.GroupLayout.Alignment.BASELINE) .GroupLayout.Alignment.BASELINE)
.addComponent(jLabel19) .addComponent(jLabel15)
.addComponent(jTextField10, .addComponent(jTextField5,
javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE,
javax.swing.GroupLayout.PREFERRED_SIZE)) javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(10, 10, 10)
nentPlacement.RELATED) .addGroup(layout.createParallelGroup(javax.swing
.addComponent(jTextField6, .addPreferredGap(javax.swing.LayoutStyle.Compo
javax.swing.GroupLayout.PREFERRED_SIZE, nentPlacement.RELATED)
javax.swing.GroupLayout.PREFERRED_SIZE)) .addGroup(layout.createParallelGroup(javax.swing
.addGap(10, 10, 10) .GroupLayout.Alignment.LEADING)
.addGroup(layout.createParallelGroup(javax.swing .addGroup(layout.createParallelGroup(javax.swing
.GroupLayout.Alignment.BASELINE) .GroupLayout.Alignment.BASELINE)
.addComponent(jLabel13) .addComponent(cmdExit,
.addComponent(jTextField7, javax.swing.GroupLayout.DEFAULT_SIZE, 38,
javax.swing.GroupLayout.PREFERRED_SIZE, Short.MAX_VALUE)
javax.swing.GroupLayout.DEFAULT_SIZE, .addComponent(cmdExit1,
javax.swing.GroupLayout.PREFERRED_SIZE)) javax.swing.GroupLayout.DEFAULT_SIZE, 38,
.addGap(10, 10, 10) Short.MAX_VALUE))
.addComponent(cmdUpdate,
.addGroup(layout.createParallelGroup(javax.swing javax.swing.GroupLayout.DEFAULT_SIZE, 38,
.GroupLayout.Alignment.BASELINE) Short.MAX_VALUE))
javax.swing.GroupLayout.PREFERRED_SIZE, .addGap(21, 21, 21))
);
javax.swing.GroupLayout.PREFERRED_SIZE)) bindingGroup.bind();
.addGap(10, 10, 10)
java.awt.Dimension screenSize =
.addGroup(layout.createParallelGroup(javax.swing java.awt.Toolkit.getDefaultToolkit().getScreenSize(
.GroupLayout.Alignment.BASELINE) );
.addComponent(jLabel10) setBounds((screenSize.width-646)/2,
.addComponent(jTextField9, (screenSize.height-528)/2, 646, 528);
javax.swing.GroupLayout.PREFERRED_SIZE, }// </editor-fold>
javax.swing.GroupLayout.DEFAULT_SIZE, Statement stmt = null;
javax.swing.GroupLayout.PREFERRED_SIZE))) ResultSet rs = null;
String SQL = "SELECT * FROM Student";
.addGap(12, 12, 12) private void
.addComponent(jLabel6) cmdExitActionPerformed(java.awt.event.ActionEv
ent evt) {
nentPlacement.RELATED) jTextField1.setText(null);
.addComponent(jScrollPane1, jTextField2.setText(null);
javax.swing.GroupLayout.PREFERRED_SIZE, 255, jTextField3.setText(null);
javax.swing.GroupLayout.PREFERRED_SIZE))) jTextField4.setText(null);
.addGap(27, 27, 27)
javax.swing.GroupLayout.PREFERRED_SIZE, 21, jTextField5.setText(null);
javax.swing.GroupLayout.PREFERRED_SIZE) jTextField6.setText(null);
jTextField9.setText(null); else
JOptionPane.showMessageDialog(this,"Record
modified Sucessfully");
} } catch (Exception e) {
JOptionPane.showMessageDialog(this,
private void e.getMessage());
cmdUpdateActionPerformed(java.awt.event.Actio }
nEvent evt) { }
try {
Class.forName("com.mysql.jdbc.Driver"); private void
Connection con = (Connection) jList1MouseClicked(java.awt.event.MouseEvent
evt) {
DriverManager.getConnection("jdbc:mysql://local // getSelectedValue() method extracts the
host:3306/school","root","root"); current cursor location value into a variable
stmt = con.createStatement(); String admno = (String)
rs = stmt.executeQuery(SQL); jList1.getSelectedValue();
// Extract the first 4 characters as Member No
int admno = into a variable
Integer.parseInt(jTextField10.getText()); String Mno =admno.trim().substring(0, 2);
String name = jTextField1.getText(); String query = "SELECT * FROM Student
String standard = jTextField2.getText(); WHERE admno = " + (Mno) + ";";
try {
String rollno = jTextField3.getText(); Class.forName("com.mysql.jdbc.Driver").newInsta

String fname = jTextField4.getText(); nce();
String mname = jTextField5.getText(); Connection con = (Connection)
DriverManager.getConnection("jdbc:mysql://local
host:3306/school","root","root");
String address = jTextField6.getText(); // Create SQL statement and execute query.
String city = jTextField7.getText(); stmt = con.createStatement();
String religion = jTextField8.getText(); rs = stmt.executeQuery(query);
String contact = jTextField9.getText();
if (rs.next()) {
int adm = rs.getInt("admno");
String strSQL = "Update student set name String name = rs.getString("name");
='"+(name)+"', standard = '"+(standard)+"', rollno = String standard = rs.getString("standard");
'"+(rollno)+"', fname = '"+(fname)+"', mname = String rollno = rs.getString("rollno");
'"+(mname)+"', address = '"+(address)+"', city = String fname = rs.getString("fname");
'"+(city)+"', religion = '"+(religion)+"', contact = String mname = rs.getString("mname");
String address = rs.getString("address");
"+(contact)+" where admno = " + (admno); String city = rs.getString("city");
String religion = rs.getString("religion");
String contact = rs.getString("contact");
int rowsEffected =
stmt.executeUpdate(strSQL);
if (rowsEffected == 0)
JOptionPane.showMessageDialog(this, // Displaying the contents in respective text
"Record does not exists"); boxes.
jTextField10.setText(""+adm);
jTextField1.setText(name); if (Mno.length() < 4)
jTextField2.setText(standard); {
jTextField3.setText(rollno); int x = Mno.length();
int nl = 4 - x;
while (nl > 0){
jTextField4.setText(fname); Mno = Mno + " ";
jTextField5.setText(mname); nl--;
jTextField6.setText(address); }
jTextField7.setText(city); }
jTextField8.setText(religion); dModel.addElement(Mno+ "- " + Mna);
jTextField9.setText(contact); }
jList1.setModel(dModel);
} catch (Exception e) {
} else {
JOptionPane.showMessageDialog(null, JOptionPane.showMessageDialog(this,e.getMessa
"Record does not found in Student table"); ge());
} e.printStackTrace();
} catch (Exception e) { }
JOptionPane.showMessageDialog(this, }
e.getMessage());
} private void
} cmdExit1ActionPerformed(java.awt.event.ActionE
vent evt) {
private void // TODO add your handling code here:
formWindowGainedFocus(java.awt.event.Window
Event evt) { new menu ().setVisible(true);
jTextField10.setEditable(false); dispose();
// Creating a ListModel object dModel to
perform DefaultListModel }
// method operations
DefaultListModel dModel = (DefaultListModel) /**
jList1.getModel(); * @param args the command line arguments
// Method to add elements into jList1 control */
dModel.clear(); public static void main(String args[]) {
try { java.awt.EventQueue.invokeLater(new
Class.forName("com.mysql.jdbc.Driver"); Runnable() {
Connection con = (Connection) public void run() {
new update().setVisible(true);
DriverManager.getConnection("jdbc:mysql://local }
host:3306/school","root","root"); });
stmt = con.createStatement(); }
rs = stmt.executeQuery(SQL);
while (rs.next()) { // Variables declaration - do not modify
String Mno = rs.getString("admno"); private javax.swing.JButton cmdExit;
String Mna = rs.getString("name"); private javax.swing.JButton cmdExit1;
// To make the Member no. as 4 digit private javax.swing.JButton cmdUpdate;
because we will extract 4 digit from list value private javax.swing.JLabel jLabel10;
// in mouse click event. private javax.swing.JLabel jLabel11;
private javax.swing.JLabel jLabel12; private javax.swing.JTextField jTextField10;
private javax.swing.JLabel jLabel6; private org.jdesktop.beansbinding.BindingGroup
private javax.swing.JList jList1; bindingGroup;
private javax.swing.JScrollPane jScrollPane1; // End of variables declaration
private javax.swing.JSeparator jSeparator2; } // End of variables declaration
DELETE
import java.sql.*; jLabel19 = new javax.swing.JLabel();
import javax.swing.JOptionPane; jLabel2 = new javax.swing.JLabel();
import javax.swing.DefaultListModel; cmdExit1 = new javax.swing.JButton();
public class delete extends javax.swing.JFrame {

setDefaultCloseOperation(javax.swing.WindowCon
/** Creates new form update */ stants.EXIT_ON_CLOSE);
public delete() { setBounds(new java.awt.Rectangle(200, 70, 0,
initComponents(); 0));
}
org.jdesktop.beansbinding.Binding binding =
/** This method is called from within the org.jdesktop.beansbinding.Bindings.createAutoBin
constructor to ding(org.jdesktop.beansbinding.AutoBinding.Upda
* initialize the form. teStrategy.READ_WRITE, this,
* WARNING: Do NOT modify this code. The org.jdesktop.beansbinding.ELProperty.create("Sch
content of this method is ool Management System || www.ezindagi.in ||"),
* always regenerated by the Form Editor. this,
*/ org.jdesktop.beansbinding.BeanProperty.create("ti
@SuppressWarnings("unchecked") tle"));
// <editor-fold defaultstate="collapsed" bindingGroup.addBinding(binding);
desc="Generated Code">
private void initComponents() { addWindowFocusListener(new
bindingGroup = new java.awt.event.WindowFocusListener() {
org.jdesktop.beansbinding.BindingGroup(); public void
windowGainedFocus(java.awt.event.WindowEvent
cmdExit = new javax.swing.JButton(); evt) {
jSeparator2 = new javax.swing.JSeparator(); formWindowGainedFocus(evt);
cmdUpdate = new javax.swing.JButton(); }
jScrollPane1 = new javax.swing.JScrollPane(); public void
jList1 = new javax.swing.JList(); windowLostFocus(java.awt.event.WindowEvent
jLabel11 = new javax.swing.JLabel(); });
jLabel13 = new javax.swing.JLabel(); cmdExit.setBackground(new
jLabel15 = new javax.swing.JLabel(); cmdExit.setFont(new
jLabel17 = new javax.swing.JLabel(); cmdExit.setText("Clear");
jLabel18 = new javax.swing.JLabel(); cmdExit.addActionListener(new
jTextField9 = new javax.swing.JTextField(); java.awt.event.ActionListener() {
jTextField3 = new javax.swing.JTextField(); public void
jTextField4 = new javax.swing.JTextField(); actionPerformed(java.awt.event.ActionEvent evt) {
jTextField2 = new javax.swing.JTextField(); cmdExitActionPerformed(evt);
jTextField1 = new javax.swing.JTextField(); }
cmdUpdate.setBackground(new jLabel14.setForeground(new
cmdUpdate.setFont(new jLabel14.setText("Father's Name : ");
cmdUpdate.setText("Delete"); jLabel15.setFont(new java.awt.Font("Arial", 1,
cmdUpdate.addActionListener(new 14));
java.awt.event.ActionListener() { jLabel15.setForeground(new
public void java.awt.Color(51, 0, 0));
actionPerformed(java.awt.event.ActionEvent evt) { jLabel15.setText("Mother's Name : ");
cmdUpdateActionPerformed(evt);
} jLabel16.setFont(new java.awt.Font("Arial", 1,
}); 14));
jList1.setModel(new DefaultListModel()); java.awt.Color(51, 0, 0));
jList1.addMouseListener(new jLabel16.setText("Roll No. : ");
java.awt.event.MouseAdapter() {
public void jLabel17.setFont(new java.awt.Font("Arial", 1,
mouseClicked(java.awt.event.MouseEvent evt) { 14));
jList1MouseClicked(evt); jLabel17.setForeground(new
}); jLabel17.setText("Class : ");
jScrollPane1.setViewportView(jList1);
jLabel6.setFont(new 14));
java.awt.Font("Helvetica", 1, 15)); jLabel18.setForeground(new
jLabel6.setHorizontalAlignment(javax.swing.Swing jLabel18.setText("Name : ");
Constants.CENTER);
jLabel6.setText("Select a Student"); jTextField9.setFont(new
14)); java.awt.Color(51, 0, 0));
java.awt.Color(51, 0, 0)); jTextField9.setBorder(javax.swing.BorderFactory.cr
jLabel10.setText("Contact No. : "); eateEtchedBorder());
jLabel11.setFont(new java.awt.Font("Arial", 1, jTextField3.setFont(new

14)); java.awt.Font("Tahoma", 1, 14));
jLabel11.setForeground(new jTextField3.setForeground(new
jLabel11.setText("Religion : ");
jLabel12.setFont(new java.awt.Font("Arial", 1, eateEtchedBorder());
14));
jLabel12.setForeground(new jTextField4.setFont(new
java.awt.Color(51, 0, 0)); java.awt.Font("Tahoma", 1, 14));
jLabel12.setText("Local Address : "); jTextField4.setForeground(new
14)); jTextField4.setBorder(javax.swing.BorderFactory.cr
jLabel13.setForeground(new eateEtchedBorder());
jLabel13.setText("City / District : "); jTextField2.setFont(new
14)); java.awt.Color(51, 0, 0));
jTextField2.setBorder(javax.swing.BorderFactory.cr jLabel2.setFont(new java.awt.Font("Tahoma",
eateEtchedBorder()); 3, 36));
jTextField1.setFont(new java.awt.Color(102, 102, 255));
java.awt.Font("Tahoma", 1, 14)); jLabel2.setText(" School Management
jTextField1.setForeground(new System");
cmdExit1.setBackground(new
jTextField1.setBorder(javax.swing.BorderFactory.cr java.awt.Color(204, 204, 255));
eateEtchedBorder()); cmdExit1.setFont(new
jTextField8.setFont(new cmdExit1.setText("Exit");
java.awt.Font("Tahoma", 1, 14)); cmdExit1.addActionListener(new
jTextField8.setForeground(new java.awt.event.ActionListener() {
java.awt.Color(51, 0, 0)); public void
actionPerformed(java.awt.event.ActionEvent evt) {
jTextField8.setBorder(javax.swing.BorderFactory.cr cmdExit1ActionPerformed(evt);
eateEtchedBorder()); }
});
java.awt.Font("Tahoma", 1, 14)); javax.swing.GroupLayout layout = new
jTextField6.setForeground(new javax.swing.GroupLayout(getContentPane());
java.awt.Color(51, 0, 0)); getContentPane().setLayout(layout);
layout.setHorizontalGroup(
eateEtchedBorder()); layout.createParallelGroup(javax.swing.GroupLayo
jTextField5.setFont(new .addGroup(layout.createSequentialGroup()
java.awt.Font("Tahoma", 1, 14)); .addGap(33, 33, 33)
java.awt.Color(51, 0, 0)); .addGroup(layout.createParallelGroup(javax.swing
.GroupLayout.Alignment.LEADING, false)
eateEtchedBorder()); .addGroup(layout.createSequentialGroup()
jTextField7.setFont(new .addGroup(layout.createParallelGroup(javax.swing
java.awt.Font("Tahoma", 1, 14)); .GroupLayout.Alignment.LEADING)
.addGap(15, 15, 15)
jTextField7.setBorder(javax.swing.BorderFactory.cr .addComponent(jScrollPane1,
eateEtchedBorder()); javax.swing.GroupLayout.PREFERRED_SIZE, 171,
java.awt.Font("Tahoma", 1, 14)); .addGroup(layout.createSequentialGroup()
jTextField10.setForeground(new .addGap(32, 32, 32)
java.awt.Color(51, 0, 0)); .addComponent(jLabel6,
jTextField10.setBorder(javax.swing.BorderFactory. javax.swing.GroupLayout.PREFERRED_SIZE)))
createEtchedBorder()); .addGap(34, 34, 34)
jLabel19.setFont(new java.awt.Font("Arial", 1, .addGroup(layout.createParallelGroup(javax.swing

14)); .GroupLayout.Alignment.TRAILING)
jLabel19.setText("Admission No : ");
.addComponent(cmdExit1,
.addGroup(layout.createParallelGroup(javax.swing javax.swing.GroupLayout.PREFERRED_SIZE, 78,
.GroupLayout.Alignment.TRAILING) javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel18) .addGap(140, 140, 140))
.addComponent(jLabel17) .addGroup(layout.createSequentialGroup()
.addComponent(jLabel16) .addGap(25, 25, 25)
.addComponent(jLabel14) .addComponent(jLabel2,
.addComponent(jLabel15) javax.swing.GroupLayout.PREFERRED_SIZE, 559,
.addComponent(jLabel12) javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel13) .addContainerGap(46,
.addComponent(jLabel11) Short.MAX_VALUE))
.addComponent(jLabel10)) );
layout.setVerticalGroup(
nentPlacement.UNRELATED) layout.createParallelGroup(javax.swing.GroupLayo
.addGroup(layout.createParallelGroup(javax.swing .addGroup(layout.createSequentialGroup()
.GroupLayout.Alignment.LEADING, false) .addContainerGap()
.addComponent(jTextField9) .addComponent(jLabel2)
.addComponent(jTextField8) .addGap(28, 28, 28)
.addComponent(jTextField6) .addGroup(layout.createParallelGroup(javax.swing
.addComponent(jTextField5) .GroupLayout.Alignment.LEADING)
.addComponent(jTextField3) .addGroup(layout.createSequentialGroup()
.addComponent(jTextField1, .addGroup(layout.createParallelGroup(javax.swing
javax.swing.GroupLayout.PREFERRED_SIZE, 187, .GroupLayout.Alignment.BASELINE)
javax.swing.GroupLayout.PREFERRED_SIZE))) .addComponent(jLabel19)
.addGroup(layout.createSequentialGroup() javax.swing.GroupLayout.PREFERRED_SIZE,
.addComponent(jLabel19) javax.swing.GroupLayout.DEFAULT_SIZE,
nentPlacement.UNRELATED) .addPreferredGap(javax.swing.LayoutStyle.Compo
.addComponent(jTextField10, nentPlacement.RELATED)
javax.swing.GroupLayout.PREFERRED_SIZE)))) .addGroup(layout.createParallelGroup(javax.swing
.addComponent(jSeparator2, .GroupLayout.Alignment.BASELINE)
javax.swing.GroupLayout.DEFAULT_SIZE, 570, .addComponent(jLabel18)
Short.MAX_VALUE)) .addComponent(jTextField1,
.addContainerGap(27, javax.swing.GroupLayout.PREFERRED_SIZE,
Short.MAX_VALUE)) javax.swing.GroupLayout.DEFAULT_SIZE,
.addGroup(javax.swing.GroupLayout.Alignment.TR .addGap(10, 10, 10)
AILING, layout.createSequentialGroup()
.addContainerGap(143, .addGroup(layout.createParallelGroup(javax.swing
Short.MAX_VALUE) .GroupLayout.Alignment.BASELINE)
.addComponent(cmdUpdate, .addComponent(jLabel17)
javax.swing.GroupLayout.PREFERRED_SIZE) javax.swing.GroupLayout.PREFERRED_SIZE,
.addGap(27, 27, 27) javax.swing.GroupLayout.DEFAULT_SIZE,
.addComponent(cmdExit, javax.swing.GroupLayout.PREFERRED_SIZE))
javax.swing.GroupLayout.PREFERRED_SIZE, 97, .addGap(10, 10, 10)
.addComponent(jLabel16) javax.swing.GroupLayout.DEFAULT_SIZE,
.addComponent(jTextField3, javax.swing.GroupLayout.PREFERRED_SIZE)))
javax.swing.GroupLayout.DEFAULT_SIZE, .addGroup(layout.createSequentialGroup()
javax.swing.GroupLayout.PREFERRED_SIZE)) .addGap(12, 12, 12)
.addGroup(layout.createParallelGroup(javax.swing .addPreferredGap(javax.swing.LayoutStyle.Compo
.GroupLayout.Alignment.BASELINE) nentPlacement.RELATED)
.addComponent(jLabel14) .addComponent(jScrollPane1,
.addComponent(jTextField4, javax.swing.GroupLayout.PREFERRED_SIZE, 255,
javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))
javax.swing.GroupLayout.PREFERRED_SIZE)) .addComponent(jSeparator2,
.addGap(10, 10, 10) javax.swing.GroupLayout.PREFERRED_SIZE, 21,
.GroupLayout.Alignment.BASELINE) .addPreferredGap(javax.swing.LayoutStyle.Compo
.addComponent(jLabel15) nentPlacement.RELATED)
javax.swing.GroupLayout.PREFERRED_SIZE, .addGroup(layout.createParallelGroup(javax.swing
javax.swing.GroupLayout.DEFAULT_SIZE, .GroupLayout.Alignment.LEADING)
.addGroup(layout.createParallelGroup(javax.swing .addComponent(cmdExit,
.GroupLayout.Alignment.BASELINE) javax.swing.GroupLayout.DEFAULT_SIZE, 38,
.addComponent(jLabel12) Short.MAX_VALUE)
.addComponent(jTextField6, .addComponent(cmdExit1,
javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, 38,
javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
javax.swing.GroupLayout.PREFERRED_SIZE)) .addComponent(cmdUpdate,
.addGap(10, 10, 10) javax.swing.GroupLayout.DEFAULT_SIZE, 38,
Short.MAX_VALUE))
.addGroup(layout.createParallelGroup(javax.swing .addGap(19, 19, 19))
.GroupLayout.Alignment.BASELINE) );
.addComponent(jTextField7, bindingGroup.bind();
javax.swing.GroupLayout.DEFAULT_SIZE, java.awt.Dimension screenSize =
javax.swing.GroupLayout.PREFERRED_SIZE)) java.awt.Toolkit.getDefaultToolkit().getScreenSize(
.addGap(10, 10, 10) );
setBounds((screenSize.width-646)/2,
.addGroup(layout.createParallelGroup(javax.swing (screenSize.height-528)/2, 646, 528);
.GroupLayout.Alignment.BASELINE) }// </editor-fold>
.addComponent(jLabel11) Statement stmt = null;
.addComponent(jTextField8, ResultSet rs = null;
javax.swing.GroupLayout.PREFERRED_SIZE, String SQL = "SELECT * FROM Student";
javax.swing.GroupLayout.PREFERRED_SIZE)) private void
.addGap(10, 10, 10) cmdExitActionPerformed(java.awt.event.ActionEv
ent evt) {
.GroupLayout.Alignment.BASELINE) jTextField1.setText(null);
.addComponent(jLabel10) jTextField2.setText(null);
.addComponent(jTextField9, jTextField3.setText(null);
javax.swing.GroupLayout.PREFERRED_SIZE, jTextField4.setText(null);
jTextField5.setText(null); String admno = (String)
jTextField6.setText(null); jList1.getSelectedValue();
jTextField7.setText(null); // Extract the first 4 characters as Member No
jTextField8.setText(null); into a variable
jTextField9.setText(null); String Mno =admno.trim().substring(0, 2);
jTextField10.setText(null); String query = "SELECT * FROM Student
WHERE admno = " + (Mno) + ";";
} try {
private void Class.forName("com.mysql.jdbc.Driver").newInsta

cmdUpdateActionPerformed(java.awt.event.Actio nce();
nEvent evt) { Connection con = (Connection)
try { DriverManager.getConnection("jdbc:mysql://local
Class.forName("com.mysql.jdbc.Driver"); host:3306/school","root","root");
Connection con = (Connection) // Create SQL statement and execute query.
stmt = con.createStatement();
DriverManager.getConnection("jdbc:mysql://local rs = stmt.executeQuery(query);
stmt = con.createStatement(); if (rs.next()) {
rs = stmt.executeQuery(SQL); int adm = rs.getInt("admno");
String name = rs.getString("name");
int admno = String standard = rs.getString("standard");
Integer.parseInt(jTextField10.getText()); String rollno = rs.getString("rollno");
String name = jTextField1.getText(); String fname = rs.getString("fname");
String standard = jTextField2.getText(); String mname = rs.getString("mname");
String rollno = jTextField3.getText(); String address = rs.getString("address");
String fname = jTextField4.getText(); String city = rs.getString("city");
String mname = jTextField5.getText(); String religion = rs.getString("religion");
String address = jTextField6.getText(); String contact = rs.getString("contact");
String city = jTextField7.getText();
String religion = jTextField8.getText();
String contact = jTextField9.getText();
// Displaying the contents in respective text
boxes.
String strSQL = "Delete from student where jTextField10.setText(""+adm);
admno = " + (admno); jTextField1.setText(name);
int rowsEffected = jTextField2.setText(standard);
stmt.executeUpdate(strSQL); jTextField3.setText(rollno);
if (rowsEffected == 0) jTextField4.setText(fname);
JOptionPane.showMessageDialog(this, jTextField5.setText(mname);
"Record does not exists"); jTextField6.setText(address);
else jTextField7.setText(city);
jTextField8.setText(religion);
JOptionPane.showMessageDialog(this,"Record jTextField9.setText(contact);
Deleted Sucessfully");
JOptionPane.showMessageDialog(this, } else {
e.getMessage()); JOptionPane.showMessageDialog(null,
} "Record does not found in Student table");
} }
private void JOptionPane.showMessageDialog(this,
jList1MouseClicked(java.awt.event.MouseEvent e.getMessage());
evt) { }
// getSelectedValue() method extracts the }
current cursor location value into a variable
private void new menu ().setVisible(true);
formWindowGainedFocus(java.awt.event.Window dispose();
Event evt) {
// Creating a ListModel object dModel to
perform DefaultListModel /**
// method operations * @param args the command line arguments
DefaultListModel dModel = (DefaultListModel) */
jList1.getModel(); public static void main(String args[]) {
// Method to add elements into jList1 control java.awt.EventQueue.invokeLater(new
dModel.clear(); Runnable() {
try { public void run() {
Class.forName("com.mysql.jdbc.Driver"); new delete().setVisible(true);
Connection con = (Connection) }
});
DriverManager.getConnection("jdbc:mysql://local }
stmt = con.createStatement(); // Variables declaration - do not modify
rs = stmt.executeQuery(SQL); private javax.swing.JButton cmdExit;
while (rs.next()) { private javax.swing.JButton cmdExit1;
String Mno = rs.getString("admno"); private javax.swing.JButton cmdUpdate;
String Mna = rs.getString("name"); private javax.swing.JLabel jLabel10;
// To make the Member no. as 4 digit private javax.swing.JLabel jLabel11;
because we will extract 4 digit from list value private javax.swing.JLabel jLabel12;
// in mouse click event. private javax.swing.JLabel jLabel13;
if (Mno.length() < 4) private javax.swing.JLabel jLabel15;
{ private javax.swing.JLabel jLabel16;
int x = Mno.length(); private javax.swing.JLabel jLabel17;
int nl = 4 - x; private javax.swing.JLabel jLabel18;
while (nl > 0){ private javax.swing.JLabel jLabel19;
Mno = Mno + " "; private javax.swing.JLabel jLabel2;
nl--; private javax.swing.JLabel jLabel6;
} private javax.swing.JList jList1;
} private javax.swing.JScrollPane jScrollPane1;
dModel.addElement(Mno+ "- " + Mna); private javax.swing.JSeparator jSeparator2;
jList1.setModel(dModel); private javax.swing.JTextField jTextField10;
} catch (Exception e) { private javax.swing.JTextField jTextField2;
JOptionPane.showMessageDialog(this,e.getMessa private javax.swing.JTextField jTextField4;
ge()); private javax.swing.JTextField jTextField5;
e.printStackTrace(); private javax.swing.JTextField jTextField6;
private void private org.jdesktop.beansbinding.BindingGroup
cmdExit1ActionPerformed(java.awt.event.ActionE bindingGroup;
vent evt) { // End of variables declaration
// TODO add your handling code here: }
}
BIBILOGRAPHY
Book: INFORMATICS PRACTICES
Writtten by:
1. Sumita Arora 12th IP
2. Oxford 12th IP

School System File

Uploaded by

Copyright:

Available Formats

School System File

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

School System File

Uploaded by

Copyright:

Available Formats

INFORMATICS

Senior Secondary Examination (AISSCE – 2018-19)

Submitted By: Submitted To:

Sarthak Saurabh sir

(Roll No: _______) (Informatics Practices Teacher)

This is to certify that the project titled “SCHOOL

SYSTEM” submitted by Miss/Master

Sarthak having roll no ________ of CLASS XII

has completed this project for partial rollback in full -

fillment of the requirement for thesenior secondary

examination (AISSCE)embodies the bonafide work

done by him/her under my supervision.

Internal Supervisor External Supervisor

Name : Saurabh Sir Name :

Name of Student : Sarthak

Email Address : [email protected]

Supervisor : Saurabh Sir

Project Title : School System

Front End Tool : JAVA NetBeans

Back End Tool : MySQL

It would be our outmost pleasure to express

His unflagging patience, creativity and

This program is designed for the use

of SchoolManagement Systemand its

functioning Main Objective of this

project to facilitate the transactions

through use of electronic medium.

We use java netbeans 6.5 software

and Mysql to programming our

• It should use the object-oriented programming methodology.

Multithreaded - Java supports handling multiple tasks simultaneously which greatly

High performance- Java performance is impressive for an interpreted language , mainly

Java Magic: The Bytecode

Bytecode is a highly optimized set of instruction designed to be executed by the java

Java Program Java Compiler Virtual Machine

Source code Bytecode

Bytecode Java Interpreter Machine code

Process of converting Bytecode into Machine code

Object Oriented Programming

Object Oriented Programming is an approach that provides a way of modularizing programs

Encapsulation - Wrapping of data and methods into a single unit is known as

Java SE - Java Database Connectivity (JDBC)

Advantages of JDBC Technology :

Leverage Existing Enterprise Data

Simplified Enterprise Development

Zero Configuration for Network Computers

Driver Loads database drivers and manages the

Driver Manager Connection Statement ResultSet

SQL-STRUCTURED QUERY LANGUAGE

• SQL is very readable.

• In SQL we always issue commands.

SQL statements fall into two groups:-

● Select Statements – Statements that return a set of results.

● Everything else – Statements that don’t return a set of results.

Here are some of the quries defined:-

Here are the some of the components used:

● JApplet– Applet that use SWING must be subclass of JApplet.

● JTextFields – Text field is encapsulated by the JTextComponent class which extends

● JCheckBox – It is supported by the JCheckBox class. It is a control that is used to turn an

● JTextArea - Text area is encapsulated by the JTextComponent class which extends