jsp 从数据库中掉入数据出现问题？（有50分，在线等待解答）
我从表中读取数据，想让他在页面中显示，但总是提示错误信息！请大家帮帮？
原代码？
<%@ page import="java.lang.*" contentType="text/html; charset=gb2312"%>
<%@ include file="../inc/data.jsp"%>
<%@ include file="adm_login.jsp"%>
<html>
<head>
<title>修改成员信息</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../inc/styles.css" rel="stylesheet" type="text/css">
</head>
<body bgcolor="#D7EBFF" leftmargin="0" topmargin="0">
<%
String sql="select * from member_info order by member_id";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next())
{
String d_member_id=rs.getString("member_id");
String d_name=rs.getString("name");
String sex=rs.getString("sex");
String birth_y=rs.getString("birth_y");
String birth_m=rs.getString("birth_m");
String birth_d=rs.getString("birth_d");
String tel=rs.getString("tel");
String mobile=rs.getString("mobile");
String xueli=rs.getString("xueli");
//String department_name=rst.getString("department_name");
}
%>
<p align="center" class="a02"><strong>成员信息管理</strong></p>
<table width="778" border="0" class="L13">
<tr bgcolor="#0099CC">
<td width="94"><div align="center"><font color="#FFFFFF"><strong>姓名</strong></font></div></td>
<td width="101"><div align="center"><font color="#FFFFFF"><strong>性别</strong></font></div></td>
<td width="101"><div align="center"><font color="#FFFFFF"><strong>出生日期</strong></font></div></td>
<td width="101"><div align="center"><font color="#FFFFFF"><strong>所属部门</strong></font></div></td>
<td width="101"><div align="center"><font color="#FFFFFF"><strong>电话</strong></font></div></td>
<td width="101"><div align="center"><font color="#FFFFFF"><strong>移动电话</strong></font></div></td>
<td width="77"><div align="center"><font color="#FFFFFF"><strong>学历</strong></font></div></td>
<td colspan="2"><div align="center"><font color="#FFFFFF"><strong>管理</strong></font></div></td>
</tr>
<tr>
<td><div align="center"><%=name%></div></td>
<td><div align="center"><%=sex%></div></td>
<td><div align="center"><%=birth_y%>-<%=birth_m%>-<%=birth_d%></div></td>
<td><div align="center"><%=department%></div></td>
<td><div align="center"><%=tel%></div></td>
<td><div align="center"><%=mobile%></div></td>
<td><div align="center"><%=xueli%></div></td>
<td width="32"><div align="center">删除</div></td>
<td width="32"><div align="center">修改</div></td>
</tr>
</table>
<p align="center" class="a02"> </p>
<%
stmt.close();
conn.close();
%>
</body>
</html>
错误信息
Error: 500
Location: /member_info/admin/modify.jsp
Internal Servlet Error:
org.apache.jasper.JasperException: Unable to compile class for JSPC:\tomcat-3.2.4\work\localhost_8080\_0002fmember_0005finfo_0002fadmin_0002fmodify_0002ejspmodify_jsp_0.java:126: Undefined variable: d_name
out.print(d_name);
^
C:\tomcat-3.2.4\work\localhost_8080\_0002fmember_0005finfo_0002fadmin_0002fmodify_0002ejspmodify_jsp_0.java:132: Undefined variable: sex
out.print(sex);
^
C:\tomcat-3.2.4\work\localhost_8080\_0002fmember_0005finfo_0002fadmin_0002fmodify_0002ejspmodify_jsp_0.java:138: Undefined variable: birth_y
out.print(birth_y);
^
C:\tomcat-3.2.4\work\localhost_8080\_0002fmember_0005finfo_0002fadmin_0002fmodify_0002ejspmodify_jsp_0.java:144: Undefined variable: birth_m
out.print(birth_m);
^
C:\tomcat-3.2.4\work\localhost_8080\_0002fmember_0005finfo_0002fadmin_0002fmodify_0002ejspmodify_jsp_0.java:150: Undefined variable: birth_d
out.print(birth_d);
^
C:\tomcat-3.2.4\work\localhost_8080\_0002fmember_0005finfo_0002fadmin_0002fmodify_0002ejspmodify_jsp_0.java:156: Undefined variable: department
out.print(department);
^
C:\tomcat-3.2.4\work\localhost_8080\_0002fmember_0005finfo_0002fadmin_0002fmodify_0002ejspmodify_jsp_0.java:162: Undefined variable: tel
out.print(tel);
^
C:\tomcat-3.2.4\work\localhost_8080\_0002fmember_0005finfo_0002fadmin_0002fmodify_0002ejspmodify_jsp_0.java:168: Undefined variable: mobile
out.print(mobile);
^
C:\tomcat-3.2.4\work\localhost_8080\_0002fmember_0005finfo_0002fadmin_0002fmodify_0002ejspmodify_jsp_0.java:174: Undefined variable: xueli
out.print(xueli);
^
9 errors
at org.apache.jasper.compiler.Compiler.compile(Compiler.java, Compiled Code)
at org.apache.jasper.servlet.JspServlet.doLoadJSP(JspServlet.java:612)
at org.apache.jasper.servlet.JasperLoader12.loadJSP(JasperLoader12.java:146)
at org.apache.jasper.servlet.JspServlet.loadJSP(JspServlet.java:542)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.loadIfNecessary(JspServlet.java:258)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:268)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:429)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java, Compiled Code)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405)
at org.apache.tomcat.core.Handler.service(Handler.java, Compiled Code)
at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java, Compiled Code)
at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:806)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java:752)
at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:213)
at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java, Compiled Code)
at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java, Compiled Code)
at java.lang.Thread.run(Thread.java:479)
问题点数：0、回复次数：10Top
1 楼sgdb（神天月晓）回复于 2003-09-04 11:01:10 得分 0
把类似于d_member_id的东西放在循环提的外面定义Top
2 楼wangwd（coffee I love）回复于 2003-09-04 11:06:55 得分 0
String d_member_id=rs.getString("member_id");
String d_name=rs.getString("name");
String sex=rs.getString("sex");
String birth_y=rs.getString("birth_y");
String birth_m=rs.getString("birth_m");
String birth_d=rs.getString("birth_d");
String tel=rs.getString("tel");
String mobile=rs.getString("mobile");
String xueli=rs.getString("xueli");
兄弟呀，你的这些变量应该放到块外面定义，否则下面怎么能访问到呢Top
3 楼loverface（双面人）回复于 2003-09-04 11:07:03 得分 0
变量没有定义啊，你所定义的这些变量只在while(){ }花括号范围内有效。
把while的位置变一下就行了，好好的看一看变量的生存期。
<p align="center" class="a02"><strong>成员信息管理</strong></p>
<table width="778" border="0" class="L13">
<tr bgcolor="#0099CC">
<td width="94"><div align="center"><font color="#FFFFFF"><strong>姓名</strong></font></div></td>
<td width="101"><div align="center"><font color="#FFFFFF"><strong>性别</strong></font></div></td>
<td width="101"><div align="center"><font color="#FFFFFF"><strong>出生日期</strong></font></div></td>
<td width="101"><div align="center"><font color="#FFFFFF"><strong>所属部门</strong></font></div></td>
<td width="101"><div align="center"><font color="#FFFFFF"><strong>电话</strong></font></div></td>
<td width="101"><div align="center"><font color="#FFFFFF"><strong>移动电话</strong></font></div></td>
<td width="77"><div align="center"><font color="#FFFFFF"><strong>学历</strong></font></div></td>
<td colspan="2"><div align="center"><font color="#FFFFFF"><strong>管理</strong></font></div></td>
</tr>
<%
String sql="select * from member_info order by member_id";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next())
{
String d_member_id=rs.getString("member_id");
String d_name=rs.getString("name");
String sex=rs.getString("sex");
String birth_y=rs.getString("birth_y");
String birth_m=rs.getString("birth_m");
String birth_d=rs.getString("birth_d");
String tel=rs.getString("tel");
String mobile=rs.getString("mobile");
String xueli=rs.getString("xueli");
//String department_name=rst.getString("department_name");
%>
<tr>
<td><div align="center"><%=name%></div></td>
<td><div align="center"><%=sex%></div></td>
<td><div align="center"><%=birth_y%>-<%=birth_m%>-<%=birth_d%></div></td>
<td><div align="center"><%=department%></div></td>
<td><div align="center"><%=tel%></div></td>
<td><div align="center"><%=mobile%></div></td>
<td><div align="center"><%=xueli%></div></td>
<td width="32"><div align="center">删除</div></td>
<td width="32"><div align="center">修改</div></td>
</tr>
<%}%>
</table>
<p align="center" class="a02"> </p>
<%
stmt.close();
conn.close();
%>
</body>
</html>Top
4 楼Geranium（魂归阿寒）回复于 2003-09-04 11:09:11 得分 0
把你的java代码也贴上来看看Top
5 楼dmhorse（dmhorse）回复于 2003-09-04 11:09:32 得分 0
Undefined variable: d_name
out.print(d_name);
while(rs.next())
{
String d_member_id=rs.getString("member_id");
String d_name=rs.getString("name");
String sex=rs.getString("sex");
String birth_y=rs.getString("birth_y");
String birth_m=rs.getString("birth_m");
String birth_d=rs.getString("birth_d");
String tel=rs.getString("tel");
String mobile=rs.getString("mobile");
String xueli=rs.getString("xueli");
//String department_name=rst.getString("department_name");
}
外部定义这些StringTop
6 楼dmhorse（dmhorse）回复于 2003-09-04 11:14:25 得分 0
Undefined variable: d_name
out.print(d_name);
while(rs.next())
{
String d_member_id=rs.getString("member_id");
String d_name=rs.getString("name");
String sex=rs.getString("sex");
String birth_y=rs.getString("birth_y");
String birth_m=rs.getString("birth_m");
String birth_d=rs.getString("birth_d");
String tel=rs.getString("tel");
String mobile=rs.getString("mobile");
String xueli=rs.getString("xueli");
//String department_name=rst.getString("department_name");
}
外部定义这些StringTop
7 楼Geranium（魂归阿寒）回复于 2003-09-04 11:17:48 得分 0
这位哥哥真强！
这样：
<%@ page import="java.lang.*" contentType="text/html; charset=gb2312"%>
<%@ include file="../inc/data.jsp"%>
<%@ include file="adm_login.jsp"%>
<html>
<head>
<title>修改成员信息</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../inc/styles.css" rel="stylesheet" type="text/css">
</head>
<body bgcolor="#D7EBFF" leftmargin="0" topmargin="0">
<%
String sql="select * from member_info order by member_id";
ResultSet rs=stmt.executeQuery(sql);
String d_member_id=rs.getString("member_id");
String d_name=rs.getString("name");
String sex=rs.getString("sex");
String birth_y=rs.getString("birth_y");
String birth_m=rs.getString("birth_m");
String birth_d=rs.getString("birth_d");
String tel=rs.getString("tel");
String mobile=rs.getString("mobile");
String xueli=rs.getString("xueli");
//String department_name=rst.getString("department_name");
}
%>
<p align="center" class="a02"><strong>成员信息管理</strong></p>
<table width="778" border="0" class="L13">
<tr bgcolor="#0099CC">
<td width="94"><div align="center"><font color="#FFFFFF"><strong>姓名</strong></font></div></td>
<td width="101"><div align="center"><font color="#FFFFFF"><strong>性别</strong></font></div></td>
<td width="101"><div align="center"><font color="#FFFFFF"><strong>出生日期</strong></font></div></td>
<td width="101"><div align="center"><font color="#FFFFFF"><strong>所属部门</strong></font></div></td>
<td width="101"><div align="center"><font color="#FFFFFF"><strong>电话</strong></font></div></td>
<td width="101"><div align="center"><font color="#FFFFFF"><strong>移动电话</strong></font></div></td>
<td width="77"><div align="center"><font color="#FFFFFF"><strong>学历</strong></font></div></td>
<td colspan="2"><div align="center"><font color="#FFFFFF"><strong>管理</strong></font></div></td>
</tr>
<%
while(rs.next())
{
%>
<td><div align="center"><%=name%></div></td>
<td><div align="center"><%=sex%></div></td>
<td><div align="center"><%=birth_y%>-<%=birth_m%>-<%=birth_d%></div></td>
<td><div align="center"><%=department%></div></td>
<td><div align="center"><%=tel%></div></td>
<td><div align="center"><%=mobile%></div></td>
<td><div align="center"><%=xueli%></div></td>
<td width="32"><div align="center">删除</div></td>
<td width="32"><div align="center">修改</div></td>
</tr>
</table>
<p align="center" class="a02"> </p>
<%
}
stmt.close();
conn.close();
%>
</body>
</html>
<%}%>
</table>
<p align="center" class="a02"> </p>
<%
stmt.close();
conn.close();
%>
</body>
</html>
Top
8 楼dugang106（冷风细雨）回复于 2003-09-04 11:18:21 得分 0
nod
只是变量也没有必要定义，直接读出来rs.getString("xxxxxx")用就可以了
Top
9 楼Geranium（魂归阿寒）回复于 2003-09-04 11:29:26 得分 0
刚才改错了，再改了一次：
<%@ page import="java.lang.*" contentType="text/html; charset=gb2312"%>
<%@ include file="../inc/data.jsp"%>
<%@ include file="adm_login.jsp"%>
<html>
<head>
<title>修改成员信息</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../inc/styles.css" rel="stylesheet" type="text/css">
</head>
<body bgcolor="#D7EBFF" leftmargin="0" topmargin="0">
<%
String sql="select * from member_info order by member_id";
ResultSet rs=stmt.executeQuery(sql);
%>
<p align="center" class="a02"><strong>成员信息管理</strong></p>
<table width="778" border="0" class="L13">
<tr bgcolor="#0099CC">
<td width="94"><div align="center"><font color="#FFFFFF"><strong>编号</strong></font></div></td>
<td width="94"><div align="center"><font color="#FFFFFF"><strong>姓名</strong></font></div></td>
<td width="101"><div align="center"><font color="#FFFFFF"><strong>性别</strong></font></div></td>
<td width="101"><div align="center"><font color="#FFFFFF"><strong>出生日期</strong></font></div></td>
<td width="101"><div align="center"><font color="#FFFFFF"><strong>所属部门</strong></font></div></td>
<td width="101"><div align="center"><font color="#FFFFFF"><strong>电话</strong></font></div></td>
<td width="101"><div align="center"><font color="#FFFFFF"><strong>移动电话</strong></font></div></td>
<td width="77"><div align="center"><font color="#FFFFFF"><strong>学历</strong></font></div></td>
<td colspan="2"><div align="center"><font color="#FFFFFF"><strong>管理</strong></font></div></td>
</tr>
<%
while(rs.next()){
%>
<tr><td><div align="center"><%=rs.getString("member_id")%></div></td>
<td><div align="center"><%=rs.getString("name")%></div></td>
<td><div align="center"><%=rs.getString("name")%></div></td>
<td><div align="center"><%=rs.getString("sex")%></div></td>
<td><div align="center"><%=rs.getString("birth_y")%>-<%=rs.getString("birth_m")%>-<%=rs.getString("birth_d")%></div></td>
<td><div align="center"><%=department%></div></td>
<td><div align="center"><%=rs.getString("tel")%></div></td>
<td><div align="center"><%=rs.getString("mobile")%></div></td>
<td><div align="center"><%=rs.getString("xueli")%></div></td>
<td width="32"><div align="center">删除</div></td>
<td width="32"><div align="center">修改</div></td>
</tr> <%}%>
</table>
<p align="center" class="a02"> </p>
<%
stmt.close();
conn.close();
%>
</body>
</html>
老大，拜托你有问题先自己想想好不好，一有问题也不想想就问人对你提高没什么帮助。Top
10 楼znef88（张宁）回复于 2003-09-04 11:30:26 得分 0
谢谢以上好心大哥，刚才疏忽了。Top
11 楼Geranium（魂归阿寒）回复于 2003-09-04 11:32:20 得分 0
<%
while(rs.next()){
%>
<tr><td><div align="center"><%=rs.getString("member_id")%></div></td>
<td><div align="center"><%=rs.getString("name")%></div></td>
<td><div align="center"><%=rs.getString("sex")%></div></td>
<td><div align="center"><%=rs.getString("birth_y")%>-<%=rs.getString("birth_m")%>-<%=rs.getString("birth_d")%></div></td>
<td><div align="center"><%=department%></div></td>
<td><div align="center"><%=rs.getString("tel")%></div></td>
<td><div align="center"><%=rs.getString("mobile")%></div></td>
<td><div align="center"><%=rs.getString("xueli")%></div></td>
<td width="32"><div align="center">删除</div></td>
<td width="32"><div align="center">修改</div></td>
</tr> <%}%>
</table>
这段再改下。你多试试就行了Top
