高手快来救救菜鸟吧!!!!!!!!!
我的服务器的配置如下:
win2000+jdk1.3+resin2.0.4
我在首页上作了一个连接用作测试:
<a href="list.jsp">测试</a>
当我点击连接后,转到页面list.jsp但是跳出一个信息说:
打开所需资源失败
以下为list.jsp的代码:<%@ page language="java" import="java.sql.*"%>
<%@ page contentType="text/html;charset=gb2312"%>
<jsp:useBean id="buy" scope="session" class="Club.Club_dbconnect"/>
<html>
<head>
<title>测试</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="style" type="text/css">
</head>
<jsp:include page="top.jsp" flush="true" ></jsp:include>
<body bgcolor="#FFFFFF" text="#FFFFCC" background="images/back.gif" vlink="#FFFFCC" link="#FFFFCC" alink="#FFFFCC">
<%
ResultSet rs;
String sql_1="select * from user where nickname='cxl'";
rs=buy.executeQuery(sql_1);
%>
<%=rs.getString("name")%>
<jsp:include page="footer.jsp" flush="true" ></jsp:include>
</body>
</html>
我的javaBean的代码如下:
package Club;
import java.sql.*;
import java.io.*;
public class Club_dbconnect {
String sDBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr="jdbc:odbc:soft";
Connection conn=null;
ResultSet rs=null;
public Club_dbconnect() {
try{
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e){
System.err.println("Class Club_dbconnection not found!"+e.getMessage());
}
}
//数据查询部分
public ResultSet executeQuery(String sql){
rs=null;
try{
conn=DriverManager.getConnection(sConnStr);
Statement stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
}
catch(SQLException ex){
System.err.println("aq.executeQuery:"+ex.getMessage());
}
return rs;
}
//数据更新
public ResultSet executeUpdate(String sql){
rs=null;
try{
conn=DriverManager.getConnection(sConnStr);
Statement stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
}
catch(SQLException ex){
System.err.println("aq.executeQuery:"+ex.getMessage());
}
return rs;
}
public void close()
{try{
if(rs!=null)
rs.close();
if(conn!=null)
conn.close();}
catch(SQLException ex){
System.err.println("aq.executeQuery:"+ex.getMessage());}
}
}