aspose file tools*
The moose likes Object Relational Mapping and the fly likes Ibatis servlets query Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Ibatis servlets query" Watch "Ibatis servlets query" New topic
Author

Ibatis servlets query

muntago Richard
Ranch Hand

Joined: Nov 13, 2010
Posts: 82
I tried querying database records using pass variable from ibatis servlets
it works fine and fetch the records if correct pass value is entered but return error message if wrong pass value is entered
using if statement.
eg








Display1.java







ibatis servlet Display2.java




okay now i tried to fetch the record using form inputs from jsp via pass variable, it keeps on returning
error message irrespective of whether correct pass is entered or not.
it seems that Display2.java is no seeing the pass variable from Jsp form.

can someone tell me what is wrong in the Display2.java
thanks
muntago Richard
Ranch Hand

Joined: Nov 13, 2010
Posts: 82
when i used input form my query becomes

any help please
muntago Richard
Ranch Hand

Joined: Nov 13, 2010
Posts: 82
i also try this but is not working

select * from account
WHERE pass = #pass:VARCHAR#


any help
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Ibatis servlets query