//DBconn.java
import java.sql.*;
public class DBconn {
String DBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String ConnStr = "jdbc:odbc:Customers";
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);
//与DBMS建立链接
Statement stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
}
catch(SQLException ex) {
System.err.println("aq.executeQuery:"+ex.getMessage());
}
return rs;
}
}
import java.sql.*;
public class DBconn {
String DBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String ConnStr = "jdbc:odbc:Customers";
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);
//与DBMS建立链接
Statement stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
}
catch(SQLException ex) {
System.err.println("aq.executeQuery:"+ex.getMessage());
}
return rs;
}
}
<%@page contentType="text/html; charset=GBK"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>客户信息调查</title>
</head>
<body >
<p ><b >客户信息调查</b ></p >
<%@ page language="java" import="java.sql.*"%>
<jsp:useBean id="dbconn" scope="page" class="DBconn">
</jsp:useBean>
<%ResultSet RS = dbconn.executeQuery("SELECT * FROM Customers");
while (RS.next()) {
out.println(RS.getString("name"));
out.println(RS.getString("address"));
out.println(RS.getString("info"));
}
out.println("hahahah");
RS.close();%></body >
</html >
请确认所有需要的类都放到web/web-inf/classes文件中,
而且把所需要数据库驱动文件放到web/web-inf/lib/文件中
好的检查你的小错误,
大的错误是没有的,我已经帮你检查过了,我就看到你的Customers.asp是不是应该把后缀名改为Customers.jsp还是你的笔呀!!!!!!!`
Customers.jsp文件引用bean 时也加个包名,把bean文件放入db目录下..