下面是更新页面的代码, 等成功跳转到response.sendRedirect("M_user_in.jsp");
但是,数据并没有变化,谁能帮我解答一下
<%@page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<jsp:useBean id="wu" scope="page" class="wu.jdbc" />
<body>
<%
String login = (String)session.getAttribute("login") ;
if(login==null){
out.println("您不是管理员!不能登陆删除");
}else{
Connection con = wu.getConn() ;
Statement stmt = con.createStatement() ;
String id = request.getParameter("id") ;
String name=request.getParameter("Username");
String Password =request.getParameter("Psd1");
//content = wu.ex_chinese(content) ;
String Company =request.getParameter("Companyname");
// qq = wu.ex_chinese(addr) ;
String Rname =request.getParameter("Rename");
// qq = wu.ex_chinese(tel) ;
//int tel = (int) tel ;
String Email =request.getParameter("Email");
String Phone =request.getParameter("Phone");
String sql = "update alluser set username='"+name+"',password='"+Password+"',company='"+Company+"',rname='"+Rname+"',email='"+Email+"',phone='"+Phone+"' where id="+id;
int rs=stmt.executeUpdate(sql);
try {
stmt.close();
con.close();
}
catch (Exception ex) {
}
response.sendRedirect("M_user_in.jsp");
}
%>
</body>
</html>
能具体说一下吗?那怎么 吧password 等参数传递过去啊?
数据没有更新成功,不知道是哪的问题
追答那就是了,有错你能更新出来么,看看你的sql有错么?