ACKNOWLEDGEMENT

At the outset I am especially indebted to lord almighty for flooding his grace and blessings on me in all
aspects to terminate this project on fine manner and schedule.

I thank my informatics practioner teacher [Link] Rajesh for conceiving in me the required confidence to
incorporate this project and nurture me with constructive suggestions and critical insights to wind up this
project.

I also express thanks to my fellow batch mates who with small but really helpful guidance stood beside me to
develope this work.

thank you all

1
CONTENTS

i. system requirments and

specifications
ii. introducton
iii. database dictionary
iv. source code
v. output
vi. biblogrraphy

2
 PROJECT AT A GLANCE

Agro SOFT management software is a user-friendly application

which helps the common busy farmers to audit there expense and
calculate their gains on a daily bases than the conventional paper-
pen-accounting method. It helps us in analyzing the day to day
activities in the farm with accurate calculations according to each
and overall sector of farming practiced.

The project mainly contains the following forms-

LOGIN PAGE
The user enters correct login username and password to enter into
the home menu.

HOME MENU
A door to different sectors of animal agricultural sector managed.

CATTLE SECTOR
Auditing of daily expense and earnings and its [Link] overall
gain in this sector can also be known.

POULTRY SECTOR
Auditing of daily expense and earnings and its [Link] overall
gain in this sector can also be known.

3
RABBIT SECTOR
Auditing of daily expense and earnings and its [Link] overall
gain in this sector can also be known.

EXOTIC PETS SECTOR

Auditing of daily expense and earnings and its [Link] overall
gain in this sector can also be known.

OVERALL EVALUATION
The overall evaluation of the complete sector is displayed with the
overall PROFIT or LOSS.

4
system requirments and
specifications

To develop a new system ,certain hardware and software

specifications are needed.

SYSTEM REQUIRMENTS
[Link]-IBM-compatiable
[Link]-Pentium 4
[Link]-2.0GHz
[Link] Disk-20GB

HARDWARE SPECIFICATIONS

[Link] System-Windows XP or above

[Link] Environment-Net Beans
[Link] used=Java
[Link] End-Java
[Link] End-Mysql

5
 Database
Dictionary

TABLES IN MYSQL

Cattle
Field Type Null Default
eid int(11) YES NULL
vac int(11) YES NULL
mant int(11) YES NULL
feed int(11) YES NULL
bio int(11) YES NULL
milk int(11) YES NULL
date YES NULL
char(78)
int(11) YES NULL
number

RABBIT
Field Type Null Default
eid int(11) YES NULL
vac int(11) YES NULL
mant int(11) YES NULL
feed int(11) YES NULL
bio int(11) YES NULL
milk int(11) YES NULL
date char(78) YES NULL
number int(11) YES NULL

6
POULTRY
Field Type Null Default

eid int(11) YES NULL

vac int(11) YES NULL
mant int(11) YES NULL
feed int(11) YES NULL
bio int(11) YES NULL
fur int(11) YES NULL
date char(45) YES NULL
number int(11) YES NULL

EXOTIC
Field Type Null Default
id int(11) YES NULL
breed char(47) YES NULL
no int(11) YES NULL
mant int(11) YES NULL
feed int(11) YES NULL
price int(11) YES NULL
date char(45) YES NULL

SELLCATTLE
Field Type Null Default
iid int(11) YES NULL
sell int(11) YES NULL

SELLRABBIT
Field Type Null Default
iid int(11) YES NULL
sell int(11) YES NULL

7
SELLPOULTRY
Field Type Null Default
iid int(11) YES NULL
sell int(11) YES NULL

SELLEXOTIC
Field Type Null Default
iid int(11) YES NULL
sell int(11) YES NULL

