login_u2.jsp

解压在c盘

<%@ 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 maijianame=chStr.chStr(request.getParameter("username"));


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


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