moduserinfoact.jsp

本论坛开发环境：jdk1.5+Tomcat5.5.17+sql server2000+Windows 2000 1、支持HTML内容编辑,支持网络贴图与附件上传等,支持多种版面风格. 2、论坛

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*"%>
<%@ page import="java.sql.*"%> 
<%@ page import="java.util.*"%>
<%@ page import="java.util.Date"%>
<%@ page import="java.text.*"%>
<%@ include file="../inc/conn.jsp"%>
<%@ include file="../inc/md5.jsp"%>
<%@ include file="checkbbsuser.jsp"%>
<%!String sql;%>
<%
String img=request.getParameter("img");
String bbsuser=new String(request.getParameter("bbsuser").getBytes("iso-8859-1"));
String clubuser_sex=new String(request.getParameter("sex").getBytes("iso-8859-1"));
String oldpassword=new String(request.getParameter("oldpassword").getBytes("iso-8859-1"));
String password=new String(request.getParameter("password").getBytes("iso-8859-1"));
String question=new String(request.getParameter("question").getBytes("iso-8859-1"));
String answer=new String(request.getParameter("answer").getBytes("iso-8859-1"));
String email=new String(request.getParameter("email").getBytes("iso-8859-1"));
String signname=new String(request.getParameter("signname").getBytes("iso-8859-1"));
String IP=request.getRemoteAddr();
oldpassword=md5(oldpassword);
password=md5(password);
answer=md5(answer);
Date currTime = new Date();
SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss",Locale.US);
String ftime=new String(formatter.format(currTime).getBytes("iso-8859-1"));

ResultSet rs1;
String str="select * from clubuser where clubuser_name='"+username+"'";
Statement stmt1=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs1=stmt1.executeQuery(str);
if(rs1.next()){
     if(rs1.getString("clubuser_password").equals(oldpassword)){
	 }
	 else{
	 out.print("<center><br><br><br><br>你的旧密码不正确,修改不成功！</center>");
	 out.close();
	 return;
	 }
}

if(signname==null||signname.equals("")||email==null||email.equals("")){
sql="update clubuser set clubuser_name='"+bbsuser+"',clubuser_password='"+password+"',clubuser_question='"+question+"',clubuser_answer='"+answer+"',clubuser_sex='"+clubuser_sex+"',clubuser_ip='"+IP+"',userimg='"+img+"' where clubuser_name='"+username+"'";
}
else{
sql="update clubuser set clubuser_name='"+bbsuser+"',clubuser_password='"+password+"',clubuser_question='"+question+"',clubuser_answer='"+answer+"',clubuser_sex='"+clubuser_sex.trim()+"',clubuser_email='"+email+"',clubuser_ip='"+IP+"',userimg='"+img+"',signname='"+signname+"' where clubuser_name='"+username+"'";
}

stmt.executeUpdate(sql);
out.print("<script>");
out.print("alert('恭喜你，修改个人信息成功!');");
out.print("window.location.href='moduserinfo.jsp';");
out.print("</script>");
%>