Hi Paul,
Welcome to the Ranch!
Why did you create 5 topics for the same issue? Please create only one message for your issue. Using all caps is considered shouting, so, please avoid that. As you are new here, I would also like to point you out to a link
How To Ask Questions which explains how to ask questions effectively and nicely.
For your issue:
You are adding a list of
String values to the JList. These strings are of the format "1.name".
When you call list.getSelectedValue(), you will get back this String value. So, if you want to get the 'name' part from this string,
you should use the String methods like indexOf() and substring() to get the value and then use it.
I would also like to point out the various issues in your code:
1) You should add a ListSelecttionListener to listen to selection changes and not MouseListener. You can read about this
here
2) You are using Statement and appending the value to the where condition. This is not a good coding practice. You should use PreparedStatement.
3) You have the GUI code and the DB code in the same place. You should look to separate these into separate classes.