一个jsp错误 javabean 不用写配置文件是吧,呵呵不好意思!!我是菜鸟 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 WEB-INF/classes/student 你看看这个目录是否正确,我在自己机器用你的代码试了一下,没有出现你所说的错误。你可能是在路径上有个地点大意弄错了而已。别急,我也遇到过很多类似的错误,最后都是自己在意造成的。 你里面有几个语法错误studentScore=RS_result.getString("score");应为getInt<% =studentName%>等号和%之间不能空格<% =studentscore%>改为studentScore 我把你的程序改成这样就成功了conn.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>test db connection</title></head><body bgcolor="ffffff"><div align="center"> <table width="60%" border="1"> <tr bgcolor="#ccccff"> <td width="50%"><div align="center"><font color="#ff0033"><b>姓名</b></font></div></td> <td width="25%"><div align="center"><font color="#ff0033"><b>性别</b></font></div></td> <td width="25%"><div align="center"><font color="#ff0033"><b>姓名</b></font></div></td> </tr><%ResultSet RS_result=connDbBean.executeQuery("select * from student");String studentName="";String studentSex="";int studentScore=0;while(RS_result.next()){ studentName=RS_result.getString("name"); studentSex=RS_result.getString("sex"); studentScore=RS_result.getInt("score");%> <tr> <td width="50%" bgcolor="#ffffff"><div align="center"><%=studentName%> </div></td> <td width="25%" bgcolor="#ffffff"><div align="center"><%=studentSex%> </div></td> <td width="25%" bgcolor="#ffffff"><div align="center"><%=studentScore%> </div></td> </tr><%}connDbBean.close();%> </table></div></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; Statement stmt = 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); stmt=connect.createStatement(); rs=stmt.executeQuery(sql); } catch(SQLException ex) { System.err.println(ex.getMessage()); } return rs; } public void close() { try { if(rs != null) { rs.close(); } if(stmt != null) { stmt.close(); } if(connect != null) { connect.close(); } } catch(Exception e) { e.printStackTrace(); } }} studentScore=RS_result.getString("score");这个改成studentScore=RS_result.getInt("score"); HttpClient模拟登陆下载一个文件时 中间有个302跳转报错 dwr技术实现注册用户 点一点聊天的问题 hibernate map 映射 有关jsp 组合多条件查询例如既有下拉框还有文本框 spring错误 javamail标题和附件显示乱码 在XML文件中可以直接嵌入.jpg文件吗? 如何在字符串中判断全角字符和半角字符?在线等待!!! 有没有关于xml生成树的例子,有请发给我? lucene分组之后进行高亮显示报错 关于访问数据库的问题?? 大家来帮帮我吧,到底是什么原因啊?先谢过了啊!!
studentScore=RS_result.getString("score");应为getInt
<% =studentName%>等号和%之间不能空格
<% =studentscore%>改为studentScore
conn.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>test db connection</title></head><body bgcolor="ffffff"><div align="center">
<table width="60%" border="1">
<tr bgcolor="#ccccff">
<td width="50%"><div align="center"><font color="#ff0033"><b>姓名</b></font></div></td>
<td width="25%"><div align="center"><font color="#ff0033"><b>性别</b></font></div></td>
<td width="25%"><div align="center"><font color="#ff0033"><b>姓名</b></font></div></td>
</tr>
<%
ResultSet RS_result=connDbBean.executeQuery("select * from student");
String studentName="";
String studentSex="";
int studentScore=0;
while(RS_result.next())
{
studentName=RS_result.getString("name");
studentSex=RS_result.getString("sex");
studentScore=RS_result.getInt("score");
%>
<tr>
<td width="50%" bgcolor="#ffffff"><div align="center"><%=studentName%> </div></td>
<td width="25%" bgcolor="#ffffff"><div align="center"><%=studentSex%> </div></td>
<td width="25%" bgcolor="#ffffff"><div align="center"><%=studentScore%> </div></td>
</tr>
<%
}
connDbBean.close();
%>
</table>
</div>
</body>
</html>
import java.sql.*;
public class conn
{
String sDBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr="jdbc:odbc:student";
Connection connect=null;
ResultSet rs=null;
Statement stmt = 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);
stmt=connect.createStatement();
rs=stmt.executeQuery(sql);
}
catch(SQLException ex)
{
System.err.println(ex.getMessage());
}
return rs;
}
public void close()
{
try
{
if(rs != null)
{
rs.close();
}
if(stmt != null)
{
stmt.close();
}
if(connect != null)
{
connect.close();
}
}
catch(Exception e)
{
e.printStackTrace();
}
}
}
这个改成
studentScore=RS_result.getInt("score");