然后问题来了,我对选中对待某一行做了修改操作后,网页传值是这样的:
lhost:8084/JavaWebTest6/Subscripton.jsp?mailserver=qq.com&mailusernae=zsq&mailpassword=1&mailservertype=1&Username=null&mailserver=126.com&mailusernae=zs&mailpassword=1&mailservertype=2&Username=null&mailserver=136.com&mailusernae=ad&mailpassword=1&mailservertype=POP3&Username=null&mailserver=qq.com&mailusernae=w&mailpassword=q&mailservertype=1&Username=null&mailserver=136.com&mailusernae=e&mailpassword=e&mailservertype=e&Username=null&mailserver=qq.com&mailusernae=q&mailpassword=q&mailservertype=q&Username=null&Mailserver=&Mailusernae=&Mailpassword=&Mailservertype=&Username=null*
很明显,把所有值都传过来了,下面是显示页的代码(有标注的地方是有问题的地方):
<%--
Document : mainMenu
Created on : 2019-11-7, 11:28:27
Author : Administrator
--%>
<%@page language ="java" pageEncoding="UTF-8"%>
<%@page import="java.sql.*"%>
<!DOCTYPE html>
<html>
<head>
<title>用户账号管理系统</title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<div></div>
<h2><b>用户账号及邮箱信息维护界面</b></h2>
<table frame="hsides">
<% String username=request.getParameter("name");
out.println("用户名:"+username);
%>
<tr>
<a href="account.jsp?username=<%=username%>">修改密码</a><br>
</tr>
<tr><br></tr>
<tr>
<td><input type="text" disabled="true" value="邮箱主机"></td>
<td><input type="text" disabled="true" value="邮箱用户名"></td>
<td><input type="text" disabled="true" value="邮箱密码"></td>
<td><input type="text" disabled="true" value="邮箱服务器类型"></td>
</tr>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection("jdbc:odbc:ACCountdb");
Statement stat = conn.createStatement();
String sql = "SELECT * FROM TB_SUBSCRIPTION WHERE USERNAME='"+username+"'";
ResultSet rs = stat.executeQuery(sql);
//这里写的循环直接导致后面传值的时候,所有表中数据都传过去了
while (rs.next()){
//String username = rs.getString("USERNAME");
String mailserver = rs.getString("MAILSERVER");
String mailusernae = rs.getString("MAILUSERNAE");
String mailpassword = rs.getString("MAILPASSWORD");
String mailservertype = rs.getString("MAILSERVERTYPE");
%>
<form action="Subscripton.jsp">
<tr> <br>
<td><input type="text" value='<%=mailserver%>' name="mailserver" ></td>
<td><input type="text" value='<%=mailusernae%>' name="mailusernae"></td>
<td><input type="text" value='<%=mailpassword%>' name="mailpassword"></td>
<td><input type="text" value="<%=mailservertype%>" name="mailservertype"></td>
<td><input type="submit" value="修改邮箱信息"></td>
<td><a href="delSubscription.jsp?mailserver=<%=mailserver%>&mailusernae=<%=mailusernae%>">删除</a></td>
<td><input name="Username" value='<%=username%>'</td>
</tr>
<%
}
stat.close();
conn.close();
%>
<form action="addSubscription.jsp">
<tr>
<br>
<td><input type="text" name="Mailserver"></td>
<td><input type="text" name="Mailusernae"></td>
<td><input type="password" name="Mailpassword"></td>
<td><input type="text" name="Mailservertype"></td>
<td><input type="submit" value="添加新邮箱"></td>
<td><input name="Username" value='<%=username%>'</td>
</tr>
</form>
</table>
<a href="login.jsp">退出</a>
</body>
</html>
这是修改页的代码:
<%--
Document : Subscripton
Created on : 2019-12-7, 10:01:00
Author : Administrator
--%>
<%@page language="java" pageEncoding="UTF-8"%>
<%@page import="java.sql.*"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>用户账号管理系统</title>
</head>
<body>
<%
String username=request.getParameter("Username");
String mailserver=request.getParameter("mailserver");
String mailusernae=request.getParameter("mailusernae");
%>
<form action="editSubscripton.jsp?mailserver=<%=mailserver%>&mailusernae=<%=mailusernae%>">
用户名:<input type="text" name="Username" value="<%=username%>"><br><br>
邮箱密码:<input type="text" name="mailpassword">*<br><br>
邮箱服务器类型: <input type="text" name="mailservertype">*<br><br>
<input type="submit" value="修改">
<input type="reset" value="重置">
</form>
<a href="mainMenu.jsp">返回</a>
</body>
</html>
希望能得到解答!感谢!!