81,092
社区成员
发帖
与我相关
我的任务
分享各位帮我看一个紧急的问题
这是我的java文件中的一个方法
public ResultSet query(String custno)
{
String sql="create temp table cust_jsp_tmp(abc varchar(30))";
try{
executeUpdate(sql);
sql="insert into cust_jsp_tmp select aaa from custom1 where cust_no='"+custno+"' ";
executeUpdate(sql);
sql="insert into cust_jsp_tmp select bbb from custom2 where cust_no='"+custno+"'";
executeUpdate(sql);
sql="select abc from cust_jsp_tmp";
return executeQuery(sql);
}
catch(Exception e){
return null;
}
}
JSP文件如下:
<HTML>
<HEAD><Title>保单详细信息</Title></HEAD>
<body bkcolor=#EEEEEE text=blue bgcolor="#00FFFF">
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="error.jsp" %>
<jsp:useBean id="workM" scope="page" class="custquery.Connect1" />
<%
String custno = request.getParameter("cust");
ResultSet RE=workM.query(custno);
}
%>
<%while(RE.next())
{%>
<%=RE.getString(1)%>
<%}%>
</body>
</HTML>
怎么总是报错:
org.apache.jasper.JasperException: Unable to compile class for JSP
An error occurred at line: 18 in the jsp file: /test.jsp
Generated servlet error:
RE cannot be resolved
An error occurred at line: 20 in the jsp file: /test.jsp
Generated servlet error:
RE cannot be resolved
各位帮我看一下呀!
public ResultSet query(String custno)
{
String sql="create temp table cust_jsp_tmp(abc varchar(30))";
try{
executeUpdate(sql);
sql="insert into cust_jsp_tmp select aaa from custom1 where cust_no='"+custno+"' ";
executeUpdate(sql);
sql="insert into cust_jsp_tmp select bbb from custom2 where cust_no='"+custno+"'";
executeUpdate(sql);
sql="select abc from cust_jsp_tmp";
return executeQuery(sql);
}
catch(Exception e){
return null;
}
}
JSP文件如下:
<HTML>
<HEAD><Title>保单详细信息</Title></HEAD>
<body bkcolor=#EEEEEE text=blue bgcolor="#00FFFF">
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="error.jsp" %>
<jsp:useBean id="workM" scope="page" class="custquery.Connect1" />
<%
String custno = request.getParameter("cust");
ResultSet RE=workM.query(custno);
}
%>
<%while(RE.next())
{%>
<%=RE.getString(1)%>
<%}%>
</body>
</HTML>
怎么总是报错:
org.apache.jasper.JasperException: Unable to compile class for JSP
An error occurred at line: 18 in the jsp file: /test.jsp
Generated servlet error:
RE cannot be resolved
An error occurred at line: 20 in the jsp file: /test.jsp
Generated servlet error:
RE cannot be resolved
各位帮我看一下呀!
...全文
请发表友善的回复…
发表回复
