Help with Java program (Swing + database)

Question

Could somebody give me a suggestion on how to simply and effectively make GUI representation of directories which are contained inside the database. Now, getting information using SQL queries is one thing. I can do that. In fact using separate small examples I can put a file inside the database along with his information and I can get the file out of the database. The thing is I was just doing this without GUI, just to test does it work.

Now I need a GUI of this and I really don't know where to start. DO I use JTable, JList or something third? Also, I think I need an multidimensional array because I have, for example, id of a file, name_of_file and size.

So I need different types to put them in: int, String and int. Also, I need to obviously hide the id of a file from the user yet keep it at the same time in order to be able to reference it.

How do I hide it in a GUI component?

So, let's say that I have a database table for files with these columns: id, name, size, binary_of_file.

My real table has a bit more of columns like, id of a parent directory, id of a owner, etc. but for now this is not important.

So, I tell database to give me all info about the file (except it's binary because I just want to list the files):

...
ResultSet rs = statementObject.executeQuery("SELECT id, name, size FROM Files;");
while(rs.next()){
    //Where do I store the values in? Which GUI component and how?
...

I guess I need an JPanel that will contain this component that will show my files from the database. What component? Please help!

@trashgod: After carefully reviewing the answers and comments to this question, I am beginning to suspect the OP is not following links. :-( — Andrew Thompson
– Andrew Thompson, Commented Aug 28, 2011 at 19:36

Andrew Thompson · Accepted Answer · 2011-08-28 19:32:40Z

4

It sounds like you want to use a JTable, it has a TableModel interface that you can implement to adapt to your resultset.

Also follow the link at the top of the docs. to Creating a Table Model.

edited Aug 28, 2011 at 19:32

Andrew Thompson

169k42 gold badges224 silver badges441 bronze badges

answered Aug 28, 2011 at 17:19

Tom

45.1k4 gold badges44 silver badges61 bronze badges

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

7 Comments

trashgod Over a year ago

For example, JDBCAdapter.

aarnes Over a year ago

Can JTable show certain information like name, size etc. and hide other like id that corresponds to the file in database?

Andrew Thompson Over a year ago

"Can JTable show certain information ...and hide other" Yes. It depends on the TableModel as to what is and is not included. As I keep saying:- "See the linked code (in my answer) for an example." Have you tried that code yet? Have you looked at how it works?

Andrew Thompson Over a year ago

@Tom: I edited your answer to include a link to TableModel (since I noticed I was just repeating what you'd already said). But then I got carried away and added the text after the line. Please review it and remove anything you feel is not appropriate.

aarnes Over a year ago

Will try it with TableModel. I'm not exactly familiar with all this new information like models etc. so it will take time I think.

|

Community · Accepted Answer · 2017-04-13 12:40:33Z

4

Perhaps a combined JList/JTable component would fit this need.

That is a screen shot of the GUI of FileBro.

My idea is that the JTree on the left would represent the 'directories' and table (names) of the DB. The JTable on the right would contain the data of the selected table. Change the Locate Open Edit Print buttons for Create Update Delete and the panel below that to show details of records, and it would be the start of a DB CRUD component.

edited Apr 13, 2017 at 12:40

CommunityBot

11 silver badge

answered Aug 28, 2011 at 17:46

Andrew Thompson

169k42 gold badges224 silver badges441 bronze badges

2 Comments

aarnes Over a year ago

Looks great but is JTree capable of showing database files or is it only able to "see" real files? How would one add information from the example SQL I posted?

Andrew Thompson Over a year ago

A JTree can contain any objects. What it looks like on-screen is all about the renderer. See the linked code for an example.

Collectives™ on Stack Overflow

Help with Java program (Swing + database)

2 Answers 2

7 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

7 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related