代码如下:
<%@ page contentType="test/html;charset=GBK" %>
<%@ page language="java" import ="java.sql.*" %>
<jsp:useBean id="conn" scope="page" class="student.conn"/>
<html>
<head>
<title>fdsfs</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>id:</b></font></div>
</td>
<td width="25 %">
<div align="center"><font color="#ff0033"><b>data1:</b></font></div>
</td>
<td width="25 %">
<div align="center"><font color="#ff0033"><b>data2:</b></font></div>
</td>
</tr>
<% ResultSet rs=conn.executeQuery("select * from test1");
String id="";
int data1=0;
int data2=0;{
id=rs.getString("id");
data1=rs.getInt("data1");
data2=rs.getInt("data2");
%>
<tr>
<td width="50 %" bgcolor="#ffffff">
<div align="center"><%=id%></div>
</td>
<td width="25 %">
<div align="center"><%=data1%></div>
</td>
<td width="25 %">
<div align="center"><%=data2%></div>
</td>
</tr>
<%
}
rs.close();
%>
</table>
</body>
</html>
错误提示:
HTTP Status 500 - --------------------------------------------------------------------------------type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:510)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause java.lang.NullPointerException
org.apache.jsp.conn_jsp._jspService(conn_jsp.java:78)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
note The full stack trace of the root cause is available in the Apache Tomcat/5.5.17 logs.。怎么也搞不定。。还有个类似的程序也是一样的问题。是我没配好还是什么没加?还是代码有问题??前提:数据库已经打开。
<%@ page contentType="test/html;charset=GBK" %>
<%@ page language="java" import ="java.sql.*" %>
<jsp:useBean id="conn" scope="page" class="student.conn"/>
<html>
<head>
<title>fdsfs</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>id:</b></font></div>
</td>
<td width="25 %">
<div align="center"><font color="#ff0033"><b>data1:</b></font></div>
</td>
<td width="25 %">
<div align="center"><font color="#ff0033"><b>data2:</b></font></div>
</td>
</tr>
<% ResultSet rs=conn.executeQuery("select * from test1");
String id="";
int data1=0;
int data2=0;{
id=rs.getString("id");
data1=rs.getInt("data1");
data2=rs.getInt("data2");
%>
<tr>
<td width="50 %" bgcolor="#ffffff">
<div align="center"><%=id%></div>
</td>
<td width="25 %">
<div align="center"><%=data1%></div>
</td>
<td width="25 %">
<div align="center"><%=data2%></div>
</td>
</tr>
<%
}
rs.close();
%>
</table>
</body>
</html>
错误提示:
HTTP Status 500 - --------------------------------------------------------------------------------type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:510)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause java.lang.NullPointerException
org.apache.jsp.conn_jsp._jspService(conn_jsp.java:78)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
note The full stack trace of the root cause is available in the Apache Tomcat/5.5.17 logs.。怎么也搞不定。。还有个类似的程序也是一样的问题。是我没配好还是什么没加?还是代码有问题??前提:数据库已经打开。
解决方案 »
- 正则表达式—分页显示获得最大记录数
- 将页面数据导出到xml格式的文件中 求助
- 关于jsp页面中el语言的问题
- x-fire调用webservice Exception
- 我用poi读excel,在window下没有问题,但把程序放到linux上时,读取客户端的excel文件报错,不知道如何解决
- 重大问题:用JSP代码创建ACCESS数据库/表格!!!!
- 如何用JAVA脚本实现 创建文件夹和删除文件夹
- 怎样对*.swf格式进行编辑修改?
- JSONArray join = JSONArray.fromObject(list);
- 如何使用include(急!~)
- 求Hibernate3.12 WEB代码,简单实现,只要一个表的实例就行
- 使用cell控件画柱状图时ie关闭问题,急,在线等
检查你写的bean
data1=rs.getInt("data1");
data2=rs.getInt("data2");”前rs.first()
HTTP Status 500 - --------------------------------------------------------------------------------type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: Exception in JSP: /connect.jsp:2623: String id="";
24: int data1=0;
25: int data2=0;
26: while(rs.next())
27: {
28: id=rs.getString("id");
29: data1=rs.getInt("data1");
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:504)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause java.lang.NullPointerException
org.apache.jsp.connect_jsp._jspService(connect_jsp.java:76)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
note The full stack trace of the root cause is available in the Apache Tomcat/5.5.17 logs.给点意见吧。没招了都。
这种结构安全性、稳定性、快速性都很好