login_u.jsp

来自「解压在c盘」· JSP 代码 · 共 30 行

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="chStr"%>
<%
String spath="wangye/ec.mdb";   
String dbpath = application.getRealPath(spath);
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); 
String url="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ="+dbpath;
Connection conn= DriverManager.getConnection(url,"",""); 
Statement stmt=conn.createStatement(); 

chStr chStr=new chStr();
String username=chStr.chStr(request.getParameter("username"));


     ResultSet rs=stmt.executeQuery("select * from person where username='"+username+"'");
	if(rs.next()){
		String PWD=request.getParameter("PWD");
		if(PWD.equals(rs.getString("password"))){		 
			session.setAttribute("username",username);
			response.sendRedirect("../index.jsp");
		}else{
			out.println("<script language='javascript'>alert('您输入的用户名或密码错误，请与管理员联系!');window.location.href='../index.jsp';</script>");
		}
	}

rs.close();
stmt.close(); 
conn.close(); 
%>