81,091
社区成员
发帖
与我相关
我的任务
分享
<%@ page contentType="text/html;charset=GB2312" language="java"
import="java.sql.*"%>
<html>
<head>
<title>找回密码</title></head>
<%@ include file="convert.jsp" %>
<%
String strName = request.getParameter("user");
String strPass=new String(request.getParameter("key").getBytes("8859_1"),"gb2312");
String spath = "kuaidi.mdb";//Access
String dbpath = application.getRealPath(spath);
String dbname = "";
String user = "";
String url ="jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ="+dbpath;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn= DriverManager.getConnection(url);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql = "select * from user where u_Name='"+strName+"'and u_Key='"+strPass+"'";
ResultSet rs = stmt.executeQuery(sql);
if(rs.next())
{
out.print("<script type='text/javascript'>prompt('请输入新密码')</script>");
} else {
out.print("<script type='text/javascript'>alert('请输入正确的用户名和密钥');history.back();</script>");
}
%>
</html>