SIBAN Ip Project

JAWAHAR NAVODAYA VIDYALAYA
ANGUL
INFORMATICS PRACTICES PROJECT
2019-20
ANIMAL AND PLANT KINGDOM
Submitted to Submitted by
MISS DOLLY NAYAK NAME : SIBAN PRADHAN
(P.G.T I.P) HALL TICKET NO. :

ACKNOWLEDGEMENT
It is my humble pleasure to acknowledge my deep

sense of gratitude to Mr. Rudra Prasad Sahoo , Principal
JNV ANGUL ,providing me laboratory facilities to carry
out this project.
I express my sincere thanks to Miss Dolly Nayak,
PGT I.T for his valuable support, constant help and
guidance at each and every stage, without which it
wouldn’t have been possible to complete this project.
Name: Siban Pradhan

Class : XII Sc.
CERTIFICATE
This is to certify that SIBAN

PRADHAN of class XII has
created an application(project) named “PLANT AND
ANIMAL KINGDOM” . He has successfully prepared
this project report in the I.P laboratory of JAWAHAR
NAVODAYA VIDYALAYA ANGUL. This project may be
considered as partial fulfillment of AISSCE 2019-20
conducted by the Central Board of Secondary
Education, Bhubaneswar region.
Date: Signature of the student
HALL TICKET NO:-

Introduction
Biology project is about the animal and plant
kingdom this helps the biology students to find the
particular animal and plant details something like
biological, genus ,order etc. here I used netbeans IDE
8.2 as the front end and mysql as the back end
If he/ she does't understand the classification

they can approach the another form in which he can
understand the different classification related to the
certain group and they can also insert the records if
they know the full information about the particular animal
or plant
The application uses Database Connectivity to

connect front end and back end.
We hope that the present application will cater

the needs of biology students as a matter of fact,
we would feel rewarded if this application is
found helpful to the users .All the attempts have
been made to make this application error free.
Theoretical Background
What is Database?
Introduction and Concepts:

A database is a collection of information related to a particular subject or purpose, such
as tracking customer orders or maintaining a music collection. Using any RDBMS
application software like MS SQL Server, MySQL, Oracle, Sybase etc, you can manage all
your information from a single database file. Within the file, divide your data into
separate storage containers called tables. You may and retrieve the data using queries.
A table is a collection of data about a specific topic, such as products or suppliers. Using
a separate table for each topic means you can store that data only once, which makes
your database more efficient and reduces data-entry errors. Table organises data into
columns (called fields) and rows (called records).
A Primary key is one or more fields whose value or values uniquely identify each record
in a table. In a relationship, a primary key is used to refer to specific record in one table
from another table. A primary key is called foreign key when it is referred to from
another table.
What is My SQL ?
The management of data in a database system is done by means of a general-purpose
software package called a Database Management System (DBMS). Some commercially
available RDBMS are MS SQL Server, MS ACCESS, INGRES, ORACLE, and Sybase.
 MySQL is a database management system.

 MySQL is based on SQL.
 MySQL software is Open Source.
 The MySQL Database Server is very fast, reliable, and easy to use.
 MySQL Server works in client/server or embedded systems.
 Unix. Connector/J source is available.
3.3 What is NetBeans IDE ?
NetBeans started as a student project (originally called Xelfi) in the Czech Republic in
1996. The goal was to write a Delphi-like Java IDE in Java. Xelfi was the first Java IDE
(Integrated Development Environment) written in Java, with its first pre-releases in
1997. Xelfi was a fun project to work on, especially since Java IDE space was uncharted
territory at that time. The project attracted enough interest that these students, once
they graduated, decided that they could market it as a commercial product. Soliciting
resources from friends and relatives for a web space, they formed a company around it.
OBJECTIVE
T he objective of the software project is to develop a computerized MIS to
automate the functions of a PLANT AND ANIMAL KINGDOM .This software project is
also aimed to enhance the current record keeping system, which will help managers to
retrieve the up-to-date information at right time in right shape.
The proposed software system is expected to do the following functionality-
 To provide a user friendly, Graphical User Interface (GUI) based integrated and
centralized environment for MIS activities.
 The proposed system should maintain all the records and transactions, and should
generate the required reports and information when required.
 To provide graphical and user-friendly interface to interact with a centralized database
