Solved

placing values in an array

Posted on 2003-11-05
8
237 Views
Last Modified: 2010-04-01
i have an array ar[] and i want to store values in it from the databse,how will i do it?
this is just a part of the code:
 
String[] arr = null;
i nt i = 0 ;
while(rs2.next()){
String duid = rs2.getString("userid");
String ddn = rs2.getString("dn");
String dtn = rs2.getString("tn");                        
arr[i] = dtn;
i++;
}statement2.close();connection2.close();%>

i want to put the values dtn in my array arr[] and pass it to a bean.
hop u can help me on this.thanks.
0
Comment
Question by:kurisuchine22
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
  • 2
8 Comments
 
LVL 15

Expert Comment

by:jimmack
ID: 9692927
The problem is that you don't know how big the ResultSet is until you've iterated through it.

It is easier to store the data in an ArrayList so that it can "grow" as you add new elements, then convert that to an array later (or better yet, just store the ArrayList in your bean).

ArrayList arr = new ArrayList();

while...
.
.
String dtn = rs2.getString("tn");
arr.add(dtn);

You don't need the "i" counter then either.
0
 
LVL 1

Accepted Solution

by:
JNic earned 20 total points
ID: 9697178
I dont know the details of your application, but if it is a multi-thread-environment, I would use Vector instead of ArrayList, since it is synchronized. This is the main difference between the two classes.

Example with Vector:

import java.util.Vector;

Vector arr = new Vector();

while..
.
.
String dtn = rs2.getString("tn");
arr.addElement(dtn);

Regards,

Nic
0
 

Expert Comment

by:tizay
ID: 9698527
thanks nic
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 15

Expert Comment

by:jimmack
ID: 9699829
I'm not happy about this.  JNic simply copied my answer with a different container.

I'll give it 24 hours before I contact CS to resolve this.
0
 
LVL 1

Expert Comment

by:JNic
ID: 9700177
Sorry jimmack, I did not mean to steal your points! :-(
I just thought a Vector would be more suitable in a threaded environment since it is synchronized, and to make it simple, I used your example again, since tizay obviously is not yet a wizard in java.

Would it satisfy you, if I posted 20 points for you, or how would you like it?

Regards,

Nic
0
 
LVL 15

Expert Comment

by:jimmack
ID: 9700237
Hi JNic.

If you don't mind, that would be good :-)

My comment was really for kurisuchine22.  I know you can't split 20 points, but the fact that their comment showed no recognition for my contribution really annoyed me.

Thanks JNic ;-)

(BTW: I'd use add() instead of addElement().  addElement() is not deprecated (yet), but if you use add(), you can switch between other containers - like ArrayList - without changing the methods ;-))
0
 
LVL 1

Expert Comment

by:JNic
ID: 9700290
Ooooooooops - SORRY TIZAY!
I meant of course kurisuchine22 (blush)

Thanks for you comment updon addElement jimmack. I'll post some points for you ! :-)
0
 

Expert Comment

by:tizay
ID: 9712311
how come you guys are fighting over my question?i dont want to cause arguments in this page.hope you understand.i'm just asking a question.:-)
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
bean mapper frameworks 5 68
caughtSpeeding java challenge 16 141
how to exclude a file using regex 5 123
servlet example 17 69
CTAs encourage people to do something specific to show interest in your company, product or service. Keep reading to learn why CTAs should always be thought of as extremely important, albeit small, sections of websites.
Check out this step-by-step guide for asking an anonymous question on Experts Exchange.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

734 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