提示结果永远都是数据重写失败,0.这三个jsp文件我查了无数遍都查不出来问题在哪,头发要薅没了。
update_stu_2_edit.jsp:
<%@page contentType="text/html" import="java.sql.*" pageEncoding="GB2312"%>
<html>
<head> <title>修改编辑页面</title> </head>
<body>
<% String driverName = "com.mysql.jdbc.Driver"; //驱动程序名
String userName = "root"; //数据库用户名
String userPwd = ""; //密码
String dbName = "students"; //数据库名
String url1="jdbc:mysql://localhost:3306/"+dbName;
String url2 ="?user="+userName+"&password="+userPwd;
String url3="&useUnicode=true&characterEncoding=utf-8";
String url =url1+url2+url3; //形成带数据库读写编码的数据库连接字
Class.forName(driverName);
Connection conn=DriverManager.getConnection(url);
request.setCharacterEncoding("utf-8");//设置字符编码,避免出现乱码
String sex=request.getParameter("sex");
String name=request.getParameter("name");
session.setAttribute("sex",sex);
session.setAttribute("name",name);
String sql="select * from stu_info where sex=? and name=?";
PreparedStatement pstmt= conn.prepareStatement(sql);
pstmt.setString(1,sex);
pstmt.setString(2,name);
ResultSet rs=pstmt.executeQuery();
if(rs.next()){
int id=rs.getInt("id");
String name2=rs.getString("name");
String sex2=rs.getString("sex");
int age=rs.getInt("age");
String weight=rs.getString("weight");
String hight=rs.getString("hight");
if(rs!=null){ rs.close(); }
if(pstmt!=null){ pstmt.close(); }
if(conn!=null){ conn.close(); }
%>
<form action= "update_stu_2.jsp" method="post">
<table border="0" width="238" height="252">
<tr><td>书号</td><td><input name="id" value=<%=id%>></td></tr>
<tr><td>书名</td><td><input name="name2" value=<%=name2%>></td></tr>
<tr><td>作者</td><td><input name="sex2" value=<%=sex2%>></td></tr>
<tr><td>价格</td><td><input name="age" value=<%=age%>></td></tr>
<tr><td>分类</td><td><input name="weight" value=<%=weight%>></td></tr>
<tr><td>备注</td><td><input name="hight" value=<%=hight%>></td></tr>
<tr align="center">
<td colspan="2">
<input type="submit" value="提 交">
<input type="reset" value="取 消">
</td>
</tr>
</table>
</form>
<%}
else{%>
没有找到合适条件的记录!!<%
if(rs!=null){ rs.close(); }
if(pstmt!=null){ pstmt.close(); }
if(conn!=null){ conn.close(); }
}%>
</body>
</html>
update_stu_2_tijiao.jsp:
<%@ page language="java" pageEncoding="UTF-8"%>
<html>
<head> <title>修改记录的条件提交页面</title> </head>
<body>
请选择修改记录所满足的条件<hr width="100%" size="3">
<form action= "update_stu_2_edit.jsp" method="post"><br>
书名:<input type="text" name="name"><br><br>
作者:<input type="text" name="sex"><br><br>
<input type="submit" value="提 交">
<input type="reset" value="取 消">
</form>
</body>
</html>
update_stu_2.jsp:
<%@ page language="java" import="java.sql.*" pageEncoding="GB2312"%>
<html>
<head>
<title>修改后重写记录页面</title>
</head>
<body>
<%
String driverName = "com.mysql.jdbc.Driver"; //驱动程序名
String userName = "root"; //数据库用户名
String userPwd = ""; //密码
String dbName = "students"; //数据库名
String url1="jdbc:mysql://localhost:3306/"+dbName;
String url2 ="?user="+userName+"&password="+userPwd;
String url3="&useUnicode=true&characterEncoding=utf-8";
String url =url1+url2+url3; //形成带数据库读写编码的数据库连接字
Class.forName(driverName);
Connection conn=DriverManager.getConnection(url);
String sql="update stu_info set id=?,name=?,sex=?,age=?,weight=?,hight=? where name=? and sex=?";
PreparedStatement pstmt= conn.prepareStatement(sql);
request.setCharacterEncoding("utf-8");//设置字符编码,避免出现乱码
int id=Integer.parseInt(request.getParameter("id"));
String name2=request.getParameter("name2");
String sex2=request.getParameter("sex2");
int age=Integer.parseInt(request.getParameter("age"));
String weight=request.getParameter("weight");
String hight=request.getParameter("hight");
String name=(String) session.getAttribute("name");
String sex=(String) session.getAttribute("sex");
pstmt.setInt(1,id);
pstmt.setString(2,name2);
pstmt.setString(3,sex2);
pstmt.setInt(4,age);
pstmt.setString(5,weight);
pstmt.setString(6,hight);
pstmt.setString(7,name);
pstmt.setString(8,sex);
try{
int n=pstmt.executeUpdate();
if(n>=1){%>
重写数据操作成功!<br>
<%}
else{%>
重写数据操作失败!<%=n%><br>
<%}
}catch(Exception e){%>
重写过程出现异常错误!<br>
<%=e.getMessage()%>
<%
}
if(pstmt!=null){ pstmt.close(); }
if(conn!=null){ conn.close(); }
%>
</body>
</html>
```java
```
运行后IDE有啥子报错吗