changepsdaction.jsp

学生学籍管理系统sql 学生学籍管理系统sql

<%@ page language="java" contentType="text/html; charset=gb2312" pageEncoding="GBK"%>
<%@page  import="com.record.connectionDataBase.ConnectionDataBase,java.sql.Connection,java.sql.ResultSet,java.sql.PreparedStatement"%>

<%
	String oldPassword,password,user;
	user=request.getParameter("user");
	oldPassword=request.getParameter("old_password");
	password=request.getParameter("password");
	if(null==oldPassword || null==password)
	{
		response.sendRedirect("changePsd.jsp");
		return;
	}
	Connection conn;
	ResultSet rs;
	PreparedStatement pstmt;
	ConnectionDataBase connectionDataBase=new ConnectionDataBase();
	conn=connectionDataBase.getConn();
	String sql="select * from admin where name='"+user+"'";
	rs=conn.createStatement().executeQuery(sql);
	rs.next();
	if(!rs.getString("password").trim().equals(oldPassword)){
		out.print("输入的旧密码错误，<br><a href=changePsd.jsp?user="+user+">点击返回</a>");
	}
	else
	{
		String sqll="update admin set password='"+password+"' where name='"+user+"'";
		pstmt=conn.prepareStatement(sqll);
		pstmt.executeUpdate();
		out.print("修改成功，<br><a href=changePsd.jsp?user="+user+">点击返回</a>");
		
	}
%>