怎么都运行不了,有错误<%@ page contentType="text/html;charset=gb2312" language="java" %>
<%@page import="java.sql.*" %>
<%@ page import="java.util.* "%>
<html>
<head>
<meta http-equiv="Content-Type"content="text/html;chareset=gb2312">
<jsp:useBean scope="page" id="ExecuteDB" class="com.ExecuteDB"/>
</head>
<%!
String userid=null;
String password=null;
String role=null;
String sql=null;
ResultSet rs=null;
%><%
String userid=request.getParameter("userid");
String password=request.getParameter("password");
String role=request.getParameter("role");
int i=0;
String sql;
if(role.equals("0"))
{
sql = "SELECT * FROM studentmessage WHERE ID=? AND PassWord=?" ;
i=1;
}
if(role.equals("1"))
{
sql = "SELECT * FROM teachermesage WHERE ID=? AND PassWordd=?" ;
i=2;
}
ResultSet rs=ExecuteDB.exeQuery(sql);
if(rs.next())
{
session.setAttribute("userid", userid);
session.setAttribute("password", password);
session.setAttribute("role",role);
if(i==1)
{ response.sendRedirect("./sutdent/index.jsp");}
if(i==2)
{ response.sendRedirect("./teacher/index.jsp");}
}
else
{
out.println("登陆错误");
}
%>
</html>
系统提示错误org.apache.jasper.JasperException: Unable to compile class for JSP: An error occurred at line: 33 in the jsp file: /check.jsp
The type ResultSet cannot be resolved. It is indirectly referenced from required .class files
30: sql = "SELECT * FROM teachermesage WHERE ID=? AND PassWordd=?" ;
31: i=2;
32: }
33: ResultSet rs=ExecuteDB.exeQuery(sql);
34: if(rs.next())
35: {
36: session.setAttribute("userid", userid);
An error occurred at line: 33 in the jsp file: /check.jsp
Type mismatch: cannot convert from ResultSet to ResultSet
30: sql = "SELECT * FROM teachermesage WHERE ID=? AND PassWordd=?" ;
31: i=2;
32: }
33: ResultSet rs=ExecuteDB.exeQuery(sql);
34: if(rs.next())
35: {
36: session.setAttribute("userid", userid);
数据库连上了,怎么都想不通哪里错了
<%@page import="java.sql.*" %>
<%@ page import="java.util.* "%>
<html>
<head>
<meta http-equiv="Content-Type"content="text/html;chareset=gb2312">
<jsp:useBean scope="page" id="ExecuteDB" class="com.ExecuteDB"/>
</head>
<%!
String userid=null;
String password=null;
String role=null;
String sql=null;
ResultSet rs=null;
%><%
String userid=request.getParameter("userid");
String password=request.getParameter("password");
String role=request.getParameter("role");
int i=0;
String sql;
if(role.equals("0"))
{
sql = "SELECT * FROM studentmessage WHERE ID=? AND PassWord=?" ;
i=1;
}
if(role.equals("1"))
{
sql = "SELECT * FROM teachermesage WHERE ID=? AND PassWordd=?" ;
i=2;
}
ResultSet rs=ExecuteDB.exeQuery(sql);
if(rs.next())
{
session.setAttribute("userid", userid);
session.setAttribute("password", password);
session.setAttribute("role",role);
if(i==1)
{ response.sendRedirect("./sutdent/index.jsp");}
if(i==2)
{ response.sendRedirect("./teacher/index.jsp");}
}
else
{
out.println("登陆错误");
}
%>
</html>
系统提示错误org.apache.jasper.JasperException: Unable to compile class for JSP: An error occurred at line: 33 in the jsp file: /check.jsp
The type ResultSet cannot be resolved. It is indirectly referenced from required .class files
30: sql = "SELECT * FROM teachermesage WHERE ID=? AND PassWordd=?" ;
31: i=2;
32: }
33: ResultSet rs=ExecuteDB.exeQuery(sql);
34: if(rs.next())
35: {
36: session.setAttribute("userid", userid);
An error occurred at line: 33 in the jsp file: /check.jsp
Type mismatch: cannot convert from ResultSet to ResultSet
30: sql = "SELECT * FROM teachermesage WHERE ID=? AND PassWordd=?" ;
31: i=2;
32: }
33: ResultSet rs=ExecuteDB.exeQuery(sql);
34: if(rs.next())
35: {
36: session.setAttribute("userid", userid);
数据库连上了,怎么都想不通哪里错了
?要用prepareStatement对象的setString(int n,String str)取代