I am Experienced Delphi C/S application Programmer willing to shift to JAVA. I have Installed Eclipse and trying out test applications in Java. I have done a plain form with No database connection and it works.
Now I want to establish connection with database and do a View/Insert/Edit/Delete test form in java.
Can somebody suggest me a good tutorial for this ?
My ultimate aim is to write a 3 Tier database application. With my limited study I have chosen Spring/Hibernate for serverside and Swing/Spring at Client side. In any case the client dont want any browser based Solution. So The application has to run on Desktop. The Server will be as of today in a intranet (i.e. in a LAN) but in future it may be on Internet. Client wants flexibility as far as Backend RDBMS is Concerned. (His Choices are MySQL/PostgreSQL/Oracle/Firebird). We want to code Business Logic Independent of Presentation Layer and Backend database. So that if at later date, Client insist Browser based application we can reuse the same business logic.
Please suggest some good links/Books to achieve this Goal.
Tutorial: try here. Probably a good idea to get the client to decide on the RDBMS to ues; there are slight differences between them (eg MySQL won't accept VARCHAR but will accept VARCHAR(40)) so it will cause no end of annoyance to change at a late date. You can connect Java to different RDBMSs simply by downloading and invoking different drivers.
Joined: May 26, 2008
Seems To be What I Want for get Started.
I will Study That Then come back if needed
Thanks Once Again for extending Help
Joined: May 26, 2008
I have gone through the Links you have suggested and I am able to connect to database and fire some queries there then i used print statements to printout the values from the result set also. Other concepts like transaction, transaction isolations etc. etc. i was able to grasp quickly since i was acquainted with them in delphi CS programming.
Now my difficulty is how to link the values in result set to Swing controls ? In Delphi we are used to define TQuery which is linked to TDataSource and TDataSource Fields Linked to Controls or TDatasource was linked to TGrid which was able to show Values from Query Result in respective controls.
When we want to edit we used put Tquery in Edit Mode Change values in Controls and then fire TQuery Post Method to make the changes permanent off course this used to happen in a context of a explicit Transaction.
Is Java/Swing/JDBC similar to this or I have to do something different ? If possible please suggest me link which will elaborate a simple Insert/edit/Delete GUI example so that I can get started.
Thanks and Best regards.
subject: Swing Database application which runs from Desktop (Win/Lin)