admin_password_editdo.jsp

用JSP实现的 满好的 大家支持哦 大家多多支持

<%@ page language="java"%>
<%@ page import="java.sql.*"%>
<%@ page contentType="text/html;charset=GB2312"%>

<%
    String admin_device_Loginmessage=(String)session.getValue("admin_device_loginSign");
    String adminID=(String)session.getValue("adminID");    
    if(admin_device_Loginmessage!="OK")
    {
	response.sendRedirect("../book.jsp");
    }
%>

<jsp:useBean class="manage_sys.manage_sys" id="admin_password_editdo" scope="page"></jsp:useBean>
<%
    //String adminID=(String)session.getValue("adminID");
    String oldpassword=new String(request.getParameter("oldpassword").getBytes("8859_1"));
    String newpassword=new String(request.getParameter("newpassword").getBytes("8859_1"));
    String newpassword2=new String(request.getParameter("newpassword2").getBytes("8859_1"));
	String sql="select * from admin_sys where adminID='"+adminID+"' and password='"+oldpassword+"' ";
	ResultSet rs=admin_password_editdo.executeQuery(sql);
    if(rs.next())
        { 
			String sql_up="update admin_sys set password='"+newpassword2+"' where adminID='"+adminID+"' and device='user'";
			admin_password_editdo.executeUpdate(sql_up);
			rs.close();
			%><SCRIPT LANGUAGE="JavaScript">
				<!--
				alert("修改密码成功！");
				window.location.href("admin_device_index.jsp");
				//-->
				</SCRIPT><%
			
		  }
	else
	{
	   %><SCRIPT LANGUAGE="JavaScript">
				<!--
				alert("输入旧密码不正确，请重新输入！");
				window.location.href("admin_password_edit.jsp");
				//-->
				</SCRIPT><%
	}
%>