using database in swing project

Question

I have to develop a Swing Project. I need to access the database in various places. So how should I arrange the classes so that there is one database class. Should I use inheritance for that. Just a brief outline. I'm a java(struts/spring/hibernate) developer but its going to be my first Swing Application.

what will you put in your database class? are you using JDBC? — Cacho Santa
– Cacho Santa, Commented Feb 29, 2012 at 13:14

Hovercraft Full Of Eels · Accepted Answer · 2012-02-29 13:15:10Z

7

Inheritance? No, rather you'd use composition. Accessing a database is no different for a Swing application than a non-Swing application with a few caveats:

Do all database access off of the main Swing event thread or event dispatch thread (EDT).
Do most all Swing calls on the EDT.
If the data will change dynamically will need to read up on ways to listen for data changes and bind the data to your display.

answered Feb 29, 2012 at 13:15

Hovercraft Full Of Eels

286k25 gold badges268 silver badges391 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Lajos Arpad · Accepted Answer · 2012-02-29 13:31:22Z

5

A few ideas:

I think you should use an ORM (like OrmLite, for example) in your application
Create a package which will contain interfaces or abstract classes for your data access layer.
Create another package where your interfaces and abstract classes (of the data access layer) are implemented (these implementations should contain all your direct commands to the database)
Create another package, where you will have your business layer. The methods of your classes in this package should use the data access layer through the interfaces and combine them to solve any business-logic-level problem
You should access directly your business layer classes from the backend part of your application which should be separated from your user interface as much as possible

answered Feb 29, 2012 at 13:31

Lajos Arpad

80.5k42 gold badges124 silver badges235 bronze badges

2 Comments

Hovercraft Full Of Eels Over a year ago

1+ I wish I could transfer all my upvotes on this question to your answer. Very nice.

Lajos Arpad Over a year ago

I've also upvoted your answer, I believe it can be useful for many.

Collectives™ on Stack Overflow

using database in swing project

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related