Java Client/Server With Database

[cruesit]

I'm Developing a Hospital Management System Application using: Java,MySQL,Crys tal Reports.

Since this application will run on network environment, then there will be multiple users who connected to my database server.

The idea:
- I would like to make the application in 3tire mode
- Client connect to the server, server Query the database & returning the result to the client display.
- I will use Desktop environment (JSE).

While searching the internet i read about using XML.
I don't want to use web service, it will be all using SWING for both Client&Server.

Any suggestions, Examples will be wonderful.

[r035198x]

1.) You can't use swing for the server. It's for developing user interfaces only.
2.) Before using swing for the interface, think about how you are going to deploy the interface program to the client. The usual approach would be to use Java webstart. Make sure you understand all that is involved with that and that you are comfortable with it before finalizing on using swing. Make a comparison with advantages and disadvantes of using swing vs making a web based frontend that users access via their browsers.
3.) You need to consider using a proper application server (or equivalent ) for hosting the server side program.
4.) You don't need to use XML for webservices. You can use other data formats like JSON.
5.) If you insist on using swing then other integration tools to consider are remote EJB invocations.