iterate

[Ritika Misra]

Hello ranchers,

My code

 Iterator dataList=Database.open(new File("c:\\purchaseOrder2000.mdb")).getTable("Transaction").iterator(collection);
	while (dataList.hasNext()) {
		Object object = (Object) dataList.next();
		System.out.println("object   ====="+object);
		
	}
	   

My output :

   
object   ====={id=1, name=Baseball, price=2, quantity=200}
object   ====={id=2, name=Bat, price=20, quantity=400}
object   ====={id=3, name=Glove, price=80, quantity=800}
object   ====={id=4, name=Catchers Glove, price=120, quantity=1000}
 

Can any one help me ..with this output...how can i convert this out put to an arrayList......

[Vijitha Kumara]

how can i convert this out put to an arrayList

By looking at your System.out statement and the output,
Just declare an ArrayList of type of the objects you are displaying. Add those objects to the list as you iterate.

 List<TypeOfObject> list = new ArrayList<TypeOfObject>()   

Is this what you want?

[prasad guna]

Hi,

Just declare the arraylist object
but arraylist allow duplicates..

 ArrayList al=new ArrayList();
          al.add(yourobject);
            

hope will use..

[Rob Spoor]

prasad guna wrote:Hi,

Just declare the arraylist object
but arraylist allow duplicates..

 ArrayList al=new ArrayList();
          al.add(yourobject);
            

hope will use..

Just make sure to declare and initialize the array list outside of the loop. Otherwise you will have many array lists, each with only one element, that is ready for garbage collection immediately.

[Ritika Misra]

well guys,
i dont want to add it as it is appearing in the output.
I want to add to my data to a POJO first and then that POJO to ArrayList .
Somewat like this ....

POJO Name =Transaction
skeleton

  

public int id;
public String name;
public double price;
public double quantity;

//followed by setter and getter methods.
  

i want to set the value of column id to id ,name to name and so on...
then these each Transcation object to arrayList.

so how do i do this

thanks in advance

[Vijitha Kumara]

Well, you have to populate POJOs with the values retrieved from database while iterating the loop and add each of them to the list unless you are using a O/R Mapping framework like Hibernate which will load POJOs for you from the database.

[Ritika Misra]

i know that ..
but as you can see my out put .....
this data which i get...is coming from Access database
so i m not getting in the regular format through which i can populate my POJO..

[Vijitha Kumara]

   while (dataList.hasNext()) {   
             Object object = (Object) dataList.next();
                ........     

What ever you are getting you assigned to a type Object here. What type is that object? Isn't that the type you want (i.e: type of your POJO) ?

[Ritika Misra]

Well Vijitha Kumara,

As you suggest ,

What ever you are getting you assigned to a type Object here. What type is that object? Isn't that the type you want

if i do this,

    while (dataList.hasNext()) {   
             Transaction object = (Transaction) dataList.next();
                ........        

And this error is valid as it is a linked hashMap ....so please suggest some way out for retreiving data from LinkedHashMap
I get an error ....pasting error below,

 
java.lang.ClassCastException: java.util.LinkedHashMap
	at com.jmbaxi.cwms.web.LoginController.login(LoginController.java:180)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:585)
	at org.springframework.web.servlet.mvc.multiaction.MultiActionController.invokeNamedMethod(MultiActionController.java:473)
	at org.springframework.web.servlet.mvc.multiaction.MultiActionController.handleRequestInternal(MultiActionController.java:410)
	at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
	at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:874)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:808)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:523)
	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:463)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
	at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:831)
	at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:652)
	at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1203)
	at java.lang.Thread.run(Thread.java:595)



 

[Vijitha Kumara]

If that is a Map then you retrieve the values using the keys (as you know the keys are id,name,etc..) and set them in the POJO.

 
       pojoObject.setXXX(object.get("id"));
       ........

 

And make sure the types of properties of the POJO match with what you retrieve.