based on client-server architecture.
 To identify the critical operation procedure and possibilities of simplification using
modern IT tools and practices.
In its current scope, the software enables user to retrieve and update the information
from centralized database designed with MySQL . This software does not require much
training time of the users due to limited functionality and simplicity.
During the development of PLANT AND ANIMAL KINGDOM project, Java NetBeans IDE,
a powerful, open source event-driven form-based development environment is used for
modular design and future expandability of the system.
Despite of the best effort of the developer, the following limitations and functional
boundaries are visible, which limits the scope of this application software.
1. This software can store records and produce reports in pre-designed format in soft
copy. There is no facility yet to produce customized reports. Only specified reports are
covered.
2. There is no provision to calculate fine or penalty etc. for defaulter members; however it
can be developed easily with the help of adding modules.
3. Some application area like accounting of vehicles and fines etc. are not implemented in
the project. It facilitates manager to record and update only transaction record.
So far as future scope of the project is concerned, firstly it is open to any modular
expansion i.e. other modules or functions can be designed and embedded to handle the
user need in future. Any part of the software and reports can be modified independently
without much effort.
Problem Definition & Analysis
The hardest part of building a software system is deciding precisely what to build. No
other part of the conceptual work is so difficult as establishing the detailed technical
requirement. Defining and applying good, complete requirements are hard to work, and
success in this endeavor has eluded many of us. Yet, we continue to make progress.
Problem definition describes the What of a system, not How . The quality of a software
product is only as good as the process that creates it. Problem definition is one of the
most crucial steps in this creation process. Without defining a problem, developers do
not know what to build, customers do not know what to expect, and there is no way to
validate that the built system satisfies the requirement.
Problem definition and Analysis is the activity that encompasses learning about the
problem to be solved, understanding the needs of customer and users, trying to find out
who the user really is, and understanding all the constraints on the solution. It includes
all activities related to the following:
 Identification and documentation of customer’s or user’s needs.

 Creation of a document that describes the external behavior and the association
constraints that will satisfies those needs.
 Analysis and validation of the requirements documents to ensure consistency,
completeness, and feasibility
 Evolution of needs.
After the analysis of the functioning of a PLANT AND ANIMAL KINGDOM, the proposed
System is expected to do the following: -
 To provide a user friendly, Graphical User Interface (GUI) based integrated and
centralized environment for computerized Plant And Animal Kingdom,
 The proposed system should maintain all the records and transactions, and
should generate the required reports and information when required.
 To provide efficient and secured Information storage, flow and retrieval system,
ensuring the integrity and validity of records.
 To provide graphical and user-friendly interface to interact with a centralized

database based on client-server architecture.
 To identify the critical operation procedure and possibilities of simplification

using modern IT tools and practices.
System Implementation
The Hardware used:

While developing the system, the used hardware are:
Laptop with AMD A8 Processor (1.60GHz), having 6 GB RAM and other required
devices.
The Software’s used:

 Microsoft Windows® 10 as Operating System.
 Java NetBeans 8.2 as Front-end Development environment.
 MySQL as Back-end Sever with Database for Testing.
 MS-Word 2010 for documentation.

BIBLIOGRAPHY
In order to work on this project titled – plant and animal kingdom , the following
books and literature are referred by me during the various phases of development of
the project.
(1) The Complete Reference Java 2.0 -by Shildit
(2) MySQL, Black Book -by Steven Holzner
(3) Understanding SQL – Gruber
(4) http://www.mysql.org/
(5) http://www.netbeans.org/
(6) On-line Help of NetBeans ®
(7) Informatics Practices for class XII -by Sumita Arora

