What is required for building Java Windows Application to access Online MySQL Database

Question

Can anyone list the requirements (i.e. any books, tutorials, libraries etc) to build an application in Java, which could communicate with my MySQL Database which is running on web.

I am running an online webstore built in PHP and MySQL. I would like to build a Java Application through which I can (CRUD) Products, Categories, Orders etc.

My Database is already built in MySQL and all the data is present in my online site. So I only need to work on a GUI App which can access my Store's data.

Here is an example application built in Delphi which acts as a Front End (Store Manager) for oscommerce shopping cart.

What technologies do I need for creating Windows GUI in java and Database Application to communicate with my Online Store's Database. ?

I have found some tutorials:

https://web.archive.org/web/20120126005135/http://www.netbeans.org/kb/docs/java/gui-db.html

https://web.archive.org/web/20101125223754/http://www.netbeans.org/kb/docs/java/gui-db-custom.html

https://web.archive.org/web/20090228020221/http://www.netbeans.org/kb/articles/mysql-client.html

https://web.archive.org/web/20110923093326/http://www.netbeans.org/kb/docs/java/gui-db.html

Are the above tutorials enough?

UPDATE:

How about the following books:

1). JDBC Practical Guide for Java Programmers
2). JDBC API Tutorial and Reference, 3rd Edition

Would these be enough for a beginner?

Answer 1

Why don't you just use the MySQL tools directly or any Javabased database viewer? If it is only for you you will save quite a bit of time.

DBvisualizer has worked well for me.

http://www.minq.se/products/dbvis/

Answer 2

For the database communication you're going to need a JDBC driver for MySql.

Check out the official Sun JDBC tutorial for details on how to use this to access your database.

Answer 3

also Java Swing tutorial or check out SWT if you prefer faster and more native looking UI