Java Swing MySQL School Timetable Project for Beginners | netbeans IDE

0:00
hi friends welcome to tutori channel today I'm going to teach how to make the school timetable system in Java
0:07
so first what I'm going to do is I'm going to go to the file i already open the net bins file
0:13
new project select Java application click next
0:20
create main class you have to uncheck it if it is checked java school
0:27
time table
0:33
click finish button
0:39
now you'll be you can see the project has been created successfully with the name of school timetable
0:47
yeah this one here default package select the default
0:52
package here if you have the project is created there will be the two folders are created source package and library
1:00
select the source package for you we have to expand it right click the inside the default package right click and new
1:05
Java frame for here i'm going to add it as
1:11
uh time table time table school time table
1:18
just as it right
1:25
okay now first I'm going to say this one
1:31
first I'm going to register the
1:36
first you have to make the registration part okay so first I'm going to drag the
1:42
label the registration your class registration
1:48
your class and your days and subject all the stuff you have to make it as a
1:54
regist your command you name it as registration registration
2:01
registration okay commonly you have to name it as registration whatever thing you have to do it here I'm going to name
2:07
it as registration save the font but the font you have to font style I'm going to
2:13
make a bit bold 24 click to 36 we'll make it 36
2:19
click okay perfect after that I'm going to drag the panel
2:25
over here just going to select this one right click properties
2:32
border select the border bevel border okay close it
2:37
drag the label this label I'm going to name it as
2:44
uh this one should be the class you can what is the class you have to
2:51
try properties B with 40 enough oh 16 will be 80
3:01
right class and we need one one text field
3:07
what is the class class name this also you have named 18
3:15
default it's a font coming as 11 make this 18 close it right click edit text
3:21
back select again after that what I'm going to do is here
3:27
you have to uh class your registration you have to drag one button
3:35
this one you have to name it as save
3:42
bold 14 okay after that I'm going to the same thing i just copy and paste below
3:55
this one should be the subject
4:07
right okay we have a we can we can
4:15
we have a two uh two things in same form if you want you can register as a subject one class one form subject one
4:22
form you will be able to uh
4:27
uh designs two form as you wish okay now I am doing the same form now what I'm
4:32
going to do is a class here first I have to go to the database
4:38
first i'm going to design a database
4:50
which name is school time table school time table
5:06
time table i have a first one should be the class
5:11
the class two field
5:16
first one is ID
5:28
okay
5:37
i'm going to create a new field that is uh
5:43
uh I'm creating a new field that is that that should be the uh two this one should be
5:50
subject
5:56
ID Hey
6:07
subject
6:19
right now what I'm going to do is here I have created two different tables classes and subject let's back here
6:27
after what I'm going to say I'm going to establish a database connection so you have to install the appropriate
6:33
connector appropriate connector mean you have to download in order to connect NetB and
6:38
Java you have to download the MySQL connector for Java you go to the Google and type MySQL
6:45
J for Java MySQL connector for Java it goes to the respective website you can
6:50
download the uh zip file after you got those zip files here you have to extract
6:56
them the normal folder and you have to import them to the libraries okay so here at JAR you can import them then
7:03
you'll be able to connect the Java and MySQL okay after that you have
7:08
to import the SQL class import JavaSc
7:14
I'm going to write the connection so public white connect
7:21
openly packet so what I'm going to do is import the
7:27
class like this so here copy and paste it you have to click on this one and
7:35
the try and patch so here we have a connection object try to connect objects
7:40
connection object
7:52
statement
7:57
PST now here import the track catch also right now here you have to your this is
8:03
this how you have registered the MySQL driver you have to given the path over here where your uh database reside on my
8:12
database reside on local which name is you given here which name is school time
8:18
table you just copy this one paste it over here this is the username and
8:24
password when you install the MySQL this is the default username and password Okay that's it right after that what I'm
8:30
going to do is here we have a two buttons first I'm going to
8:36
create a class class so you have to this one class you have to this text box name
8:42
I'm going to give as txt class this one txt subject
8:52
first I'm going to create event action action for
8:59
write the query simply write a query
9:10
don't I explain it right one by one I take too much of time
9:15
to compute the budget so that I return right okay now here what I did here is
9:20
First I have this is a text field this text field txt class this text
9:26
field I have what is the value you have type on this text field i have assigned the variable txt class after that I have I
9:32
already create the prepare statement object PSD connection prepare statement i have write insert query inside which
9:38
table you are going to uh store the record it's a registration table this is registration class table and subject
9:46
table i have two table so it's a class table class table class table there is a
9:52
column which is a name so name column
9:59
but the class you're typing assigning here coming here it will be register the class registration class registration
10:05
register success registration successful okay that's what
10:10
you have right the same thing copied
10:16
so here sorry here we have values
10:24
one question
10:38
right so after that what I'm going to do is uh
10:45
take the class regist Okay so here only one feed here on this this table so this
10:51
is the one column this is what is the value you type on this text by assigning here assigning here it it put into this
10:58
question or not it insert here if you call the PS execute update same code I just copy and
11:05
paste it over here this select this save button event action action perform
11:10
paste it all the same code but we have a we have to modify them instead of the class you have type is
11:17
subject subject
11:22
subject subject okay the table which name is
11:28
subject here also subject okay subject registration successful perfect
11:36
this one you have few
11:43
now let's run and check whe I'm going to yes 6A
11:53
subject class you can save if you save
11:59
the problem uh class what's the name
12:04
inside into class name uh what is the problem right the problem
12:11
is this connection method I haven't called
12:16
that's why there is no connection inside if you if you I wrote the
12:21
connection but I haven't called into the constructor then the without the connection how the date record should be
12:28
show that's why now now it's working class 6A
12:35
the class you can check here click save class registration successfully Okay if
12:42
you want to save subject what's the subject you are going to save your subject english
12:52
save subject registration successful it's very simple right so I hope you
12:57
guys understood the things well uh I'll see in my next lecturing how to uh this
13:03
all the things are important to that uh time table and my part three video I'll
13:10
explain how to build the beautiful time table with along with the database connection thank you for watching you
13:16
have to follow my all the videos of this one we will be able to do the complete timetable system in Java thank you for
13:21
watching hi friends welcome to tutors panic
13:26
channel in our last class we saw how to register the uh class registration we
13:32
saw and subject registration in this class I'm going to teach about the timets the time table registration we
13:39
have to see right so first what I'm going to do is here I'm going to go to create a new form so here go to the
13:50
here right so this one should be the our first one i'm going to create another comp time table
13:57
registration registation
14:03
but rich here what I'm going to do is first we
14:11
have to drag the label time table time table
14:26
You have to font bold
14:31
36
14:40
right now what I'm going to do is here select this one properties border
14:49
soft border click okay close it now here let's drag the label
14:56
this one select the class select this one properties
15:05
184
15:13
drag the combo box we have to load all the classes so we have a we have to drag
15:20
the combo box over here
15:26
right so combo box select this both ctrl C copy ctrl B to
15:33
paste here I have to the subject what is subject you enter here this is the subject
15:44
after that we have a class and subject another thing C copy this this we have
15:50
to not loading from the database manually we have to add it this
15:55
to add it manually over here uh select
16:01
properties item model item you have to start it on Monday
16:09
Tuesday Wednesday
16:18
Thursday Friday
16:29
click okay right now here we have to change the font
16:35
18 click okay right we did the design
16:42
here also the font you select as 18
16:49
here also you select the font select this one font size 80
16:57
with bold perfect after that what I'm going to do is I'm going to drag the labels button
17:06
save
17:11
button okay now what I'm going to do is here we have
17:18
a we have to create Uh uh
17:25
another form select this one new frame main
17:35
right here I have to drag the label
17:42
i have to name as main menu select this one properties
17:49
font bold 24
17:55
you have to drag the buttons this one should be
18:00
select this one properties with 36
18:06
this one should be uh what's the button we have to put it
18:15
subject
18:20
this one time table extension
18:41
font you select as bold 24
18:48
subject Check
18:54
perfect after this control C copy control V get another copy this one should be tiny
19:00
table view
19:07
select this one go to source ctrl F ui
19:12
metal
19:19
so here I'm going to this is the starting form i'm going to set it
19:25
uh here set run file
19:35
okay so here when the application is run it will be properties code generate center center
19:44
of the screen so let's try try on that
19:51
it come in the centers of the screen you click the subject the subject header time table registration and table you
19:58
link them it's very simple control right click event action action
20:04
form let's call the forms first form is a school
20:13
get c new scroll
20:21
dot set visible
20:28
that's The same thing control shift copy
20:33
control bit add over here yeah I'm going to name it as time rich
20:40
this com is time rich
20:54
this one should be also for source ctrl F UI design you have to make it as metal
21:01
okay right now what I'm going to do is here metal
21:08
this form also select this one properties code generate center
21:15
generate center then school form also we have already set it okay now let's
21:21
execute the program and check
21:28
run main class uh you have to write the main class is a
21:33
main as a main to run the project when you run the project it is main class is
21:40
running first right here click the subject
21:46
click subject it it will be open the subject over here
21:52
uh after that what I'm going to say I have to click time table it will be open right now let me see how to load the
21:58
data class if you select the class all the data will should be dot subject is all the data should be so how to do the
22:04
task we'll see let's load this two combo uh datas right
22:10
the class and subject you have to load it right uh subject we have to this one should be English just it
22:19
load the data right now what I'm going to do Select this class properties this all
22:25
the default one select them and we have to clear okay so here also properties so
22:32
click the model this a default one backspace will remove the existing item click okay right now let's load them
22:43
let's load the data
22:53
so what I'm going to say is this a data load so where the type
22:59
here write the school
23:07
this one properties
23:15
set RS
23:23
so here we simply import this class we don't need this all the classes here we
23:28
simply this all the things we have to do it over here
23:35
import java dotsql
23:40
if you import it you don't need to import the another classes okay but it's simply it will take care of it just a
23:47
comp combo box lo right so here the connection also we copy and paste it this is the database connection you
23:53
already you just copy and paste this one we already talked okay how to connect the database okay this form also we have
23:59
connect it right so here the load class we have create the function load class
24:04
here we have the prepare statement uh prepare statement select dist mean it duplicate the values okay duplicate
24:10
value it will be uh avoided okay so here this is this a name class name here this
24:17
is name what's the name class there's a table called you have to load the class of the first one name
24:25
which class from class class this class table okay this following table you have
24:30
to load load and put it where you have to name it as CB or combo
24:37
class it will load and put it here
24:43
right class this one should be the name
24:50
yes you have to write simple ex there's any error it will be gone right
24:55
this a combo box loading code you have to load all the name for the name of the classes what is the name you are given 6
25:02
A 6 B this all the names it will be loaded if there are any duplicated value it distance should be only take the
25:08
unique only duplicate value it will be avoided so that we have the distinct keyword is must this one should be the
25:14
must the SQL okay rs do.execute it will be load all the data and if it is
25:20
existing data available it will be remove it and put the while loop and load and then this column right this
25:27
data also we have to call it over here when the form is loaded loaded the load
25:32
the form and connection property also we have to load it the constru of the class we have to call it okay right now let's
25:40
check whether it's working fine or not run the form and check
25:46
the form which we check okay it's working it's loading data will
25:52
be loading right it's working fine right the same thing you have to do subject also subject also same thing copy this
25:59
one paste it here you have to write the load subject
26:07
yes so this one should be the table you have to load subject subject subject right subject table subject subject
26:15
table subject to subject that's it right the same
26:20
thing like like uh class okay load subject that's it if you load
26:28
it
26:35
subject it's not loaded not take the subject why
26:44
right the club because we haven't provided the name so here also CV or
26:54
this name we have to give the appropriate name for the identify the combo box
27:00
then it will be loaded otherwise it won't load
27:10
Okay it's loaded successfully the day also you can select it and you have to you will be able to save the data on the
27:16
database okay for the class you can select A 6 A 6 B 6 C 7 A you have to
27:23
register the class you have to add the subject over here and days right how to
27:30
save the part we will be discuss about in my next video tutorial thank you for watching
27:36
now here I'm going to store this record into the timetable table time table
27:41
database so here go to our database table i'm going to create a new table
27:47
which is a time table so here uh create a new
27:54
here I'm going to name this one as a time table this a table name I'm going to give ID
28:10
class
28:18
subject
28:27
class subject
28:33
Now what I'm going to say I have created the tables class and subject uh days
28:43
there are three columns I have created hit save button
28:49
table has been created successfully class subject and this now what I'm going to use here I'm going to add the
28:56
data into the database back to our net beans
29:03
save here event action action perform here what I'm going to say the save post
29:09
I'm going to write here okay so here I already
29:15
establish the database connection and all I'm going to write the insert code say already insert code I have written
29:21
So the same window code I just copy and paste it here only I'm going to change the
29:27
things okay so here first this is a class what is the name cho com class
29:34
here these are called as combo box so here I have write this one should be the
29:39
class not text this are combo box so dot get
29:46
selected index get selected
29:51
item dot two string method the same thing Ctrl C to copy ctrl V to
29:59
paste over here you can write here otherwise you can write here string
30:05
uh here you have to write second one should be the subject subject you have to write like this
30:11
subject okay here you can write like this method otherwise you can write here this also possible
30:20
uh what's the problem
30:28
oh it's not okay you can write like this okay this working i don't know why it's not
30:33
working so it's no problem you can write this okay right
30:39
all right this is working
30:49
this a name I'm going to preset this name subject
30:56
subject you can write like this otherwise you can write this this is also possible
31:04
okay here this also okay you can write like this it's it's not problem
31:10
this also possible okay you can get string two string method you can write like this as well
31:17
uh the same thing here copied paste it over here you can write this way otherwise this way my all the another
31:24
tuto I'm telling that this that way that's why I put it this way this also possible right after that what I'm got
31:31
Monday this also combo the combo box this also the days so string days
31:39
this also this copy This one should be like this cbo
31:46
this copy it
31:51
paste it over here right now here we have what what are the columns available
31:58
class subject days class
32:03
class subject comma days
32:10
1 2 3 questions mark there
32:15
so here you have write 1 2 3
32:21
this one should be two this one should be the subject so three this one should be the days
32:29
after that you have to write this uh uh registration registration successfully time table time table
32:37
registered registration successfully that's it
32:43
right after done the stuff you have to write this one get selected in item
32:50
selected index get selected index
32:57
that write this it will be the clear um
33:02
set select item
33:08
set selected index write like this this how we have clear
33:14
the combo box set selected and index
33:21
same thing ctrl C to copy control V to paste here this one also set selected index right that's it
33:28
now let's run and check
33:45
time table registration click here 6a English Monday i'm create as a
33:52
English Thursday hit save button uh what was the problem class is in the
33:59
list unknown class in the list class of
34:06
this is the table I am not giving here this a table which is a time table I given the wrong table that's the problem
34:14
okay now let's again we have to we have to run the project
34:23
time table registration Tuesday click save button time table
34:28
registration successfully now all the clear of all the
34:34
combo box here 1 6A English and Thursday this is this how your record will be
34:39
displayed here okay uh I hope you guys you understood things well I'll be get
34:45
back in my next video tutorial if you have any doubt on this one you
34:51
can ask me anytime uh in this video I I will teach about how to register the
34:58
uh class and subject and test It's very simple right in my next tutorial what
35:04
I'm going to do here is if you click the time table view it goes to the form
35:10
timetable view form and show to the particular details in this class this subject is display this class this if it
35:18
is example of 6A these are subjects on that Monday okay that is thing it will
35:25
be displayed we will discuss about those stuff in my next tutorial in detailing
35:30
uh thank you for watching if you have any doubt do you let me know that
35:36
thank you for watching hi today I'm going to teach continue the
35:43
time table registration system using Java and uh MySQL now here
35:50
I have a timetable table this is the table I have created
35:55
one row I have to create it okay I haven't I forgot to create that one there is a time the subject is starting
36:01
from which time which time ended so I forgot to do it so here what I'm going
36:07
to I'm to add it here as additional row so here that is as a subject right uh
36:15
this okay so what I'm going to do is I have to this one this is a record I have
36:21
deleted again I'm going to write it no problem this is the row so what I'm going is
36:28
here I'm going to put a structure so structure I have structure after the
36:35
day I'm going to go go here here I'm going to add another one go so this this
36:41
one should be the time time here write this watch
36:50
okay which time which right that is must so back to my code so Here
37:00
added another C copy paste this one should be the time
37:06
the time zone is must okay time
37:13
time here drag one text field
37:41
okay this one I'm going to edit text back to remove existence text select
37:48
again uh change variable time txt time
37:58
perfect now what I'm going to do is
38:04
double click on the save button
38:10
here I'm going to add additionally one column that's a time
38:16
one question mark here ctrl C to copy control V to paste
38:23
here just another line this line we have a time so here we have a copy this one
38:31
times this one should be the text not box so
38:39
uh txt time
38:45
dot get x that call the get x method right
38:50
that's it this is the time you paste it over here right that's it after things
38:57
you have to clear the time and set
39:11
right now let's run and check
39:28
now here we have a time table 6 a have another class only the time I'm going to
39:34
store 9 to 9 a.m
39:42
to 10 a.m uh 12 a.m
39:49
uh 9:40 starting other 8 a.m
39:58
it's working
40:04
that's it hit save button time table registered successfully now you will be
40:09
able to see here uh browse button here it's recorded
40:15
successfully right this is must the time is must right now let's check how to
40:20
view the tables uh records so that's must select this new Aframe form yeah
40:28
this one the view table
40:35
finish now we will be make the design
40:43
must professionally make the design right the time table view this is the
40:49
user can see okay here time table
40:58
view click here properties
41:05
font we have to make it as little bit sorry not here select the
41:12
here this one bold width 24
41:19
or third 24
41:28
this one should be the time table view
41:36
properties foreground color red
41:44
panel
41:50
here right click properties border
41:56
bevel border drag it on label use a class
42:03
select this one 36
42:08
table view is a class
42:26
i'm going to change it as
42:33
blue
42:40
this one select this one change variable txt class
42:51
after that
42:59
class subject days and time yeah days
43:04
this one day paste here day
43:22
I have recorded only one subject if you have a more subject it should be displayed here okay right more subject
43:27
it will display here uh here it will be displayed the most
43:33
subject subjects will be displayed here is a subject we have to maintain subject
43:38
from the city copy We basic
44:07
this one should be the
44:24
This one select both control C copy control V paste this here the sub subject will be display over here right
44:31
this one should be this select both we have a two to this one as a blue we have
44:38
to do it right we have to loop it all the subjects what are the subjects yeah
44:43
it will be loop it okay here we have to put it the one J table and do the do the stuff it's very simple right so this how
44:52
we have made the time table this one we will be discussing my uh upcoming tutorials
45:00
video okay thank you for watching if you have an any problem on this you will be
45:06
asking anytime uh thank you for watching uh you can have any problems
45:13
you will contact uh contact me so simple one so here we have make the time table
45:19
registration and time view uh time table view also we have designed right that's
45:26
it uh we'll meet in our next video tutorial
45:34
here table view you will be able to select the classes and days but here I'm
45:40
going to this one you have to delete them instead of the label I'm going to drag the combo box
45:47
so here the combo box where is the combo box you have to go to the pallet this combo box you drag it load the item
45:55
the same thing you have load the item intr copy control to paste this one should be the days
46:02
so here right click properties is model select and backspace to remove the
46:07
existing item this one also select them properties select here backspace to
46:13
remove the existing item now we have to load the classes and days how to load them uh we have to load them simply
46:22
let's back to our project we already load we don't need to load again the
46:27
same thing the classes and subject right classes for the class we are we load the
46:33
same code we already did instead of doing this one is copy and paste it over here when the page is open it will be
46:40
loaded uh we load it
46:51
right basic right first you have to import the SQL
46:57
name space i haven't imported import java dots
47:02
sql now you have to write connection
47:15
prepared statement PS
47:23
after that result set object prepared statement
47:28
write the correct without spelling mistake then only it will be work out result set object I'll write result
47:36
set by test but here you have to display the classes
47:43
this one you have to c CBO CB
47:48
class this one should be also CBO D
47:59
class right class it will display class when the when the page is loaded your
48:05
call inside the constructor the same thing you have create another class this is a days load days create different
48:12
class days okay this one should be the we have to load the days
48:20
uh days also happen to the class there will be the field called
48:27
uh this one class name this is subject
48:32
this is the table time table days you have to write a test subject
48:41
this also we don't need to write here you have to load it here as well we don't need them okay the model we have
48:47
to write the list simply uh because the uh day won't change okay
48:52
so that we have write here uh Monday write Monday
48:59
Sunday Sunday Monday Tuesday right like this otherwise you
49:06
will be able to create separate table for days and you can store it that is your wish okay the day won't change okay
49:14
so that this same thing uh because uh once you if you have a system if you want to put the extra
49:20
class and po as you can maintain by the separate table in the database and you have to call it
49:26
okay here in this video I'm not doing this one we have to uh there are seven
49:33
days in a week so that I have write from the Sunday to Saturday right Saturday
49:38
Wednesday Thursday
49:44
Friday Saturday Right
49:51
right this one this one right now if you select the class and days
49:58
appropriate subject and times will be displayed right it's very simple right so it's a class and day right your day
50:05
Monday the subject relevant subject will be displayed right so here uh
50:12
this one you have to write like this you have to put the heading and write it simple
50:17
table you can get the table over here j table
50:28
the label can't load the uh only load one data only at a
50:35
time there is no features would load more than one data at a time so we have
50:42
to write the table table can can load right so here this one should be the
50:48
we have to configure the table right click table content rows just delete the
50:54
existing rows and columns there are two columns
51:00
subjects
51:05
subject time only
51:11
this one no needed delete them click and delete okay that's it
51:19
if you want you just put it here id simple right that's it
51:25
subject and ID you can maintain by the separate table right like it's very simple you'll be able to maintain this
51:31
one also you have to properties click on this one
51:40
b
51:53
now here let's go to the file uh right click run the file you can check here
52:13
uh we have to we have to give the link as well
52:18
main time table so double click on this one we have to make the link
52:24
copy and paste it over here time range uh this one should be the
52:30
view table
52:47
why what's the problem it's not load okay the problem is this i haven't made
52:52
the connection connectivity copy this one here we have make the connectivity
53:06
copy this one the same connection you just connected your connection is must if the database connection is started
53:13
only it work right now let's do it
53:20
okay again here it's a problem
53:30
class this class name
53:36
uh the problem is first the connection work after that only we will be working the load the class that's the problem
53:49
click on this one now it's work Here the class is loaded you'll be able to
53:55
uh select the day the appropriate subject and time will be displayed over here
54:01
right so let's do the stuff as well now here uh it's very simple
54:09
let's do it as well
54:19
uh this one
54:24
table so we will load the table there a table you have to load select
54:31
the days and time okay if you are load uh select the day time you have to load
54:36
load and show the subject okay so what I'm going to do is here
54:44
we have to a button we have a button
54:53
this button we have to call as filter
55:00
that called as filter
55:08
now here select the class and date appropriate subject and time will be
55:14
displayed below in the table okay this is the things I want to do right so we
55:19
will the complete the if I if the uh uh subject and time is displayed our system
55:25
is finished we have to do some modification and all uh we will do all the stuff in my next video tutorial uh
55:32
next next video tutorial we will be able to finish the all the stuff right if the video is lengthy
55:39
uh it is not a good that's why I have finished it only the 10 minutes thanks for watching
55:46
hi friends welcome to tutor learning channel today I'm going to teach about the time table view part in Java here in
55:55
our last class we design all the stuff now here only we view the table only so
56:00
if you have click this one table select the class and day relevant time table
56:07
time table should be display on the table over here so how to do the task double click on this filter button so
56:13
here I'm going to I want to load the code i have paste it over the code i will be explained don't worry about that because if I
56:20
do the things step by step it take too much of time to complete that that's why I have just copy and paste it i will be
56:26
explained don't worry i have to set the alignment first then only I be easily I will be explained to you without any
56:32
problem right right so here what I did here is first
56:41
this one combo box this another combo box if you select the class and day if
56:50
if both correct data should be click filter button the data should be the relevant data should be displayed the
56:57
table if you select the class A and date Monday the the relevant information will be
57:04
displayed on this J table so what's the class you have selected here this class
57:12
so you have to write get selected item two string okay you have write like this otherwise you can write the two string
57:18
you have to put in the string like this both are same okay both are same you can do like these
57:25
two ways both are same okay okay this you can cross like this this a cast you
57:30
can write like this okay right so here it the data should be passing to
57:36
here what is the class you have selected the date should be the class will be passed here the thing what's the day you
57:44
are selected pass into the days so here you have to write the prepare statement
57:50
here select all from time table where class mean it's a class right
57:58
you have to go to the MySQL database here time table this is a data the class subject and days and time so you can see
58:05
here class from time table we have class and day okay what is the class the class
58:10
and days correct relevant relevant data should be display on the J table so here
58:16
after that this is the classes and days these are we have used the prepare statement to do achieve the stuff
58:23
rspec.execute Execute it to execute it all the query we have to filtering according to the
58:28
data right so here data table data table model we have to casting as a default
58:35
data table model this all set metadata we have set the metadata so in order to count the columns and all you have to
58:41
create a variable and you have to cast J table and set uh set row count zero okay
58:49
it will be reset the columns so we have to write the while loop you have to create the class vector and here we have
58:55
to write the for loops and we have to vector at rs.get string the subject what are the uh record will be display only
59:04
subjects and times only display when you select the class and particular day the
59:09
relevant subject and days should be displayed on the J table so here subject and time you are
59:17
passing to the vector okay after that J FT this one we have to add to the vector
59:22
so we have to display on the J table what is the name of the J table you have to pass it here j table one you can see
59:29
J table one this is name right we passing right now let's check whether it's working fine or not so main
59:36
run it so select the table view
59:41
select the class array Monday click okay sub will display now
59:47
we will be adding to more subjects right so here subject and
59:55
uh here you have to edit more subject classes and class classes we only I'm
1:00:00
going to add the subjects uh English maths
1:00:09
maths and uh maths PD
1:00:22
right this one should be ID which subject I'm
1:00:28
going right now let's what I'm going to say I'm going to do another thing is add the
1:00:34
subjects now here the time table registration you have to go here class A
1:00:40
I'm going to add the subjects right Why the software is not only English only
1:00:45
display others are not display why what's the problem let's go here and check the database
1:00:55
uh here why it's not adding the subjects
1:01:00
what is the problem here is there the problem this text name is TX sub so we
1:01:08
have to change this one CS sub the problem right this is subject subject
1:01:14
that's the problem right if there's any error you can here the same text field I
1:01:19
just copy and paste it I uh without change the name so so that the the same
1:01:24
name will be here as well so that it it won't work right now here now the problem is solved again I'm going to go
1:01:32
and have a reg registration part subject
1:01:38
max saved Subject saved science
1:01:45
saved Hindi
1:01:50
saved it save right now let's add the
1:01:56
data uh we will be provide the link and all
1:02:01
no problem so here time table registration here your class
1:02:06
A here all the columns are there now I'm going to select the maths this one here
1:02:12
we have to what's the problem here is you have to get rid of the lines this empty data you have to I have added only
1:02:19
the numbers you have to clear up that one that's why that's why it's a blank will
1:02:24
be display again I'm going to run it stop the things you stop it and run it again
1:02:33
registration now it's working here it's no problem uh I'm going to select I'm going to subject
1:02:41
6A English at uh maths Monday time
1:02:48
9 9 to 9:00 a.m
1:02:54
oh 10
1:03:04
save again we select the science
1:03:10
Monday time 10 to 10:40
1:03:20
again I'm going to go here run Hindi Monday
1:03:27
10 11 to 11:40
1:03:37
it Monday this one I'm going to switch 12 to
1:03:44
1 that's it time table save now let's view the table
1:03:55
if you have to select Monday 6 this time table will be display you have
1:04:01
have a nice table the same thing you have to you have to add another class you select as Monday the relevant record
1:04:09
will be displayed if you change the day that the Tuesday I haven't added so that it's no data is there okay Monday only I
1:04:16
have added it's recorded into the database it will be display the uh day
1:04:21
class according to the according to when the record data will be displayed right
1:04:27
the class and date which you are selecting selected on the from the combo
1:04:32
box according to the data will be displayed on the J table like this right it's very simple
1:04:38
okay all this if you want to do another thing is here
1:04:43
uh you have to do it the simple stuff
1:04:50
right click property This font
1:04:58
bold 18 range as 18
1:05:05
uh foreground color background color if you want to change the background color as
1:05:10
black foreground color as white it now the
1:05:19
yellow now you'll be able to see the output sum differently
1:05:27
one day here you can see the output like this so here
1:05:33
the font is little bit bigger i hope you have to change it as a 14 will be
1:05:39
enough otherwise it's not a beauty the beauty is must know
1:05:46
one day yeah it's working now you can easily you can see the software
1:05:53
the days and time will be displayed this is simple time table you will be able to do it okay uh here if you have a in my
1:06:02
next video tutorial I'll be given the uh another links login and all the credential we will give you uh I hope
1:06:09
you guys will understood things well if you haven't doubt on this you can ask me anytime if you like my channel
1:06:18
uh you can subscribe me thank you for watching
1:06:23
hi friends welcome to Tutor's funny channel this is the final video of time
1:06:28
table school sign table system in our last class we all the classes and
1:06:34
subject and days and time all the things have we did we we we will be able to view the table right now we will have a
1:06:42
login simple login form and everything we will be finishing in this video tutorial so let's what what I'm going to
1:06:47
do is I'm going to go to the project this is my project select the default
1:06:53
package right click new Aframe form here I'm going to create
1:06:59
the login form
1:07:06
this login form drag the panel
1:07:13
this panel right click properties uh background color I'm going to change
1:07:19
it as uh black
1:07:26
drag one label foreground color I'm going text i'm
1:07:32
going to change it as login and select the text and back properties
1:07:38
and foreground color I'm going to change it as white and font I'm going to with bold
1:07:47
24 or 36 will be changed as 36 it will be
1:07:53
enough for for us right
1:08:01
after After that I'm going to drag the labels before drag drag I'm going to drag the
1:08:09
panel
1:08:17
right click properties border uh bevel border okay
1:08:28
now here what I'm going to do is
1:08:36
drag the labels username
1:08:46
properties board 18
1:08:53
this one C to copy V to paste this one should be the password
1:09:07
drag two text fields
1:09:17
check this one properties bit bold 18
1:09:24
text we have to get rid of the text here close it select again text variable txt
1:09:32
user select this one ctrl C copy control B to paste this one should be the txt
1:09:38
password tx txt pass
1:09:43
right now what I'm going to do is here track one layer button
1:09:51
this one should be locking
1:09:59
after that this button control C copy control B to paste and get another copy this one should be I have named as
1:10:04
cancel right we have a two button one is a
1:10:12
login another one is a cancel now what I'm going to do here is select this
1:10:18
login button event action action performed
1:10:29
first this one have a pass txt user right first you have to
1:10:34
write here stringame equal txt user dot
1:10:45
get text same thing ctrl + C to copy ctrl V to
1:10:50
paste here this one to do the pass takes the pass
1:10:56
you have to here we have a we have a check if
1:11:02
this one this user have to test here username
1:11:08
dot equals
1:11:14
admin and
1:11:20
This one should be pass
1:11:25
dot equals 1 2 3 if the username is admin and
1:11:33
password is 1 2 3 what you have to do here is we have to here
1:11:41
login successfully and visit in the main form or the name of the main form main so main here create the object m equal
1:11:48
new main the current form we have this dot
1:11:56
set vable false
1:12:01
and current form we have show m dot
1:12:08
and set viable true
1:12:13
that's it that's the thing we have The current form this form is log if the username and password correct it's
1:12:19
showing otherwise we have a message display the option pan dot save message
1:12:30
dialogue this
1:12:38
user name of password
1:12:44
error that's it that's the thing we have to write
1:12:49
right now let's check first you have to go to the project we have set this one as a
1:12:55
uh initial form so customize it's a main the run you have to
1:13:01
customize this one login form click okay select the project here you have to create default configuration
1:13:07
now let's back and run the project and again you have to do it
1:13:16
now here this is not uh nice select it here go to source ctrl F ui i'm going to
1:13:22
change it as matter look and design select the design right click
1:13:29
properties code generate center click run it
1:13:37
perfect here we have to write admin 1 2 3
1:13:43
just login so here the password I forgot to put the password text box over here
1:13:48
this is not efficient way get rid of this one this is password text field you have to
1:13:55
paste it over here this one should be selected here
1:14:02
uh properties this one should be the board with 18 characters
1:14:07
and the name should be txt pass you have to give the name here
1:14:13
that's it that's the thing we have to do right okay that's the login form right
1:14:18
now you have a you have type wrong username and password username and password error if
1:14:25
you type the correct username and password login here you can view the time table
1:14:32
here you will be able to uh select the classes and all you get get the time
1:14:38
table here okay the simple one if it is you can create the classes and days and you will be able to visit all the stuff
1:14:44
right you you you'll be able to drag and drop and you can visit here right simple
1:14:51
okay guys i hope you guys you understood the simple time table system in Java uh
1:14:56
system tutorial well uh here the cancel button I haven't written the code so
1:15:02
here also I'm going to write it as
1:15:09
you can write simply system dot
1:15:14
exit zero it will be exit here
1:15:21
that's it that's the stuff you have to write okay very simple system I have made it uh I hope you guys you
1:15:28
understood this one if you have any doubt you let me know that thank you for watching

Java Swing MySQL School Timetable Project for Beginners | netbeans IDE

Tutusfunny

Java Essentials - Life cycle of a thread | Java

Java Essentials - Thread synchronization

Java Swing Student Grade Calculator | Step-by-Step Tutorial with AI!

C# Desktop and Android Studio App and SQL Server Project

Prompt Engineering: A Must Have Skill for Everyone

How to Create Digital Clock in Excel | How to Create Running Clock in Excel Using VBA

New to Coding? Start Java Programming Today | Java Course for Beginners

How to Create a Spring Boot 3.0 Project Using Spring Initializr (Step-by-Step)

Boosting Productivity with .NET Source Generators

Java Project: Build an Age Calculator App (Easy Tutorial)

Complete online examination system project Java Swing + MySQL | Free Source Code!

ACC PLC Simulator – How to Use the Free Browser Based PLC Trainer!

Backtesting Scot1and’s Slingshot Trading Strategy in Python

Python Datetime Module & Pytz Tutorial

Simple Date Functions and Sliding Date Window Filters | Essential SQL

Up next in 10

Java Swing MySQL School Timetable Project for Beginners | netbeans IDE

Tutusfunny