also Java Swing tutorial or check out SWT if you prefer faster and more native looking UI
oykuo
2009-07-05 09:53:51
views:
334answers:
3
+1
A:
+3
A:
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.
Brian Agnew
2009-07-05 10:07:35
Can you recommend any good book on this topic ?
Ibn Saeed
2009-07-05 10:11:08
I'd look at the tutorial (I've just edited my original answer). Otherwise, I think there's an OReilly book on this
Brian Agnew
2009-07-05 10:12:05
Just read the following at the first link you posted: ------ Although JDBC is useful by itself, we would hope that if you are not familiar with JDBC that after reading the first few sections of this manual, that you would avoid using naked JDBC for all but the most trivial problems and consider using one of the popular persistence frameworks such as Hibernate, Spring's JDBC templates or Ibatis SQL Maps to do the majority of repetitive work and heavier lifting that is sometimes required with JDBC. --------Do I need to learn Hibernate or Spring as well ? or would JDBC suffice ?
Ibn Saeed
2009-07-05 10:13:36
I don't think so for this. If you have an existing db schema, and are familiar with it, and presumably you have stored procs/queries etc. already fashioned for your existing application, then translating those into JDBC is relatively straightforward. Depending on the complexity of the objects you want to retrieve, you may want some automated solution to perform that mapping, but I would suggest trying it first, getting something working (with JDBC) and then see how much effort it is
Brian Agnew
2009-07-05 10:21:23
What GUI technology should I use ? Swing or SWT with JDBC
Ibn Saeed
2009-07-05 10:56:20
Shouldn't make a difference. That decision should be orthogonal to the database work
Brian Agnew
2009-07-05 11:26:08
For starters JDBC works find. Remember to have anything SQL related outside the GUI code.
Thorbjørn Ravn Andersen
2009-07-05 11:31:09
A:
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.
Thorbjørn Ravn Andersen
2009-07-05 11:32:51
I did not understand your post. Can you elaborate please. How would DBVisualizer help me in building a Windows Application interacting with my Online MySQL Database.
Ibn Saeed
2009-07-05 12:50:15
I was suggesting that if you were the only person working with your database and the database is small , it might be much easier and faster to do the work in a database interaction program than to hand code an application. If not, Netbeans has a tutorial on creating a CRUD application against MySQL - http://platform.netbeans.org/tutorials/nbm-crud.html
Thorbjørn Ravn Andersen
2009-07-05 23:33:49