“UNIVERSITY MANAGEMENT SYSTEM”

Project Report

Submitted in partial fulfillment of the requirement for the award of

Degree of

Bachelor of Computer Applications

Submitted to

452 – Catalyst Institute of Management and

Advanced Global Excellence

Submitted By Under Joint Guidance of

Utkarsh Raj Prof. Ravi Kumar Soni &
Registration No. 202245200104 Prof. Niraj Kumar Singh
BCA-3RD Year [Asst. Professor]
Session-2022-2025 Computer Science &
Information Technology
 Catalyst Institute of Management and
Advanced Global Excellence
Department of Computer Science & Information Technology
Session 2022-2025

DATE:…………………

CERTIFICATE
This is to certify that the work embodies in this project entitled,
“University Management System”, being submitted by Utkarsh Raj
(202245200104) in partial fulfillment of the requirement for the award of
“Bachelor of Computer Applications” to PATLIPUTRA UNIVERSITY, PATNA

during the academic year 2022-25 is a record of bonafide piece of work,

carried out by him/her under our/my supervision and guidance in the
“Department of Computer Science & information Technology”,
CIMAGE.

Dr. Neeraj Agrawal Er. Amit Kumar Shukla Prof. Ravi Kumar Soni
Director Head of Department-IT Assistant Professor-IT

Page1|
 Catalyst Institute of Management and Advanced
Global Excellence
Department of Computer Science & Information Technology

Session 2022-2025

Date:

APPROVAL CERTIFICATE
The project report entitled “University Management System”, being submitted by
Utkarsh Raj (202245200104) has been examined by us and is hereby approved for the
award of degree “Bachelor of Computer Applications”, for which it has been submitted.
It is understood that by this approval the undersigned do not necessarily endorse or
approve any statement made, the opinion expressed or conclusion drawn therein, but
approve the project only for the purpose for which it has been submitted.

(Internal Examiner) (External Examiner)

Date: Date:

Page2|
 Catalyst Institute of Management and Advanced
Global Excellence
Department of Computer Science & Information Technology

Session 2022-2025

Date:

DECLARATION

I, Utkarsh Raj hereby declare that the work, which is being presented in the

project report entitled “University Management System” partial

fulfillment of the requirements for the award of degree of “Bachelor of

Computer Applications” submitted in the department of Computer

Science & Information Technology (CIMAGE) is an authentic record of

myown work carried under the joint guidance of Prof. Ravi Kumar Soni Sir

and Prof. Niraj Kumar Singh Sir. I have not submitted the matter

embodied in this report for the award of any other degree.

Utkarsh Raj

Registration No : 202245200104

BCA 3RD Year

Session-2022-2025

Page3|
 ACKNOWLEDGEMENT

“A journey is easier when you travel together. Interdependence is certainly more valuable than
independence.”

I would like to thanks, Prof. Ravi Kumar Soni Sir and Prof. Niraj Kumar Singh Sir, for providing
regular guidance and insight into my project work. I also thank them for all advice he has given me in the
past year, and for always having time for me, whenever I needed.

I give special thanks to Er. Amit Kumar Shukla Sir, Prof. Raju Upadhyay Sir, and Prof. Anjesh
Sir for always being willing to help find solutions to any problems I had with my work.

“The completion of any project depends upon the cooperation, coordination, and combined
efforts of several resources of knowledge, inspiration, and energy”.

I also extend my deepest gratitude to Director, CIMAGE GROUP OF INSTITUITIONS, PATNA,

Dr. Neeraj Agrawal Sir, Dean CIMAGE GROUP OF INSTITUITIONS, PATNA, Dr. Neeraj Kumar Sir and
Centre Head Mrs. Megha Agrawal Ma’am for providing all the necessary facilities and true encouraging
environment to bring out the best in my endeavors.

I express my gratitude and thanks to all the staff members of Computer Science departments for
their sincere cooperation in furnishing relevant information to complete this Project well in time
successfully.

I extend a special word to my friends, who have been a constant source of inspiration throughout
my project work.

Lastly but not least I must express my cordial thank to my parent and family members who gave
me the moral support without that it is impossible to complete my project work. With this note, I thank
everyone for the support.

(Utkarsh Raj)

Registration No : 202245200104

BCA 3rd Year

Session-2022-2025

Page4|
CONTENTS
REPORT.................................................................................................... ……………………………………………...

INTRODUCTION ......................................................................................................................................... 8

OBJECTIVE ............................................................................................................................................... 9

PROJECT CATEGORY JAVA .................................................................................................................. 10

ADVANTAGES OF JAVA ......................................................................................................................... 11

TOOLS/PLATFORM required ................................................................................................................... 13

HARDWARE & SOFTWARE REQUIREMENTS ................................................................................... 13

PROBLEM DEFINITION ............................................................................................................................ 14

REQUIREMENT SPECIFICATIONS ...................................................................................................... 14

PROJECT PLANNING & SCHEDULING ................................................................................................... 14

GANTT CHART ....................................................................................................................................... 16

PERT CHART ........................................................................................................................................... 18

SYSTEM ANALYSIS ....................................................................................................................................... 1

IDENTIFICATION OF NEED ................................................................................................................... 1

FEASIBILITY STUDY ................................................................................................................................ 6

TECHNICAL FEASIBILITY: ...................................................................................................................7

ECONOMICAL FEASIBILITY:...............................................................................................................7

OPERATIONAL FEASIBILITY: ............................................................................................................ 8

ANALYSIS..................................................................................................................................................... 10

DFD ........................................................................................................................................................... 10

MODULE DESCRIPTION ............................................................................................................................ 11

DATA STRUCTURE SNAP SHOT .............................................................................................................. 13

LIST OF REPORTS ...................................................................................................................................... 18

SCOPE AND FUTURE ENHANCEMENT ............................................................................................. 19

IMPLEMENTATION METHODOLOGY ............................................................................................... 19

Page5|
TESTING....................................................................................................................................................... 21
LIMITATIONS AND FURTHER ENHANCEMENTS .............................................................................. 24
SECURITY MECHANISM ........................................................................................................................... 25
SNAPSHOTS ............................................................................................................................................... 26

Page6|
UNIVERSITY MANAGEMENT SYSTEM

Page7|
INTRODUCTION
The “UNIVERSITY MANAGEMENT SYSTEM” has been design with the help of two

powerful programming languages “JAVA” and “MySQL”. The “JAVA” being in the

foreground and the “MySQL” in the background respectively.

The foreground language is favorite today, due to his interactive user interface and

supporting powerful tool for development of interactive software.

The background language is favorite many of the programmers because it offers the

much wanted structured query facility. The MySQL provides high security, as the

database is stored in the logical area called “DB Engine”. As “DB Engine” is created in

the virtual memory and end user cannot access that directly it.

With these thoughts the “UNIVERSITY MANAGEMENT SYSTEM” has been

developed. The “JAVA” gives the interactive look and “MySQL” gives high security.

The “PATLIPUTRA UNIVERSITY” is a big school of our country, it should have high

security. So the “UNIVERSITY MANAGEMENT SYSTEM” has been developed after

brainstorming the needs and requirements of the “PATLIPUTRA UNIVERSITY”.

Page8|
OBJECTIVE

The motive of the project entitled “University Management System” is to

maintain all the record and activities taken place in the administrative
department of the school.

The objectives of this system:

• Maintain the information about students.

• Maintain the details of staff members.

• Maintain the attendance of students.

• Keep the leave record of students as well as teachers.

• Record the fees details.

• Maintain the examination details.

• Provide various reports like fee report, student report etc.

Page9|
PROJECT CATEGORY JAVA

The Java is a programming language originally developed by James Gosling

at Sun Microsystems (which is now a subsidiary of Oracle Corporation) and
released in 1995 as a core component of Sun Microsystems' Java platform.
The language derives much of its syntax from C and C++ but has a simpler
object model and fewer low-level facilities. Java applications are typically
compiled to bytecode (class file) that can run on any Java Virtual Machine
(JVM) regardless of computer architecture. Java is general-purpose,
concurrent, class-based, and object-oriented, and is specifically designed to
have as few implementation dependencies as possible. It is intended to let
application developers "write once, run anywhere". Java is considered by
many as one of the most influential programming languages of the 20th
century, and widely used from application software to web
application.[9][10]

The original and reference implementation Java compilers, virtual machines,

and class libraries were developed by Sun from 1995. As of May 2007, in
compliance with the specifications of the Java Community Process, Sun
relicensed most of their Java technologies under the GNU General Public
License. Others have also developed alternative implementations of these
Sun technologies, such as the GNU Compiler for Java and GNUClasspath.

P a g e 10 |
ADVANTAGES OF JAVA

1. Java is simple: Java was designed to be easy to use and is therefore

easy to write, compile, debug, and learn than other programming
languages. The reason that why Java is much simpler than C++ is
because Java uses automatic memory allocation and garbage collection
where else C++ requires the programmer to allocate memory and to
collect garbage.

2. Java is object-oriented: Java is object-oriented because programming

in Java is centered on creating objects, manipulating objects, and
making objects work together. This allows you to create modular
programs and reusable code.

3. Java is platform-independent: One of the most significant

advantages of Java is its ability to move easily from one computer
system to another.

4. Java is distributed: Distributed computing involves several

computers on a network working together. Java is designed to make
distributed computing easy with the networking capability that is
inherently integrated into it.

P a g e 11 |
5. Java is interpreted: An interpreter is needed in order to run Java
programs. The programs are compiled into Java Virtual Machine code
called bytecode.

6. Java is secure: Java is one of the first programming languages to

consider security as part of its design. The Java language, compiler,
interpreter, and runtime environment were each developed with
security in mind.

7. Java is robust: Robust means reliable and no programming language

can really assure reliability. Java puts a lot of emphasis on early
checking for possible errors, as Java compilers are able to detectmany
problems that would first show up during execution time in other
languages.

8. Java is multithreaded: Multithreaded is the capability for a program

to perform several tasks simultaneously within a [Link] Java,
multithreaded programming has been smoothly integrated into it,
while in other languages, operating system-specific procedures have
to be called in order to enable multithreading.

P a g e 12 |
TOOLS/PLATFORM REQUIRED

Operating System

• Windows , Linux , MacOS.

HARDWARE & SOFTWARE REQUIREMENTS

Hardware Requirements:

• Intel i3 or higher/ Ryzen Processor

• 512 MB RAM

• Min 50 GB Hard Disk

Software Requirements:

• JDK

• SQL Workbench

• Notepad/Editor

• Apache Netbeans

P a g e 13 |
PROBLEM DEFINITION

To maintain the record of students, staffs, fees, and many more, in

order to help the university.

REQUIREMENT SPECIFICATIONS

A Software Requirements Specification (SRS) is a complete description of the

behavior of the system to be developed. It includes a set of use cases that
describe all the interactions the users will have with the software. Use cases
are also known as functional requirements. In addition to use cases, the SRS
also contains non-functional (or supplementary) requirements. Non-
functional requirements are requirements which impose constraints on the
design or implementation (such as performance engineering requirements,
quality standards, or design constraints).

The general requirements of the project are:

• To maintain the admission details.

• To keep track the staff and students details.

• To record attendance of students.

• To keep the leave records.

• To keep the record of fee details.

• To keep the back-up of important data.

PROJECT PLANNING & SCHEDULING

P a g e 14 |
Project planning is part of project management, which relates to the use of
schedules such as Gantt charts to plan and subsequently report progress
within the project environment.

Initially, the project scope is defined and the appropriate methods for
completing the project are determined. Following this step, the durations for
the various tasks necessary to complete the work are listed and groupedinto
a work breakdown structure. The logical dependencies between tasks are
defined using an activity network diagram that enables identification ofthe
critical path. Float or slack time in the schedule can be calculated using
software. Then the necessary resources can be estimated and costs for each
activity can be allocated to each resource, giving the total project cost. At
this stage, the project plan may be optimized to achieve the appropriate
balance between resource usage and project duration to comply with the
project objectives. Once established and agreed, the plan becomes what is
known as the baseline. Progress will be measured against the baseline
throughout the life of the project. Analyzing progress compared to the
baseline is known as earned value management.

The PROJECT SCHEDULE is a calendar that links the tasks

