<% String legal = (String)session.getAttribute("UserName"); if(legal==null) { %> Session expired, Sign-In again <% } else { %> <%@ include file="include/connection.jsp" %> <%! ResultSet rs,rs1,rs2; Statement stmt1; int flag=0; int i=0; int y=0; %> <% String ss=null; String msg=null; if(request.getParameter("status")!=null && request.getParameter("status").equals("change") ) { try { String query1 = "select password from anandu_mails.user_info where username='" + (String)session.getAttribute("UserName") + "'"; rs2 = stmt.executeQuery(query1); rs2.next(); if(request.getParameter("OldPassword").equals(rs2.getString("password"))) { String qry = "Update anandu_mails.user_info set password='" + request.getParameter("CPassword") + "' where username='" + (String)session.getAttribute("UserName")+ "'"; stmt.executeQuery(qry); ss=null; msg="Password Successfully Changed"; } else { ss="Old Password incorrect !"; } } catch(Exception e) { System.out.println("Exception caught lower is:"+e.getMessage()); } } %> onload="init()" <%}%> >

Change Password

<%if(msg==null ){%> <%}%>    <%if(ss!=null){%>     <%=ss%><%}%> <%if(msg!=null){%>     <%=msg%><%}%>    Old Password      New Password      Confirm Password

<%}%>