aspose file tools*
The moose likes JDBC and the fly likes how can i write a user defined query statement Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "how can i write a user defined query statement" Watch "how can i write a user defined query statement" New topic
Author

how can i write a user defined query statement

David Nelson
Greenhorn

Joined: Nov 13, 2003
Posts: 22
this function is just like most site provided, there are several options, user can specify values for some options, but don't have to specify all of them,

e.g. to find users, there are some options such as: age arrange, sex, occupation, living place, height..., user can specify values for some of them, so that to shrink search result.

how can i write a prepared statement for this kind of query,

Cheers.
Adeel Ansari
Ranch Hand

Joined: Aug 15, 2004
Posts: 2874
here somethin for you Nelson


And then some if conditions,



hope it will give you atleast an idea.
[ October 25, 2004: Message edited by: adeel ansari ]
David Nelson
Greenhorn

Joined: Nov 13, 2003
Posts: 22
i c it, thanks sooo much
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: how can i write a user defined query statement