A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
Node.js in Action
this week in the
how to get dynamic data from the oracle back end
Joined: Aug 01, 2006
Mar 31, 2008 03:19:00
getting dynamic data from the oracle.
i want to make the below code as dynamic one. please help me.
rset = stmt.executeQuery("select * from VW_SAP_CFOUR_PODATA where dt_etd='14-NOV-08'");
insted of given the hard coded date i want to give the dynamic vaule.
thanks in advance,
Joined: May 26, 2003
Mar 31, 2008 17:36:00
You want to use a
PreparedStatement stmt = conn.prepareStatement("select * from VW_SAP_CFOUR_PODATA where dt_etd=?"); stmt.setDate(1, yourDate); rset = stmt.executeQuery();
This also has the advantage of not having to worry about the date format.
How To Ask Questions The Smart Way
Blogging on Certs:
SCEA Part 1
Part 2 & 3
Core Spring 3
TOGAF part 1
With a little knowledge, a
cast iron skillet
is non-stick and lasts a lifetime.
subject: how to get dynamic data from the oracle back end
JDBC connection with JTable
displaying the data from oracle in excel sheet
Dynamic Data Display in JSF
Java Dynamic Servlet
Mail Merge in frame maker?
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014