to be done with the resources that will do them. Before a project schedule
can be created, the project manager must have a work breakdown structure
(WBS), an effort estimate for each task, and a resource list with availability
for each resource. If these are not yet available, it may be possible to create
something that looks like a schedule, but it will essentially be a work of
fiction. A project manager’s time is better spent on working with the team to
create a WBS and estimates (using a consensus-driven estimation method
like Wideband Delphi than on trying to build a project schedule without
them. The reason for this is that a schedule itself is an estimate: each date in
the schedule is estimated, and if those dates do not have the buy-in of the
people who are going to do the work, the schedule will almost certainly be
inaccurate.

P a g e 15 |
GANTT CHART

Gantt charts (developed by Henry L. Gantt) are a project control technique

that can be used for several purposes including scheduling, budgeting and
resource planning. A Gantt chart is a bar chart with each bar representing an
activity.

The bars are drawn against a time line. The length of each bar is proportional
to the length of time planned for the activity. Gantt chart can take different
phase depending on their intended use. The Gantt chart of University
Management System is drawn for the time management. The Gantt chart
is drawn below:

P a g e 16 |
 YEAR 2025
11th Nov 1st Dec 16th Dec 1st Jan 16th Jan 1st Feb

Start

ANALYSIS

DESIGN DATABASE(BACKEND)

Design of Front End

Code data base part

Code Part

Report

Write Manual

Integration & Testing

Finish

P a g e 17 |
PERT CHART

PERT (Project Evaluation and Review Technique) charts consist of a

network of boxes and arrows. The boxes represent activities and the arrows
represent task dependencies.

PERT is organized by events and activities or tasks. PERT have more

advantages and they are likely to be used for more complex projects.
Through PERT chart the various task paths are defined. PERT enables the
calculation of critical path. Each path consists of combination of tasks, which
must be completed. The time and the cost associated with each task along a
path are calculated, and the path that requires the greatest amount of
elapsed time is the critical path. Calculation of the critical path enables
project manager to monitor this series of task more closely than others to
shift resources to it, if it begins to fall behind schedule.

PERT controls time and cost during the project and also facilitate
finding the right balance between completing a project on time and
completing it within the budget. There are thus not one but many critical
paths, depending on the permutations of the estimates for each task. This
makes analysis of critical path in PERT charts very complex. The PERT chart
representation of the University Management System is shown below.

16th Dec 1st Jan 16th Jan 1st Feb

Analysis Design Code P a g e 18 |

Integrate
Part Part Database and Test
Part
11th Nov
SYSTEM ANALYSIS

IDENTIFICATION OF NEED

To Important Indication for software we use the Principles of

Requirement Engineering. Requirement engineering provides the
appropriate mechanism for understanding what the customer wants,
analyzing need, assessing feasibility, negotiating a reasonable solution,
specifying the solution unambiguously, validating the specification and
managing the requirement as they are transformed into an operational
system. The requirement engineering process can be described in five
distinct steps:

Requirement elicitation.

Requirement analysis & negotiation.

Requirement specification.

System Modeling.

Requirement validation.

Requirement Management.

Page1
 In other words we can say that requirement analysis is a software
task that bridges the gap between system level requirement engineering
and software design.

Requirement analysis allows the software engineering to refine

the software allocation and build models of the data, functional and
behavioral domains that will be treated by software. Requirement
analysis provides the software designer with a representation of
information, function and behavior that can be translated into data,
architectural, interface and component level design; finally the
requirement specification provides the developer and the customer with
the means to assess quality once software is built.

The most commonly used requirement elicitation technique is to

conduct a meeting or interview. The first meeting between a software
engineer and customer can be likened to the awareness of a first date
between to adolescents. Neither person knows what to

say or ask; Both are worried that what they do say will bemisinterpreted;
both are thinking about where it might lead (Both likely have radically
different expectation here); Both want to get the think over with, but at
the same time, both want it to be a success.

Here according to this principle the analyst starts by asking

context-free-questions. That is a set of question that will lead to a basic
understanding of the problem, the people who want a solution, the
nature of solution that is desired, and the effectiveness of the first

Page2
encounter itself. The first set of Context-free question focuses on the
customer, the overall goals, and the benefits. For example, the analyst
might ask: -

Who is behind the request for this Work?

Who will use the solution?

What will be economic benefit of a successful solution?

Is there another source for the solution that you need?

The next set of questions enables the software engineer to gain a

better Understanding of the problem and the customer to voice his or
her perceptions about a solution: -

How would you characterize “good” output that would be generated by

a successful solution?

What problem(s) will this solution address?

Can you show me (or describe) the environment in which the solution
will be used?

Will special performance issues or constraints affect the way the

solution is approached?

The final set of question focuses on the effectiveness of the meeting:

Page3
Are you the right person to answer these questions? Are your answers?
Official”?

Are my questions relevant to the problem that you have?

Am I asking too many questions?

Can anyone else provide additional information?

Should I be asking you anything else?

According to the above concepts I went to institution and met its

staffs, management, and some persons related with the organizational
work, which advised me related with my project such as details of agent,
policy related information will be cater this system.

Preliminary Investigation: -

The first step in the system development life cycle is the

preliminary investigation to determine the feasibility of the System. The
purpose of the preliminary investigation is to evaluate projectrequests.
It is not a design study nor does it includes the collection of details top
describe the business system in all respect. Rather, it is collecting of
information that helps committee members to evaluate the merits of the
project request and make an informed judgment about the feasibility of
the proposed project.

Page4
 Here for the Ngo Management System, I have worked on the
preliminary investigation that accomplished the following objectives: -

Clarify and understand the project request.

Determine the size of the project.

Assess costs and benefits of alternative approaches.

Determine the technical and operational; feasibility of alternative

approaches.

Report the findings to management, with recommendation outlining

the acceptances or rejection of the proposal.

Considering above criteria I also keep in mind that the

requirements are clearly understandable when the clarification of
project request is enquired. The data of the Ngo Management System,
which are collected by me during preliminary investigation, are through
Reviewing organization Documents Onsite observation and

Conducting interviews.

Page5
FEASIBILITY STUDY

Not everything imaginable is feasible, not even in software, even as it

may appear to outsiders. Feasibility is the determination of whether or
not a project is wrong doing. On the contrary, software feasibility has
seven solid dimensions as below: -

• Technical feasibility.
• Operational feasibility.
• Economic feasibility.
• Social feasibility.
• Management feasibility.
• Legal feasibility.
• Time feasibility.

The process followed in making this determination is called a

feasibility study. The type of study determines if a project can and should
be taken. Once it has been determined that a project is feasible, that
analyst can go ahead and prepare the project specification which
finalizes project requirements. Generally, feasibility studies are
undertaken within tight time constraints and normally culminate in a
written and oral feasibility report. The contents and recommendation of
such a study will be used as a sound basis for deciding whether to
proceed, postpone or cancel the project. Thus, since the feasibility study
may lead to the commitment of large resources, it becomes

Page6
necessary that it should be conducted competently and that no
fundamental errors of judgment are made.

In other words we can say that a feasibility study is conducted to select

the best system that meets performance requirement. This contains and
identification description, an evaluation of candidate system and the
selection of best system for the job. The system required a statement of
constraints; the identification of specific system objective and a
description of outputs define performance.

TECHNICAL FEASIBILITY: -

Technical feasibility is concerned with specifying equipment and

software that will successfully satisfy the user requirements. My project
is fit in technical feasibility because it requires neither toomuch heavy
configuration system for its run nor in its development.

Following hardware and software components are used in the

development of proposed system.

The same configuration system is also meets all the requirements

to run or for implements to run or for implementation of the system.
Though I have also tested this software for that systems whose
configuration is lower than the above specified

ECONOMICAL FEASIBILITY: -

Economic analysis is the most frequently used technique for

evaluation of the effectiveness of a proposed system. More commonly

Page7
known as Cost/Benefit analysis, the procedure is to determine the
benefits and saving that are expected from a proposed system and
compare them with costs. If benefits outweigh costs, a decision is taken
to design and implement the system. Other weight costs, a decision is
taken to design and implement the system. Otherwise, further
justification or alternative in the proposed system will have to be made
if is to have a chance of being approved. This is an ongoing effort that
improves in accuracy at each phase of the system life cycle.

Before establishing Economical Feasibility so as to justify the

expenses that different organization working under this category has to
bear for this Software. It is crystal clear that the user or Customer ofthis
Software has no need to invest heavy amount for this software. As my
project has been written in such a language, which is a platform
Independent. It has also the feature of WORM. It means it possess the
technology of Write Once & Read Many.

There is no any heavy expense on the maintenance of this

Software. Also there is no need to expense a heavy amount on the set of
“Very Expert Personals” because it is very easy and user-friendly
software. It is fully tighten protection of Secret Password and User Name
for unauthorized access of this Software.

For different types of Process or Operation, Reports or Query

and Output also, there is no need of heavy expenditure.

OPERATIONAL FEASIBILITY: -

Page8
 My project is also fit in Operational Feasibility Study. As I have
explained before this about Technical Feasibility and Economical
Feasibility, this Software is very easy and user-friendly.

I have used a very easy menu system and also used some controlbuttons
in the easy way by which one can choose the options on his desire.

Though this is fully protected with the security by word (Password

and user name), if both are matched only then one can get access of this
software.

Various Reports, Forms and Queries can be generated on the

fingertips for the user.

In nutshell we can say that it has following operational features:

1. It is User-Friendly.
2. It is having less paperwork.
3. Efficient tractability.
4. Query can be generated.
5. Various Reports and Forms can be generated.
6. Fully protected by Password and User name for unauthorized
access.

Page9
ANALYSIS

System Analysis refers into the process of examining a situation

with the intent of improving it through better procedures and methods.
System Analysis is the process of planning a new System to either
replace or complement an existing system.
DFD
The DFD is an excellent communication tool for analysts to model processes and functional
requirements. Used effectively, it is a useful and easy to understand modeling tool. It has broad application

ENQURY DETAIL
FACULTY
View/Delete
FEE DETAIL

UNIVER
STUDENT REGISTRATION
Department SITY

Add/Update
View/ Print
STUDENT DETAILS
REPORT

STUDENT REGISTRATION OPERATOR GENERATE REPORT

P a g e 10
MODULE DESCRIPTION

These are the following Modules in the project:-

1. STUDENT :- This module is used for the information about the

students through which it can be considered for particular student
information as roll_no, address, course, admission status etc. In
this module admission, student record updation etc happen.

2. FACULTY :- This module consists, the information about faculty

(working members) in the university.

3. ATTENDANCE :- This module keep the record of student’s attendance

on daily basis.

4. LEAVE :- This module keep the leave records of students as well as

teachers.

5. FEE : - This module maintains the information of student’s

Course fee.

6. SETTING :- It is necessary to maintain the security level by

implementing the concept of user authentication checking. The
security module deals with user authentication and security
measures. In which the user login id and password is used to
secure & maintain the protection feature.
P a g e 11
7. REPORT :-This module is used to view or print different type of
Report like admission details, fee details etc.

P a g e 12
 DATA STRUCTURE SNAP SHOT

DATA DICTIONERY:- The data dictionary stores description of

data items and structures, as well as systems processes. Data dictionary
used for database design in this project is mentioned. Care was taken
during the database design for future expansion of university’s need.

User_ Details (Login)

Student Details

P a g e 13
Teacher Details

Attendance

P a g e 14
Student Leave

Teacher Leave

P a g e 15
Subject

Marks

P a g e 16
FEE

COLLEGE FEE

P a g e 17
LIST OF REPORTS

The following reports will be generated:

1. Registration: - This report contains the information of all

registered students of the school.

2. Fee: - In this report, the fee details will be displayed.

P a g e 18
SCOPE AND FUTURE ENHANCEMENT

There is always a scope of betterment and the candidate system

is not against perception. The project uses very nearly the same
calculations as university does; if clients want any other type of changes
it can also be done because the project is upgradeable.

The project can be used as a sub-project for any other projects. The main
future scope is as follows:-

🞛 To Store the large amount of data for future point of view.

🞛Reducing manual efforts for maintain the system.

🞛 Reducing the lead time.

🞛It gives correct information about Student details, Staff details, Fee
etc.

IMPLEMENTATION METHODOLOGY

Implementation of a tested system is done on the actual location

with the actual hardware, Software and manpower platforms or

P a g e 19
limitation. To implement of this software, the followings are the necessary:

This project run on internet or intranet , so I have to selectedinternet

supportive software. For implementing this software a web- server is
required . I have to install IIS(internet information service). Know this
project is web-based so it will need a web-browser which will act as its
interface, so for this project install a web-browser capableof providing
proper interface to this project such as internet Explorer/mozilla
Firefox/opera e.t.c and many other [Link] for back-end operation
,I have to install SQL Workbench which handle all the work related to
database query and updation as required by the sostware. In future also
use better databases. We know that this project will be developed on
heavy platform JAVA , so there is requirement of advance processer and
proper RAM and other advance Hardware configuration.

✓ Create separate user for this application: A user with the password
is to be created for storing the data in a separate place. Storing
data under separate user will protect the data. SQL Workbench
can be used for creating the said username and password.
✓ Create required tables: The structure of tables required for this
project (Detail given in the data base design section) is to be
created in the said user. The SQL statement CREATE can be used
for creating such tables.

P a g e 20
 ✓ Create Distributable set of files: An installation package of the
software is to be built for implementation of the project at desired
location.

TESTING

Software testing consists of the following stages.

a) TEST PLAN DEVELOPMENT:-

