javabean封装sqlserver2000的问题
我的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 ;
}
}