java iterator using list and map

Posted on 2011-03-16
Medium Priority
Last Modified: 2012-05-11
Below Im trying to put the resultset of the queryForList into the functions but its not working out the way I want. I know im doing something wrong. Where ever there is a al2 in the code thats where I want to put the resultset. The way I was trying to do it was with a arraylist (al2) then getting the indexed item and putting it into the method called. I tried  Iterator<Map> iterator=list.iterator(); but it tells me to go use jre1.5...which is wierd.      

List list= getJdbcTemplate().queryForList(mManifestISeriesQueries.getTerminalPrinterList(), PARAMS, Get_Term_Printer_List);
                  Map map = (Map) list.iterator();
                  while(((Iterator) map).hasNext())
                        ((ResultSet) map).next();
                        _printerDefaultsVO = new manifestTerminalPrinterDefaultsVO();
                        _printerDefaultsVO.setPrinterId((String) al2.get(1));
                        _printerDefaultsVO.setPrinterDesc((String) al2.get(2));
                        _printerDefaultsVO.setTerminalDefault(((String) al2.get(3)).charAt(0));

Any help would be appreciated.
Question by:Jtw549
  • 2
  • 2
LVL 47

Expert Comment

ID: 35148985
If you want to iterate through ResultSet, it is much easier.
You just say

String s1 = resultSet.getString(1);
int num = resultSet.getInt(2);

then use the values  in any functyions

} //end of loop through ResultSet


Author Comment

ID: 35149161
Is that even possible to do with Spring, without doing a resultSet Extractor?
LVL 47

Expert Comment

ID: 35149487
As far as I can understand, it should be possible to do it all directly, once
you have access to ResultSet object - these are the basic properities of resultSet which we are using.

ResultSetExtractor is supposed to simplify your interactions with database and to deal better with
error messages, etc., see, e.g.
 but the excerpt in my posting above which relies on basic properities of ResultSet
should still work.
Well, I don't have much experience wit Spring, perhaps we'll hear from someone
who is aware of some implications for other aprts of your spring web app.
LVL 36

Accepted Solution

mccarl earned 1000 total points
ID: 35152992
To answer the question at hand, we would need to know what Get_Term_Printer_List is in the first line of your code, ie. what type is that variable because that determines which overloaded queryForList method is called which changes what is in the resultant list.

Are you against using Spring RowMapper interfaces? I think it would make this a lot easier. It would look something like this...

List<manifestTerminalPrinterDefaultsVO> _printerList = getJdbcTemplate.query(mManifestISeriesQueries.getTerminalPrinterList(), PARAMS, new RowMapper<manifestTerminalPrinterDefaultsVO>() {
  public manifestTerminalPrinterDefaultsVO mapRow(ResultSet rs, int rowNum) throws SQLException
    manifestTerminalPrinterDefaultsVO _printerDefaultsVO = new manifestTerminalPrinterDefaultsVO();
    return _printerDefaultsVO;

Open in new window

(Note: the above was written without testing, or even trying to compile, but it should be pretty close and give you the idea)

What is happening here is that for each row that the SQL returns, Spring passes the ResultSet for it to your mapRow method, where you create and return the object that represents that row. And then (under the covers), Spring creates an List and adds each of the object returned from mapRow to that list, and when all is finished, it passes the built list back to you.

Author Closing Comment

ID: 35156136
actually....that worked Mccarl...thanks

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Computer science students often experience many of the same frustrations when going through their engineering courses. This article presents seven tips I found useful when completing a bachelors and masters degree in computing which I believe may he…
This article describes and provides a custom-made tool I wrote to give businesses a means of identifying commercial music content, without having to expend too much effort. Business recordings are easily identified from possibly illegal music files …
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…
Suggested Courses

597 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question