wood burning stoves 2.0*
The moose likes JDBC and the fly likes Problem with update and create methods in MVC 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 "Problem with update and create methods in MVC" Watch "Problem with update and create methods in MVC" New topic
Author

Problem with update and create methods in MVC

Ana Pan
Greenhorn

Joined: Oct 23, 2012
Posts: 4

Hello all,

I have a login MVC, where in my model User.java I have 2 methods that are not working correctly:

1-create method creates a new user in database, but servlet still redirects me to "operation failed" page
2-update method shows this when deployed:
java.lang.RuntimeException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT userId FROM user WHERE username='oksana' AND password ='oksana'' at line
1

Can somebody please help me to understand what I am doing wrong here.

This is my model User.java


This is my controller UserSystem.java



Big THANK YOU in advance!
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 61082
    
  66

Copied to the JDBC forum as this seems to be primarily JDBC issues.


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
Ankit Dan
Ranch Hand

Joined: Aug 31, 2012
Posts: 47

the problem is in line no 85

and line no 89

as you are trying to assign the whole query to userid instead of storing the result from query1 to userId
hope this helps...
Sresh Rangi
Ranch Hand

Joined: Nov 28, 2012
Posts: 46
    
    1
It would be less error prone, and more secure, to use PreparedStatements with parameters to create all these queries.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Problem with update and create methods in MVC