Java: mysql query to JList

Question

My select query returns 2 columns, ID and Text I want to display the value of Text in an Jlist which works :)

When a user clicks on the specific Jlist item, this item needs to be deleted from the database. To do this safely I need to know the ID.

How do I get to know the ID of that specific item of my JList? Can I store this with the Jlist somehow?

Thomas · Accepted Answer · 2014-02-25 14:34:42Z

1

Well, since you can define the type of the elements in a JList just create a class that contains the id and text and then query the selected element for its id. Shouldn't be too hard.

Note that if you don't want to display the id in the list (or maybe display it in a non-standard way), you'd either have to override the element's toString() method or provide a custom ListCellRenderer.

answered Feb 25, 2014 at 14:34

Thomas

88.9k13 gold badges126 silver badges162 bronze badges

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

Comments

Jorge_B · Accepted Answer · 2014-02-25 14:36:11Z

0

JList is an UI component following a Model-View pattern.

I suggest you to build a ListModel based on your query results, populate it with the information you need, and then build an ActionListener reacting on events on your JList. This ActionListener would just read the selected index on your JList, and that brings you to your original object with all the information you stored on the model.

answered Feb 25, 2014 at 14:36

Jorge_B

9,8622 gold badges19 silver badges22 bronze badges

Collectives™ on Stack Overflow

Java: mysql query to JList

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related