my dog learned polymorphism
The moose likes JDBC and Relational Databases 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
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Problem with update and create methods in MVC" Watch "Problem with update and create methods in MVC" New topic

Problem with update and create methods in MVC

Ana Pan

Joined: Oct 23, 2012
Posts: 4

Hello all,

I have a login MVC, where in my model 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

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

This is my model

This is my controller

Big THANK YOU in advance!
Bear Bibeault
Author and ninkuma

Joined: Jan 10, 2002
Posts: 63866

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

[Asking smart questions] [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: 50
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:
subject: Problem with update and create methods in MVC
It's not a secret anymore!