File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Swing / AWT / SWT and the fly likes Swing Database application which runs from Desktop (Win/Lin) Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Swing / AWT / SWT
Bookmark "Swing Database application which runs from Desktop (Win/Lin)" Watch "Swing Database application which runs from Desktop (Win/Lin)" New topic

Swing Database application which runs from Desktop (Win/Lin)

raja patil

Joined: May 26, 2008
Posts: 24

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.

Thanks and Best Regards

Raja S Patil
Campbell Ritchie

Joined: Oct 13, 2005
Posts: 46344
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.
raja patil

Joined: May 26, 2008
Posts: 24
Thanks Ritchie,

Seems To be What I Want for get Started.

I will Study That Then come back if needed

Thanks Once Again for extending Help

Raja Patil
raja patil

Joined: May 26, 2008
Posts: 24
Well Ritchie,

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.

Raja Patil
I agree. Here's the link:
subject: Swing Database application which runs from Desktop (Win/Lin)
It's not a secret anymore!