求教JSP高手,The method delete(String) is undefined for the type conn
源码是这样的。
在usermanger.jsp用代码导入到delete.jsp中
<a href="delete.jsp?id=1">删除</a>
delete.jsp源码如下
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>My JSP 'wrong.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<body>
<jsp:useBean id="connDBBean2" scope="page" class="Conn.conn"/>
<%
String n = request.getParameter("id");
if(n.equals("1")){
String sql="delete from denglu where pkid=1";
connDBBean2.delete(sql);
response.sendRedirect("usermanger.jsp");
}
else if(n.equals("2")){
}
else{
}
%>
</body>
</html>
Conn.jsp源码如下
package Conn;
import java.sql.*;
public class conn{
String sDBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr="jdbc:odbc:test";
Connection connect=null;
ResultSet rs=null;
public conn(){
try{
Class.forName(sDBDriver);
}catch(java.lang.ClassNotFoundException e)
{
System.err.println(e.getMessage());}
}
public ResultSet executeQuery(String sql){
//执行查询数据库操作的方法
try{
connect=DriverManager.getConnection(sConnStr);
//连接Access数据库
Statement stmt=connect.createStatement();
//创建向数据库提交查询语句的Statement对象
rs=stmt.executeQuery(sql);
//将查询结果保存再结果集rs中
}catch(SQLException ex){System.err.println(ex.getMessage());}return rs;
}
public String delete(String sql) {
PreparedStatement pre=null;
int num=0;
try {
connect=DriverManager.getConnection(sConnStr);
pre=connect.prepareStatement(sql);
num=pre.executeUpdate();
if(num>0){
return "1";
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return "0";
}
}
tomcat显示的错误为:
org.apache.jasper.JasperException: Unable to compile class for JSP:
An error occurred at line: 31 in the jsp file: /delete.jsp
The method delete(String) is undefined for the type conn
28: String n = request.getParameter("id");
29: if(n.equals("1")){
30: String sql="delete from denglu where pkid=1";
31: connDBBean2.delete(sql);
32: response.sendRedirect("usermanger.jsp");
33:
34: }
conn.java中明明有delete方法啊,为什么行,求教。