我编的JSP程序为何报错,哪位高手能帮我看看,源代码如下:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<HTML>
<HEAD>
<%@ page
pageEncoding="GB2312"
import="java.sql.*"
%>
<META http-equiv="Content-Type" content="text/html; charset=GB2312">
<META name="GENERATOR" content="IBM WebSphere Studio">
<META http-equiv="Content-Style-Type" content="text/css">
<LINK href="../theme/Master.css" rel="stylesheet"
type="text/css">
</HEAD>
<BODY>
<jsp:useBean id="connectdatabase" scope="page"class="dbms.Database"/>
<%
ResultSet rs=connectdatabase.excute("select EmployerID from pertable;");
%>
<FORM action=perrecordfindFinally.jsp method="get">
<TABLE border="0">
<TBODY>
<TR>
<TD>
<CENTER>
<TABLE border="2">
<CAPTION align="top">
<H2>查询人员档案</H2>
</CAPTION>
<TBODY>
<TR>
<TD align="center" valign="middle">员工编号:</TD>
<TD valign="middle">
<SELECT name="EmployerID">
<OPTION value="0" selected>所有</OPTION>
<%while(rs.next()){%>
<OPTION value=<%=rs.getString("EmployerID")%>><%=rs.getString("EmployerID")%></OPTION>
<%}%>
</SELECT>
</TR>
</TBODY>
</TABLE>
</FORM>
</BODY>
</HTML>
报错信息:Error 500: No data found
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<HTML>
<HEAD>
<%@ page
pageEncoding="GB2312"
import="java.sql.*"
%>
<META http-equiv="Content-Type" content="text/html; charset=GB2312">
<META name="GENERATOR" content="IBM WebSphere Studio">
<META http-equiv="Content-Style-Type" content="text/css">
<LINK href="../theme/Master.css" rel="stylesheet"
type="text/css">
</HEAD>
<BODY>
<jsp:useBean id="connectdatabase" scope="page"class="dbms.Database"/>
<%
ResultSet rs=connectdatabase.excute("select EmployerID from pertable;");
%>
<FORM action=perrecordfindFinally.jsp method="get">
<TABLE border="0">
<TBODY>
<TR>
<TD>
<CENTER>
<TABLE border="2">
<CAPTION align="top">
<H2>查询人员档案</H2>
</CAPTION>
<TBODY>
<TR>
<TD align="center" valign="middle">员工编号:</TD>
<TD valign="middle">
<SELECT name="EmployerID">
<OPTION value="0" selected>所有</OPTION>
<%while(rs.next()){%>
<OPTION value=<%=rs.getString("EmployerID")%>><%=rs.getString("EmployerID")%></OPTION>
<%}%>
</SELECT>
</TR>
</TBODY>
</TABLE>
</FORM>
</BODY>
</HTML>
报错信息:Error 500: No data found
String tmp;
while(rs.next()){
tmp = rs.getString("EmployerID");
%>
<OPTION value='<%=tmp%>'><%=tmp%></OPTION>......
import java.sql.*;
public class Database {
Connection conn = null;
ResultSet rs = null;
public boolean logincheck(String name, String pwd) {
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection("Jdbc:Odbc:hys");
Statement stat = conn.createStatement();
rs =stat.executeQuery("select * from admin where name='"+ name+ "'and pwd='"+ pwd+ "';");
if (rs.next()) {
return true;
} else {
return false;
}
} catch (Exception e) {
return false;
}
}
public ResultSet excute(String sql){
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection("Jdbc:Odbc:hys");
Statement stat = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs =stat.executeQuery(sql);
return rs;
} catch (Exception e){return rs;}
}
public void close(){
try {
rs.close();
conn.close();
} catch (Exception e){}
}
}
好像不是javabean的原因
ResultSet rs=connectdatabase.execute("select EmployerID from pertable;");
改为
ResultSet rs=connectdatabase.executeQuery("select EmployerID from pertable;");