<%@ page language = "java" import= "java.sql.*" %>
<%
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("Jdbc:Odbc:orads","scott","tiger");
String old_pwd=(String)request.getParameter("old_pwd");
String new_pwd=(String)request.getParameter("new_pwd");
String uid="Admin";
String sql="select pwd from wbmslogin where userid=? and pwd=? ";
PreparedStatement pst=con.prepareStatement(sql);
pst.setString(1,uid);
pst.setString(2,old_pwd);
//System.out.println(sql);
ResultSet rs=pst.executeQuery();
if(rs.next()==false)
{
%>
Invalid password
Please enter Correct Password
Back to Change Password
<%
}
else
{
sql="update wbmslogin set pwd=? where userid=? ";
pst=con.prepareStatement(sql);
pst.setString(1,new_pwd);
pst.setString(2,uid);
int num=pst.executeUpdate();
if(num>0)
{
%>
Password changed Successfully
Now you have to use new Password
<%
session.putValue("PWD",new_pwd);
}
else
{
%>
Password Not Changed
Back to Change Password
<%
}
}
}catch(Exception e)
{
out.println(e);
}
%>