jsp修改数据问题，请大侠指导
1）查询输出后显示查询结果后，增加修改状态。页面代码如下2）直接修改这个参数后返回当前页面显示（这个如何写，求具体代码）
<%@ page language="java" import="java.sql.*" pageEncoding="gb2312" errorPage="error.jsp"%>
<html>
<head>
<title>list2.jsp</title>
</head>
<body>
<table border="1" bgcolor="#ffffff" align="center" cellspacing="1" cellpadding="1">
<caption>会员管理系统</caption>
<tr>
<td align="center" width=6%>序号</td>
<td align="center" width=6%>姓名</td>
<td align="center" width=3%>性别</td>
<td align="center" width=12%>卡号</td>
<td align="center" width=12%>联系电话</td>
<td align="center" width=12%>体检单位</td>
<td align="center" width=18%>身份证</td>
<td align="center" width=3%>体检状态</td>
<td align="center" width=3%>操作</td>
</tr>
<%
String sql="";
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
String url="jdbc:oracle:thin:@192.168.0.174:1521:orcl11";
String user="healthy";
String password="healthy";
Connection con=DriverManager.getConnection(url,user,password);
Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE,ResultSet.CONCUR_READ_ONLY);
//request.setCharacterEncoding("ISO8859_1");
//out.println("0"+sql+"/n");String(szUserName.getBytes("ISO8859_1"),"GB2312")
String key=new String(request.getParameter("key").getBytes("ISO8859_1"),"GB2312");
sql="select * from t_3 where yhm='"+key+"' OR sjhm='"+key+"' OR sfz='"+key+"' ";
//out.println("1"+sql+"/n");
ResultSet rs=stmt.executeQuery(sql);
//String yhm,sfz,sjhm;
if (rs!=null)
{
while (rs.next()){
out.println("查询结果:");
%>
<tr>
<td width=6% align="center"><%=rs.getString(1) %></td>
<td width=6% align="center"><%=rs.getString(2) %></td>
<td width=3% align="center"><%=rs.getString(3) %></td>
<td width=12% align="center"><%=rs.getString(4) %></td>
<td width=12% align="center"><%=rs.getString(5) %></td>
<td width=12% align="center"><%=rs.getString(6) %></td>
<td width=18% align="center"><%=rs.getString(8) %></td>
<%
if(rs.getString(7).equals("0"))
{//out.println("2"+sql+"/n");
%>
<td width=6% align="center">未体检</td>
<td width=6% algin="center" onclick="return modifyStu()"><a href="change.jsp?xuehao=<%=rs.getObject(1)%>">修改状态</a></td>
<%
}
else
{//out.println("3"+sql+"/n");
%>
<td width=6% align="center">已体检</td>
<td width=6% algin="center" onclick="return modifyStu()"></td>
<%
}
%>
</tr>
<%
}
rs.close();
stmt.close();
con.close();
}
else out.println("查询错误");
}catch(Exception e){
out.println("查询结果:"+sql);
e.printStackTrace();
}
%>
</table>
<div align="center"><a href="insert.jsp">添加新记录</a></div>
</body>
</html> 不太懂，同问。。。 增加一列<td><a href="edit.jsp?id=<%=rs.getString(1)%>">修改</a></td>
至于修改完后跳转到显示页面，就在edit.jsp里面更新完数据库后 response.sendRedirect("list.jsp");
具体代码应该写得出来，显示都写出来了，无非是 select 改成 update
页:
[1]