用JavaBean連接access,javaBean成功編譯,但加入jsp中時取出錯,請各位幫幫忙.
javaBean如下
import java.sql.*;
public class DBconn {
String DBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String ConnStr = "jdbc:odbc:message"; //odbc中建有system dsn "message"
Connection conn = null;
ResultSet rs = null;
public DBconn(){
try {
Class.forName(DBDriver);
}
catch(java.lang.ClassNotFoundException e) {
System.err.println("DBconn ():" + e.getMessage());
}
}
public ResultSet executeQuery(String sql) {
rs = null;
try {
conn = DriverManager.getConnection(ConnStr);
Statement stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
}
catch(SQLException ex) {
System.err.println("aq.executeQuery:"+ex.getMessage());
}
return rs;
}
}
jsp如下
<%@ page contentType="text/html;charset=big5" language="java" import="java.sql.*" %>
<html>
<head>
<title>test</title>
<meta http-equiv="Content-Type" content="text/html; charset=big5">
</head>
<body>
<jsp:useBean id="DBconn1" scope="page" class="DBconn" />
<%
ResultSet RS = DBconn1.executeQuery("SELECT * FROM message");
while (RS.next()){
out.print("< LI>" + RS.getString("send_id")+"</LI>");
out.print("<LI>"+ RS.getString("send_time")+"</LI >");
out.print("<LI>"+RS.getString("contents")+"< /LI >");
}
RS.close();
%>
</body>
</html>
提示有三個錯誤.
C:\JBuilder8\thirdparty\jakarta-tomcat-4.1.12-LE-jdk14\work\Standalone\localhost\_\message_jsp.java:88: cannot resolve symbol
symbol : class DBconn
location: class org.apache.jsp.message_jsp
DBconn DBconn1 = null;
^
An error occurred at line: 36 in the jsp file: /message.jsp
Generated servlet error:
C:\JBuilder8\thirdparty\jakarta-tomcat-4.1.12-LE-jdk14\work\Standalone\localhost\_\message_jsp.java:90: cannot resolve symbol
symbol : class DBconn
location: class org.apache.jsp.message_jsp
DBconn1 = (DBconn) pageContext.getAttribute("DBconn1", PageContext.PAGE_SCOPE);
^
An error occurred at line: 36 in the jsp file: /message.jsp
Generated servlet error:
C:\JBuilder8\thirdparty\jakarta-tomcat-4.1.12-LE-jdk14\work\Standalone\localhost\_\message_jsp.java:93: cannot resolve symbol
symbol : class DBconn
location: class org.apache.jsp.message_jsp
DBconn1 = (DBconn) java.beans.Beans.instantiate(this.getClass().getClassLoader(), "DBconn");
^
3 errors
請大家幫忙
如分不夠再加
问题点数：100、回复次数：6Top
1 楼jndszl（jj）回复于 2003-10-04 00:06:45 得分 0
<jsp:useBean id="DBconn1" scope="page" class="DBconn" />
中的id=中的DBconn1之前要加入包名的Top
2 楼youandi79（嘻嘻哈哈）回复于 2003-10-04 00:07:01 得分 0
没找到bean类Top
3 楼xupiao（叫個什麼名字好呢,得好好讓我想想...）回复于 2003-10-04 09:53:32 得分 0
DBconn.class 和jsp文件在同一目錄下Top
4 楼qqyb2000（答案）回复于 2003-10-04 10:01:55 得分 0
你用的服务器是什么呀，如果是TOMCAT的话，必须先设定路径，还有XML文件！Top
5 楼matq2008（叶子.net）回复于 2003-10-04 10:03:24 得分 100
给javaBean起个包名,在首行加一句:如
package Bean;
将编译后的class放入如下:E:\tomcat4.1.27\webapps\ROOT\WEB-INF\classes\Bean\
没有的目录自己建,就可以了
引用时加上包名:<jsp:useBean id="DBconn1" scope="page" class="Bean.DBconn" />
Top
6 楼xupiao（叫個什麼名字好呢,得好好讓我想想...）回复于 2003-10-04 12:14:36 得分 0
matq2008是對的Top
