komalee
发贴: 3
积分: 0
|
于 2006-05-29 10:41
我用Tomcat 5.028服务器,ACCESS 2003数据库,做JSP登陆验证出现以下错误,不知道怎么搞的请高手多点指点!! <%@ page contentType="text/html; charset=gb2312" %> <%@ page language="java" import="java.sql.*"%> <% String name=request.getParameter("Username"); String pass=request.getParameter("passWd");
boolean bl; try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ; String url="jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ=F:\\koma\\Tomcat 5.0\\webapps\\netdiskWA\\users.mdb"; Connection conn = DriverManager.getConnection(url,"",""); Statement stmt=conn.createStatement(); PreparedStatement stmt=conn.prepareStatement( "select * from users where username=name and password=pass");
ResultSet result=stmt.executeQuery(); result.setString(username); result.setString(password);
if(result.next()) bl=true; else bl=false;
} catch(Exception e) { out.println(e); } if(bl) response.sendRedirect("FileManage.jsp"); else response.sendRedirect("error.jsp");
why edited on 2006-05-29 22:24
风---- 催生涅磐之火 经典的色彩从脉络中慢慢渗出 斑斓的翅膀带走蝶的绮舞 驱走曾经的季节 我看见一只凤泣在树颠
|