MySQL And Java Tutorial using netbeans part4 mysql to java classes

Description: Map Mysql table to java code by using data service
see part 5:http://www.youtube.com/watch?v=yhjrTlzL4CY
completing data access object functionalities

about this video :
1-make mysql connection
2-create mysql dataservice
3-bind it to jtable
4-generating java object from mysql automatically
5-begin with DAL Java class


Facebook:https://www.facebook.com/dev.ahmadnaser

---

Closed Caption:

welcome everybody to our fourth tutorial
on my sequel and java this tutorial
which is the most important one of our
series we're going to add the function
of these such as significant all insert
and do all that stuff to the user
interface that we have government in the
previous tutorial so let's begin to
forget to subscribe as all time by this
video I would like to remember remind
you with the thing that we're going to
cover gonna bring the table to object
conversion because we don't want to
create the table from scratch we've got
to take it from the my sequel directly
to java code
this is very nice and we gotta use the
service object table source binding
we're going to take the table from is
equal and bind it directly to the g
table and java knit bees after that
we're going to use the data access layer
object in order to select and get all
the records in the database and also we
got to use the dell or the object in
order to insert data into the database
and after that we gotta learn also how
to call the data X object and assign it
to the g table so all these we gotta see
it in this tutorial it's very nice
tutorial so first things go to the
netbeans first thing we need to to going
to the services we have a tab here
called services so we need to go to the
databases and create a new connection
and disconnection is going to be with a
my sequel database so go to my secret
connection and notice you need the
driver can download it and if you don't
have it but i already have it here we
can add if you don't have about you
by default must be here if not you need
to download it
this is the my secret connector general
5.1 need to download it and added to the
my sequel connector driver so after they
can go next
here you can type the host the database
we talking about school so school and we
can't miss the connection connection
succeed you can click Next and you just
die finish before I talk finish I
couldn't go to projects but as you see
before we went to this connection wizard
we will have a magic thing here we have
we will have something cool
ah in order to have a magic thing that
i'm talking about the cool thing you
need to go to the services in order to
generate the student object from the
connection from the database directly
from the my sequel without timing and a
single line of code
okay because we're talking about student
who has an ID name and an address we
need to do note that that object so in
order to do that you just go to school
and here you just go to tables you can
see student here
ok this is the table student you
remember that we have the we had design
and data service form
ok as I told you this is a data service
form we don't wanna r-type any code we
just want to drag and drop something you
because of the other service so we take
this data from this data service we just
drag and drop this table into our d
table so just drag it and drop it over
this G table
ok so as you can see here the g table
and something happened to him
we got an ID we got an AV got an address
so if you go to projects you go to
there's a new object you called student
so this is all generated from there from
there my sequel into a java code so this
is very nice
you can see all the Gator and sitters
here is origin
it you don't need to miss with him
because they are also generating this
about 125 line of code or the generated
for you
so this is very nice so when you run
this and try to run the application that
you have created you go to the data
service form we got to see all the
rivers so as you can see here we've got
all the records we got 21 the name i'm
at 123 so got all the records and it's
already generated to just the seconds it
took us to do all this stuff and also to
create an object so this is the first
thing using drag-and-drop features in
netbeans so this is a known as i call it
as a data service for ok so this is the
first thing other thing you can do is by
going to create the custom object or
called me close this called data access
object or down or doubt
ok so this dau object a you to do this
manually by creating everything manually
so our have full customization power to
do all this stuff manually so in order
to do this let me create a new
connection so it the connection here is
Orel binded now i need to create it by
using some manual code diving so if you
go to the database create a new object i
need to create a connection object so
let's see let me name it my connection
to connect to the sequel database my
sequel database so my good connection
and finish ok it's very fine here
I
with everything so my connection I just
copy this and paste the stuff here so as
you can see here we just created a new
connection object with which returned a
connection so in order to do this you
need to import the following libraries
ok driver manager connection and sequel
exception i'm also you need to create a
connection here to be involved and after
that inside the connection you define a
method to be get connection which
returned a connection and you just
thought the following line of codes in
order to connect with the with my sequel
database so first thing you time try
class.forname you just type this is
sometimes optional but you need to tie
bit catch classnotfoundexception if
there's no driver install you just you
know do this if everything is fine we
just same thing we just put this as to
be no okay this is you know there's no
need for this but no problem and this is
the nice thing here we just tried to
make a new connection by using driver
manager the gate connection we type GDC
my sequel local homes we talked to the
database name and permission the best
word and the username the username and
the password so that our username is
root and the password we don't have any
best or save it or set so is the default
configuration to create a new connection
is we catch any air here if connection
is not equal to no mean that it's open
are we to tap this message else you know
everything is fine we just returned the
connection so this is pretty much how
you can make a connection so this is all
the code that you needed to
make the connection after this we're
going to use different story
are we will make let me make sure that I
close the the arm
ok the the way two minutes ago netbeans
let me make sure that I close the class
so i think is it closed boats not close
yeah it's close ok this one so after
this i need to create the data X object
so you need to focus here with me it's
very important because if you understand
this you will understand this in many
other languages like C sharp java and
it's very very important the data X
object because sometimes you need to
make connection with many databases for
example you need to make connection with
both gray database where though
for example secret database or sometimes
you need to make a connection with no
secret identities so you need to
understand the idea of that X object so
that I x object is a separate liar
between your application user interface
and your database so you just change the
connection without changing their that
acts objects so it's very very important
ok so let me let us create the new data
access objects so here we need to create
the data access objects for the object
student so just go java class he retired
student
ow ok data X object we just finished so
here we got their student data access
objects that acts object may you to
create do the crude operation which is
great update
give me and what what croch create you
know delete update and insert you can do
all the separation by using the data X
object so in order to do this I i just
want to copy all the predefined data xrd
because I don't have time to time it
manually so I just put it here so you
just need to insert the following
libraries we inserted that the result
set and the statement
those two are very important and we are
using an array lists and lists and force
the connection because we want to bring
their connection and connect to the
database by using the data exile just so
all the time you need a connection
ok so you need to import these values
and this or very important
ok first thing I just wanna cut this
video into toolbars because it's going
to be very long
we need more than 10 minutes in the next
video so i gotta cut it right now and
continue this video in the next part
because you know YouTube limit us to 15
high-definition minute
so first thing you need to just you know
that you understand the structure of the
decks object we need this both library
just bored them and make a statement to
be in all in a connection to be able
because we're gonna do all the stuff
based on the statement and the DB
connection in the next video in the next
video guys see you there thanks