File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and the fly likes Question about datasource Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Question about datasource" Watch "Question about datasource" New topic

Question about datasource

Gökhan Sakalli

Joined: Apr 04, 2009
Posts: 20
Hello. I want to execute an SQL query in a method.

re = preparedstatement.execute(parameters);

After i invoke this method, how is the format of the rs?

And can i populate a textbox in a JSP file with my rs?
Jeanne Boyarsky
internet detective

Joined: May 26, 2003
Posts: 30068

The format of the resultset depends on the SQL query. The best way to get the JSP is to store it in a data structure and then forward to the JSP.

[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3700

At its cores, and a resultset is just a list of uniform hash maps. Each hash map contains a set of records based on your projection. I'd recommend trying some JDBC tutorials to get you familiar with it. And as Jeanne pointed out, never put JDBC code inside of a JSP!

My Blog: Down Home Country Coding with Scott Selikoff
I agree. Here's the link:
subject: Question about datasource
Similar Threads
Problem with html:select
Reading Socket!!
Indian Edition - Java/J2EE Job Interview Companion
Reading Socket!!