javabean封装sqlserver2000的问题

fanggangyi 2003-08-29 08:26:28
我的jsp代码为
<%@ page language="java" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.lang.*" %>
<%@ page import="java.io.*" %>
<%@ page import="java.util.*"%>
<%@ page contentType="text/html;charset=gb2312" %>

<%

%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head>

<body>
<jsp:useBean id="work" scope="request" class="connection.dbconn"/>

<%
work.init();
String str1="select * from member";
ResultSet record=work.executequery(str1);

%>

<table width="400" border="0">
<tr>
<td>username</td>
</tr>
<%
while(record.next())
{
out.print("<tr><td>"+record.getString("username")+"</td></tr>");
}
%>

</table>
</body>
</html>
在ie打开时出现如下错误
Generated servlet error:
[javac] Compiling 1 source file

C:\Tomcat 5.0\work\Catalina\localhost\_\org\apache\jsp\dbfirst_jsp.java:68: package connection does not exist
connection.dbconn work = null;
^



An error occurred at line: 25 in the jsp file: /dbfirst.jsp

Generated servlet error:
C:\Tomcat 5.0\work\Catalina\localhost\_\org\apache\jsp\dbfirst_jsp.java:70: package connection does not exist
work = (connection.dbconn) pageContext.getAttribute("work", PageContext.REQUEST_SCOPE);
^



An error occurred at line: 25 in the jsp file: /dbfirst.jsp

Generated servlet error:
C:\Tomcat 5.0\work\Catalina\localhost\_\org\apache\jsp\dbfirst_jsp.java:73: package connection does not exist
work = (connection.dbconn) java.beans.Beans.instantiate(this.getClass().getClassLoader(), "connection.dbconn");
^



An error occurred at line: 27 in the jsp file: /dbfirst.jsp

Generated servlet error:
C:\Tomcat 5.0\work\Catalina\localhost\_\org\apache\jsp\dbfirst_jsp.java:86: cannot resolve symbol
symbol : variable rst
location: class org.apache.jsp.dbfirst_jsp
rst=work.executequery(str1);
^



An error occurred at line: 38 in the jsp file: /dbfirst.jsp

Generated servlet error:
C:\Tomcat 5.0\work\Catalina\localhost\_\org\apache\jsp\dbfirst_jsp.java:96: cannot resolve symbol
symbol : variable record
location: class org.apache.jsp.dbfirst_jsp
while(record.next())
^



An error occurred at line: 38 in the jsp file: /dbfirst.jsp

Generated servlet error:
C:\Tomcat 5.0\work\Catalina\localhost\_\org\apache\jsp\dbfirst_jsp.java:98: cannot resolve symbol
symbol : variable record
location: class org.apache.jsp.dbfirst_jsp
out.print(""+record.getString("username")+"");
^
6 errors


org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:128)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:307)
org.apache.jasper.compiler.Compiler.generateClass(Compiler.java:420)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:460)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:444)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:603)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:300)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:294)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)


note The full stack trace of the root cause is available in the Tomcat logs.

dbconn源代码为
package connection;
import java.sql.*;
public class dbconn
{
String user="sa";
String password="123";
String url="jdbc:microsoft:sqlserver://l00.100.98.10:1433;DatabaseName=lotusdb";

String driver="com.microsoft.jdbc.sqlserver.SQLServerDriver";

Connection con=null;
public ResultSet rst=null;
Statement smt=null;
public void init()
{
System.out.print("\n\n ----------欢迎使用 sql server2000 数据库----------\n\n");
rst=null;
try
{
Class.forName(driver);
System.out.print("\n\n 1.恭喜你,初始化数据库驱动程序成功!!!\n");
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println("\n\n 1.初始化数据库驱动程序出错,请检查sql server2000的驱动程序是否配置正确。建议把驱动放在tomcat的WEB-INF/classes下。即:函数==>>init()出错。\n\n"+e.getMessage());
}
}
public ResultSet executequery(String sql)
{
try
{
con=DriverManager.getConnection(url,user,password);
Statement smt=con.createStatement();
rst=smt.executeQuery(sql);
System.out.print("\n\n 2.恭喜你,查询数据库成功!!!即:==>>executequery()操作成功。\n\n");
}
catch(SQLException ex)
{
System.err.println("\n\n 2.操作查询数据库失败,请检查数据库地址、用户名、密码以及你的SQL语句是否正确。即:==>>executeQuery()出错。\n\n"+ex.getMessage());
}
return rst ;
}

}


...全文
35 5 打赏 收藏 转发到动态 举报
写回复
用AI写文章
5 条回复
切换为时间正序
请发表友善的回复…
发表回复
wenic705 2003-08-29
  • 打赏
  • 举报
回复
对了,请指教一下init()那么用可以吗?。
请高手指点init()这个线程的用法
wenic705 2003-08-29
  • 打赏
  • 举报
回复
事先申明:
<%@ page import="java.我是菜鸟.*" contentType="text/html;charset=GBK"%>
work.init()是什么东东???
能这么调用吗?
在BEAN里面Class.forName(driver).newInstance();
rst没定义,你的BEAN能编译好吗?
sql就那么用能行吗??

work.executequery(str1)应该是work.executeQuery(str1)
还有你的bean的位置放对了吗?
搞不清楚了
joincsdn 2003-08-29
  • 打赏
  • 举报
回复
我想错误可能不在你的bean,而是程序找不到你的connection包

你可以检查一下connection包所放的位置是否正确
noratong 2003-08-29
  • 打赏
  • 举报
回复
我用了你这种方法连了的,报错!我想肯定是你这个地方有问题!
noratong 2003-08-29
  • 打赏
  • 举报
回复
你这中连接方式在一般的JAVA程序中行的通吗????
我用的连接方式和你的只有一个地方不同,就是:
con=DriverManager.getConnection(url,user,password);
我用的是:
con=DriverManager.getConnection(url + user + password);

81,090

社区成员

发帖
与我相关
我的任务
社区描述
Java Web 开发
社区管理员
  • Web 开发社区
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