I have a user table that has user name and password columns. I would like to encrypt the password column. I also have a java application that retrieves user name and password. It then does a plain string compare between password that was typed in and the one that is in the database. If they match, the user is logged in.
I would like to encrypt the password on the database side and then somehow be able to compare the password that was typed in by the user and the encrypted password in the database. I would appreciate your help in getting this to work.
I am using JDK 1.4 and in conjunction with Oracle 8.1.7 db.