The importance of software testing and its implications need not

be emphasized. Software testing is a critical element of software quality
assurance and represents the ultimate review of specifications, design
and coding. The main objective of testing is to uncover a host oferrors,
systematically, with minimum effort and time. It improves the reliability
of the software.

b) TESTING STRATEGY:-

A testing strategy explains how to conduct a test to uncover all the errors
with minimum possible time and effort. It should be flexible enough to
promote customization that may be necessary in due course of
development process.

c) UNIT TESTING:-

Unit testing focuses verification effort on the smallest unit of software

module using the detailed design criteria. Process specifications testing
are done to uncover errors within the boundaries of the module. All

P a g e 21
modules must be successful in the unit test before start of the
integration testing. The software developed for e-banking is tested
module wise by giving normal values and extreme values as input. All
the bugs have been identified and removed. The software designed is
tested module wise. Before using the software, an employee has to give
organization name and password.

In the next stage he has to provide division name, employee ID and

password. If any of this information is wrong, the system gives an error
message- “invalid user and password”

INTEGRATION TESTING:-

It is a systematic technique for constructing different program module

in to an integrated software structure. This test uncovers the errors
during integration process. The integration aspect is tested after
integrating all the modules and validated.

VALIDATION TESTING:-

After the culmination of integration testing the software is ready as

per the specification. But it has to be validated as per the specification
and to uncover the unexpected future errors and to improve its
reliability. The random value and boundary values as input is fed to the
software developed and studied the software performance andvalidated

P a g e 22
TEST CASE DESIGN

The techniques that are used in deriving the test cases are explained
below.

CONDITION TESTING:-

Condition testing is a test case design method that exercises the

logical conditions contained in the program. The possible components
in a condition statement are a Boolean operator, Boolean variable,
relational operator, arithmetic expression and parenthesis.

BOUNDARY VALUE ANALYSIS:-

Boundary value analysis leads to the selection of test cases that

exercise the boundary conditions or boundary values. It is observed that
a large number of errors tend to appear at the boundaries of the input
domain than in the [Link] boundary condition is tested by inserting
values beyond specification/availability of project allocations. [Link]
software is tested by giving more amount of money in the indent form
than available in the budget. Under this conciliation the software gives
an error message stating that insufficient fund.

EQUIVALENCE PARTITIONING:-

Equivalence portioning is a black box testing method that

divides the input domain of a program into classes of data from which

P a g e 23
test cases can be derived. A typical test uncovers a class errors might
otherwise require many more test cases before the error is observed.
Equivalence classes for input determine the valid and invalid inputs for
the program

LIMITATIONS AND FURTHER ENHANCEMENTS

LIMITATIONS:

Despite tremendous growth potentialities continues with a series of

challenges and contradictions in its implementations. The main
shortcomings are mentioned below.

• Easy transaction of money.

• Reliability of electronic payment system.
• Accounting, legal, taxation and security issues etc.

RECOMMENDED AREAS FOR FURTHER RESEARCH

Considering the fact that has already gone ahead the following areas
needs to be further probed for improving the system to meet the
changing scenario.

1) There is a lot of scope for future research in the areas like

automatic component/material planning, automatic advanced

P a g e 24
 indenting, micro transactions, and customer relationship
management.

2) Components like electronic payment system, digital certificates,

electronic tokens, electronic cheques etc. are still in an embryonic
stage of development. This area opens up a lot of scope for further
research.

In the absence of universal standards for electronic transactions, the

organization should develop a standard internal to it and that translate
between its formats and those supported by its trading partners. This
approach reduces dependence on industry schedules for adopting
standards, and avoids the pitfalls of an organization-imposed solution.

SECURITY MECHANISM

Implementation of security is a key issue in any software

development different application use different kind of security
mechanism according to their [Link] Ngo Management Systemthe
implementation of security has been confined up to the user level. The
“Ngo Management System” authenticates a user by its username and

P a g e 25
password to a user. A user is able to work on the software if she/he is an
authorized user with user id and password.

It is the system administrator who is responsible for granting

permission to any user. He can grant as well as revoke permissions from
any [Link] important security level is data level. In the data level
security defined validation and constraints in the database. Due to this
only valid data can be entered in the tables.

All information and management forms are stored within the

system, and access to this sensitive information is controlled through an
effective authentication system: one has to know the USER ID, and
PASSWORD to gain access to any of the information.

The management (administrator) can create new user, while a

normal user can’t do this. This system will provide the facility to change
the password according to the user need. For security measure the
‘Password’ field will be taken as ‘Varchar2’ data type, so that a user can
use in this field both integer and alphabets.

SNAPSHOTS

P a g e 26
SIGN UP FORM([Link])

Code for sign up page:

package [Link];

import [Link].*;
import [Link].*;
import [Link].*;
import [Link].*;

