editpwd.jsp

来自「JSP+ORACLE网站开发实例（下）.rar」· JSP 代码 · 共 70 行

<%@ include file="admintop.jsp"%>
<%@ include file="isadmin.jsp"%>
<%String  sql;
      String id=request.getParameter("id");   
      String ordpwd=request.getParameter("ordpwd");   
	  String action1=request.getParameter("action");  
	  String newpwd=request.getParameter("newpwd");
	  String newpwd1=request.getParameter("newpwd1");
	  String names=request.getParameter("names");
	  String   sql2;
	  if(action1==null){
		  sql="select * from scott.admingly where user_name='"+session.getValue("username")+"'";
      ResultSet rst=stmt.executeQuery(sql); 
    if(!rst.next()){
out.print("<script>alert('对不起,你所要操作的对象不存在\n请返回重试');history.back();</script>");
	}else{
%>

 <form name="form1" method="post" action="editpwd.jsp?action=edit&id=<%=rst.getString("id")%>">
  <table width="350" border="1" align="center" bordercolor="#000000">
    <tr bgcolor="#B1E1F3"> 
      <td height="25" colspan="2" align="center"><strong>更改密码</strong></td>
    </tr>
    <tr> 
      <td width="101">原密码:</td>
      <td width="239"> <input type="password" name="ordpwd"> </td>
    </tr>
    <tr> 
      <td>新密码:</td>
      <td><input type="password" name="newpwd"></td>
    </tr>
    <tr> 
      <td>确认密码:</td>
      <td><input type="password" name="newpwd1"></td>
    </tr>
    <tr> 
      <td>真实姓名:</td>
      <td><input type="text" name="names" value="<%=rst.getString("names")%>"></td>
    </tr>
    <tr align="center"> 
      <td colspan="2"> 
        <input type="submit" name="Submit" value="确 定">
        　
<input type="reset" name="Submit2" value="取 消">
      </td>
    </tr>
  </table>
</form>
<%}
 }else{
	  if(action1.equals("edit")){		  
    stmt.executeUpdate("update scott.admingly set password='"+newpwd+"', names='"+names+"' where user_name='"+session.getValue("username")+"'");	

 %>
			<table width="350" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#000000">
  <tr>
    <td height="30" align="center" bgcolor="#B4E7F1"><strong>修改成功</strong></td>
  </tr>
  <tr>
    <td>你可以返回到上一页面查看</td>
  </tr>
  <tr>
    <td align="center"> <a href="adminbody.jsp">【返回】</a></td>
  </tr>
</table>
<%  }
} %>
</body>
</html>