我有一个简单的表格,我想保存数据并通过以相同的形式给出第一个值来编辑数据。我能够保存数据,但要进行编辑,我有问题,我想我遵循正确的方法,但是我找不到问题,我没有收到任何错误,我删除了我的总代码,请解决此问题
index.jsp:
<body>
<%String status;
status=(String)session.getAttribute("edit");
if(status=="fail")
{%>
<h6>there are no records with this no</h6>
<% }
%>
<form action="indexaction.jsp" method="post">
Id <input type="text" name="id" id="id2"><br>
<%
if(status=="success")
{%>
<script type="text/javascript">
document.getElementsById("id2").value='<%=request.getAttribute("id1")%>';
</script>
<%} %>
Name <input type="text" name="name" id="name2"><br>
<%
if(status=="success")
{%>
<script type="text/javascript">
document.getElementsById("name2").value='<%=request.getAttribute("name1")%>';
</script>
<%} %>
sex <input type="text" name="sex" id="sex2"><br>
<%
if(status=="success")
{%>
<script type="text/javascript">
document.getElementsById("sex2").value='<%=request.getAttribute("sex1")%>';
</script>
<%} %>
<input type="submit" name="action" value="save">
<input type="submit" name="action" value="edit">
</form>
</body>
indexaction.jsp:
<body>
<%!
PreparedStatement preparedStatement;
int id1;
String name1,sex1;
%>
<%
Connection connection=DBCreation.getConnection();
String action=request.getParameter("action");
int i=Integer.parseInt(request.getParameter("id"));
String name=request.getParameter("name");
String sex=request.getParameter("sex");
if(action.equals("save")){
preparedStatement=connection.prepareStatement("insert into sample values(?,?,?)");
preparedStatement.setInt(1, i);
preparedStatement.setString(2, name);
preparedStatement.setString(3, sex);
int j=preparedStatement.executeUpdate();
if(j>0)
{
out.println("<h3>inserted success</h3>");
response.sendRedirect("index.jsp");
}
}
else if(action.equals("edit")){
int x=0;
System.out.println("edit called");
preparedStatement=connection.prepareStatement("select * from sample where id=?");
preparedStatement.setInt(1, i);
ResultSet resultSet=preparedStatement.executeQuery();
while(resultSet.next())
{
x++;
request.getSession().setAttribute("edit", "success");
System.out.println("while called"+x);
id1=resultSet.getInt(1);
name1=resultSet.getString(2);
sex1=resultSet.getString(3);
request.setAttribute("id1", id1);
request.setAttribute("name1",name1);
request.setAttribute("sex1", sex1);
}
if(x<=0)
{
request.getSession().setAttribute("edit", "fail");
}
response.sendRedirect("index.jsp");
}
%>
</body>
</html>
使用此代码,如果我输入了错误的ID,则会收到错误消息“没有此No的记录”,这意味着由于设置了状态“失败”,它可以正常工作。如果我输入正确的ID,问题就来了。
最佳答案
尝试这个
<body>
<%String status;
status=(String)session.getAttribute("edit");
if(status.equals("fail")) //compare string with .equals not ==
{%>
<h6>there are no records with this no</h6>
<% }
%>
<form action="indexaction.jsp" method="post">
Id <input type="text" name="id" id="id2"><br>
<%
if(status=="success")
{%>
<script type="text/javascript">
document.getElementsById("id2").value='<%=request.getAttribute("id1")%>';
</script>
<%} %>
Name <input type="text" name="name" id="name2"><br>
<%
if(status=="success")
{%>
<script type="text/javascript">
document.getElementsById("name2").value='<%=request.getAttribute("name1")%>';
</script>
<%} %>
sex <input type="text" name="sex" id="sex2"><br>
<%
if(status=="success")
{%>
<script type="text/javascript">
document.getElementsById("sex2").value='<%=request.getAttribute("sex1")%>';
</script>
<%} %>
<input type="submit" name="action" value="save">
<input type="submit" name="action" value="edit">
</form>
</body>