modifyuserinfoservlet.java

jsp+javabean写的论坛

package com.alumni.servlet;
import javax.servlet.jsp.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.sql.*;
import java.util.*;
import com.alumni.bean.*;
import com.jspsmart.upload.*;
public class ModifyUserInfoServlet extends HttpServlet
{
	ServletConfig config;
	public void init(ServletConfig config) throws ServletException
	{
		this.config=config;
		super.init(config);
	}
	
	//调用doPost方法
	public void doGet(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException
	{
		this.doPost(request,response);
	}
	
	//doPost核心方法
	public void doPost(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException
	{
		SmartUpload su=null;
		//使用SmartUpload组件的request对象
		Request req=null;
		
		//session
		HttpSession session=request.getSession();
		//out
		PrintWriter out=response.getWriter();
		//application
		ServletContext application=this.getServletConfig().getServletContext();
		
		DBConnection dbConn=null;
		Connection conn=null;
		
		String loginUserID="";
		int userID=0;
		String password="";
		String head="";
		String email="";
		String realName="";
		String qq="";
		String msn="";
		
		try
		{
			//初始化SmartUpload对象
			su=new SmartUpload();
			su.initialize(config,request,response);
			//设定最大上传的文件大小
			su.setMaxFileSize(50000);
			su.setTotalMaxFileSize(50000);
			//设定允许上传的文件格式
			su.setAllowedFilesList("jpg,gif,png");
			su.upload();
			
			//获取表单数据对象
			req=su.getRequest();
			
			com.jspsmart.upload.Files files=su.getFiles();
			com.jspsmart.upload.File file=files.getFile(0);
			//利用SmartUpload的Request对象提取表单数据
			password=req.getParameter("password");
			loginUserID=(String)session.getAttribute("userID");
			userID=Integer.parseInt(loginUserID);
			realName=req.getParameter("realname");
			email=req.getParameter("email");
			qq=req.getParameter("qq");
			msn=req.getParameter("msn");
			if(!file.isMissing())
			{
				//如果表单有值就另存为
				String fileExt=file.getFileExt();
				//文件另存为
				java.util.Date time=new java.util.Date();
				Long preFile=new Long(time.getTime());
				String fileName="/upload/uploadHead/"+preFile.toString()+"."+fileExt;
				file.saveAs(fileName,su.SAVE_VIRTUAL);
				head=fileName;
			}
			else
			{
				head="/image/head/"+req.getParameter("head");
			}
			//打开数据库
			dbConn=new DBConnection();
			conn=dbConn.getConnectionToAccess(application.getRealPath("db/alumni.mdb"));
			Statement stmt=conn.createStatement();
			String sql="UPDATE USERINFO SET PASSWORD='"+password+"',REALNAME='"+realName+"',EMAIL='"+email+"',QQ='"+qq+"',MSN='"+msn+"',HEAD='"+head+"' WHERE ID="+userID;
			stmt.executeUpdate(sql);
			if(dbConn!=null)
			{
				dbConn.close();
			}
			response.sendRedirect("/userinfo.jsp?uid="+userID);
		}
		catch(SmartUploadException s)
		{
			if(dbConn!=null)
			{
				dbConn.close();
			}
			response.sendRedirect("/error.jsp?code=SmartUploadException");
		}
		
		catch(SQLException sqle)
		{
			if(dbConn!=null)
			{
				dbConn.close();
			}
			//out.println(sqle.toString());
			response.sendRedirect("/error.jsp?code=SQLException");
		}
		catch(Exception e)
		{
			if(dbConn!=null)
			{
				dbConn.close();
			}
			response.sendRedirect("/error.jsp?code=UnknownException");
		}
	}
}