actmodify.jsp

来自「现今的社会是一个信息飞速发达的社会」· JSP 代码 · 共 32 行

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<jsp:useBean id="con" scope="page" class="numb1.com.db"/>
<%
String id=null;id=(String)session.getAttribute("id");
request.setCharacterEncoding("gb2312");
String user_mail=request.getParameter("mail");

String user_question=con.gb2iso(request.getParameter("question"));
String user_answer =con.gb2iso(request.getParameter("answer"));
String user_name=con.gb2iso(request.getParameter("name"));
String user_sex=request.getParameter("sex");
String em=request.getParameter("em");
String user_qq=con.gb2iso(request.getParameter("qq"));
String user_web=con.gb2iso(request.getParameter("web"));
String user_tel=con.gb2iso(request.getParameter("tel"));
String user_comefrom=request.getParameter("comefrom");
String come=request.getParameter("fu_province")+"-"+request.getParameter("fu_city");if("---".equals(come)){come=user_comefrom;}
String user_job=con.gb2iso(request.getParameter("job"));
String user_love=con.gb2iso(request.getParameter("love"));
String user_aboutme=con.gb2iso(request.getParameter("aboutme"));
String birth=request.getParameter("year")+"-"+request.getParameter("month")+"-"+request.getParameter("day");
String sql;

sql="update numb1 set mail='"+user_mail+"' where userid='"+id+"'";
con.update(sql);

come=con.gb2iso(come);
sql="update user set question='"+user_question+"',answer='"+user_answer+"',name='"+user_name+"',sex='"+user_sex+"',birth='"+birth+"',mail='"+em+"',qq='"+user_qq+"',web='"+user_web+"',tel='"+user_tel+"',comefrom='"+come+"',job='"+user_job+"',love='"+user_love+"',aboutme='"+user_aboutme+"' where userid='"+id+"'";
con.update(sql);
response.sendRedirect("../index.jsp");

%>