How do I add rows to jtable in same line when it has same id number from DB in java?

Question

1.00/5 (2 votes)

See more:

hi all , i have table in DB and i need to add rows to table in my JTable in java , i was add these rows successfully but i need to keep each values which have same id in same line in JTable .
how i see if items have same id number without assign the specific number ? i mean without id = 1 and so on . ?

What I have tried:

Quote:
my DB table look like

frequent_set_id ----- item_name
1 -------------------------- butter
1 -------------------------- oil
1 -------------------------- apple
2 ------------------------- cookies
2 --------------------------orange

Quote:

any help please .

Posted 25-Apr-17 9:56am

Member 13152044

Updated 25-Apr-17 10:31am

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dave Kreskowiak · Answer 1 · 2017-04-25T10:31:00

Solution 1

Each record has to have it's won ID to uniquely identify it. You're treating your existing ID column as a primary key for the table when it is, in fact, a foreign key into another table.

The solution is pretty easy. Add a new identity column to the table.

ID    Frequency_Set_Id    Item_Name
 1            1           Butter
 2            1           Oil
 3            1           Apple
 4            2           Cookies
 5            2           Orange

Posted 25-Apr-17 10:31am

Dave Kreskowiak

Comments

Member 13152044 25-Apr-17 16:35pm

actually item_Name is a item_id and its foreign key from table ITEM , but i wrote it in this way to understand my problem .

Dave Kreskowiak 25-Apr-17 16:40pm

No, you actual made it more confusing. What is the EXACT layout of this table, with example data?

Member 13152044 25-Apr-17 17:05pm

frequent_set_id -- Item_id
1 ---------- 1
1 ---------- 2
1 --------- 5
2 --------- 7
2 --------- 9

this is my exact table . and Item_id is foreign key refers to table ITEM , i can extract the names of items but my problem in how to see if frequent_set_id same to put them in same line in java table .

Dave Kreskowiak 25-Apr-17 17:29pm

You're asking how do you retrieve everything that has a frequent_set_id of 1 from that table and consolidate it into a single string? Like ID 1 should be shown as "Butter, Oil, Apple"?

Member 13152044 25-Apr-17 17:40pm

Yes , but note that i will not write specefic id number for example: see which items has id = 1 and put them together and so on, Because the DB table may have other elements added with new id and my java code not.