modifyuser_manage.jsp

JSP论坛bb 毕业设计 文档加代码

<%@page contentType="text/html; charset=gb2312" language="java" import="java.sql.*,java.util.*"  %>
<jsp:useBean id="yy" scope="page" class="yy.jdbc"/>



<%!String User_Name,User_Password,sql,User_Sex,User_Email,User_Address,User_Mobile,User_Oicq,User_Birthay,User_Class,User_Sign;%>
<%
User_Name=request.getParameter("name");

//out.println(User_Name);
User_Password=request.getParameter("password");
User_Password=yy.ex_chinese(User_Password);
User_Sex=request.getParameter("sex");
User_Sex=yy.ex_chinese(User_Sex);
User_Email=request.getParameter("email");
User_Address=request.getParameter("address");
User_Address=yy.ex_chinese(User_Address);
User_Mobile=request.getParameter("mobile");
User_Oicq=request.getParameter("oicq");
User_Birthay=request.getParameter("birthday");
User_Birthay=yy.ex_chinese(User_Birthay);
User_Class=request.getParameter("userclass");
User_Class=yy.ex_chinese(User_Class);
User_Sign=request.getParameter("sign");
User_Sign=yy.ex_chinese(User_Sign);

Connection con=yy.getConn();
Statement  stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
sql="update 用户表 set 用户密码='"+User_Password+"',用户性别='"+User_Sex+"',用户邮箱='"+User_Email+"',居住地址='"+User_Address+"',手机号码='"+User_Mobile+"',Oicq='"+User_Oicq+"',出生日期='"+User_Birthay+"',用户等级='"+User_Class+"',签名='"+User_Sign+"' where 用户名='"+User_Name+"'";
//out.println(sql);
stmt.executeUpdate(sql);
out.println("<font size=2 color=blue>正在处理您的用户信息，请稍后...</font><meta http-equiv='refresh' content='2;url=user_manager.jsp'>");
%>
<jsp:include page="inc/online.jsp" flush="true"/>