dnf成就完成券哪里买:JSP连接access代码问题```怎么连不上??

来源：百度文库编辑：杭州交通信息网时间：2024/04/28 12:10:45

我做的一个会员登入的JSP

以下是我写的代码可就是连接不上ACCESS 请问高手是哪有错啊??
数据库文件名:checkuser.mdb 内有表huiy 字段为 username password
login.htm
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>会员登入</title>
</head>

<body>
<form name="frm" method="post" action="check.jsp">
<table width="100%" border="0">
<tr>
<td><div align="right">用户名:</div></td>
<td><input name="username" type="text" /></td>
</tr>
<tr>
<td><div align="right">密码:</div></td>
<td><label>
<input name="password" type="password" />
<input type="submit" name="submit" value="提交" />
<input name="reset" type="reset" " value="重置" />
</label></td>
</tr>
</table>
</form>
</body>
</html>

check.jsp 代码

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%
String url="jdbc:odbc:checkuser";
String driver="sun.jdbc.odbc.JdbcOdbcDriver";
Class.forName(driver);
Connection conn=DriverManager.getConnection(url,"","1");
Statement sqlStatement=conn.createStatement();
String sql="select * from huiy";

ResultSet rs=sqlStatement.executeQuery(sql);
String username=request.get.Parameter("username");

String username=request.get.Parameter("password");
String role="非会员";
while(rs.next())
{
if(username.equals(rs.getString("username"))&&password.equals(rs.getString("password")))
{
role=rs.getString("role");
}
}
%>

你是<%=role%>!

以上是我写的代码可就是连接不上ACCESS 请问高手是哪有错啊??
我有连接数据源哦报的错是这样的
望高手们快帮帮我啊
type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException: Unable to compile class for JSP

An error occurred at line: 4 in the jsp file: /check.jsp
Generated servlet error:
request.get cannot be resolved or is not a field

An error occurred at line: 4 in the jsp file: /check.jsp
Generated servlet error:
Duplicate local variable username

An error occurred at line: 4 in the jsp file: /check.jsp
Generated servlet error:
request.get cannot be resolved or is not a field

是呀，还有上面是你的笔误还是错了，你再仔细看看你写的程序。

有没有在“数据源”里添加ACCESS数据库连接驱动？具体办法是“控制面板”->“管理工具”->“数据源”->“添加”，找到MS Access Database添加进去

JSP连接access代码问题```怎么连不上?? jsp连接access问题 jsp关于access数据库配置连接问题 jsp连接access的路径问题 JSP连接ACCESS jsp连接Access 有关Jsp连接Access以及JDBC,SQL的问题 jsp access数据库的连接问题高手帮忙 ACCESS三个表连接代码怎么不行? jsp连接oracle代码？