Solved

java iterator using list and map

Posted on 2011-03-16
5
466 Views
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.setTermNum(Integer.parseInt(dto.getpTerminal()));
                        _printerDefaultsVO.setPrinterId((String) al2.get(1));
                        _printerDefaultsVO.setPrinterDesc((String) al2.get(2));
                        _printerDefaultsVO.setTerminalDefault(((String) al2.get(3)).charAt(0));
                        _printerList.add(_printerDefaultsVO);
                        
                  }

Any help would be appreciated.
0
Comment
Question by:Jtw549
  • 2
  • 2
5 Comments
 
LVL 47

Expert Comment

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

while(resulSet.next()){
String s1 = resultSet.getString(1);
int num = resultSet.getInt(2);


then use the values  in any functyions
ettc.

} //end of loop through ResultSet

0
 

Author Comment

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

Expert Comment

by:for_yan
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.
http://www.vogella.de/articles/SpringJDBC/article.html
 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.
0
 
LVL 35

Accepted Solution

by:
mccarl earned 250 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>() {
  @Override
  public manifestTerminalPrinterDefaultsVO mapRow(ResultSet rs, int rowNum) throws SQLException
  {
    manifestTerminalPrinterDefaultsVO _printerDefaultsVO = new manifestTerminalPrinterDefaultsVO();
    _printerDefaultsVO.setTermNum(Integer.parseInt(dto.getpTerminal()));
    _printerDefaultsVO.setPrinterId(rs.getString(1));
    _printerDefaultsVO.setPrinterDesc(rs.getString(2));
    _printerDefaultsVO.setTerminalDefault((rs.getString(3)).charAt(0));
    
    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.
0
 

Author Closing Comment

by:Jtw549
ID: 35156136
actually....that worked Mccarl...thanks
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
This is about my first experience with programming Arduino.
Viewers will learn about arithmetic and Boolean expressions in Java and the logical operators used to create Boolean expressions. We will cover the symbols used for arithmetic expressions and define each logical operator and how to use them in Boole…
Viewers will learn about basic arrays, how to declare them, and how to use them. Introduction and definition: Declare an array and cover the syntax of declaring them: Initialize every index in the created array: Example/Features of a basic arr…

760 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now