Stringsql="updatestu_infosetid=?,name=?,sex=?,age=?,weight=?,hight=?wherename=?andsex=?";PreparedStatementpstmt=conn.prepareStatement(sql);intid=Integer.parseInt(request....
String sql="update stu_info set id=?,name=?,sex=?,age=?,weight=?,hight=? where name=? and sex=?"; PreparedStatement pstmt=conn.prepareStatement(sql); int id=Integer.parseInt(request.getParameter("id")); String name2=request.getParameter("name2"); String sex2=request.getParameter("sex2"); int age=Integer.parseInt(request.getParameter("age")); float weight=Float.parseFloat(request.getParameter("weight")); float hight=Float.parseFloat(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.setFloat(5,weight); pstmt.setFloat(6,hight); pstmt.setString(7,name); pstmt.setString(8,sex); int n=pstmt.executeUpdate(); if(n>=1){%>重写数据操作成功! 重写数据操作失败!!!
展开