unable Update table using Prepared Statement

[jiral dekhtawala]

public static ForgetObj forget(ForgetObj user) {
		
		PreparedStatement pstmt = null;
		
		String sql ="update registration set password = ? where email = ? ";
		System.out.println("str sql==> "+sql);
		
		try{
			dbCon = DBConnection.getConnection();
			
			pstmt = dbCon.prepareStatement(sql);
			
			pstmt.setString(1, user.getPassword());
			pstmt.setString(2, user.getEmail());
			
			
			int update = pstmt.executeUpdate();
			System.out.println("update value "+update);
		
			if (update != 1) {
				System.out.println("Records Does not Update...");
			}
			
		}catch(SQLException se){
			se.printStackTrace();
			System.out.println("sql exception"+se);
		} 
		
		catch (Exception ex) {
			ex.printStackTrace();
			System.out.println("Update failed " + ex);

		}

[Jesper de Jong]

Ok, you posted your code, but what is exactly the problem? What happens when you run this code? Do you get an error? Please explain and copy & paste the error message here.

The SQL statement updates the column 'password' in the 'registration' table for a record which has a specific value in the 'email' column. That's not what I would expect a method called "forget" to do. Is "forgetting" the same thing as changing a password?

[jiral dekhtawala]

@Jesper de Jong
i tried to update password on my database with compare email id exist in DB. But surprise is that i didn't get any error or exception during handle or execute this code... look below attach

[jiral dekhtawala]

try with Simple Statement Still same issue

public static ForgetObj forget(ForgetObj user) {
		

		Statement st = null;

		
		String email = user.getEmail(); 
		String password = user.getPassword(); 
		
		
		String sql = "UPDATE registration SET password ='"+password+"' WHERE email = '"+email+"'";

		System.out.println("str sql==> "+sql);
		
		try{
		
			dbCon = DBConnection.getConnection();
			st = dbCon.createStatement();
			System.out.println("Execute Statement==> "+st.executeUpdate(sql));
			
			st.executeUpdate(sql);
			System.out.println("sql==> "+sql);
			System.out.println("Statement==> "+st);
		
			
		}catch(SQLException se){
			se.printStackTrace();
			System.out.println("sql exception"+se);
		} 
		
		catch (Exception ex) {
			ex.printStackTrace();
			System.out.println("Update failed " + ex);

		}

[Dave Tolls]

What happens when you run that second query against your database directly, through whatever tool comes with your db?
By directly, I mean copy and paste it from your sys out, not write what you think it looks like.

[Jesper de Jong]

jiral dekhtawala wrote:@Jesper de Jong
i tried to update password on my database with compare email id exist in DB. But surprise is that i didn't get any error or exception during handle or execute this code... look below attach

The result "update value 1" means that one row is updated.

That is exactly what I would expect.

What exactly are you surprised about? What did you expect the program to do, and how does that differ from what it is actually doing?

[jiral dekhtawala]

ya that's right but on actual DB value does not updated...

[Jesper de Jong]

Are you using transactions? Did you remember to commit the transaction?

[jiral dekhtawala]

@Dave Tolls
i had also try with manually using DB tool its work success..

[jiral dekhtawala]

@Jesper de Jong
no transaction simple update password on DB with acquire Email id

[Dave Tolls]

jiral dekhtawala wrote:@Dave Tolls
i had also try with manually using DB tool its work success..

OK.
So, going with Jesper's line, are you committing?
What database are you using?
Is your connection auto commit?

[jiral dekhtawala]

mysql
not at all