UC知道JSP:ResultSet调用NEXT()出现错误,请高手们帮帮忙
来源：百度知道 编辑：UC知道 时间：2024/05/28 20:25:47
indexj.jsp
<html>
<head>
</head>
<body >
<%@ page language="java" import="java.sql.*,test.sql;"%>
<%@ page contentType="text/html;charset=big5"%>
<jsp:useBean id="sqlbean" class="test.sql" scope="session"/>
<%! String name,email,url,body,sql;%>
<%
name=request.getParameter("name");
email=request.getParameter("email");
url=request.getParameter("url");
body=request.getParameter("body");
if(name!=""&&email!=""&&body!="")
{
sql="insert into guestbook(name,email,url,body) values('"+name+"','"+email+"','"+url+"','"+body+"')";
<html>
<head>
</head>
<body >
<%@ page language="java" import="java.sql.*,test.sql;"%>
<%@ page contentType="text/html;charset=big5"%>
<jsp:useBean id="sqlbean" class="test.sql" scope="session"/>
<%! String name,email,url,body,sql;%>
<%
name=request.getParameter("name");
email=request.getParameter("email");
url=request.getParameter("url");
body=request.getParameter("body");
if(name!=""&&email!=""&&body!="")
{
sql="insert into guestbook(name,email,url,body) values('"+name+"','"+email+"','"+url+"','"+body+"')";
<jsp:useBean id="sqlbean" class="test.sql" scope="session"/>
中出错
javabean应该是java类，而你的class="test.sql"写成了sql，当然会出错了
test.sql不会执行javabean的功能
你察看一下是不是这个原因。
注意这段代码：
<%
ResultSet RS=sqlbean.executeQuery("select * from guestbook");
while(RS.next())
{
name=RS.getString("name");
email=RS.getString("email");
url=RS.getString("url");
body=RS.getString("body");
%>
<%
}
RS.close();
%>
改为：
<%
try{
ResultSet RS=sqlbean.executeQuery("select * from guestbook");
while(RS.next())
{
name=RS.getString("name");
email=RS.getString("email");
url=RS.getString("url");
body=RS.getString("body");
%>
<%
}
RS.close();
}
catch(Exception