How to update a table in database when changes are made to already existing records?

[anna george]

hi!
i have created a class 'ChangePassword' which is called from 'login' both extending jframe.
i'm trying to take a new password from the user and update the savelogin table in database Employ that contains fields username and password.

but it gives me the following error

[error]
Error:java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'password'.

 
 
    private void btnChgSubmitActionPerformed(java.awt.event.ActionEvent evt) {                                             
          newpass=jpassChgNew.getText();
          confirmpass=jpassChgConfirm.getText();
 
       if(jpassChgOld.getText().equals(old))
 
       {
 
 if(newpass.equals(confirmpass))
try{
       Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
       Connection con= DriverManager.getConnection("jdbc:odbc:Employ");
       Statement st=con.createStatement();
st.executeUpdate("update emp set password="+newpass+" where  password= "+old);
 
       ResultSet rs1=st.executeQuery("select * from savelogin");
 
       st.close();
       con.close();
   }
    catch(Exception err)
    {
        System.out.println("Error:"+err);
    }
 
       }
 
    }                                            
 

please do answer.
sincerely

[Dheeraj Joshi]

That means, you are not having the column "password" in the table.

Are you sure you have the column with this name? And these column names are case sensitive.

Regards
Dheeraj Joshi