Jay Brass

I realized that my rowListener and my tableHeaderRender were in both trying to update the selected row. I created a RowClickedListener that extended MouseAdapter to check for when a user clicked on a row instead of when they clicked on a header. Long story short, this allowed me to set a boolean value and only change (or reset) the selected row to what the user clicked on and not what the header sort had changed it to. Seems to work pretty well.

Hey There,

I have a JTable in a JScrollPane. The table model is created from a resultset from a database query. I've set tempTable.setRowSorter(sorter) where sorter is a new TableRowSorter<TableModel>(model); I've also set sorter.setMaxSortKeys(4); because I only want to sort on 4 specific columns. Currently I call a header render to sort the columns but after it sorts them the selected row is incorrect. I had to add the columns to the SortKeys and adjust for the column selected to sort on so that it would be similar to an OrderBy clause in a database query. Does anyone have any idea how to keep the selected column after the sort? Converting to model or view don't seem to help.
From the class where the table is:
tempTable.getTableHeader().setDefaultRenderer(new ALETableHeaderRender());

the table header render class
public class ALETableHeaderRender extends DefaultTableCellRenderer { /** * */ private static final long serialVersionUID = 1L; protected SortIcon sortIcon = new SortIcon(7); Builder builder = ConfigFaultData.getInstance(); int selectedRow = -1; private int direction; public ALETableHeaderRender() { setHorizontalAlignment(SwingConstants.CENTER); setHorizontalTextPosition(SwingConstants.LEADING); } // try creating a method to hold the selected row and then setting it after the sort is complete public Component getTableCellRendererComponent(JTable table, Object value, boolean isSelected, boolean hasFocus, int row, int column) { JTableHeader tableHeader = table.getTableHeader(); int faultCode = builder.build().faultCode(); Color fg = null; Color bg = null; Border border = null; Icon icon = null; tableHeader.setToolTipText(value.toString()); if(table.getSelectedRow()>-1){ selectedRow = table.convertRowIndexToModel(table.getSelectedRow()); System.out.println("ALETableHeaderRender selectedRow after assigning "+selectedRow); // System.out.println("ALETableHeaderRender selectedRow "+table.convertRowIndexToModel(table.getSelectedRow())); } if (hasFocus) { fg = UIManager.getColor("TableHeader.focusCellForeground"); bg = UIManager.getColor("TableHeader.focusCellBackground"); border = UIManager.getBorder("TableHeader.focusCellBorder"); } if (fg == null) fg = tableHeader.getForeground(); if (bg == null) bg = tableHeader.getBackground(); if (border == null) border = UIManager.getBorder("TableHeader.cellBorder"); if (!tableHeader.isPaintingForPrint() && table.getRowSorter() != null) icon = getSortIcon(table, table.convertColumnIndexToModel(column)); setFont(tableHeader.getFont()); setText(value != null && value != "" ? value.toString() : " "); setBorder(border); setIcon(icon); setSelectedRow(table, selectedRow); return this; } protected Icon getSortIcon(JTable table, int column) { List<? extends SortKey> sortKeys = table.getRowSorter().getSortKeys(); if (sortKeys == null || sortKeys.size() == 0) return null; List<SortKey> sortKeysUpdated = new ArrayList<SortKey>(); SortOrder sa = ((SortKey) sortKeys.get(0)).getSortOrder(); switch (((SortKey) sortKeys.get(0)).getColumn()) { case 3: sortKeysUpdated.add(new SortKey(3, sa)); sortKeysUpdated.add(new SortKey(4, sa)); sortKeysUpdated.add(new SortKey(5, sa)); sortKeysUpdated.add(new SortKey(14, sa)); break; case 4: sortKeysUpdated.add(new SortKey(4, sa)); sortKeysUpdated.add(new SortKey(3, sa)); sortKeysUpdated.add(new SortKey(5, sa)); sortKeysUpdated.add(new SortKey(14, sa)); break; case 5: sortKeysUpdated.add(new SortKey(5, sa)); sortKeysUpdated.add(new SortKey(3, sa)); sortKeysUpdated.add(new SortKey(4, sa)); sortKeysUpdated.add(new SortKey(14, sa)); break; case 14: sortKeysUpdated.add(new SortKey(14, sa)); sortKeysUpdated.add(new SortKey(5, sa)); sortKeysUpdated.add(new SortKey(3, sa)); sortKeysUpdated.add(new SortKey(4, sa)); break; } table.getRowSorter().setSortKeys(sortKeysUpdated); int priority = 0; for (SortKey sortKey : sortKeysUpdated) { if (sortKey.getColumn() == column) { System.out.println("ALETableHeaderRender forLoop column selectedRow "+column+" " +selectedRow); sortIcon.setPriority(priority); sortIcon.setSortOrder(sortKey.getSortOrder()); return sortIcon; } priority++; } return null; } class SortIcon implements Icon, SwingConstants { private int baseSize; private int size; private BasicArrowButton iconRenderer; private double[] sizePercentages = { 1.0, .85, .70, .55, .40, .25, .10 }; public SortIcon(int size) { this.baseSize = this.size = size; iconRenderer = new BasicArrowButton(direction); } public void setPriority(int priority) { size = (int) (baseSize * sizePercentages[priority]); } public void setSortOrder(SortOrder sortOrder) { direction = sortOrder == SortOrder.ASCENDING ? NORTH : SOUTH; System.out.println("ALETableHeaderREnder direction "+direction); } public void paintIcon(Component c, Graphics g, int x, int y) { iconRenderer.paintTriangle(g, x, y, size, direction, true); } public int getIconWidth() { return size; } public int getIconHeight() { return size / 2; } } protected void setSelectedRow(JTable table, int row){ if(row > -1){ System.out.println("ALETableHeaderRender setSelectedRow row2 "+row); System.out.println("ALETableHeaderRender setSelectedRow row2 convertedToView "+table.convertRowIndexToView(row)); // table.setRowSelectionInterval(row, row); ListSelectionModel tableSelectionModel = table.getSelectionModel(); tableSelectionModel.addListSelectionListener(new SharedListSelectionHandler()); table.setSelectionModel(tableSelectionModel); System.out.println("ALETableHeaderRender setSelectedRow table.selectedRow "+table.getSelectedRow()); System.out.println("ALETableHeaderRender setSelectedRow table.selectedRow converted toView "+table.convertRowIndexToView(table.getSelectedRow())); // table.getSelectionModel().setSelectionInterval(table.convertRowIndexToView(table.getSelectedRow()), table.convertRowIndexToView(table.getSelectedRow())); } } /** * @author g72272 * *This class can be used to maintain the selected row *after a row selection has been made */ class SharedListSelectionHandler implements ListSelectionListener { public void valueChanged(ListSelectionEvent e) { ListSelectionModel lsm = (ListSelectionModel) e.getSource(); boolean isAdjusting = e.getValueIsAdjusting(); if ((isAdjusting) || e.getFirstIndex() == -1){ return; } else{ int firstIndex = e.getFirstIndex(); int lastIndex = e.getLastIndex(); int minIndex = lsm.getMinSelectionIndex(); int maxIndex = lsm.getMaxSelectionIndex(); System.out.println("ALETableHeaderRender SharedListSelectionHandler first last min and max AND ROW "+firstIndex +" " +lastIndex+" " +minIndex+" " +maxIndex+" "+selectedRow); if(direction == 5 ) lsm.setSelectionInterval(lastIndex, lastIndex); else lsm.setSelectionInterval(firstIndex, firstIndex); } // for (int i = minIndex; i <= maxIndex; i++) { // if (lsm.isSelectedIndex(i)) { // e.setRowSelectionInterval(tempTable.convertRowIndexToView(i), // tempTable.convertRowIndexToView(i)); // // tempTable.setRowSelectionInterval(i,i); // System.out.println("ALETableHeaderRender SharedListSelectionHandler selected index " + i); // System.out.println("ALETableHeaderRender SharedListSelectionHandler convertedToView index " // + tempTable.convertRowIndexToView(i)); // } } } }

First thanks to you all for your replies. It made me think a little more about what I was trying to do. The solution I have come up with is this:
This works:
sourceComboBox.setModel(dba.getSource());
calls the class to get the resultset from the database

in the database class:
public DefaultComboBoxModel getSource() {
....
I still have to do the trick to get the number of rows returned with the cursor
in order to create my arrays
.....
// rs.getRow starts at 1 not 0 if (rs != null) { while (rs.next()) { sourceValues[rs.getRow()-1] = rs.getInt(2); descriptions[rs.getRow()-1] = rs.getString(1); } } builder.dataSources(sourceValues); dcbm = new DefaultComboBoxModel(descriptions);
builder is an object of the container class that will hold the array of the numeric ranking, in this case an array of results from the database. That's all I need because the other array is used ot create the DefaultComboBoxModel which is the return type of this method.
The Builder class uses the builder design pattern to hold dynamic data throughout the application. I get an instance to the builder class and in my class that sets the model to the JComboBox:
builder.source(builder.build().dataSources()[sourceComboBox.getSelectedIndex()]);

It does what I need it to do and I don't need to.

I'm probably over thinking the problem. I figured creating a whole class to hold these was overkill. That's why I thought HashMap until I realized I needed them in a certain order. From there I moved to multi dimensional arrays or as you put it an array of arrays. I think I could still use a TreeMap for this though instead of a new class.

I need to add data from a resultSet to a JComboBox. It always has to be in the order that the database returns it to me. A minus for HashMap and a Plus for Array. I can get the number of columns from the ResultSetMetaData and I can get the row count by setting the resultset to rs.last rs.getRow() and resetting it back to rs.beforeFirst to iterate over it. This gives me the 2 values for my 2 dimensional array.
new Object[rowcount][columnCount] So if the database people add more items I don't have to change my code. I know an ArrayList is variable length but it's slow.

An array will help me create the model for the JComboBox. In the database the items are stored with a column that specifies the numeric ranking of the item and a column for the text description to be displayed. The numeric ranking starts with -1 and a JComboBox index starts at 0. The problem currently is when a user chooses an item and I get the selectedIndex of the JComboBox, I'm off by 1 when I do the look up in the database. I could just subtract one from the selectedIndex when I get it but I was hoping for a better and more dynamic solution in case the database people add a -2 item. I don't think there will ever be null values but I know better than to assume this.

As I understand them:
Arrays - First class object. An array is a container object that holds a fixed number of values of a single type. The length of an array is established when the array is created. After creation, its length is fixed

HashMap - This implementation provides all of the optional map operations, and permits null values and the null key. (The HashMap class is roughly equivalent to Hashtable, except that it is unsynchronized and permits nulls.) This class makes no guarantees as to the order of the map; in particular, it does not guarantee that the order will remain constant over time.

My first thought was to use a HashMap since it would be easier to get the key based on the value selected (JComboBox.getSelectedItem) and pass the key to the database which would always give me the correct results. Should I sort the Hashmap first, before creating the JComboBox model? Or should I iterate over the 2D array and create a new array from the descriptions that it holds?
On the Object oriented front you're going to tell me to create a class to hold my values returned from the database where one field of that class is the numeric ranking and the other is the description. I think.

You guys are awesome. Thank you Bear Bibeault and Paul and everyone. Timestamp (not TimeStamp) is what I will use.
Thanks

long l = Calendar.getInstance().getTimeInMillis(); Timestamp t = new Timestamp(l); Calendar c = Calendar.getInstance(); c.setTimeInMillis(t.getTime()); System.out.println(c.get(Calendar.YEAR) + "-" + c.get(Calendar.MONTH) + "-" + c.get(Calendar.DAY_OF_MONTH));

as opposed to System.out.println(dateTime);
which would show 2013-02-07 15:30:25.123
I think I like using the string when I have formatted it with SimpleDateFormat. That being said, my question isn't how to get it to the database, it's about whether I should pass around a String or Date object. Passing a Long has some good points, but I think using the original object is the best idea. I don't know if I will need to use it in any other situation in the future and if I use a String or Long, I am limiting myself. I didn't realize this until I saw all of your postings. That got me thinking that a String puts me in a corner where I'm limited to what I can do with my Date time object.
This also sparked a new question, if I were to use a TimeStamp as has been suggested, and against the DBA's wishes, can SQLServer implicitly convert it to a DateTime type? There are hundreds of tables that have DateTime fields. I'd have to make someone go back and change them all to TimeStamps.

Yeah, I thought about TimeStamp, but the DBA warned me that he had a bad experience using TimeStamp in the past and got burned really bad. A Long would be OK but it doesn't make testing very easy. I can log or system.out Strings and they are readily readable. Just a little more to do if I put Longs out there. The other advantage to Strings is that SQLServer converted it for me.

I've been working in Java for awhile but never thought about this. I have a class that captures the current time. This has to be sent to a database. There seems to be a problem going from Java.util.Date to java.sql.Date. All of the hours, minutes and seconds get set to zero. The stored procedure doesn't return the right data since the data is time (and Date) sensitive. My question is, is there any taboo in creating a string from the Date object and passing it around? I will never change this since it represents a moment in time that I never have to add or delete from. It makes it a lot easier since SQLServer does the conversion from a string to DateTime for me. I also don't have to monkey around with Calendar or GregorianCalendar classes or deprecated date methods. I'm using Java 1.6

Looking at some of the other topics in the forum, it looks like one way to read all the images is to create a Table of Contents (TOC) list. It won't be hard to implement but is an extra maintenance step I had hoped to avoid. If I write the code correctly, checking for null, I won't have to worry about the directory of images and the TOC being in sync, as long as the images I want to show are correctly referenced in the TOC.

I know this topic is a little old but I have a similar problem. I can access an image from the executable jar while the application is running using this:
JPanel panel = new JPanel(); ImageIcon icon = new ImageIcon(Thread.currentThread().getContextClassLoader().getResource("ABC.png")); JLabel label = new JLabel(); label.setIcon(icon); panel.add(label);
That works fine for 1 image. What I would like to do is read the entire directory of images and load them without having to hardcode the name of each and every image.

The below code works fine from eclipse but when I make an executable jar file, it doesn't work anymore.
String path = "."; String files; File folder = new File(path); File[] listOfFiles = folder.listFiles(); for (int i = 0; i < listOfFiles.length; i++) { if (listOfFiles[i].isFile()) { files = listOfFiles[i].getName(); System.out.println(files); if(files.endsWith("jpg")){ File image = (File)listOfFiles[i]; Image img; try { img = ImageIO.read(image); JLabel label = new JLabel(new ImageIcon(img)); f.add(label); } catch (IOException e1) { // TODO Auto-generated catch block e1.printStackTrace(); } } } }
In the above code f is a JFrame I created earlier in the code.
I have a piece of code that tries to get the resources
Enumeration<URL> en = Thread.currentThread().getContextClassLoader().getResources("."); while(en.hasMoreElements()){ URL imageNoteUrl = (URL)en.nextElement(); try { System.out.println("URL "+imageNoteUrl.toURI()); } catch (URISyntaxException e1) { // TODO Auto-generated catch block e1.printStackTrace(); } }
but that points to the workspace where the project is: ......./workspace/Images/bin and that won't work from the runnable jar when I execute the jar from my desktop or from another machine.
how can I access a list of all the .jpg files in my runnable jar without hard coding the names of each of them?

Thank you I'll look into ORMs. The current architecture uses all stored procs and I built the front end to retrieve the meta data to get the number of columns in the result. I build the model for the JTable using this information by putting the cloumn names in one container and the data in another. This way my JTable stays dynamic based on the results returned. Any table joins or view loo kups are done in the stored proc. Much of this code is inherited and there is already a class for reading XML so I just reused it as well as editing the existing XML file that had it's own xsd schema file. A lot of this code was written in 2003 so I'm trying to bring it up to date. (it used flat files) A lot has changed since then. There aren't any frameworks used either and I'm not sure I want to retrofit something like Spring into this. Originally I didn't think there would be any problem holding the initial database IP with things like title or backgroundImage. They aren't supposed to change over the life of the app. But I think separating them does make sense.
Thanks for your advice.

Hi all,

I'm working with a swing application that does not connect to the internet. It does connect to a database. Before it can do that, it needs to read the IP address of the database from an XML config file that is resident on the local machine. If the app is ported to another computer, the IP could change which is why it's in the config. (that's out of my control). I need a class to hold the IP address so the app can connect to the database. So when the app starts, it reads the config.xml, connects to the database and performs queries. I'd also like to add some more values to the properties of this configuration class after some more queries have been run and results returned. For instance, if I were building a volkswagon, the number of seats, and engine size would be different than if I were building a Ferrari. These results would be returned from the queries. If I create a static instance variable and get an instance of the class, all the information I need would be there or I could add new information as more queries and results are returned. I'd like to avoid using setters but since the class holds a lot of information, the constructor would be ugly with all of the parameters necessary. Does this sound like a candidate for a builder pattern? My understanding is that a factory pattern would create the same type of object every time and I might not need all of the properties. I need the properties available though in case I want to build a Ferrari instead of a Volkswagon. As the user makes choices, I want to add to this class and use its properties to drive other area's of the app without having to return to the database all the time.

You're awesome. I don't know why I couldn't think of it.

Thank you.
~J

Thanks Paul,
I had kinda gotten you hint in your first post, I'm not sure how to implement it though. Creating a list isn't the problem. What I'm having trouble with is how to get to the lower lever buttons from the top list. I have to name the buttons based on a value in the database, to keep things generic. If the top list has a bunch of names in it, how do I store or retrieve the list of buttons for the lower level?
I had thought of creating a class like a bean and storing some attributes in it.(buttonName, buttonText, buttonColor, etc) Then I could add that object to the list. One of the attributes in the class could be a list so it would have the lower level buttons available by iterating over the list contained in the class.
I'm still not sure this is the best solution though. I will be trying it, and will let you know how I make out.

Thanks

~J