0:00
system using uh Java and MySQL Let I
0:05
first Here this is the demo Uh here
0:09
there will be the two choices employee
0:11
payroll and allows Here you will be able
0:14
to add the employee to the system So
0:17
click click on this button You will be
0:19
able to add the employee Here employee
0:21
number will be autogenerated Now I'm
0:23
going to uh enter the employee name
0:28
Peter Last name I'm going to give as a
0:31
John Right Peter John Uh address I'm
0:35
going to give us a India Telephone
0:37
number like this Salary I'm going to
0:42
20,000 Department I'm going to give as a
0:46
uh account department Right that's the
0:50
stuff you have to do After that or fill
0:52
all the information click save Employee
0:56
inserted right employee inserted Now
0:58
let's close the one Now uh let's go to
1:02
our database This is a database here
1:06
This is the your newly created record Uh
1:09
employee number is auto generated Peter
1:12
uh first name last name John Uh address
1:15
India This is a telephone number salary
1:18
and department account right now in this
1:22
employee I'm going to add the allows
1:27
let's let's click on let's click allows
1:31
now I'm going to add the allows allows
1:34
consist of three parts this is the this
1:36
allows this will will be provide all the
1:39
employee who is working on our company
1:41
here this all the employee we will be
1:44
providing this allows this one should be
1:49
allows this one should be department
1:51
wise department mean we have uh three
1:54
department IT marketing and accounts
1:57
right this how we will be providing the
1:59
allowance right now first I'm going to
2:01
give the uh allowance for all the
2:03
employee who works in the company so
2:06
here I'm going to select the employee
2:08
allows as bus so here I'm going to add
2:11
the allows as 5,000 right click add
2:14
button allows inserted Click okay You'll
2:18
be able to see the allows for all the uh
2:22
employee So you will be able to see okay
2:24
allows type amount and employee number
2:27
All the employee will be get the allows
2:30
for 5,000 Right this is one type of
2:32
allows Now you'll be able to see the
2:35
allows Go to the allows table here All
2:38
the employee will be getting the allows
2:40
Right now second individual wise right
2:43
individual wise I'm going to give the
2:45
person the final one this one this is
2:48
the record we are inserted last this one
2:51
uh this one this number belongs to this
2:54
person John Peter John right now I'm
2:57
going to give the uh allowance for car
3:01
so I'm going to give car allows for
3:04
10,000 right so here click okay inserted
3:10
you'll be able to see here only one
3:12
person get the car allows Okay only one
3:15
person right this one should be all the
3:19
uh employees added the allowance This
3:20
one should be only one person get the
3:22
allowance right the third one should be
3:25
the department wise right there will be
3:27
consist of three departments right
3:28
you'll be able to check right it
3:31
marketing account right now I'm going to
3:33
give the allowance for only for uh
3:37
marketing part right so marketing there
3:39
will be John and Kumar right so there
3:42
will be two persons available So
3:44
marketing selected this marketing I'm
3:46
going to give the food allowance for
3:49
2,000 All right Click okay Allows inside
3:53
You'll be able to check here There'll be
3:56
two person get the marketing allows here
3:58
Right the only these two right get the
4:01
allows here You'll be able to check here
4:04
This number this employee number right
4:07
the very simple payroll system This is a
4:10
very simple payroll system only I cover
4:13
the allowance part only
