Bosun (SCJP, SCWCD).
So much trouble in the world -- Bob Marley
, in some jsp it's throwing some exception like statement is closed
mallikarjun don wrote:Then how to return result-set?
I don't have any idea about connection pooling
and your SQL is highly inefficient for that.
mallikarjun don wrote:
and your SQL is highly inefficient for that.
What is this means i can not understand please tell me
mallikarjun don wrote:rs.next() What it returns if value is correct?
[OCP 17 book] | [OCP 11 book] | [OCA 8 book] [OCP 8 book] [Practice tests book] [Blog] [JavaRanch FAQ] [How To Ask Questions] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
Hi Bear. I'm wondering if select count(*) would really be more efficient than say select username. I'm thinking that for select count(*) it has to read every row in the table no matter what, whereas for select username it will stop searching when the row is found.Bear Bibeault wrote:
If you only care whether the record exists or not, why fetch all the data with a "select *"? To check for existence a "select count(*)" will be more efficient.