newbie JDBC SP exec

Thread view:

homesick_alien - 14 Mar 2004 14:31 GMT

Hey There,

Ive been thrown into the deep end at work, ...i" want you to write these
servlets....im assuming you gonna need to learn java..you have two
weeks"...kinda thing....

Im using Velocity and the MVC method...i have a servlet that connects to a
Sybase DB and executes a Stored Procedure, the stored procedure returns a
bunch of records consisting of two columns....

CallableStatement cs = con.prepareCall("{call sp_ml_getglobalfilms}");
ResultSet rs = cs.executeQuery();

while (rs.next()) {

String fid = rs.getString("film_id");
String fname = rs.getString("film_name");

Now how do i add these to "something" ..like array or hashtable? ....that
will hold the two coloums of multiple results.....im not sure if this works
but i just threw a couple of things together

HashMap result = new HashMap();
ArrayList resultList = new ArrayList();

.....

result.put(fidKey,fid);
result.put(fnameKey,fname);

resultList.add(result);

Which then i will have to add to the context in velocity..

ctx.put(fidKey,result.get(fidKey));
ctx.put(fnameKey,result.get(fnameKey));

so the velocity template can iterate over the context and display the
results on a web page...

#foreach ($item in $result)

<tr class="tableData">

<td>$item.get(fidKey)</td>

<td>$item.get(fnameKey)</td>

</tr>

#end

Now what i get is...the ctx isnt displayed onthe webpage.... and im not sure
if all the results are added to the context....or ...?

Can anybody point me in the right direction?

Reply to this Message

javamad - 17 Mar 2004 12:53 GMT

Hi there,

The #foreach loop in velocity can iterate through the following java
Object types: Vector, Hashtable or an Array.

For you to display a key,value pair in your web page, the best thing is
to use a Hashtable (I can't remember if you can use a HashMap object
instead, try it!)

The code would look something like this

Hashtable hash = new Hashtable();

> CallableStatement cs = con.prepareCall("{call
> sp_ml_getglobalfilms}");
[quoted text clipped - 4 lines]
> String fid = rs.getString("film_id");
> String fname = rs.getString("film_name");

// Add key,value pair to Hashtable hash
hash.put( fid, fname );
}

// Then on to your context ctx:

ctx.put( "result", hash );
// result is the name to be used in the template file
// that is $result

// And on your velocity template file

> #foreach ($item in $result)
>
> <tr class="tableData">

<td>$item</td>


<td>$result.get($item)</td>

> </tr>
>
> #end

Hope this helps,

Fabricio.

Reply to this Message

newbie JDBC SP exec

Free Magazines