public class Signup extends JFrame implements ActionListener {

JButton signup, cancel;

JTextField tfUsername, tfPassword, tfConfirmPassword;

Signup() {
setTitle("Signup Page");
getContentPane().setBackground([Link]);
setLayout(null);

ImageIcon i1 = new ImageIcon([Link]("icons/[Link]"));

Image i2 = [Link]().getScaledInstance(100, 100, Image.SCALE_DEFAULT);
ImageIcon i3 = new ImageIcon(i2);
JLabel image = new JLabel(i3);
[Link](350, 50, 100, 100);
add(image);

JLabel user = new JLabel("Username");

[Link](40, 20, 100, 20);
P a g e 27
 add(user);

tfUsername = new JTextField();

[Link](150, 20, 150, 20);
add(tfUsername);

JLabel pass = new JLabel("Password");

[Link](40, 70, 100, 20);
add(pass);

tfPassword = new JPasswordField();

[Link](150, 70, 150, 20);
add(tfPassword);

JLabel confirmPass = new JLabel("Confirm Password");

[Link](40, 120, 120, 20);
add(confirmPass);

tfConfirmPassword = new JPasswordField();

[Link](150, 120, 150, 20);
add(tfConfirmPassword);

signup = new JButton("Signup");

[Link](40, 170, 120, 30);
[Link](this);
[Link]([Link]);
[Link]([Link]);
[Link](new Font("Algerian", [Link], 20));
add(signup);

cancel = new JButton("Cancel");

[Link](180, 170, 120, 30);
[Link](this);
[Link]([Link]);
[Link]([Link]);
[Link](new Font("Algerian", [Link], 20));
add(cancel);

setSize(520, 270);
setLocation(600, 300);
setVisible(true);
}

@Override
public void actionPerformed(ActionEvent ae) {
if ([Link]() == signup) {
String username = [Link]();
String password = [Link]();

P a g e 28
 String confirmPassword = [Link]();

// Validate username
if (!validateUsername(username)) {
[Link](null, "Username must start with a capital letter and can only contain
letters and @.");
return;
}

// Validate password
if (!validatePassword(password)) {
[Link](null, "Password must contain at least 8 characters, including the special
character '@'.");
return;
}

if ([Link](confirmPassword)) {
try {
// Check if the username already exists
String queryCheck = "SELECT * FROM login WHERE username = '" + username + "'";
Conn c = new Conn();
ResultSet rs = [Link](queryCheck);

if ([Link]()) {
[Link](null, "Username already exists!");
} else {
// Insert the new user into the database
String queryInsert = "INSERT INTO login (username, password) VALUES ('" + username + "', '" +
password + "')";
int result = [Link](queryInsert);

if (result > 0) {
[Link](null, "Signup successful!");
setVisible(false);
new Login(); // Redirect to login screen
} else {
[Link](null, "Signup failed! Please try again.");
}
}
} catch (Exception e) {
[Link]();
}
} else {
[Link](null, "Passwords do not match!");
}
} else if ([Link]() == cancel) {
setVisible(false);
}

P a g e 29
 }

// Username validation: Starts with capital letter, contains only letters and '@'
private boolean validateUsername(String username) {
String usernamePattern = "^[A-Z][A-Za-z@]+$";
return [Link](usernamePattern);
}

// Password validation: At least 8 chars, includes '@'

private boolean validatePassword(String password) {
String passwordPattern = "^(?=.*[@])(?=.{8,}).*$";
return [Link](passwordPattern);
}

public static void main(String[] args) {

new Signup();
}
}

LOGIN FORM ([Link])

code for login page :-

package [Link];
P a g e 30
import [Link].*;
import [Link].*;
import [Link].*;
import [Link].*;

public class Login extends JFrame implements ActionListener {

JButton login, cancel, changePassword; // Added changePassword button

JTextField tfuser, tpass;

Login() {
setTitle("Login Page");
getContentPane().setBackground([Link]);

JLabel user = new JLabel("Username");

[Link](40, 20, 100, 20);
add(user);

tfuser = new JTextField();

[Link](150, 20, 150, 20);
add(tfuser);

JLabel pass = new JLabel("Password");

[Link](40, 70, 100, 20);
add(pass);

setLayout(null);
tpass = new JPasswordField();
[Link](150, 70, 150, 20);
add(tpass);

login = new JButton("Login");

[Link](40, 140, 120, 30);
[Link](this);
[Link]([Link]);
[Link]([Link]);
[Link](new Font("Algerian", [Link], 20));
add(login);

cancel = new JButton("Cancel");

[Link](180, 140, 120, 30);
[Link](this);
[Link]([Link]);
[Link]([Link]);
[Link](new Font("Algerian", [Link], 20));
add(cancel);

P a g e 31
 // Adding Change Password Button
changePassword = new JButton("Change Password");
[Link](100, 180, 150, 30);
[Link](this);
[Link]([Link]);
[Link]([Link]);
[Link](new Font("Algerian", [Link], 10));
add(changePassword);

ImageIcon i1 = new ImageIcon([Link]("icons/[Link]"));

Image i2 = [Link]().getScaledInstance(250, 200, Image.SCALE_DEFAULT);
ImageIcon i3 = new ImageIcon(i2);
JLabel image = new JLabel(i3);
[Link](350, 20, 200, 200);
add(image);

setSize(600, 300);
setLocation(500, 250);
setVisible(true);
}

@Override
public void actionPerformed(ActionEvent ae) {
if ([Link]() == login) {
String username = [Link]();
String password = [Link]();

String query = "Select * from login where username = '" + username + "'and password = '" + password + "'";
try {
Conn c = new Conn();
ResultSet rs = [Link](query);

if ([Link]()) {
setVisible(false);
new Project();
} else {
[Link](null, "Invalid username or password");
setVisible(false);
}
} catch (Exception e) {
[Link]();
}
} else if ([Link]() == cancel) {
setVisible(false);
} else if ([Link]() == changePassword) {
// Open Change Password Window
new ChangePassword();
}

P a g e 32
 }

public static void main(String[] args) {

new Login();
}
}

// New class to handle password change

class ChangePassword extends JFrame implements ActionListener {

JTextField tfOldPassword, tfNewPassword, tfConfirmPassword;

JButton submit, cancel;

ChangePassword() {
setTitle("Change Password");
getContentPane().setBackground([Link]);

JLabel oldPasswordLabel = new JLabel("Old Password:");

[Link](40, 20, 120, 20);
add(oldPasswordLabel);

tfOldPassword = new JPasswordField();

[Link](160, 20, 150, 20);
add(tfOldPassword);

JLabel newPasswordLabel = new JLabel("New Password:");

[Link](40, 70, 120, 20);
add(newPasswordLabel);

tfNewPassword = new JPasswordField();

[Link](160, 70, 150, 20);
add(tfNewPassword);

JLabel confirmPasswordLabel = new JLabel("Confirm Password:");

[Link](40, 120, 120, 20);
add(confirmPasswordLabel);

tfConfirmPassword = new JPasswordField();

[Link](160, 120, 150, 20);
add(tfConfirmPassword);

submit = new JButton("Submit");

[Link](40, 170, 120, 30);
[Link](this);
[Link]([Link]);
[Link]([Link]);
[Link](new Font("Algerian", [Link], 15));
add(submit);

P a g e 33
 cancel = new JButton("Cancel");
[Link](180, 170, 120, 30);
[Link](this);
[Link]([Link]);
[Link]([Link]);
[Link](new Font("Algerian", [Link], 15));
add(cancel);

setLayout(null);
setSize(400, 250);
setLocation(600, 300);
setVisible(true);
}

@Override
public void actionPerformed(ActionEvent ae) {
if ([Link]() == submit) {
String oldPassword = [Link]();
String newPassword = [Link]();
String confirmPassword = [Link]();

if ([Link](confirmPassword)) {
try {
String query = "UPDATE login SET password = '" + newPassword + "' WHERE password = '" +
oldPassword + "'";
Conn c = new Conn();
int result = [Link](query);

if (result > 0) {
[Link](null, "Password Changed Successfully!");
setVisible(false);
new Login(); // Go back to login screen
} else {
[Link](null, "Incorrect Old Password");
}
} catch (Exception e) {
[Link]();
}
} else {
[Link](null, "New Password and Confirm Password do not match!");
}
} else if ([Link]() == cancel) {
setVisible(false);
}
}
}

P a g e 34
MAIN FORM ([Link]) :

code :

package [Link];
import [Link].*;
import [Link].*;
import [Link].*;

public class Project extends JFrame implements ActionListener{

Project(){
setSize(1500,800);

ImageIcon i1 = new ImageIcon([Link]("icons/[Link]"));

Image i2 = [Link]().getScaledInstance(1500, 750, Image.SCALE_DEFAULT);
ImageIcon i3 = new ImageIcon(i2);
JLabel image = new JLabel(i3);
add(image);

JMenuBar mb = new JMenuBar();

// New Information
JMenu newInfo = new JMenu("New Information");

P a g e 35
[Link]([Link]);
[Link](newInfo);

JMenuItem facultyInfo = new JMenuItem("New Faculty Information");

[Link]([Link]);
[Link](this);
[Link](facultyInfo);

JMenuItem studentInfo = new JMenuItem("New Student Information");

[Link]([Link]);
[Link](this);
[Link](studentInfo);

// Details
JMenu details = new JMenu("View Details");
[Link]([Link]);
[Link](details);

JMenuItem facultyDetails = new JMenuItem("View Faculty Details");

[Link]([Link]);
[Link](this);
[Link](facultyDetails);

JMenuItem studentDetails = new JMenuItem("View Student Details");

[Link]([Link]);
[Link](this);
[Link](studentDetails);

JMenu attendance = new JMenu("Attendance");

[Link]([Link]);
[Link](attendance);

JMenuItem att = new JMenuItem("Attendance");

[Link](this);
[Link]([Link]);
[Link](att);

// Leave
JMenu leave = new JMenu("Apply Leave");
[Link]([Link]);
[Link](leave);

JMenuItem facultyLeave = new JMenuItem("Faculty Leave");

[Link]([Link]);
P a g e 36
[Link](this);
[Link](facultyLeave);

JMenuItem studentLeave = new JMenuItem("Student Leave");

[Link]([Link]);
[Link](this);
[Link](studentLeave);

// Leave Details
JMenu leaveDetails = new JMenu("Leave Details");
[Link]([Link]);
[Link](leaveDetails);

JMenuItem facultyLeavedetails = new JMenuItem("Faculty Leave Details");

[Link]([Link]);
[Link](this);
[Link](facultyLeavedetails);

JMenuItem studentLeavedetails = new JMenuItem("Student Leave Details");

[Link]([Link]);
[Link](this);
[Link](studentLeavedetails);

// Exams
JMenu exam = new JMenu("Examination");
[Link]([Link]);
[Link](exam);

JMenuItem examdetail = new JMenuItem("Examination Result");

[Link]([Link]);
[Link](this);
[Link](examdetail);

JMenuItem entermarks = new JMenuItem("Enter Marks");

[Link]([Link]);
[Link](this);
[Link](entermarks);

// Update
JMenu update = new JMenu("Update Details");
[Link]([Link]);
[Link](update);

JMenuItem updatefaculty = new JMenuItem("Update Faculty Details");

P a g e 37
[Link]([Link]);
[Link](this);
[Link](updatefaculty);

JMenuItem updatestudent = new JMenuItem("Update Student Details");

[Link]([Link]);
[Link](this);
[Link](updatestudent);

// Fee
JMenu fee = new JMenu("Fee Details");
[Link]([Link]);
[Link](fee);

JMenuItem feestructure = new JMenuItem("Fee Structure");

[Link]([Link]);
[Link](this);
[Link](feestructure);

JMenuItem feeform = new JMenuItem("Student Fee Form");

[Link]([Link]);
[Link](this);
[Link](feeform);
setJMenuBar(mb);

// Utility
JMenu utility = new JMenu("Utility");
[Link]([Link]);
[Link](utility);

JMenuItem notepad = new JMenuItem("Notepad");

[Link](this);
[Link]([Link]);
[Link](notepad);

JMenuItem calc = new JMenuItem("Calculator");

[Link](this);
[Link]([Link]);
[Link](calc);

// about
JMenu about = new JMenu("About");
[Link]([Link]);
[Link](about);
P a g e 38
 JMenuItem ab = new JMenuItem("About");
[Link](this);
[Link]([Link]);
[Link](ab);

// Exit
JMenu exit = new JMenu("Exit");
[Link]([Link]);
[Link](exit);

JMenuItem logout = new JMenuItem("Logout");

[Link](this);
[Link]([Link]);
[Link](logout);

JMenuItem ex = new JMenuItem("Exit");

[Link](this);
[Link]([Link]);
[Link](ex);

setVisible(true);
}
@Override
public void actionPerformed(ActionEvent e){
String msg = [Link]();

if ([Link]("Logout")){
[Link](null, "Do you really want to
logout","Select",JOptionPane.YES_NO_CANCEL_OPTION);
setVisible(false);
new Login().setVisible(true);
}else if([Link]("Exit")){
[Link](null, "Are you sure to close the
application","Select",JOptionPane.YES_NO_CANCEL_OPTION);
setVisible(false);
} else if([Link]("Calculator")){
try{
[Link]().exec("[Link]");
}catch (Exception ae){

}
}else if([Link]("Notepad")){
try{
P a g e 39
 [Link]().exec("[Link]");
}catch (Exception ae){

}
}else if([Link]("New Faculty Information")){
new AddTeacher();
}else if([Link]("New Student Information")){
new AddStudent();
}else if([Link]("View Faculty Details")){
new TeacherDetails();
}else if([Link]("View Student Details")){
new StudentDetails();
}else if([Link]("Attendance")){
new Attendance();
}else if([Link]("Student Leave")){
new StudentLeave();
}else if([Link]("Faculty Leave")){
new TeacherLeave();
}else if([Link]("Student Leave Details")){
new StudentLeaveDetails();
}else if([Link]("Faculty Leave Details")){
new TeacherLeaveDetails();
}else if([Link]("Update Student Details")){
new UpdateStudent();
}else if([Link]("Update Faculty Details")){
new UpdateTeacher();
}else if([Link]("Enter Marks")){
new EnterMarks();
}else if([Link]("Examination Result")){
new ExaminationDetails();
}else if([Link]("Fee Structure")){
new FeeStructure();
}else if([Link]("About")){
new About();
}else if([Link]("Student Fee Form")){
new StudentFeeForm();
}
}
public static void main(String []args){
new Project();
}
}

P a g e 40
Student form :

code :

package [Link];
import [Link].*;
import [Link].*;
import [Link].*;
import [Link];
import [Link].*;

public class AddStudent extends JFrame implements ActionListener{

JTextField tfname,tffname,tffaddress,tfphone,tfemail,tfx,tfxii,tfgraduate,tfaadhar;
JLabel lbroll;
JDateChooser dcdob;
JComboBox cbcourse;
JButton submit,reset,cancel;

Random ran = new Random();

long first4 = [Link](([Link]() % 9000L) + 1000L);

AddStudent(){
setSize(900,700);
setLocation(350,50);
setLayout(null);

JLabel heading = new JLabel("New Student Information");

[Link](300,30,400,30);
[Link]([Link]);
[Link](new Font("serif",[Link],30));
P a g e 41
add(heading);

JLabel name = new JLabel("Name");

[Link](50, 150, 150, 30);
[Link](new Font("serif",[Link],20));
add(name);

tfname = new JTextField();

[Link](200, 150, 150, 30);
add(tfname);

JLabel fname = new JLabel("Father's Name");

[Link](400, 150, 200, 30);
[Link](new Font("serif",[Link],20));
add(fname);

tffname = new JTextField();

[Link](600, 150, 150, 30);
add(tffname);

JLabel roll = new JLabel("Roll Number");

[Link](50, 200, 200, 30);
[Link](new Font("serif",[Link],20));
add(roll);

lbroll = new JLabel("2025" + first4);

[Link](200, 200, 200, 30);
[Link](new Font("serif",[Link],20));
add(lbroll);

JLabel dob = new JLabel("Date Of Birth");

[Link](400, 200, 200, 30);
[Link](new Font("serif",[Link],20));
add(dob);

dcdob = new JDateChooser();

[Link](600, 200, 150, 30);
add(dcdob);

JLabel address = new JLabel("Address");

[Link](50, 250, 200, 30);
[Link](new Font("serif",[Link],20));
add(address);

tffaddress = new JTextField();

[Link](200, 250, 150, 30);
add(tffaddress);

P a g e 42
JLabel phone = new JLabel("Phone No.");
[Link](400, 250, 150, 30);
[Link](new Font("serif",[Link],20));
add(phone);

tfphone = new JTextField();

[Link](600, 250, 150, 30);
add(tfphone);

JLabel email = new JLabel("Email ID");

[Link](50, 300, 200, 30);
[Link](new Font("serif",[Link],20));
add(email);

tfemail = new JTextField();

[Link](200, 300, 150, 30);
add(tfemail);

JLabel x = new JLabel("Class X (%)");

[Link](400, 300, 200, 30);
[Link](new Font("serif",[Link],20));
add(x);

tfx = new JTextField();

[Link](600, 300, 150, 30);
add(tfx);

JLabel xii = new JLabel("Class XII (%)");

[Link](50, 350, 200, 30);
[Link](new Font("serif",[Link],20));
add(xii);

tfxii = new JTextField();

[Link](200, 350, 150, 30);
add(tfxii);

JLabel graduate = new JLabel("Graduate (if applicable)");

[Link](400, 350, 200, 30);
[Link](new Font("serif",[Link],18));
add(graduate);

tfgraduate = new JTextField();

[Link](600, 350, 150, 30);
add(tfgraduate);

JLabel aadhar = new JLabel("Aadhar Number");

[Link](50, 400, 200, 30);
[Link](new Font("serif",[Link],20));

P a g e 43
 add(aadhar);

tfaadhar = new JTextField();

[Link](200, 400, 150, 30);
add(tfaadhar);

JLabel lblcourse = new JLabel("Course");

[Link](400, 400, 200, 30);
[Link](new Font("serif",[Link],20));
add(lblcourse);

String course[] = {"BCA","BBA","BBM","MCA","MBA","[Link]","[Link]","BA"};

cbcourse = new JComboBox(course);
[Link](600, 400, 150, 30);
[Link]([Link]);
add(cbcourse);

submit = new JButton("Submit");

[Link](150, 500, 150, 30);
[Link](this);
[Link]([Link]);
[Link]([Link]);
[Link](new Font("Algerian",[Link],20));
add(submit);

reset = new JButton("Reset");

[Link](350, 500, 150, 30);
[Link](this);
[Link]([Link]);
[Link]([Link]);
[Link](new Font("Algerian",[Link],20));
add(reset);

cancel = new JButton("Close");

[Link](550, 500, 150, 30);
[Link](this);
[Link]([Link]);
[Link]([Link]);
[Link](new Font("Algerian",[Link],20));
add(cancel);

setVisible(true);
}
public void actionPerformed(ActionEvent ae){
if ([Link]() == submit){
String name = [Link]();
String fname = [Link]();
String roll = [Link]();

P a g e 44
 String dob = ((JTextField) [Link]().getUiComponent()).getText();
String address = [Link]();
String phone = [Link]();
String email = [Link]();
String x = [Link]();
String xii = [Link]();
String graduate = [Link]();
String aadhar = [Link]();
String course = (String) [Link]();

try{
String query = "insert into student values('"+name+"', '"+fname+"', '"+roll+"', '"+dob+"', '"+address+"',
'"+phone+"', '"+email+"', '"+x+"', '"+xii+"', '"+graduate+"', '"+aadhar+"', '"+course+"')";

Conn c = new Conn();

[Link](query);

[Link](null, "Student Information Inserted Successfully");

setVisible(false);
}catch(Exception e){
[Link]();
}
}else if([Link]() == reset){
setVisible(false);
new AddStudent().setVisible(true);
}else{
setVisible(false);
}
}
public static void main(String []args){
new AddStudent();
}
}

Faculty form:
P a g e 45
 Code :

package [Link];
import [Link].*;
import [Link].*;
import [Link].*;
import [Link];
import [Link].*;

public class AddTeacher extends JFrame implements ActionListener{

JTextField tfname,tffname,tffaddress,tfphone,tfemail,tfx,tfxii,tfgraduate,tfaadhar;
JLabel lbt_id;
JDateChooser dcdob;
JComboBox cbcourse;
JButton submit,reset,cancel;

Random ran = new Random();

long first4 = [Link](([Link]() % 9000L) + 1000L);

AddTeacher(){
setSize(900,700);
setLocation(350,50);

setLayout(null);
JLabel heading = new JLabel("New Teacher Information");
[Link](300,30,400,30);
[Link]([Link]);
[Link](new Font("serif",[Link],30));
add(heading);

P a g e 46
JLabel name = new JLabel("Name");
[Link](50, 150, 150, 30);
[Link](new Font("serif",[Link],20));
add(name);

tfname = new JTextField();

[Link](200, 150, 150, 30);
add(tfname);

JLabel fname = new JLabel("Father's Name");

[Link](400, 150, 200, 30);
[Link](new Font("serif",[Link],20));
add(fname);

tffname = new JTextField();

[Link](600, 150, 150, 30);
add(tffname);

JLabel t_id = new JLabel("Teacher ID");

t_id.setBounds(50, 200, 200, 30);
t_id.setFont(new Font("serif",[Link],20));
add(t_id);

lbt_id = new JLabel("101" + first4);

lbt_id.setBounds(200, 200, 200, 30);
lbt_id.setFont(new Font("serif",[Link],20));
add(lbt_id);

JLabel dob = new JLabel("Date Of Birth");

[Link](400, 200, 200, 30);
[Link](new Font("serif",[Link],20));
add(dob);

dcdob = new JDateChooser();

[Link](600, 200, 150, 30);
add(dcdob);

JLabel address = new JLabel("Address");

[Link](50, 250, 200, 30);
[Link](new Font("serif",[Link],20));
add(address);

tffaddress = new JTextField();

[Link](200, 250, 150, 30);
add(tffaddress);

JLabel phone = new JLabel("Phone No.");

[Link](400, 250, 150, 30);

P a g e 47
[Link](new Font("serif",[Link],20));
add(phone);

tfphone = new JTextField();

[Link](600, 250, 150, 30);
add(tfphone);

JLabel email = new JLabel("Email ID");

[Link](50, 300, 200, 30);
[Link](new Font("serif",[Link],20));
add(email);

tfemail = new JTextField();

[Link](200, 300, 150, 30);
add(tfemail);

JLabel x = new JLabel("Class X (%)");

[Link](400, 300, 200, 30);
[Link](new Font("serif",[Link],20));
add(x);

tfx = new JTextField();

[Link](600, 300, 150, 30);
add(tfx);

JLabel xii = new JLabel("Class XII (%)");

[Link](50, 350, 200, 30);
[Link](new Font("serif",[Link],20));
add(xii);

tfxii = new JTextField();

[Link](200, 350, 150, 30);
add(tfxii);

JLabel graduate = new JLabel("Graduate");

[Link](400, 350, 200, 30);
[Link](new Font("serif",[Link],20));
add(graduate);

tfgraduate = new JTextField();

[Link](600, 350, 150, 30);
add(tfgraduate);

JLabel aadhar = new JLabel("Aadhar Number");

[Link](50, 400, 200, 30);
[Link](new Font("serif",[Link],20));
add(aadhar);

P a g e 48
 tfaadhar = new JTextField();
[Link](200, 400, 150, 30);
add(tfaadhar);

JLabel qualification = new JLabel("Qualification");

[Link](400, 400, 200, 30);
[Link](new Font("serif",[Link],20));
add(qualification);

String course[] = {"BCA","BBA","BBM","MCA","MBA","[Link]","[Link]","BA"};

cbcourse = new JComboBox(course);
[Link](600, 400, 150, 30);
[Link]([Link]);
add(cbcourse);

submit = new JButton("Submit");

[Link](150, 500, 150, 30);
[Link](this);
[Link]([Link]);
[Link]([Link]);
[Link](new Font("Algerian",[Link],20));
add(submit);

reset = new JButton("Reset");

[Link](350, 500, 150, 30);
[Link](this);
[Link]([Link]);
[Link]([Link]);
[Link](new Font("Algerian",[Link],20));
add(reset);

cancel = new JButton("Close");

[Link](550, 500, 150, 30);
[Link](this);
[Link]([Link]);
[Link]([Link]);
[Link](new Font("Algerian",[Link],20));
add(cancel);

setVisible(true);
}
public void actionPerformed(ActionEvent ae){
if ([Link]() == submit){
String name = [Link]();
String fname = [Link]();
String t_id = lbt_id.getText();
String dob = ((JTextField) [Link]().getUiComponent()).getText();
String address = [Link]();

P a g e 49
 String phone = [Link]();
String email = [Link]();
String x = [Link]();
String xii = [Link]();
String graduate = [Link]();
String aadhar = [Link]();
String qualification = (String) [Link]();

try{
String query = "insert into teacher values('"+name+"', '"+fname+"', '"+t_id+"', '"+dob+"', '"+address+"',
'"+phone+"', '"+email+"', '"+x+"', '"+xii+"', '"+graduate+"', '"+aadhar+"', '"+qualification+"')";

Conn c = new Conn();

[Link](query);

[Link](null, "Teacher Information Inserted Successfully");

setVisible(false);
}catch(Exception e){
[Link]();
}
}else if([Link]() == reset){
setVisible(false);
new AddTeacher().setVisible(true);
}else{
setVisible(false);
}
}
public static void main(String []args){
new AddTeacher();
}
}

P a g e 50
 View Student Details :

Code :

package [Link];
import [Link].*;
import [Link].*;
import [Link].*;
import [Link];
import [Link].*;

public class StudentDetails extends JFrame implements ActionListener{

Choice crollno;
JTable table;
JButton search, print, update, add, cancel;

StudentDetails(){

getContentPane().setBackground([Link]);
setLayout(null);

JLabel heading = new JLabel("Search by Roll No.");

[Link](20, 20, 200,30);
[Link](new Font("serif",[Link],20));
add(heading);

crollno = new Choice();

[Link](230, 20, 150, 20);
add(crollno);

try{
Conn c = new Conn();
ResultSet rs = [Link]("Select * from student");
while([Link]()){
[Link]([Link]("roll"));

P a g e 51
 }

}catch(Exception e){
[Link]();
}

table = new JTable();

try{
Conn c = new Conn();
ResultSet rs = [Link]("select * from student");
[Link]([Link](rs));

}catch(Exception e){
[Link]();
}
JScrollPane jsp = new JScrollPane(table);
[Link](0, 100, 900, 600);
add(jsp);

search = new JButton("Search");

[Link](20,70,80,20);
[Link](this);
add(search);

print = new JButton("Print");

[Link](140,70,80,20);
[Link](this);
add(print);

update = new JButton("Update");

[Link](260,70,80,20);
[Link](this);
add(update);

add = new JButton("Add");

[Link](380,70,80,20);
[Link](this);
add(add);

cancel = new JButton("Cancel");

[Link](500,70,80,20);
[Link](this);
add(cancel);

setSize(900,700);
setLocation(350,50);

P a g e 52
 setVisible(true);
}
@Override
public void actionPerformed(ActionEvent ae){
if([Link]() == search){
String query = "select * from student where roll = '"+[Link]()+"'";
try{
Conn c = new Conn();
ResultSet rs = [Link](query);
[Link]([Link](rs));
}catch(Exception e){
[Link]();
}
}else if([Link]() == print){
try{
[Link]();
}catch(Exception e){
[Link]();
}
}else if([Link]() == add){
setVisible(false);
new AddStudent();
}else if([Link]() == update){
new UpdateStudent();
}else{
setVisible(false);
}
}
public static void main(String []args){
new StudentDetails();
}

P a g e 53
View Faculty Details :

Code :

package [Link];
import [Link].*;
import [Link].*;
import [Link].*;
import [Link];
import [Link].*;

public class TeacherDetails extends JFrame implements ActionListener{

Choice cid;
JTable table;
JButton search, print, update, add, cancel;

TeacherDetails(){

getContentPane().setBackground([Link]);
setLayout(null);

JLabel heading = new JLabel("Search by Teacher ID");

[Link](20, 20, 200,30);
[Link](new Font("serif",[Link],20));
add(heading);

cid = new Choice();

[Link](230, 20, 150, 20);
add(cid);

try{
Conn c = new Conn();
P a g e 54 |
 ResultSet rs = [Link]("Select * from teacher");
while([Link]()){
[Link]([Link]("t_id"));
}

}catch(Exception e){
[Link]();
}

table = new JTable();

try{
Conn c = new Conn();
ResultSet rs = [Link]("select * from teacher");
[Link]([Link](rs));

}catch(Exception e){
[Link]();
}
JScrollPane jsp = new JScrollPane(table);
[Link](0, 100, 900, 600);
add(jsp);

search = new JButton("Search");

[Link](20,70,80,20);
[Link](this);
add(search);

print = new JButton("Print");

[Link](140,70,80,20);
[Link](this);
add(print);

update = new JButton("Update");

[Link](260,70,80,20);
[Link](this);
add(update);

add = new JButton("Add");

[Link](380,70,80,20);
[Link](this);
add(add);

cancel = new JButton("Cancel");

[Link](500,70,80,20);

P a g e 55 |
 [Link](this);
add(cancel);

setSize(900,700);
setLocation(350,50);

setVisible(true);
}
@Override
public void actionPerformed(ActionEvent ae){
if([Link]() == search){
String query = "select * from teacher where t_id = '"+[Link]()+"'";
try{
Conn c = new Conn();
ResultSet rs = [Link](query);
[Link]([Link](rs));
}catch(Exception e){
[Link]();
}
}else if([Link]() == print){
try{
[Link]();
}catch(Exception e){
[Link]();
}
}else if([Link]() == add){
setVisible(false);
new AddTeacher();
}else if([Link]() == update){
new UpdateTeacher();
}else{
setVisible(false);
}
}
public static void main(String []args){
new TeacherDetails();
}
}

P a g e 56 |
Attendance :

Code :

package [Link];

import [Link].*;
import [Link].*;
import [Link].*;
import [Link].*;
import [Link].*;

public class Attendance extends JFrame implements ActionListener {

JButton submit, cancel;
ArrayList<JComboBox> statusList = new ArrayList<>();
ArrayList<String> rollList = new ArrayList<>();
ArrayList<String> nameList = new ArrayList<>();

Attendance() {
setSize(800, 600);
setLocation(300, 100);
setLayout(null);

JLabel heading = new JLabel("Student Attendance");

[Link](250, 30, 400, 30);
[Link](new Font("serif", [Link], 25));
[Link]([Link]);
add(heading);

P a g e 57 |
JLabel l1 = new JLabel("Roll No.");
[Link](100, 100, 100, 30);
add(l1);

JLabel l2 = new JLabel("Name");

[Link](250, 100, 150, 30);
add(l2);

JLabel l3 = new JLabel("Status");

[Link](450, 100, 100, 30);
add(l3);

try {
Conn c = new Conn();
ResultSet rs = [Link]("SELECT roll, name FROM student");

int y = 140;

while ([Link]()) {
String roll = [Link]("roll");
String name = [Link]("name");

[Link](roll);
[Link](name);

JLabel rollLabel = new JLabel(roll);

[Link](100, y, 100, 30);
add(rollLabel);

JLabel nameLabel = new JLabel(name);

[Link](250, y, 150, 30);
add(nameLabel);

JComboBox<String> cbStatus = new JComboBox<>(new String[]{"Present", "Absent"});

[Link](450, y, 100, 30);
[Link](cbStatus);
add(cbStatus);

y += 40;
}
} catch (Exception e) {
[Link]();
}
P a g e 58 |
 submit = new JButton("Submit");
[Link](200, 500, 120, 30);
[Link](this);
[Link]([Link]);
[Link]([Link]);
add(submit);

cancel = new JButton("Cancel");

[Link](400, 500, 120, 30);
[Link](this);
[Link]([Link]);
[Link]([Link]);
add(cancel);

setVisible(true);
}

public void actionPerformed(ActionEvent ae) {

if ([Link]() == submit) {
try {
Conn c = new Conn();
String date = new [Link]([Link]()).toString();

for (int i = 0; i < [Link](); i++) {

String roll = [Link](i);
String name = [Link](i);
String status = (String) [Link](i).getSelectedItem();

String query = "INSERT INTO attendance VALUES('" + roll + "', '" + name + "', '" + date + "', '" +
status + "')";
[Link](query);
}

[Link](null, "Attendance Recorded Successfully");

setVisible(false);
} catch (Exception e) {
[Link]();
}
} else {
setVisible(false);
}
}
P a g e 59 |
 public static void main(String[] args) {
new Attendance();
}
}

Apply student leave:

Code:

package [Link];
import [Link].*;
import [Link].*;
import [Link].*;
import [Link];
import [Link].*;

public class StudentLeave extends JFrame implements ActionListener{

Choice crollno,ctime;
JDateChooser dcdate;
JButton submit,cancel;

StudentLeave(){

setSize(700,500);
setLocation(500,200);
setLayout(null);

P a g e 60 |
getContentPane().setBackground([Link]);

JLabel heading = new JLabel("Student Leave Application");

[Link](100, 40, 400,40);
[Link](new Font("serif",[Link],30));
[Link]([Link]);
add(heading);

JLabel lblroll = new JLabel("Search by Roll No.");

[Link](60, 100, 200,30);
[Link](new Font("serif",[Link],20));
add(lblroll);

crollno = new Choice();

[Link](60, 150, 200, 20);
add(crollno);

try{
Conn c = new Conn();
ResultSet rs = [Link]("Select * from student");
while([Link]()){
[Link]([Link]("roll"));
}

}catch(Exception e){
[Link]();
}

JLabel date = new JLabel("Date");

[Link](60, 200, 200, 30);
[Link](new Font("serif",[Link],20));
add(date);

dcdate = new JDateChooser();

[Link](60, 230, 200, 30);
add(dcdate);

JLabel lbltime = new JLabel("Time Duration");

[Link](60, 280, 200,30);
[Link](new Font("serif",[Link],20));
add(lbltime);

ctime = new Choice();

[Link](60, 310, 200, 20);
[Link]("Full Day");
[Link]("Half Day");
add(ctime);

P a g e 61 |
 submit = new JButton("Submit");
[Link](60, 350, 150, 30);
[Link](this);
[Link]([Link]);
[Link]([Link]);
[Link](new Font("Algerian",[Link],20));
add(submit);

cancel = new JButton("Cancel");

[Link](250, 350, 150, 30);
[Link](this);
[Link]([Link]);
[Link]([Link]);
[Link](new Font("Algerian",[Link],20));
add(cancel);
setVisible(true);
}
public void actionPerformed(ActionEvent ae){
if([Link]() == submit){
String roll = [Link]();
String date = ((JTextField)[Link]().getUiComponent()).getText();
String duration = [Link]();

String query = "insert into studentleave values('"+roll+"','"+date+"','"+duration+"')";

try{
Conn c = new Conn();
[Link](query);
[Link](null,"Leave Confirmed");
setVisible(false);
}catch(Exception e){
[Link]();
}
}else{
setVisible(false);
}
}
public static void main(String []args){
new StudentLeave();
}
}

P a g e 62 |
Apply Teacher Leave:

Code :

package [Link];
import [Link].*;
import [Link].*;
import [Link].*;
import [Link];
import [Link].*;

public class TeacherLeave extends JFrame implements ActionListener{

Choice cid,ctime;
JDateChooser dcdate;
JButton submit,cancel;

TeacherLeave(){

setSize(700,500);
setLocation(500,200);
setLayout(null);

getContentPane().setBackground([Link]);

JLabel heading = new JLabel("Teacher Leave Application");

[Link](100, 40, 400,40);
[Link](new Font("serif",[Link],30));
[Link]([Link]);
add(heading);

JLabel lblid = new JLabel("Search by Teacher ID");

[Link](60, 100, 200,30);
[Link](new Font("serif",[Link],20));
add(lblid);
P a g e 63 |
cid = new Choice();
[Link](60, 150, 200, 20);
add(cid);

try{
Conn c = new Conn();
ResultSet rs = [Link]("Select * from teacher");
while([Link]()){
[Link]([Link]("t_id"));
}

}catch(Exception e){
[Link]();
}

JLabel date = new JLabel("Date");

[Link](60, 200, 200, 30);
[Link](new Font("serif",[Link],20));
add(date);

dcdate = new JDateChooser();

[Link](60, 230, 200, 30);
add(dcdate);

JLabel lbltime = new JLabel("Time Duration");

[Link](60, 280, 200,30);
[Link](new Font("serif",[Link],20));
add(lbltime);

ctime = new Choice();

[Link](60, 310, 200, 20);
[Link]("Full Day");
[Link]("Half Day");
add(ctime);

submit = new JButton("Submit");

[Link](60, 350, 150, 30);
[Link](this);
[Link]([Link]);
[Link]([Link]);
[Link](new Font("Algerian",[Link],20));
add(submit);

cancel = new JButton("Cancel");

[Link](250, 350, 150, 30);
[Link](this);
[Link]([Link]);

P a g e 64 |
 [Link]([Link]);
[Link](new Font("Algerian",[Link],20));
add(cancel);
setVisible(true);
}
public void actionPerformed(ActionEvent ae){
if([Link]() == submit){
String id = [Link]();
String date = ((JTextField)[Link]().getUiComponent()).getText();
String duration = [Link]();

String query = "insert into teacherleave values('"+id+"','"+date+"','"+duration+"')";

try{
Conn c = new Conn();
[Link](query);
[Link](null,"Leave Confirmed");
setVisible(false);
}catch(Exception e){
[Link]();
}
}else{
setVisible(false);
}
}
public static void main(String []args){
new TeacherLeave();
}
}

Student leave information:

Code:
P a g e 65 |
package [Link];
import [Link].*;
import [Link].*;
import [Link].*;
import [Link];
import [Link].*;

public class StudentLeaveDetails extends JFrame implements ActionListener{

Choice crollno;
JTable table;
JButton search, print,cancel;

StudentLeaveDetails(){

getContentPane().setBackground([Link]);
setLayout(null);

JLabel heading = new JLabel("Search by Roll No.");

[Link](20, 20, 200,30);
[Link](new Font("serif",[Link],20));
add(heading);

crollno = new Choice();

[Link](230, 20, 150, 20);
add(crollno);

try{
Conn c = new Conn();
ResultSet rs = [Link]("Select * from student");
while([Link]()){
[Link]([Link]("roll"));
}

}catch(Exception e){
[Link]();
}

table = new JTable();

try{
Conn c = new Conn();
ResultSet rs = [Link]("select * from studentleave");
[Link]([Link](rs));

}catch(Exception e){
[Link]();
}
P a g e 66 |
 JScrollPane jsp = new JScrollPane(table);
[Link](0, 100, 900, 600);
add(jsp);

search = new JButton("Search");

[Link](20,70,80,20);
[Link](this);
add(search);

print = new JButton("Print");

[Link](140,70,80,20);
[Link](this);
add(print);

cancel = new JButton("Cancel");

[Link](260,70,80,20);
[Link](this);
add(cancel);

setSize(900,700);
setLocation(350,50);

setVisible(true);
}
@Override
public void actionPerformed(ActionEvent ae){
if([Link]() == search){
String query = "select * from studentleave where roll = '"+[Link]()+"'";
try{
Conn c = new Conn();
ResultSet rs = [Link](query);
[Link]([Link](rs));
}catch(Exception e){
[Link]();
}
}else if([Link]() == print){
try{
[Link]();
}catch(Exception e){
[Link]();
}
}else{
setVisible(false);
}
}
public static void main(String []args){
new StudentLeaveDetails();
}}

P a g e 67 |
Teacher leave Information :

Code:

package [Link];
import [Link].*;
import [Link].*;
import [Link].*;
import [Link];
import [Link].*;

public class TeacherLeaveDetails extends JFrame implements ActionListener{

Choice cid;
JTable table;
JButton search, print, cancel;

TeacherLeaveDetails(){

getContentPane().setBackground([Link]);
setLayout(null);

JLabel heading = new JLabel("Search by Teacher ID");

[Link](20, 20, 200,30);
[Link](new Font("serif",[Link],20));
add(heading);

cid = new Choice();

[Link](230, 20, 150, 20);
add(cid);

P a g e 68 |
 try{
Conn c = new Conn();
ResultSet rs = [Link]("Select * from teacher");
while([Link]()){
[Link]([Link]("t_id"));
}

}catch(Exception e){
[Link]();
}

table = new JTable();

try{
Conn c = new Conn();
ResultSet rs = [Link]("select * from teacherleave");
[Link]([Link](rs));

}catch(Exception e){
[Link]();
}
JScrollPane jsp = new JScrollPane(table);
[Link](0, 100, 900, 600);
add(jsp);

search = new JButton("Search");

[Link](20,70,80,20);
[Link](this);
add(search);

print = new JButton("Print");

[Link](140,70,80,20);
[Link](this);
add(print);

cancel = new JButton("Cancel");

[Link](260,70,80,20);
[Link](this);
add(cancel);

setSize(900,700);
setLocation(350,50);

setVisible(true);
}
@Override
public void actionPerformed(ActionEvent ae){
if([Link]() == search){

P a g e 69 |
 String query = "select * from teacherleave where id = '"+[Link]()+"'";
try{
Conn c = new Conn();
ResultSet rs = [Link](query);
[Link]([Link](rs));
}catch(Exception e){
[Link]();
}
}else if([Link]() == print){
try{
[Link]();
}catch(Exception e){
[Link]();
}
}else{
setVisible(false);
}
}
public static void main(String []args){
new TeacherLeaveDetails();
}
}

Enter Marks Form:

Code:

package [Link];
import [Link].*;
import [Link].*;
import [Link].*;

P a g e 70 |
import [Link].*;
public class EnterMarks extends JFrame implements ActionListener{

Choice crollno;
JComboBox cbsemester;
JTextField
tfsubject1,tfsubject2,tfsubject3,tfsubject4,tfsubject5,tfmarks1,tfmarks2,tfmarks3,tfmarks4,tfmarks5;
JButton submit,cancel;

EnterMarks(){

setSize(1000,500);
setLocation(300,150);
setLayout(null);

getContentPane().setBackground([Link]);

ImageIcon i1 = new ImageIcon([Link]("icons/[Link]"));

Image i2 = [Link]().getScaledInstance(400, 300, Image.SCALE_DEFAULT);
ImageIcon i3 = new ImageIcon(i2);
JLabel image = new JLabel(i3);
add(image);
[Link](500,40,400,300);

JLabel heading = new JLabel("Enter marks of student");

[Link](50,0,450,40);
[Link]([Link]);
[Link](new Font("Century",[Link],30));
add(heading);

JLabel lblrollnumber = new JLabel("Select Roll No.");

[Link](50, 70, 150,20);
add(lblrollnumber);

crollno = new Choice();

[Link](200, 70, 150, 20);
add(crollno);

try{
Conn c = new Conn();
ResultSet rs = [Link]("Select * from student");
while([Link]()){
[Link]([Link]("roll"));
}

}catch(Exception e){
[Link]();
}

P a g e 71 |
 setVisible(true);

JLabel lblsemester = new JLabel("Select Semester");

[Link](50, 110, 150,20);
add(lblsemester);

String semester[] = {"1st Semester","2nd Semester","3rd Semester","4th Semester","5th Semester","6th

Semester","7th Semester","8th Semester"};
cbsemester = new JComboBox(semester);
[Link](200, 110, 150, 20);
[Link]([Link]);
add(cbsemester);

JLabel lblentersubject = new JLabel("Enter Subject");

[Link](100, 150, 200,40);
add(lblentersubject);

JLabel lblentermark = new JLabel("Enter marks");

[Link](320, 150, 200,40);
add(lblentermark);

tfsubject1 = new JTextField();

[Link](50, 200, 200, 20);
add(tfsubject1);

tfsubject2 = new JTextField();

[Link](50, 230, 200, 20);
add(tfsubject2);

tfsubject3 = new JTextField();

[Link](50, 260, 200, 20);
add(tfsubject3);

tfsubject4 = new JTextField();

[Link](50, 290, 200, 20);
add(tfsubject4);

tfsubject5 = new JTextField();

[Link](50, 320, 200, 20);
add(tfsubject5);

tfmarks1 = new JTextField();

[Link](250, 200, 200, 20);
add(tfmarks1);

tfmarks2 = new JTextField();

[Link](250, 230, 200, 20);
add(tfmarks2);

P a g e 72 |
 tfmarks3 = new JTextField();
[Link](250, 260, 200, 20);
add(tfmarks3);

tfmarks4 = new JTextField();

[Link](250, 290, 200, 20);
add(tfmarks4);

tfmarks5 = new JTextField();

[Link](250, 320, 200, 20);
add(tfmarks5);

submit = new JButton("Submit");

[Link](70, 360, 150, 30);
[Link](this);
[Link]([Link]);
[Link]([Link]);
[Link](new Font("Algerian",[Link],20));
add(submit);

cancel = new JButton("Cancel");

[Link](250, 360, 150, 30);
[Link](this);
[Link]([Link]);
[Link]([Link]);
[Link](new Font("Algerian",[Link],20));
add(cancel);

}
public void actionPerformed(ActionEvent ae) {
if([Link]() == submit) {
try {
Conn c = new Conn();
// Add closing parenthesis for query1 and query2
String query1 = "insert into subject
values('"+[Link]()+"','"+[Link]()+"','"+[Link]()+"','"+tfsubjec
[Link]()+"','"+[Link]()+"','"+[Link]()+"','"+[Link]()+"')";
String query2 = "insert into marks
values('"+[Link]()+"','"+[Link]()+"','"+[Link]()+"','"+tfmarks2
.getText()+"','"+[Link]()+"','"+[Link]()+"','"+[Link]()+"')";

// Execute both queries

[Link](query1);
[Link](query2);

[Link](null, "Marks inserted successfully");

setVisible(false);

P a g e 73 |
 } catch(Exception e) {
[Link]();
}
} else {
setVisible(false);
}
}
public static void main(String []args){
new EnterMarks();
}
}
Examination Details :

Code:

package [Link];

import [Link].*;
import [Link].*;
import [Link].*;
import [Link];
import [Link].*;

public class ExaminationDetails extends JFrame implements ActionListener{

JTextField search;
JButton submit,cancel;
JTable table;

ExaminationDetails(){

P a g e 74 |
setSize(1000,500);
setLocation(300,150);
setLayout(null);

getContentPane().setBackground([Link]);

JLabel heading = new JLabel("Check Results");

[Link](80,20,450,40);
[Link]([Link]);
[Link](new Font("Century",[Link],30));
add(heading);

search = new JTextField();

[Link](80,90,200,30);
[Link](new Font("Tahoma",[Link],20));
add(search);

submit = new JButton("Result");

[Link](300, 90, 120, 30);
[Link](this);
[Link]([Link]);
[Link]([Link]);
[Link](new Font("Algerian",[Link],20));
add(submit);

cancel = new JButton("Cancel");

[Link](450, 90, 120, 30);
[Link](this);
[Link]([Link]);
[Link]([Link]);
[Link](new Font("Algerian",[Link],20));
add(cancel);

table = new JTable();

[Link](new Font("Tahoma",[Link],15));

JScrollPane jsp = new JScrollPane(table);

[Link](0,130,1000,335);
add(jsp);

try{
Conn c = new Conn();
ResultSet rs = [Link]("select * from student");
P a g e 75 |
 [Link]([Link](rs));
}catch(Exception e){
[Link]();
}
[Link](new MouseAdapter(){
public void mouseClicked(MouseEvent me){
int row = [Link]();
[Link]([Link]().getValueAt(row,2).toString());
}
});

setVisible(true);
}
public void actionPerformed(ActionEvent ae){
if([Link]()==submit){
setVisible(false);
new Marks([Link]());
}else{
setVisible(false);
}
}

public static void main(String[] args){

new ExaminationDetails();
}
}

P a g e 76 |
Update Student Details:

Code:

package [Link];
import [Link].*;
import [Link].*;
import [Link].*;
import [Link].*;

public class UpdateStudent extends JFrame implements ActionListener{

JTextField tffaddress,tfphone,tfemail,tfcourse;
JLabel lbroll;
JButton submit,cancel;
Choice crollno;

UpdateStudent(){
setSize(900,700);
setLocation(350,50);

setLayout(null);
JLabel heading = new JLabel("Update Student Information");
[Link](50,20,450,40);

P a g e 77 |
[Link]([Link]);
[Link](new Font("Century",[Link],30));
add(heading);

JLabel lblrollnumber = new JLabel("Select Roll No.");

[Link](50, 100, 200,30);
[Link](new Font("serif",[Link],20));
add(lblrollnumber);

crollno = new Choice();

[Link](260, 100, 200, 20);
add(crollno);

try{
Conn c = new Conn();
ResultSet rs = [Link]("Select * from student");
while([Link]()){
[Link]([Link]("roll"));
}

}catch(Exception e){
[Link]();
}

JLabel name = new JLabel("Name");

[Link](50, 150, 150, 30);
[Link](new Font("serif",[Link],20));
add(name);

JLabel lblname = new JLabel();

[Link](200, 150, 150, 30);
[Link](new Font("serif",[Link],20));
add(lblname);

JLabel fname = new JLabel("Father's Name");

[Link](400, 150, 200, 30);
[Link](new Font("serif",[Link],20));
add(fname);

JLabel lblfname = new JLabel();

[Link](600, 150, 150, 30);
[Link](new Font("serif",[Link],20));
P a g e 78 |
add(lblfname);

JLabel roll = new JLabel("Roll Number");

[Link](50, 200, 200, 30);
[Link](new Font("serif",[Link],20));
add(roll);

lbroll = new JLabel();

[Link](200, 200, 200, 30);
[Link](new Font("serif",[Link],20));
add(lbroll);

JLabel dob = new JLabel("Date Of Birth");

[Link](400, 200, 200, 30);
[Link](new Font("serif",[Link],20));
add(dob);

JLabel lbldob = new JLabel();

[Link](600, 200, 150, 30);
[Link](new Font("serif",[Link],20));
add(lbldob);

JLabel address = new JLabel("Address");

[Link](50, 250, 200, 30);
[Link](new Font("serif",[Link],20));
add(address);

tffaddress = new JTextField();

[Link](200, 250, 150, 30);
add(tffaddress);

JLabel phone = new JLabel("Phone No.");

[Link](400, 250, 150, 30);
[Link](new Font("serif",[Link],20));
add(phone);

tfphone = new JTextField();

[Link](600, 250, 150, 30);
add(tfphone);

JLabel email = new JLabel("Email ID");

[Link](50, 300, 200, 30);
P a g e 79 |
[Link](new Font("serif",[Link],20));
add(email);

tfemail = new JTextField();

[Link](200, 300, 150, 30);
add(tfemail);

JLabel x = new JLabel("Class X (%)");

[Link](400, 300, 200, 30);
[Link](new Font("serif",[Link],20));
add(x);

JLabel lblx = new JLabel();

[Link](600, 300, 150, 30);
[Link](new Font("serif",[Link],20));
add(lblx);

JLabel xii = new JLabel("Class XII (%)");

[Link](50, 350, 200, 30);
[Link](new Font("serif",[Link],20));
add(xii);

JLabel lblxii = new JLabel();

[Link](200, 350, 150, 30);
[Link](new Font("serif",[Link],20));
add(lblxii);

JLabel graduate = new JLabel("Graduate (if applicable)");

[Link](400, 350, 200, 30);
[Link](new Font("serif",[Link],18));
add(graduate);

JLabel lblgraduate = new JLabel();

[Link](600, 350, 150, 30);
[Link](new Font("serif",[Link],20));
add(lblgraduate);

JLabel aadhar = new JLabel("Aadhar Number");

[Link](50, 400, 200, 30);
[Link](new Font("serif",[Link],20));
add(aadhar);

P a g e 80 |
JLabel lblaadhar = new JLabel();
[Link](200, 400, 150, 30);
[Link](new Font("serif",[Link],20));
add(lblaadhar);

JLabel lblcourse = new JLabel("Course");

[Link](400, 400, 200, 30);
[Link](new Font("serif",[Link],20));
add(lblcourse);

tfcourse = new JTextField();

[Link](600, 400, 150, 30);
add(tfcourse);

try{
Conn c = new Conn();
String query = "Select * from student where roll='"+[Link]()+"'";
ResultSet rs = [Link](query);
while([Link]()){
[Link]([Link]("name"));
[Link]([Link]("fname"));
[Link]([Link]("dob"));
[Link]([Link]("roll"));
[Link]([Link]("address"));
[Link]([Link]("phone"));
[Link]([Link]("email"));
[Link]([Link]("class_x"));
[Link]([Link]("class_xii"));
[Link]([Link]("graduate"));
[Link]([Link]("aadhar"));
[Link]([Link]("course"));
}
}catch(Exception e){
[Link]();
}

[Link](new ItemListener(){
public void itemStateChanged(ItemEvent ie){
try{
Conn c = new Conn();
String query = "Select * from student where roll='"+[Link]()+"'";
ResultSet rs = [Link](query);
P a g e 81 |
 while([Link]()){
[Link]([Link]("name"));
[Link]([Link]("fname"));
[Link]([Link]("dob"));
[Link]([Link]("roll"));
[Link]([Link]("address"));
[Link]([Link]("phone"));
[Link]([Link]("email"));
[Link]([Link]("class_x"));
[Link]([Link]("class_xii"));
[Link]([Link]("graduate"));
[Link]([Link]("aadhar"));
[Link]([Link]("course"));
}
}catch(Exception e){
[Link]();
}
}
});

submit = new JButton("Update");

[Link](250, 500, 150, 30);
[Link](this);
[Link]([Link]);
[Link]([Link]);
[Link](new Font("Algerian",[Link],20));
add(submit);

cancel = new JButton("Cancel");

[Link](450, 500, 150, 30);
[Link](this);
[Link]([Link]);
[Link]([Link]);
[Link](new Font("Algerian",[Link],20));
add(cancel);

setVisible(true);
}
public void actionPerformed(ActionEvent ae){
if ([Link]() == submit){
String roll = [Link]();
String address = [Link]();
P a g e 82 |
 String phone = [Link]();
String email = [Link]();
String course = [Link]();

try{
String query = "update student set address = '"+address+"',phone = '"+phone+"',email = '"+email+"',
course = '"+course+"' where roll ='"+roll+"'";

Conn c = new Conn();

[Link](query);

[Link](null, "Student Information Updated Successfully");

setVisible(false);
}catch(Exception e){
[Link]();
}
}else{
setVisible(false);
}
}
public static void main(String []args){
new UpdateStudent();
}
}

P a g e 83 |
Update Teacher Details

Code:

package [Link];
import [Link].*;
import [Link].*;
import [Link].*;
import [Link].*;

public class UpdateTeacher extends JFrame implements ActionListener{

JTextField tffaddress,tfphone,tfemail,tfqualification;
JLabel lbid;
JButton submit,cancel;
Choice cid;

UpdateTeacher(){
setSize(900,700);
setLocation(350,50);

setLayout(null);
JLabel heading = new JLabel("Update Teacher Information");
[Link](50,20,450,40);
[Link]([Link]);
[Link](new Font("Century",[Link],30));
add(heading);

JLabel lblid = new JLabel("Select Teacher ID");

[Link](50, 100, 200,30);
P a g e 84 |
[Link](new Font("serif",[Link],20));
add(lblid);

cid = new Choice();

[Link](260, 100, 200, 20);
add(cid);

try{
Conn c = new Conn();
ResultSet rs = [Link]("Select * from teacher");
while([Link]()){
[Link]([Link]("t_id"));
}

}catch(Exception e){
[Link]();
}

JLabel name = new JLabel("Name");

[Link](50, 150, 150, 30);
[Link](new Font("serif",[Link],20));
add(name);

JLabel lblname = new JLabel();

[Link](200, 150, 150, 30);
[Link](new Font("serif",[Link],20));
add(lblname);

JLabel fname = new JLabel("Father's Name");

[Link](400, 150, 200, 30);
[Link](new Font("serif",[Link],20));
add(fname);

JLabel lblfname = new JLabel();

[Link](600, 150, 150, 30);
[Link](new Font("serif",[Link],20));
add(lblfname);

JLabel id = new JLabel("Teacher ID");

[Link](50, 200, 200, 30);
[Link](new Font("serif",[Link],20));
add(id);

lbid = new JLabel();

[Link](200, 200, 200, 30);
[Link](new Font("serif",[Link],20));
add(lbid);

P a g e 85 |
JLabel dob = new JLabel("Date Of Birth");
[Link](400, 200, 200, 30);
[Link](new Font("serif",[Link],20));
add(dob);

JLabel lbldob = new JLabel();

[Link](600, 200, 150, 30);
[Link](new Font("serif",[Link],20));
add(lbldob);

JLabel address = new JLabel("Address");

[Link](50, 250, 200, 30);
[Link](new Font("serif",[Link],20));
add(address);

tffaddress = new JTextField();

[Link](200, 250, 150, 30);
add(tffaddress);

JLabel phone = new JLabel("Phone No.");

[Link](400, 250, 150, 30);
[Link](new Font("serif",[Link],20));
add(phone);

tfphone = new JTextField();

[Link](600, 250, 150, 30);
add(tfphone);

JLabel email = new JLabel("Email ID");

[Link](50, 300, 200, 30);
[Link](new Font("serif",[Link],20));
add(email);

tfemail = new JTextField();

[Link](200, 300, 150, 30);
add(tfemail);

JLabel x = new JLabel("Class X (%)");

[Link](400, 300, 200, 30);
[Link](new Font("serif",[Link],20));
add(x);

JLabel lblx = new JLabel();

[Link](600, 300, 150, 30);
[Link](new Font("serif",[Link],20));
add(lblx);

JLabel xii = new JLabel("Class XII (%)");

P a g e 86 |
[Link](50, 350, 200, 30);
[Link](new Font("serif",[Link],20));
add(xii);

JLabel lblxii = new JLabel();

[Link](200, 350, 150, 30);
[Link](new Font("serif",[Link],20));
add(lblxii);

JLabel graduate = new JLabel("Graduate");

[Link](400, 350, 200, 30);
[Link](new Font("serif",[Link],18));
add(graduate);

JLabel lblgraduate = new JLabel();

[Link](600, 350, 150, 30);
[Link](new Font("serif",[Link],20));
add(lblgraduate);

JLabel aadhar = new JLabel("Aadhar Number");

[Link](50, 400, 200, 30);
[Link](new Font("serif",[Link],20));
add(aadhar);

JLabel lblaadhar = new JLabel();

[Link](200, 400, 150, 30);
[Link](new Font("serif",[Link],20));
add(lblaadhar);

JLabel qualification = new JLabel("Qualification");

[Link](400, 400, 200, 30);
[Link](new Font("serif",[Link],20));
add(qualification);

tfqualification = new JTextField();

[Link](600, 400, 150, 30);
add(tfqualification);

try{
Conn c = new Conn();
String query = "Select * from teacher where t_id='"+[Link]()+"'";
ResultSet rs = [Link](query);
while([Link]()){
[Link]([Link]("name"));
[Link]([Link]("fname"));
[Link]([Link]("dob"));
[Link]([Link]("t_id"));
[Link]([Link]("address"));

P a g e 87 |
 [Link]([Link]("phone"));
[Link]([Link]("email"));
[Link]([Link]("class_x"));
[Link]([Link]("class_xii"));
[Link]([Link]("graduate"));
[Link]([Link]("aadhar"));
[Link]([Link]("qualification"));
}
}catch(Exception e){
[Link]();
}

[Link](new ItemListener(){
public void itemStateChanged(ItemEvent ie){
try{
Conn c = new Conn();
String query = "Select * from teacher where t_id='"+[Link]()+"'";
ResultSet rs = [Link](query);
while([Link]()){
[Link]([Link]("name"));
[Link]([Link]("fname"));
[Link]([Link]("dob"));
[Link]([Link]("t_id"));
[Link]([Link]("address"));
[Link]([Link]("phone"));
[Link]([Link]("email"));
[Link]([Link]("class_x"));
[Link]([Link]("class_xii"));
[Link]([Link]("graduate"));
[Link]([Link]("aadhar"));
[Link]([Link]("qualification"));
}
}catch(Exception e){
[Link]();
}
}
});

submit = new JButton("Update");

[Link](250, 500, 150, 30);
[Link](this);
[Link]([Link]);
[Link]([Link]);
[Link](new Font("Algerian",[Link],20));
add(submit);

cancel = new JButton("Cancel");

[Link](450, 500, 150, 30);

P a g e 88 |
 [Link](this);
[Link]([Link]);
[Link]([Link]);
[Link](new Font("Algerian",[Link],20));
add(cancel);

setVisible(true);
}
public void actionPerformed(ActionEvent ae){
if ([Link]() == submit){
String id = [Link]();
String address = [Link]();
String phone = [Link]();
String email = [Link]();
String qualification = [Link]();

try{
String query = "update teacher set address = '"+address+"',phone = '"+phone+"',email = '"+email+"',
qualification = '"+qualification+"' where t_id ='"+id+"'";

Conn c = new Conn();

[Link](query);

[Link](null, "Teacher Information Updated Successfully");

setVisible(false);
}catch(Exception e){
[Link]();
}
}else{
setVisible(false);
}
}
public static void main(String []args){
new UpdateTeacher();
}
}
kkkkkkkk

P a g e 89 |
Fees Structure:

Code:

package [Link];

import [Link].*;
import [Link].*;
import [Link].*;
import [Link];

public class FeeStructure extends JFrame{

FeeStructure(){
setSize(1000,750);
setLocation(250,100);
setLayout(null);

getContentPane().setBackground([Link]);

JLabel heading = new JLabel("Fee Structure");

[Link](50, 20, 350, 30);
[Link](new Font("Century",[Link],30));
[Link]([Link]);
add(heading);

JTable table = new JTable();

try{
Conn c = new Conn();
ResultSet rs = [Link]("select * from fee");
[Link]([Link](rs));
P a g e 90 |
 }catch(Exception e){
[Link]();
}

JScrollPane jsp = new JScrollPane(table);

[Link](0, 60, 1000, 750);
add(jsp);

setVisible(true);
}

public static void main(String[] args){

new FeeStructure();
}
}

Student fee form

Code:

package [Link];

import [Link].*;
import [Link].*;
import [Link].*;
import [Link].*;

public class StudentFeeForm extends JFrame implements ActionListener{

Choice crollno;
JComboBox cbcourse,cbsemester;
JLabel lbltotal;
JButton update,pay,back;
P a g e 91 |
StudentFeeForm(){
setSize(800,500);
setLocation(300,150);
setLayout(null);

getContentPane().setBackground([Link]);

ImageIcon i1 = new ImageIcon([Link]("icons/[Link]"));

Image i2 = [Link]().getScaledInstance(380, 300, Image.SCALE_DEFAULT);
ImageIcon i3 = new ImageIcon(i2);
JLabel image = new JLabel(i3);
add(image);
[Link](400,20,380,300);

JLabel lblrollnumber = new JLabel("Select Roll No.");

[Link](40, 60, 150,20);
[Link](new Font("serif",[Link],20));
add(lblrollnumber);

crollno = new Choice();

[Link](200, 60, 150, 20);
add(crollno);

try{
Conn c = new Conn();
ResultSet rs = [Link]("Select * from student");
while([Link]()){
[Link]([Link]("roll"));
}

}catch(Exception e){
[Link]();
}

JLabel name = new JLabel("Name");

[Link](40, 100, 150, 20);
[Link](new Font("serif",[Link],20));
add(name);

JLabel lblname = new JLabel();

[Link](200, 100, 150, 20);
[Link](new Font("serif",[Link],20));
add(lblname);

JLabel fname = new JLabel("Father's Name");

[Link](40, 140, 150, 20);
[Link](new Font("serif",[Link],20));
add(fname);

P a g e 92 |
 JLabel lblfname = new JLabel();
[Link](200, 140, 150, 20);
[Link](new Font("serif",[Link],20));
add(lblfname);

try{
Conn c = new Conn();
String query = "Select * from student where roll='"+[Link]()+"'";
ResultSet rs = [Link](query);
while([Link]()){
[Link]([Link]("name"));
[Link]([Link]("fname"));
}
}catch(Exception e){
[Link]();
}

[Link](new ItemListener(){
public void itemStateChanged(ItemEvent ie){
try{
Conn c = new Conn();
String query = "Select * from student where roll='"+[Link]()+"'";
ResultSet rs = [Link](query);
while([Link]()){
[Link]([Link]("name"));
[Link]([Link]("fname"));
}
}catch(Exception e){
[Link]();
}
}
});

JLabel lblcourse = new JLabel("Course");

[Link](40, 180, 150, 20);
[Link](new Font("serif",[Link],20));
add(lblcourse);

String course[] = {"BCA","BBA","BBM","MCA","MBA","[Link]","[Link]","BA"};

cbcourse = new JComboBox(course);
[Link](200, 180, 150, 20);
[Link]([Link]);
add(cbcourse);

JLabel lblsemester = new JLabel("Semester");

[Link](40, 220, 150,20);
[Link](new Font("serif",[Link],20));
add(lblsemester);

String semester[] =
{"Semester1","Semester2","Semester3","Semester4","Semester5","Semester6","Semester7","Semester8"};
P a g e 93 |
 cbsemester = new JComboBox(semester);
[Link](200, 220, 150, 20);
[Link]([Link]);
add(cbsemester);

JLabel total = new JLabel("Total Payable");

[Link](40,260,150,20);
[Link](new Font("serif",[Link],20));
add(total);

lbltotal = new JLabel();

[Link](200,260,150,20);
[Link](new Font("serif",[Link],20));
add(lbltotal);

update = new JButton("Update");

[Link](30, 350, 100, 30);
[Link](this);
[Link]([Link]);
[Link]([Link]);
add(update);

pay = new JButton("Pay Fee");

[Link](150, 350, 100, 30);
[Link](this);
[Link]([Link]);
[Link]([Link]);
add(pay);

back = new JButton("Back");

[Link](270, 350, 100, 30);
[Link](this);
[Link]([Link]);
[Link]([Link]);
add(back);
setVisible(true);
}
public void actionPerformed(ActionEvent ae){
if([Link]() == update){
String course = (String) [Link]();
String semester = (String) [Link]();
try{
Conn c = new Conn();
ResultSet rs = [Link]("select * from fee where course = '"+course+"'");
while([Link]()){
[Link]([Link](semester));
}
}catch(Exception e){
[Link]();
}
}else if([Link]() == pay){
P a g e 94 |
 String rollno = [Link]();
String course = (String) [Link]();
String semester = (String) [Link]();
String total =(String) [Link]();
try{
Conn c = new Conn();
String query = "insert into collegefee values('"+rollno+"','"+course+"','"+semester+"','"+total+"')";
[Link](query);

[Link](null, "College Fee Submitted Successfully");

setVisible(false);
}catch(Exception e){
[Link]();
}
}else{
setVisible(false);
}
}
public static void main(String[] args){
new StudentFeeForm();
}
}

Connection establish([Link])

package [Link];
import [Link].*;

public class Conn {

Connection c;
Statement s;

Conn(){
try{
[Link]("[Link]");
c=
[Link]("jdbc:mysql://localhost:3306/universitymanagementsystem","root","uraj@199
4");
s = [Link]();
}catch(Exception e){
[Link]();
}
}
}

P a g e 95 |
About([Link])

Code:

package [Link];

import [Link].*;
import [Link].*;

public class About extends JFrame{

About(){
setSize(700,500);
setLocation(400,200);
setLayout(null);

getContentPane().setBackground([Link]);

ImageIcon i1 = new ImageIcon([Link]("icons/[Link]"));

Image i2 = [Link]().getScaledInstance(400, 300, Image.SCALE_DEFAULT);
ImageIcon i3 = new ImageIcon(i2);
JLabel image = new JLabel(i3);
add(image);
[Link](400,20,250,250);

JLabel heading = new JLabel("<html>University <br> Management System</html>");

[Link](50, 20, 350, 130);
[Link](new Font("Century",[Link],30));
P a g e 96 |
 [Link]([Link]);
add(heading);

JLabel name = new JLabel("Developed By: Utkarsh Raj");

[Link](70, 225, 450, 130);
[Link](new Font("Century",[Link],30));
[Link]([Link]);
add(name);

JLabel course = new JLabel("<html>Roll No. 109 <br>Batch : BCA B3 3rd Year (452)</html>");
[Link](70, 300, 350, 130);
[Link](new Font("Century",[Link],30));
add(course);

JLabel contact = new JLabel("Contact: rajutkarsh139@[Link]");

[Link](70, 375, 500, 130);
[Link](new Font("Century",[Link],30));
add(contact);

setVisible(true);
}
public static void main(String[] args){
new About();
}
}

BIBLIOGRAPHY

• Java Programming Documentation

• SQL Workbench Reference Guide
• Apache NetBeans Developer Guide
• System Analysis and Design Books

P a g e 97 |