CODE FOR ADD BUTTON:
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
String name,biological,genus,family,order,clas,phylum;
name= jTextField1.getText();
biological=jTextField2.getText();
genus=jTextField3.getText();
family=jTextField4.getText();
order=jTextField5.getText();
clas=jTextField6.getText();
phylum=jTextField7.getText();
if(name.isEmpty())
JOptionPane.showMessageDialog(this," name is not entered");
else if (biological.isEmpty())
JOptionPane.showMessageDialog(this," biological name is not
entered");
else
if(genus.isEmpty())
JOptionPane.showMessageDialog(this," genus name is not
entered");
else
if(family.isEmpty())
JOptionPane.showMessageDialog(this," family name is not
entered");
else
if(order.isEmpty())
JOptionPane.showMessageDialog(this," order name is not
entered");
else
if(clas.isEmpty())
JOptionPane.showMessageDialog(this," class name is not
entered");
else
if(phylum.isEmpty())
JOptionPane.showMessageDialog(this," phylum name is not
entered");
else
{
try
{
Class.forName("java.sql.DriverManager");
Connection con=(Connection)
DriverManager.getConnection("jdbc:mysql://localhost:3306/BIOLOGY","r
oot","password");
Statement stmt=(Statement)con.createStatement();
String query="INSERT INTO FRIEND
VALUES('"+name+"','"+biological+"','"+genus+"','"+family+"','"+order+"','"
+clas+"','"+phylum+"');";
stmt.executeUpdate(query);
}
catch(Exception e)
{
JOptionPane.showMessageDialog(this,e.getMessage());
}
JOptionPane.showMessageDialog(this,"your file file has been
successfully saved");
}
}
CODE FOR SEARCH BUTTON:

String name =
null,biological=null,genus=null,family=null,order=null,clas=null,phylum=n
ull;
if(jRadioButton1.isSelected())
{ name=jTextField1.getText();
{if(name.isEmpty())
{
jTextField2.setText("");
JOptionPane.showMessageDialog(this,"enter the name");
}
else
{
try
{ Class.forName("java.sql.DriverManager");
oot","password");
String query="SELECT
BIOLOGICAL_NAME,GENUS,FAMILY,B_ORDER,B_CLASS,PHYLUM
FROM FRIEND WHERE COMMON_NAME='"+name+"';";
ResultSet rs =stmt.executeQuery(query);
int found=0;
while(rs.next())
{
biological=rs.getString("BIOLOGICAL_NAME");
genus=rs.getString("GENUS");
family=rs.getString("FAMILY");
order=rs.getString("B_ORDER");
clas=rs.getString("B_CLASS");
phylum=rs.getString("PHYLUM");
jTextField2.setText(biological);
jTextField3.setText(genus);
jTextField4.setText(family);
jTextField5.setText(order);
jTextField6.setText(clas);
jTextField7.setText(phylum);
JOptionPane.showMessageDialog(this,"(click OK to
continue");
found++;
}
if(found=0)
JOptionPane.showMessageDialog(this,"sorry such no name
is found");
}
catch(Exception e)
{
JOptionPane.showMessageDialog(this,"e.getMessage");
}
}
}
}
else
{ biological=jTextField2.getText();
{ if(biological.isEmpty())
{
JOptionPane.showMessageDialog(this,"enter the biological
name");
}
else
{
try
oot","password");
COMMON_NAME,GENUS,FAMILY,B_ORDER,B_CLASS,PHYLUM
FROM FRIEND WHERE BIOLOGICAL_NAME='"+biological+"';";
int found=0;
while(rs.next())
{
name=rs.getString("COMMON_NAME");
jTextField1.setText(name);
JOptionPane.showMessageDialog(this,"click OK to
continue");
found++;
}
if(found==0)
JOptionPane.showMessageDialog(this,"sorry no biological
name is found");
}
catch(Exception e)
{
}
}
}
}
else
{ genus=jTextField3.getText();
{ if(genus.isEmpty())
{
JOptionPane.showMessageDialog(this,"enter the genus");
}
else
{
try
oot","password");
COMMON_NAME,BIOLOGICAL_NAME,FAMILY,B_ORDER,B
_CLASS,PHYLUM FROM FRIEND WHERE
GENUS='"+genus+"';";
int found=0;
while(rs.next())
{
continue");
found++;
}
if(found==0)
JOptionPane.showMessageDialog(this,"sorry no such genus is
found");
}
catch(Exception e)
{
}
}
}
}
else
{ family=jTextField4.getText();
{ if(family.isEmpty())
{
JOptionPane.showMessageDialog(this,"enter the family");
}
else
{
try
oot","password");
COMMON_NAME,BIOLOGICAL_NAME,GENUS,B_ORDER,B_CLASS,
PHYLUM FROM FRIEND WHERE FAMILY='"+family+"';";
int found=0;
while(rs.next())
{
continue");
found++;
}
if(found==0)
JOptionPane.showMessageDialog(this,"sorry no such family is
found");
}
catch(Exception e)
{
}
}
}
}
else
{ order=jTextField5.getText();
{ if(order.isEmpty())
{
JOptionPane.showMessageDialog(this,"enter the order");
}
else
{
try
oot","password");
COMMON_NAME,BIOLOGICAL_NAME,GENUS,FAMILY,B_CLASS,P
HYLUM FROM FRIEND WHERE B_ORDER='"+order+"';";
int found=0;
while(rs.next())
{
continue");
found++;
}
if(found==0)
JOptionPane.showMessageDialog(this,"sorry no such order is
found");
}
catch(Exception e)
{
}
}
}
}
else
{ clas=jTextField6.getText();
{ if(clas.isEmpty())
{
JOptionPane.showMessageDialog(this,"enter the class");
}
else
{
try
oot","password");
COMMON_NAME,BIOLOGICAL_NAME,GENUS,FAMILY,B_ORDER,P
HYLUM FROM FRIEND WHERE B_CLASS='"+clas+"';";
int found=0;
while(rs.next())
{
continue");
found++;
}
if(found==0)
JOptionPane.showMessageDialog(this,"sorry no such class is
found");
}
catch(Exception e)
{
}
}
}
}
else
JOptionPane.showMessageDialog(this," please do full
information about this and login to this site");
}
MYSQL TABLE FOR THE FORM:
DESCRICPTION OF TABLE:
TABLE:
FRAME FOR THE MORE INFORMATION
BUTTON:
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt)

{
JOptionPane.showMessageDialog(this,"THIS IS THE COMMON
NAME GIVEN TO CERTAIN ANIMAL TO CALL IT GENERALLY");
}

{
JOptionPane.showMessageDialog(this,"THIS IS THE BIOLOGICAL
NAME GIVEN TO ANIMAL ACCORDING TO THE CLASSIFICATION");
}
{
new mybrother().setVisible(true);
new sanjana().setVisible(false);
}
{
new BIOLOGY().setVisible(true);
}
new mybrother().setVisible(false);
{
JOptionPane.showMessageDialog(this,"group of releted genera
with still less no. of similarities as compared to genus and species");
}
more characters in common is compared to species of the genera");
}
private void jButton5ActionPerformed(java.awt.event.ActionEvent evt) {
new sanjana().setVisible(false);
new friend().setVisible(true);
}
{
JOptionPane.showMessageDialog(this,"It comprises of a group of
related species which has
{
JOptionPane.showMessageDialog(this,"these are based on
aggregates of characters these exhibit a few similar characters");
}
FRAME FOR CLASS BUTTON:

SIBAN Ip Project

Uploaded by

Copyright:

Available Formats

SIBAN Ip Project

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

SIBAN Ip Project

Uploaded by

Copyright:

Available Formats

JAWAHAR NAVODAYA VIDYALAYA

ANIMAL AND PLANT KINGDOM

(P.G.T I.P) HALL TICKET NO. :

It is my humble pleasure to acknowledge my deep

Name: Siban Pradhan

This is to certify that SIBAN

Date: Signature of the student

HALL TICKET NO:-

If he/ she does't understand the classification

The application uses Database Connectivity to

We hope that the present application will cater

Introduction and Concepts:

 MySQL is a database management system.

3.3 What is NetBeans IDE ?

The proposed software system is expected to do the following functionality-

 Identification and documentation of customer’s or user’s needs.

 To provide graphical and user-friendly interface to interact with a centralized

 To identify the critical operation procedure and possibilities of simplification

The Hardware used:

The Software’s used:

 Java NetBeans 8.2 as Front-end Development environment.

 MySQL as Back-end Sever with Database for Testing.

 MS-Word 2010 for documentation.

(1) The Complete Reference Java 2.0 -by Shildit

(2) MySQL, Black Book -by Steven Holzner

(3) Understanding SQL – Gruber

(6) On-line Help of NetBeans ®

(7) Informatics Practices for class XII -by Sumita Arora

CODE FOR SEARCH BUTTON:

private void jButton1ActionPerformed(java.awt.event.ActionEvent evt)

private void jButton2ActionPerformed(java.awt.event.ActionEvent evt)

You might also like