●●●JavaBean调用问题！！！！！！！！！大虾帮忙！！-CSDN论坛

⋅iStringTheory的留言板 ⋅怎样使用Spring.Net的声明式事务管理基于Linq to sql的事务? ⋅★问一个Hibernate的问题，关于主表中集合数据的过滤。 更多帖子 关注私信空间博客 iStringTheory 本版专家分：1185 版主 结帖率 99.38%: 我的开发环境是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)

0 2003-06-20 17:00:02

回复数 4 只看楼主引用举报楼主

iStringTheory 本版专家分：1185 版主: 没人么？:(

0 2003-06-20 17:15:40

只看TA 引用举报 #1 得分 0

⋅一个月后的婚礼，没有激动。反而是想到以后的随时离婚 ⋅离结婚办事还有2个月，把老婆及父母惹得极其不高兴 ⋅短期钱重要,还是长期发展重要 更多帖子 关注私信空间博客 gotoidea 本版专家分：574: 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());
}

0 2003-06-20 17:55:11

只看TA 引用举报 #2 得分 50

iStringTheory 本版专家分：1185 版主: gotoidea(索欣)
不是这个问题，程序都无法运行。

0 2003-06-20 18:25:17

只看TA 引用举报 #3 得分 0

ratjohn 本版专家分：859: 是不是没有导入包含DBM.DBOperate的包？

0 2003-06-20 19:04:03

只看TA 引用举报 #4 得分 10

●●●JavaBean调用问题！！！！！！！！！大虾帮忙！！ [问题点数：60分，结帖人abigfrog]