check2.jsp

来自「JAVA制作的留言板程序」· JSP 代码 · 共 25 行

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ include file="conn.jsp" %>
<%
String name,pwd,pwd2,pwd3;
int rst=0;
name=request.getParameter("adminname");
pwd=request.getParameter("adminpwd");
pwd3=request.getParameter("adminpwd2");
pwd2=(new String(pwd3.getBytes("iso-8859-1"),"gb2312"));
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select * from admin where admin='"+name+"' and adminpwd='"+pwd+"'");

if(rs.next()){
Statement stmtcgpwd=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql4="update admin set adminpwd='"+pwd2+"'";
	stmtcgpwd.executeUpdate(sql4);
	
    stmtcgpwd.close();
	rs.close();
	stmt.close();
out.print("<script language='javascript'>alert('修改成功');window.location.href='index.jsp';</script>");
}else{
      out.print("<center>密码或用户名错误<br><a href=javascript:history.go(-1)>返回</a></center>");
	  }					
%>