Java JDBC Tutorial - Part 12.2: Connect Java Swing GUI to a MySQL Database - Create the DAO

---

---

In this video tutorial we will learn how to connect a Java GUI to a MySQL database.

---

[luvcodetv]

@MarvinSantiago: I don't have any videos on Oracle triggers. But here are some docs for Triggers Functions with Oracle.



Let me know if you need anything else.

[kevgsim]

This whole series has been an awesome help! Many thanks!

[Tudorel]

Hey. Im having trouble with the "convertRowToEmployee()" method, and I can't open the source code link anymore. It says "page not found". A bit of help regarding this method would be much appreciated

[marvinsantiago]

Hi do you have a tutorial on how to add Triggers Functions and Exceptions to a Java thats connected to an Oracle Database ? thank you in advance

[clopes]

in your source files the 'demo properties' is a PROPERTIES file. If we are learning to create/do this ourselves, can we use a txt file instead?

[gudjac]

Hi, why did you use BigDecimal for salary? And for example if create a program similar to this, like a game or sth and if it's downloadable online or it can be installed on several computers.. So a specific user has a specific login and password, therefore it can be either an admin or a regular user, but whenever the user clicks a button to begin a search or login, the program has to send a query to the database and deep in the code it uses login and pass of my DB, so basically everyone has an access to it and the question is how can I protect it properly?

[ibnrochde]

Great Job but i would like to ask you why you did not use JPA to get access to the database ?

[gilbertslam]

Hi Chad, why do we make use of the Properties object if we can define the values directly as string values? Thanks.

[Xanq]

Hey i would like ask you about "lastName+="%"; everything works but i don't understand only this one line could you tell me how it work?

[MrVisheshsingh]

Hi chad, while printing the output I am getting a hashcode representation of object, what should I be doing?

[nikitafilimonov]

Thank you very much for these great tutorials.

May I ask you a question? 
I am beginner in jdbc as in sql,
 I need to scan two databases which includes some tables. 

And after,   need to create a Database with one table( Did it)

 and then, fill in this table all info about previous two dbs, namely: the name of db, name of relations, Field name, an indication if the attribute is part of the primary key  and so on.

Should I use a ResultSetMetaData or write Constructor and do this task as you did in this tutorial?

Many Tanks.
BEST Regards.

[SKtheGEEK]

let i have a program with mysql use . so i make a jre file for the program . and i run this program in another pc. so will have to install nysql in that pc. and what will be the db url will be like ?

or even it is possible . i just want to know .

thanks


please do reply .

[rafaelperezloperez]

Thanks Luv2code good Tutorial, but can you explain the use of the Diver to connect in MySQL?

[jeromegarcia]

Hi, thankyou verymuch for this clear tutorial.
however, i got some error in Getting all Employee method and search account method saying : "The type List is not generic; it cannot be parameterized with argument <Employee>

how can i fix this...?

Thank in advance...

[ricardoaraujo]

hello, i'm developing a university project and instead of getting my data from a database, I will work with a web service, but still i need to perform the crud. Do you think it is a good idea still use DAO in this case?

[greenhat]

how to make that folder below lib and what to do with that

[sadnansaquif]

Hey thanks a lot for the videos. Also if I am using JavaFX instead of Swing is there a lot of difference in the way we would implement it?

[rakibalhasan]

hello, i tried to access your website to download this source code. but i can't reach.
how can i get your source code can you tell me please.
thank you.

[kamdemkakengne]

Hi! How do the methods convertRowtoEmployee() and close() works. Thank you

[silentass]

it shows an error saying "employee cannot resolved to a type".. what am doing wrong?