●●●JavaBean调用问题！！！！！！！！！大虾帮忙！！

iStringTheory 2003-06-20 05:00:02

我的开发环境是JB8+Resin 2.0

我的代码：
<%@ page language="java" import="java.sql.*" %>
<%@ page contentType="text/html; charset=gb2312" %>
<html>
<head>
<title>
TemTes
</title>
</head>
<body bgcolor="#ffffff">
<jsp:useBean id="sqlbean" scope="session" class="DBM.DBOperate"/>
<%
/*
DBOperate dbo=new DBOperate();
dbo.setUserId("system");
dbo.setUserPwd("manager");
*/
String qry="select data from tem where id=1";
try{
ResultSet rs=sqlbean.ExecuteQuery(qry);
System.out.println(rs.getString("data"));
sqlbean.closeStmt();
sqlbean.closeConn();
}catch(Exception ex){
System.out.println(ex.getMessage());
}
%>
<form method="post">
<br><br>
<input type="submit" name="Submit" value="Submit">
<input type="reset" value="Reset">
</form>
</body>
</html>

系统报如下错误：
<%@ page language="java" import="java.sql.*" %>
<%@ page contentType="text/html; charset=gb2312" %>
<html>
<head>
<title>
TemTes
</title>
</head>
<body bgcolor="#ffffff">
<jsp:useBean id="sqlbean" scope="session" class="DBM.DBOperate"/>
<%
/*
DBOperate dbo=new DBOperate();
dbo.setUserId("system");
dbo.setUserPwd("manager");
*/
String qry="select data from tem where id=1";
try{
ResultSet rs=sqlbean.ExecuteQuery(qry);
System.out.println(rs.getString("data"));
sqlbean.closeStmt();
sqlbean.closeConn();
}catch(Exception ex){
System.out.println(ex.getMessage());
}
%>
<form method="post">
<br><br>
<input type="submit" name="Submit" value="Submit">
<input type="reset" value="Reset">
</form>
</body>
</html>
F:\run-on-2000\JBuilder8\jdk1.4\bin\java -classpath "E:\resin\lib\dom.jar;E:\resin\lib\jaxp.jar;E:\resin\lib\jdbc2_0-stdext.jar;E:\resin\lib\jdbc-mysql.jar;E:\resin\lib\jmx.jar;E:\resin\lib\jndi.jar;E:\resin\lib\jsdk23.jar;E:\resin\lib\jta-spec1_0_1.jar;E:\resin\lib\resin.jar;E:\resin\lib\sax.jar;E:\resin\lib\webutil.jar;E:\java-home\info-pub\classes;E:\resin\lib\dom.jar;E:\resin\lib\jaxp.jar;E:\resin\lib\jdbc2_0-stdext.jar;E:\resin\lib\jdbc-mysql.jar;E:\resin\lib\jmx.jar;E:\resin\lib\jndi.jar;E:\resin\lib\jsdk23.jar;E:\resin\lib\jta-spec1_0_1.jar;E:\resin\lib\resin.jar;E:\resin\lib\sax.jar;E:\resin\lib\webutil.jar;F:\run-on-2000\JBuilder8\thirdparty\junit3.8\junit.jar;F:\run-on-2000\JBuilder8\lib\unittest.jar;F:\run-on-2000\JBuilder8\jdk1.4\demo\jfc\Java2D\Java2Demo.jar;F:\run-on-2000\JBuilder8\jdk1.4\demo\plugin\jfc\Java2D\Java2Demo.jar;F:\run-on-2000\JBuilder8\jdk1.4\jre\lib\charsets.jar;F:\run-on-2000\JBuilder8\jdk1.4\jre\lib\ext\dnsns.jar;F:\run-on-2000\JBuilder8\jdk1.4\jre\lib\ext\ldapsec.jar;F:\run-on-2000\JBuilder8\jdk1.4\jre\lib\ext\localedata.jar;F:\run-on-2000\JBuilder8\jdk1.4\jre\lib\ext\sunjce_provider.jar;F:\run-on-2000\JBuilder8\jdk1.4\jre\lib\im\indicim.jar;F:\run-on-2000\JBuilder8\jdk1.4\jre\lib\jaws.jar;F:\run-on-2000\JBuilder8\jdk1.4\jre\lib\jce.jar;F:\run-on-2000\JBuilder8\jdk1.4\jre\lib\jsse.jar;F:\run-on-2000\JBuilder8\jdk1.4\jre\lib\rt.jar;F:\run-on-2000\JBuilder8\jdk1.4\jre\lib\sunrsasign.jar;F:\run-on-2000\JBuilder8\jdk1.4\lib\dt.jar;F:\run-on-2000\JBuilder8\jdk1.4\lib\htmlconverter.jar;F:\run-on-2000\JBuilder8\jdk1.4\lib\tools.jar;E:\Downloads\classes12.zip" com.caucho.jsp.JspCompiler -app-dir "E:/java-home/info-pub/defaultroot" -class-dir "E:/java-home/info-pub/classes/Temporary_Files/.jsp/.default" "E:/java-home/info-pub/defaultroot/TemTes.jsp"
"TemTes.jsp": com.caucho.java.JavaCompileException: /TemTes.jsp:19: cannot resolve symbol
"TemTes.jsp": symbol : variable sqlbean
"TemTes.jsp": location: class _temtes__jsp
"TemTes.jsp": ResultSet rs=sqlbean.ExecuteQuery(qry);
"TemTes.jsp": ^
"TemTes.jsp": /TemTes.jsp:21: cannot resolve symbol
"TemTes.jsp": symbol : variable sqlbean
"TemTes.jsp": location: class _temtes__jsp
"TemTes.jsp": sqlbean.closeStmt();
"TemTes.jsp": ^
"TemTes.jsp": /TemTes.jsp:22: cannot resolve symbol
"TemTes.jsp": symbol : variable sqlbean
"TemTes.jsp": location: class _temtes__jsp
"TemTes.jsp": sqlbean.closeConn();
"TemTes.jsp": ^
"TemTes.jsp": 3 errors
"TemTes.jsp": at com.caucho.java.ExternalCompiler.compileInt(ExternalCompiler.java:221)
"TemTes.jsp": at com.caucho.java.JavaCompiler.compile(JavaCompiler.java:419)
"TemTes.jsp": at com.caucho.jsp.JavaGenerator.compile(JavaGenerator.java:2844)
"TemTes.jsp": at com.caucho.jsp.JspGenerator.compile(JspGenerator.java:406)
"TemTes.jsp": at com.caucho.jsp.JspParser.parse(JspParser.java:395)
"TemTes.jsp": at com.caucho.jsp.JspCompiler.compile(JspCompiler.java:122)
"TemTes.jsp": at com.caucho.jsp.JspCompiler.main(JspCompiler.java:142)

...全文

99 4 打赏收藏转发到动态举报

写回复

用AI写文章

4 条回复

切换为时间正序

请发表友善的回复…

发表回复

ratjohn 2003-06-20

打赏
举报

是不是没有导入包含DBM.DBOperate的包？

iStringTheory 2003-06-20

打赏
举报

gotoidea(索欣)
不是这个问题，程序都无法运行。

gotoidea 2003-06-20

打赏
举报

String qry="select data from tem where id=1";
try{
ResultSet rs=sqlbean.ExecuteQuery(qry);

rs.next(); //加这行，你得保证记录存在呀，如果不保证
//就if判断

System.out.println(rs.getString("data"));
sqlbean.closeStmt();
sqlbean.closeConn();
}catch(Exception ex){
System.out.println(ex.getMessage());
}

iStringTheory 2003-06-20