Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
The moose likes JDBC and the fly likes problem in query using java code Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Reply locked New topic
Author

problem in query using java code

Prasanna RamKumar
Ranch Hand

Joined: Nov 30, 2005
Posts: 31
i wrote query to select the words that start with the particular letter
iam giving through java code
it is showing errors
ResultSet rs = st.executeQuery
("select rootwords from wordlist where rootwords like '"+input%+"' ");


where input is the particular word iam getting from user
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 26173
    
  66

Closing accidental duplicate thread.


[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
 
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: problem in query using java code
 
Similar Threads
Using Struts to iterate over queries with aggregates
SQL injection
Problem With Sybase XA JDBC 2 Driver and WAS 6
Return Type of Select (*) Count query
problem in query using java code