8
LOGIN FRAME
import [Link];
public class login extends [Link] {
public login() {
initComponents() }
private void LOGIN ActionPerformed([Link] evt) {
String t1a=[Link]();
String t2b=[Link]();
String a="ericj";
String b="qwerty";
if([Link](a) && [Link](b))
{[Link](null,"User verified");
HOME ac = new HOME();
[Link](true);
[Link]();}
else
{[Link](null,"User not verified,TRY AGAIN");
[Link]("");
[Link]("");}
public static void main(String args[]) {
[Link](new Runnable() {
public void run() {
new exoticsell().setVisible(true);
}}); }

9
HOME FRAME
public class HOME extends [Link] {
public HOME() {
initComponents();}
private void EXOTIC MouseClicked([Link] evt) {
exotic a=new exotic();
[Link](true);
this .dispose();}
private void RABBIT MouseClicked([Link] evt) {
rabitdat rb=new rabitdat();
[Link](true);
[Link](); }
private void CATTLE MouseClicked([Link] evt) {
cattledat rb=new cattledat();
[Link](true);
[Link](); }
private void POULTRY MouseClicked([Link] evt) {
poultrydat rb=new poultrydat();
[Link](true);
[Link](); }
private void jButton2ActionPerformed([Link] evt) {
evltable w2 = new evltable();
[Link](true);
[Link]();}

public static void main(String args[]) {

[Link](new Runnable() {
10
public void run() {
new HOME().setVisible(true);
}}); }

CATTLE DATE

import [Link].*;
import [Link];
public class cattledat extends [Link] {
public cattledat() {
initComponents();}

public static String s1,s2,s3;

private void cb1ActionPerformed([Link] evt) {
s1=(String) [Link]();
[Link](s1);}
private void cb3ActionPerformed([Link] evt) {
s3=(String) [Link]();
[Link](s3);}
private void cb2ActionPerformed([Link] evt) {
s2=(String) [Link]();
[Link](s2);}
private void formWindowActivated([Link] evt) {
[Link](3);
[Link]("");}
private void jButton1ActionPerformed([Link] evt) {
cattle ac = new cattle();
11
[Link](true);
[Link]();}
private void jButton4ActionPerformed([Link] evt) {
HOME w = new HOME();
[Link](true);
[Link]();}

public static void main(String args[]) {

[Link](new Runnable() {
public void run() {
new cattledat().setVisible(true);
}});}

CATTLE
import [Link].*;
import [Link];
public class cattle extends [Link] {
public cattle() {

initComponents();}
int t,to;
ResultSet rs,ab,b;
private void jButton1ActionPerformed([Link] evt) {
int tt=[Link]([Link]());
int nno=[Link]([Link]());
int dno=[Link]([Link]());
tt=tt+nno-dno;
12
int v,f,man,bio,milk;
if([Link]().equals(""))
v=0;
else
v =[Link]([Link]());
if([Link]().equals(""))
man=0;
else
man=[Link]([Link]());
if([Link]().equals(""))
f=0;
else
f=[Link]([Link]());
if([Link]().equals(""))
bio=0;
else
bio=[Link]([Link]());
if([Link]().equals(""))
milk=0;
else
milk =[Link]([Link]());
cattledat c=new cattledat();
String dat=(c.s1+"-"+c.s2+"-"+c.s3);
try
{[Link]("[Link]");

13
 Connection
con=[Link]("jdbc:mysql://localhost:3306/ericproject","root
","root");
Statement st=[Link]();
rs=[Link]("select * from cattle;");
[Link]();
int id =[Link](1);
int newid=id + 1;
[Link]("insert into cattle
values("+newid+","+v+","+man+","+f+","+bio+","+milk+","+"'"+dat+"'"+","+tt+"
);");
}catch(Exception e)
{[Link]([Link]());}
try
{[Link]("[Link]");
Connection
con=[Link]("jdbc:mysql://localhost:3306/ericproject","root
","root");
Statement st=[Link]();
b=[Link]("select * from cattle;");
[Link]();
int to=[Link](8);
[Link](""+to);
}catch(Exception e)
{[Link]([Link]());}
[Link]("");
[Link]("");
[Link]("");
[Link]("");
14
[Link]("");
[Link]("");
[Link]("");
[Link]("");
[Link]("");}
private void zMouseClicked([Link] evt) {
int x1 =[Link]([Link]());
int y1 =[Link]([Link]());
[Link](""+x1*y1);
}
private void formWindowActivated([Link] evt) {
try
{[Link]("[Link]");
Connection
con=[Link]("jdbc:mysql://localhost:3306/ericproject","root
","root");
Statement st=[Link]();
b=[Link]("select * from cattle;");
[Link]();
int t=[Link](8);
[Link](""+t);
}catch(Exception e)
{[Link]([Link]());}
}
private void jButton4ActionPerformed([Link] evt) {
cattledat w = new cattledat();
[Link](true);

15
[Link](); }
private void jMenuItem1ActionPerformed([Link] evt) {
cattletable aa = new cattletable();
[Link](true);
[Link]();}
private void
jMenuItem2ActionPerformed([Link] evt) {
cattelsell ab = new cattelsell();
[Link](true);
[Link](); }

public static void main(String args[]) {

[Link](new Runnable() {
public void run() {
new cattle().setVisible(true);
}}); }

CATTTLE SELL

import [Link].*;
public class cattelsell extends [Link] {
public cattelsell() {
initComponents();}

ResultSet rs,ra; int est, ano , cno ,aprice ,cprice,dno,nno;

public static int w;
16
private void t5MouseClicked([Link] evt) {
ano =[Link]([Link]());
cno =[Link]([Link]());
aprice =[Link]([Link]());
cprice =[Link]([Link]());
est=(ano*aprice)+(cno*cprice);
[Link](""+est);}
private void jButton1ActionPerformed([Link] evt) {
try {
[Link]("[Link]");
Connection
con=[Link]("jdbc:mysql://localhost:3306/ericproject","root
","root");
Statement st=[Link]();
rs=[Link]("select * from cattle;");
[Link]();
int t=[Link](8);
int id =[Link](1);
if([Link]().equals(""))
nno=0;
else
dno=[Link]([Link]());
if([Link]().equals(""))
dno=0;
else
dno=[Link]([Link]());
t=t+nno-dno;

17
[Link]("update cattle set number="+t+" where eid="+id+";");
w=(ano*aprice)+(cno*cprice);
ra=[Link]("select * from sellcattle;");
[Link]();
int iid =[Link](1);
iid=iid+1;
[Link]("insert into sellcattle values("+iid+","+w+");");
}catch(Exception e) {
[Link]([Link]());}}
private void jButton4ActionPerformed([Link] evt) {
cattle w2 = new cattle();
[Link](true);
[Link]}

public static void main(String args[]) {

[Link](new Runnable() {
public void run() {
new cattelsell().setVisible(true);
}});}

CATTLE TABLE
import [Link].*;
import [Link];
import [Link];
public class cattletable extends [Link] {
public cattletable() {
initComponents();}
18
ResultSet rs,b,ra;
public static int cp, sp,evl;
private void formWindowActivated([Link] evt) {
DefaultTableModel tb=(DefaultTableModel)[Link]();
try
{[Link]("[Link]");
Connection
con=[Link]("jdbc:mysql://localhost:3306/ericproject","root
","root");
Statement st=[Link]();
rs=[Link]("select * from cattle;");
while([Link]())
{String a=[Link](7);
String b=[Link](4);
String c=[Link](2);
String d=[Link](3);
String e=[Link](6);
String f=[Link](5);
Object o[]={a,b,c,d,e,f};
[Link](o);}
}catch(Exception e)
{[Link]([Link]());}}
private void jButton1ActionPerformed([Link] evt) {
try {
[Link]("[Link]");
Connection
con=[Link]("jdbc:mysql://localhost:3306/ericproject","root
","root");
19
Statement st=[Link]();
b=[Link]("select (sum(vac)+sum(mant)+sum(feed)) from cattle;");
[Link]();
cp=[Link](1);
b=[Link]("select (sum(milk)+sum(bio)) from cattle;");
[Link]();
sp=[Link](1);
ra=[Link]("select sum(sell) from sellcattle;");
int sell=[Link](1);
sp=sp+sell;
}catch(Exception e) {
[Link]([Link]());}
evl=sp-cp;
[Link](""+cp);
[Link](""+sp);
[Link](""+evl);}
private void jButton4ActionPerformed([Link] evt) {
cattle w1 = new cattle();
[Link](true);
[Link]();}

public static void main(String args[]) {

[Link](new Runnable() {
public void run() {
new cattletable().setVisible(true);
}});}

20
RABBIT DATE
public class rabitdat extends [Link] {
public rabitdat() {
initComponents();}

public static String s1,s2,s3;

private void cb1ActionPerformed([Link] evt) {
s1=(String) [Link]();
[Link](s1); }
private void cb3ActionPerformed([Link] evt) {
s3=(String) [Link]();
[Link](s3);}
private void cb2ActionPerformed([Link] evt) {
s2=(String) [Link]();
[Link](s2); }
private void jButton1ActionPerformed([Link] evt) {
rabbits ac = new rabbits();
[Link](true);
[Link]();}
private void jButton4ActionPerformed([Link] evt) {
HOME w = new HOME();
[Link](true);
[Link](); }

public static void main(String args[]) {

[Link](new Runnable() {
public void run() {
21
new rabitdat().setVisible(true);
}});}

RABBIT
import [Link].*;
public class rabbits extends [Link] {
public rabbits() {
initComponents();}

ResultSet rs,ab,b;
int t,to;
private void jButton2ActionPerformed([Link] evt) {
rabbitsell ab = new rabbitsell();
[Link](true);
[Link]();}
private void jButton1ActionPerformed([Link] evt) {
int tt=[Link]([Link]());
int nno=[Link]([Link]());
int dno=[Link]([Link]());
tt=tt+nno-dno;
int v,f,man,bio,fur;
if([Link]().equals(""))
v=0;
else
v =[Link]([Link]());
if([Link]().equals(""))
man=0;
22
else
man=[Link]([Link]());
if([Link]().equals(""))
f=0;
else
f=[Link]([Link]());
if([Link]().equals(""))
bio=0;
else
bio=[Link]([Link]());
if([Link]().equals(""))
fur=0;
else
fur =[Link]([Link]());
rabitdat c=new rabitdat();
String dat=(c.s1+"-"+c.s2+"-"+c.s3);
try
{[Link]("[Link]");
Connection
con=[Link]("jdbc:mysql://localhost:3306/ericproject","root
","root");
Statement st=[Link]();
rs=[Link]("select * from rabbit;");
[Link]();
int id =[Link](1);
int newid=id + 1;

23
[Link]("insert into rabbit
values("+newid+","+v+","+man+","+f+","+bio+","+fur+","+"'"+dat+"'"+","+tt+");
");
}catch(Exception e)
{[Link]([Link]());}
try
{[Link]("[Link]");
Connection
con=[Link]("jdbc:mysql://localhost:3306/ericproject","root
","root");
Statement st=[Link]();
rs=[Link]("select * from rabbit;");
[Link]();
to=[Link](8);
}catch(Exception e)
{[Link]([Link]());}
[Link](""+to);
[Link]("");
[Link]("");
[Link]("");
[Link]("");
[Link]("");
[Link]("");
}
private void formWindowActivated([Link] evt) {
try
{[Link]("[Link]");

24
Connection
con=[Link]("jdbc:mysql://localhost:3306/ericproject","root
","root");
Statement st=[Link]();
b=[Link]("select * from rabbit;");
[Link]();
int t=[Link](8);
[Link](""+t);
}catch(Exception e)
{[Link]([Link]());}}
private void jButton4ActionPerformed([Link] evt) {
rabitdat aa = new rabitdat();
[Link](true);
[Link]();}
private void jMenuItem1ActionPerformed([Link] evt) {
rabbittable aa = new rabbittable();
[Link](true);
[Link]();}
private void jMenuItem2ActionPerformed([Link] evt) {
rabbitsell w = new rabbitsell();
[Link](true);
[Link]();}

public static void main(String args[]) {

[Link](new Runnable() {
public void run() {
new rabbits().setVisible(true);

25
}});}

RABBIT SELL
import [Link].*;
public class rabbitsell extends [Link] {
public rabbitsell() {
initComponents();}

ResultSet rs,ra; int est, ano , cno ,aprice ,cprice,dno,nno ;

public static int w;
private void t5MouseClicked([Link] evt) {
ano =[Link]([Link]());
cno =[Link]([Link]());
aprice =[Link]([Link]());
cprice =[Link]([Link]());
est=(ano*aprice)+(cno*cprice);
[Link](""+est);}
private void jButton1ActionPerformed([Link] evt) {
try {
[Link]("[Link]");
Connection
con=[Link]("jdbc:mysql://localhost:3306/ericproject","root
","root");
Statement st=[Link]();
rs=[Link]("select * from rabbit;");
[Link]();
int t=[Link](8);

26
int id =[Link](1);
if([Link]().equals(""))
nno=0;
else
dno=[Link]([Link]());
if([Link]().equals(""))
dno=0;
else
dno=[Link]([Link]());
t=t+nno-dno;
[Link]("update rabbit set number="+t+" where eid="+id+";");
w=(ano*aprice)+(cno*cprice);
ra=[Link]("select * from sellrabbit;");
[Link]();
int iid =[Link](1);
iid=iid+1;
[Link]("insert into sellrabbit values("+iid+","+w+");");
}catch(Exception e) {
[Link]([Link]());}}
private void jButton4ActionPerformed([Link] evt) {
rabbits w2 = new rabbits();
[Link](true);
[Link]();}
public static void main(String args[]) {
[Link](new Runnable() {
public void run() {
new rabbitsell().setVisible(true);
27
}});}

RABBIT TABLE
import [Link].*;
import [Link];
public class rabbittable extends [Link] {
public rabbittable() {
initComponents();}

ResultSet rs,ra,b;
public static int cp, sp,evl;
private void jButton1ActionPerformed([Link] evt) {
[Link](false);
try {
[Link]("[Link]");
Connection
con=[Link]("jdbc:mysql://localhost:3306/ericproject","root
","root");
Statement st=[Link]();
b=[Link]("select (sum(vac)+sum(mant)+sum(feed)) from rabbit;");
[Link]();
cp=[Link](1);
b=[Link]("select (sum(fur)+sum(bio)) from rabbit;");
[Link]();
sp=[Link](1);
ra=[Link]("select sum(sell) from sellrabbit;");
int sell=[Link](1);

28
sp=sp+sell;
}catch(Exception e) {
[Link]([Link]());}
evl=sp-cp;
[Link](true);
[Link](""+cp);
[Link](""+sp);
[Link](""+evl);}
private void jButton4ActionPerformed([Link] evt) {
rabbits w1 = new rabbits();
[Link](true);
[Link]();}}
private void formWindowActivated([Link] evt) {
DefaultTableModel tb=(DefaultTableModel)[Link]();
try
{[Link]("[Link]");
Connection
con=[Link]("jdbc:mysql://localhost:3306/ericproject","root
","root");
Statement st=[Link]();
rs=[Link]("select * from rabbit;");
while([Link]())
{String a=[Link](7);
String b=[Link](4);
String c=[Link](2);
String d=[Link](3);
String e=[Link](6);

29
String f=[Link](5);
Object o[]={a,b,c,d,e,f};
[Link](o);}
}catch(Exception e)
{[Link]([Link]());}}

public static void main(String args[]) {

[Link](new Runnable() {
public void run() {
new rabbittable().setVisible(true);
}});}

POULTRY DATE
public class poultrydat extends [Link] {
public poultrydat() {
initComponents();}

public static String s1,s2,s3;

private void cb1ActionPerformed([Link] evt) {
s1=(String) [Link]();
[Link](s1); }
private void cb3ActionPerformed([Link] evt) {
s3=(String) [Link]();
[Link](s3);}
private void cb2ActionPerformed([Link] evt) {
s2=(String) [Link]();
[Link](s2);}
30
private void jButton1ActionPerformed([Link] evt) {
poultryy ac = new poultryy();
[Link](true);
[Link]();}
private void jButton4ActionPerformed([Link] evt) {
HOME w = new HOME();
[Link](true);
[Link](); }

public static void main(String args[]) {

[Link](new Runnable() {
public void run() {
new poultrydat().setVisible(true);
}});}

POULTRY
import [Link].*;
public class poultryy extends [Link] {
public poultryy() {
initComponents();}

ResultSet rs,ab,b;
int t;
private void zMouseClicked([Link] evt) {
int x1 =[Link]([Link]());
int y1 =[Link]([Link]());
[Link](""+x1*y1);}
31
private void jButton2ActionPerformed([Link] evt) {
int tt=[Link]([Link]());
int nno=[Link]([Link]());
int dno=[Link]([Link]());
tt=tt+nno-dno;
int v,f,man,bio,egg;
if([Link]().equals(""))
v=0;
else
v =[Link]([Link]());
if([Link]().equals(""))
man=0;
else
man=[Link]([Link]());
if([Link]().equals(""))
f=0;
else
f=[Link]([Link]());
if([Link]().equals(""))
bio=0;
else
bio=[Link]([Link]());
if([Link]().equals(""))
egg=0;
else
egg =[Link]([Link]());
poultrydat c=new poultrydat();
32
String dat=(c.s1+"-"+c.s2+"-"+c.s3);
try
{[Link]("[Link]");
Connection
con=[Link]("jdbc:mysql://localhost:3306/ericproject","root
","root");
Statement st=[Link]();
rs=[Link]("select * from poultry;");
[Link]();
int id =[Link](1);
int newid=id + 1;
[Link]("insert into poultry
values("+newid+","+v+","+man+","+f+","+bio+","+egg+","+"'"+dat+"'"+","+tt+");
");
}catch(Exception e)
{[Link]([Link]());}}
private void formWindowActivated([Link] evt) {
try
{[Link]("[Link]");
Connection
con=[Link]("jdbc:mysql://localhost:3306/ericproject","root
","root");
Statement st=[Link]();
b=[Link]("select * from poultry;");
[Link]();
int t=[Link](8);
[Link](""+t);
}catch(Exception e)
{[Link]([Link]());}}
33
private void jButton4ActionPerformed([Link] evt) {
poultrydat w = new poultrydat();
[Link](true);
[Link]();}
private void jMenuItem1ActionPerformed([Link] evt) {
poultrytable aa = new poultrytable();
[Link](true);
[Link]();}
private void jMenuItem2ActionPerformed([Link] evt) {
poultrysell ab = new poultrysell();
[Link](true);
[Link]();}
public static void main(String args[]) {
[Link](new Runnable() {
public void run() {
new poultryy().setVisible(true);
}});
}

POULTRY SELL
import [Link].*;
public class poultrysell extends [Link] {
public poultrysell() {
initComponents();}

ResultSet rs,ra; int est, ano , cno ,aprice ,cprice,nno,dno ;

public static int w;
34
private void t5MouseClicked([Link] evt) {
ano =[Link]([Link]());
cno =[Link]([Link]());
aprice =[Link]([Link]());
cprice =[Link]([Link]());
est=(ano*aprice)+(cno*cprice);
[Link](""+est);}
private void jButton1ActionPerformed([Link] evt) {
try {
[Link]("[Link]");
Connection
con=[Link]("jdbc:mysql://localhost:3306/ericproject","root
","root");
Statement st=[Link]();
rs=[Link]("select * from poultry;");
[Link]();
int t=[Link](8);
int id =[Link](1);
if([Link]().equals(""))
nno=0;
else
dno=[Link]([Link]());
if([Link]().equals(""))
dno=0;
else
dno=[Link]([Link]());
t=t+nno-dno;

35
[Link]("update poultry set number="+t+" where eid="+id+";");
w=(ano*aprice)+(cno*cprice);
ra=[Link]("select * from sellpoultry;");
[Link]();
int iid =[Link](1);
iid=iid+1;
[Link]("insert into sellpoultry values("+iid+","+w+");");
}catch(Exception e) {
[Link]([Link]());}
}
private void jButton4ActionPerformed([Link] evt) {
poultryy w2 = new poultryy();
[Link](true);
[Link]();}

public static void main(String args[]) {

[Link](new Runnable() {
public void run() {
new poultrysell().setVisible(true);
}});
}
POULTRY TABLE
import [Link].*;
import [Link];
public class poultrytable extends [Link] {
public poultrytable() {
initComponents();}
36
ResultSet rs,ra,b;
public static int cp, sp,evl;
private void jButton1ActionPerformed([Link] evt) {
try {
[Link]("[Link]");
Connection
con=[Link]("jdbc:mysql://localhost:3306/ericproject","root
","root");
Statement st=[Link]();
b=[Link]("select (sum(vac)+sum(mant)+sum(feed)) from poultry;");
[Link]();
cp=[Link](1);
b=[Link]("select (sum(fur)+sum(bio)) from poultry;");
[Link]();
sp=[Link](1);
ra=[Link]("select sum(sell) from sellpoultry;");
int sell=[Link](1);
sp=sp+sell;
}catch(Exception e) {
[Link]([Link]());}
evl=sp-cp;
[Link](""+cp);
[Link](""+sp);
[Link](""+evl);}
private void formWindowActivated([Link] evt) {
DefaultTableModel tb=(DefaultTableModel)[Link]();

37
try
{[Link]("[Link]");
Connection
con=[Link]("jdbc:mysql://localhost:3306/ericproject","root
","root");
Statement st=[Link]();
rs=[Link]("select * from poultry;");
while([Link]())
{String a=[Link](7);
String b=[Link](4);
String c=[Link](2);
String d=[Link](3);
String e=[Link](6);
String f=[Link](5);
Object o[]={a,b,c,d,e,f};
[Link](o);}
}catch(Exception e)
{[Link]([Link]());}}
private void jButton4ActionPerformed([Link] evt) {
poultryy w1 = new poultryy();
[Link](true);
[Link]();}

public static void main(String args[]) {

[Link](new Runnable() {
public void run() {
new poultrytable().setVisible(true);

38
}});
}

EXOTIC
import [Link].*;
import [Link];
import [Link];
public class exotic extends [Link] {
public exotic() {
initComponents();}

ResultSet rs;
private void jButton1ActionPerformed([Link] evt) {
exoticinsert ac = new exoticinsert();
[Link](true);
[Link]();}
private void jButton2ActionPerformed([Link] evt) {
[Link](null,"Congragulation your record is updated ");
int f,man;
if([Link]().equals(""))
f=0;
else
f=[Link]([Link]());
if([Link]().equals(""))
man=0;
else
man=[Link]([Link]());
39
try
{[Link]("[Link]");
Connection
con=[Link]("jdbc:mysql://localhost:3306/ericproject","root
","root");
Statement st=[Link]();
DefaultTableModel tb=(DefaultTableModel)[Link]();
int z=[Link]();
int idd=z+1;
[Link]("update exotic set feed="+f+" , mant="+man+" where
id="+idd+";");
}catch(Exception e)
{[Link]([Link]());}}
private void SELLINGActionPerformed([Link] evt) {
exoticsell ac = new exoticsell();
[Link](true);
[Link]();}
private void formWindowActivated([Link] evt) {
DefaultTableModel tb=(DefaultTableModel)[Link]();
try
{[Link]("[Link]");
Connection
con=[Link]("jdbc:mysql://localhost:3306/ericproject","root
","root");
Statement st=[Link]();
rs=[Link]("select * from exotic;");
while([Link]())
{String a=[Link](1);

40
String b=[Link](7);
Statement st=[Link]();
rs=[Link]("select * from exotic
String c=[Link](2);
String d=[Link](3);
String e=[Link](5);
String f=[Link](4);
String g=[Link](6);
Object o[]={a,b,c,d,e,f,g};
[Link](o);
int z=[Link]();
[Link](""+z);}
}catch(Exception e)
{[Link]([Link]());}}
private void jButton5ActionPerformed([Link] evt) {
HOME w = new HOME();
[Link](true);
[Link](); }
private void jMenuItem1ActionPerformed([Link] evt) {
exoticeval ac = new exoticeval();
[Link](true);
[Link]();}
private void jMenuItem2ActionPerformed([Link] evt) {
exoticsell ac = new exoticsell();
[Link](true);
[Link]();}

41
public static void main(String args[]) {
[Link](new Runnable() {
public void run() {
new exotic().setVisible(true);
}});
}

EXOTIC INSERT
public class exoticinsert extends [Link] {
public exoticinsert() {
initComponents();}

String s1,s2,s3;
ResultSet rs,ab,b;
private void cb1ActionPerformed([Link] evt) {
s1=(String) [Link]();
[Link](s1);}
private void cb3ActionPerformed([Link] evt) {
s3=(String) [Link]();
[Link](s3);}
private void cb2ActionPerformed([Link] evt) {
s2=(String) [Link]();
[Link](s2);}
private void jButton1ActionPerformed([Link] evt) {
int f=0,man=0,no;
String breed=[Link]();
no=[Link]([Link]());
42
String dat=(s1+"-"+s2+"-"+s3);
int price=[Link]([Link]())*no;
try
{[Link]("[Link]");
Connection
con=[Link]("jdbc:mysql://localhost:3306/ericproject","root
","root");
;");
[Link]();
int id =[Link](1);
int newid=id + 1;
[Link]("insert into exotic
values("+newid+","+"'"+breed+"'"+","+no+","+man+","+f+","+price+","+"'"+dat+
"'"+");");
}catch(Exception e)
{[Link]([Link]());}}
private void jButton5ActionPerformed([Link] evt) {
exotic w = new exotic();
[Link](true);
[Link]();}}

public static void main(String args[]) {

[Link](new Runnable() {
public void run() {
new exoticinsert().setVisible(true);
}});
}

43
EXOTIC SELL
import [Link].*;
import [Link];
public class exoticsell extends [Link] {
public exoticsell() {
initComponents();}

int x,y,q,o,m,t,bid;
ResultSet rs,ra,rb;
private void t5MouseClicked([Link] evt) {
bid=[Link]([Link]());
y =[Link]([Link]());
q =[Link]([Link]());
o=q*y;
[Link](""+o);}
private void jButton1ActionPerformed([Link] evt) {
try
{
[Link]("[Link]");
Connection
con=[Link]("jdbc:mysql://localhost:3306/ericproject","root
","root");
Statement st=[Link]();
rs=[Link]("select * from exotic where id="+bid+";");
[Link]();
t=[Link](3);
m=t-y;

44
if(m>0)
{ra=[Link]("select * from sellexotic;");
[Link]();
int ii=[Link](1);
ii=ii+1;
[Link]("insert into sellexotic values("+ii+","+o+");");
[Link]("update exotic set no="+m+" where id="+bid+";");
}
else if(m==0)
{
ra=[Link]("select * from sellexotic;");
[Link]();
int ii=[Link](1);
ii=ii+1;
[Link]("insert into sellexotic values("+ii+","+o+");");
[Link]("delete from exotic where id="+bid+";");}
else if(m<0)
{[Link](null,"SORRY THE ENTERED NUMBER
AND RECORD NUMBER DOSEN'T MATCH,try again");
[Link]("");
[Link]("");
[Link]("");
[Link]("");}
}catch(Exception e)
{[Link]([Link]());}
}
private void jButton4ActionPerformed([Link] evt) {
45
exotic aa = new exotic();
[Link](true);
[Link](); }
}

public static void main(String args[]) {

[Link](new Runnable() {
public void run() {
new exoticsell().setVisible(true);
}});
}

EXOTIC TABLE

public class exoticeval extends [Link] {

public exoticeval() {
initComponents();}
ResultSet rs,ra,b;
public static int cp, sell,evl;

private void jButton1ActionPerformed([Link] evt) {

try {
[Link]("[Link]");
46
Connection
con=[Link]("jdbc:mysql://localhost:3306/ericproject","root
","root");
Statement st=[Link]();
b=[Link]("select (sum(price)+sum(mant)+sum(feed)) from exotic;");
[Link]();
cp=[Link](1);
ra=[Link]("select sum(sell) from sellexotic;");
[Link]();
sell=[Link](1);
evl=sell-cp;
}catch(Exception e) {
[Link]([Link]());}
[Link](true);
[Link](""+cp);
[Link](""+sell);
[Link](""+evl);
}

private void formMouseClicked([Link] evt) {

exotic ac = new exotic();
[Link](true);
[Link]();
}
private void jButton5ActionPerformed([Link] evt) {
exotic w = new exotic();
[Link](true);

47
[Link]();
}
public static void main(String args[]) {
[Link](new Runnable() {
public void run() {
new exoticeval().setVisible(true);
}});
}

EVALUATION

import [Link].*;
import [Link];
public class evltable extends [Link] {
public evltable() {
initComponents();
}

ResultSet a,b;
int c1,c,c2;
ResultSet o,x;
int p1,p,p2;
ResultSet m,n;
int r1,r,r2;
ResultSet l,g;
int e1,e,e2;
48
private void jButton1ActionPerformed([Link] evt) {
try {
[Link]("[Link]");
Connection
con=[Link]("jdbc:mysql://localhost:3306/ericproject","root
","root");
Statement st=[Link]();
a=[Link]("select (sum(vac)+sum(mant)+sum(feed)) from cattle;");
[Link]();
c1=[Link](1);
a=[Link]("select (sum(milk)+sum(bio)) from cattle;");
[Link]();
c2=[Link](1);
b=[Link]("select sum(sell) from sellcattle;");
int sell=[Link](1);
c2=c2+sell;
}catch(Exception e) {
[Link]([Link]());}
c=c2-c1;
[Link](""+c1);
[Link](""+c2);
[Link](""+c);
try {
[Link]("[Link]");
Connection
con=[Link]("jdbc:mysql://localhost:3306/ericproject","root
","root");
49
Statement st=[Link]();
o=[Link]("select (sum(vac)+sum(mant)+sum(feed)) from poultry;");
[Link]();
p1=[Link](1);
o=[Link]("select (sum(fur)+sum(bio)) from poultry;");
[Link]();
p2=[Link](1);
x=[Link]("select sum(sell) from sellpoultry;");
int sell=[Link](1);
p1=p1+sell;
}catch(Exception e) {
[Link]([Link]());}
p=p2-p1;
[Link](""+p1);
[Link](""+p2);
[Link](""+p);
try {
[Link]("[Link]");
Connection
con=[Link]("jdbc:mysql://localhost:3306/ericproject","root
","root");
Statement st=[Link]();
m=[Link]("select (sum(vac)+sum(mant)+sum(feed)) from rabbit;");
[Link]();
r1=[Link](1);
m=[Link]("select (sum(fur)+sum(bio)) from rabbit;");
[Link]();

50
r2=[Link](1);
n=[Link]("select sum(sell) from sellrabbit;");
int sell=[Link](1);
r2=r2+sell;
}catch(Exception e) {
[Link]([Link]());}
r=r2-r1;
[Link](""+r1);
[Link](""+r2);
[Link](""+r);
try {
[Link]("[Link]");
Connection
con=[Link]("jdbc:mysql://localhost:3306/ericproject","root
","root");
Statement st=[Link]();
l=[Link]("select (sum(price)+sum(mant)+sum(feed)) from exotic;");
[Link]();
e1=[Link](1);
g=[Link]("select sum(sell) from sellexotic;");
[Link]();
e2=[Link](1);
e=e2-e1;

}catch(Exception e) {
[Link]([Link]());}
[Link](""+e1);

51
[Link](""+e2);
[Link](""+e);
int pc=c1+r1+e1+p1;
int pg=c2+r2+e2+p2;
[Link](""+pc);
[Link](""+pg);
int production=pg-pc;
[Link](""+production);
if(pc<pg)
[Link](null,"Congragulation your PROFIT is"+" "+
production );
else
[Link](null,"Sorry your LOSS is"+" "+ production*-1
); // TODO add your handling code here:
}
private void jButton4ActionPerformed([Link] evt) {
HOME w2 = new HOME();
[Link](true);
[Link]();}
public static void main(String args[]) {
[Link](new Runnable() {
public void run() {
new evltable().setVisible(true);
}
})) }

52
53
54
WELCOME FORM

55
WHEN LOGIN BUTTON IS CLICKED

HOME MENU

WHEN CATTLE LABEL IS CLICKED FROM HOME MENU CLICKED

56
WHEN CONTINUE BUTTON IS CLICKED

AFTER ENTERING THE DAILY DETAILS SUMBIT BUTTON IS CLICKED

57
IN OTHER SECTION  SELLING SECTION IS CLICKED

58
SELLING DETAILS ARE ENTERED AND UPDATE BUTTON IS CLICKED

IN PRODUCTION  SUMMARY IS CLICKED

EVALUATION FRAME

59
WHEN EVALUATION CHART IS CLICKED

60
WHEN POULTRY LABEL IS CLICKED FROM HOME MENU CLICKED

WHEN CONTINUE BUTTON IS CLICKED

AFTER ENTERING THE DAILY DETAILS SUMBIT BUTTON IS CLICKED

61
IN OTHER SECTION  SELLING SECTION IS CLICKED

62
SELLING DETAILS ARE ENTERD AND UPDATE BUTTON IS CLICKED

IN PRODUCTION  SUMMARY IS CLICKED

63
EVALUATION FRAME

WHEN EVALUATION CHART IS CLICKED

64
WHEN POULTRY LABEL IS FROM HOME MENU CLICKED

WHEN CONTINUE BUTTON IS CLICKED

65
AFTER ENTERING THE DAILY DETAILS SUMBIT BUTTON IS CLICKED

IN OTHER SECTION  SELLING SECTION IS CLICKED

66
SELLING DETAILS ARE ENTERD AND UPDATE BUTTON IS CLICKED

IN PRODUCTION  SUMMARY IS CLICKED

67
EVALUATION FRAME

WHEN EVALUATION CHART IS CLICKED

68
WHEN EXOTIC LABLE IS CLICKED FROM EXOTIC

WHEN DESIERD RECORD IS SELECTED, DETAILS ARE ENTERED AND SUBMIT

BUTTON IS CLICKED

69
WHEN INSERT BUTTON IS CLICKED DETAILS ARE ENTERD AND CONFIRM
BUTTON IS CLICKED

70
WHEN BACK BUTTON IS CLICKED

IN OTHER SECTION  SELLING SECTION IS CLICKED

71
SELLING DETAILS ARE ENTERD AND UPDATE BUTTON IS CLICKED
WHEN ANIMAL NUMBER GREATER THAN ENTERED NUMBER

WHEN BACK BUTTON IS CLICKED

72
WHEN ANIMAL NUMBER EQUALS ENTERED NUMBER

73
WHEN BACK BUTTON IS CLICKED

WHEN ANIMAL NUMBER LESS THAN ENTERD NUMBER

74
IN PRODUCTION  SUMMARY IS CLICKED

75
WHEN EVALUATION CHAT IS CLICKED

WHEN OVERALL BUTTON FROM HOME MENU IS CLICKED

WHEN SUM-UP BUTTON IS CLICKED

76
77
 BIBLIOGRAPHY

# [Link]
# Informatics practices class XII,sultan
chan.
# NCERT informatic practices class 12.

78