jsp中调用javabean访问数据库(参与者都的分)
我通过javabean访问数据的jsp源代码,但总出错,可能是数据源配置出了问题,
我用的是JBuliber9.0写的。请问该如何配置数据源。谢谢!
代码如下:
conn_db.jsp
<%@ page contentType="text/html; charset=GBK" %>
<%@ page language="java" import="java.sql.*"%>
<jsp:useBean id="connDbBean" scope="page" class="student.conn"/>
<html>
<head>
<title>
conn_db
</title>
</head>
<body bgcolor="#ffffff">
<div align="conter">
<table width="60%" border="1">
<tr bgcolor="#ccccff">
<td width="50%">
<div align="conter"><font color="#ff0033"><b>姓名</b></font></div>
</td>
<td width="25%">
<div align="conter"><font color="#ff0033"><b>性别</b></font></div>
</td>
<td width="25%">
<div align="conter"><font color="#ff0033"><b>分数</b></font></div>
</td>
</tr>
<%
ResultSet RS_result=connDbBean.executeQuery("select * from table1");
String studentName="";
String studentSex="";
String studentScore="";
while(RS_result.next()){
studentName=RS_result.getString("name");
studentSex=RS_result.getString("sex");
studentScore=RS_result.getString("score");
%>
<tr>
<td width="50%" bgcolor="#ffffff">
<div align="center"><%=studentName%></div>
</td>
<td width="25%">
<div align="center"><%=studentSex%></div>
</td>
<td align="25%">
<div align="center"><%=studentScore%></div>
</td>
</td>
<%
}
%>
</body>
</html>
conn.java
package student;
import java.sql.*;
public class conn {
String sDBDriver="sun.jdbc.odbc.jdbcodbcDriver";
String sConnStr="jdbc:odbc:student";
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);
Statement stmt=connect.createStatement();
rs=stmt.executeQuery(sql);
}
catch(SQLException ex){
System.err.println(ex.getMessage());
}
return rs;
}
}