modify_user.jsp

论坛元程序

<%@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,User_Question,sql,User_Answer,User_Email,User_Icon;%>
<%
User_Name=request.getParameter("name");
session.putValue("UserName",User_Name);
User_Password=request.getParameter("password");
User_Question=request.getParameter("question");
User_Answer=request.getParameter("answer");
User_Email=request.getParameter("email");
User_Icon=request.getParameter("icon");

Connection con=yy.getConn();
Statement  stmt=con.createStatement();
String sql="update User set user_name='"+User_Name+"',user_password='"+User_Password+"',email='"+User_Email+"',user_pic='"+User_Icon+"',question='"+User_Question+"',answer='"+User_Answer+"' where user_name='"+session.getValue("UserName")+"'";

stmt.executeUpdate(sql);
out.println("<font size=2 color=blue>正在处理您的用户信息，请稍后...</font><meta http-equiv='refresh' content='2;url=index.jsp'>");
%>