clientupdateinfaction.java

电子商务网站使用MVC模式B/S结构功能不是很全适合初学者看

package Client;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.util.*;
import Common.DBConnectBean;
//取得页面传递过来的用户资料
public class clientUpdateInfAction extends HttpServlet{
	public void doGet(HttpServletRequest request,HttpServletResponse response)throws IOException,ServletException{
		ServletContext application=getServletConfig().getServletContext(); 
		HttpSession session=request.getSession();
		request.setCharacterEncoding("gb2312");
		String username=session.getAttribute("username".toUpperCase()).toString();
		String sex=request.getParameter("sex");
		String identifyCard=request.getParameter("identifyCard")+"";
		String qq=request.getParameter("qq")+"";
		String email=request.getParameter("email")+"";
		String phone=request.getParameter("phone")+"";
		String address=request.getParameter("address")+"";
		String describe=request.getParameter("mes")+"";
		//获得当前注册日期
		Calendar nowCalendar=Calendar.getInstance();
		String regdate=nowCalendar.get(Calendar.YEAR)+"/"+
			(nowCalendar.get(Calendar.MONTH)+1)+"/"+
			nowCalendar.get(Calendar.DATE);
		//建立数据库连接并执行数据插入
		String strSQL="update  client set ";
			strSQL+="sex='"+sex+"',identifyCard='"+identifyCard+"',qq='"+qq+"',email='"+email+"',phone='"+phone+"',address='"+address+"',describe='"+describe+"'";
			strSQL+=" where username='"+username+"'";
		System.out.println(strSQL);	
		DBConnectBean dbConnectBean=new DBConnectBean("sun.jdbc.odbc.JdbcOdbcDriver","jdbc:odbc:shopping","","");
		boolean result=dbConnectBean.updata(strSQL);
	//	session.setAttribute("sql",strSQL);
		if(result){
			session.setAttribute("username".toUpperCase(),username);
			application.getRequestDispatcher("/client/clientList.jsp?done=1").forward(request,response);
		}else{
			application.getRequestDispatcher("/client/clientRegisterError.jsp").forward(request,response);
		}
	}
	public void doPost(HttpServletRequest request,HttpServletResponse response)throws IOException,ServletException{
	   	doGet(request,response);
	}
}