userupdate.java~17~

用JSP写的论坛源代码 走过路过的各位千万不要错过啊！！！！

package bbs.beans.user;
import bbs.beans.dbcontact.ContactBean;
import bbs.beans.user.UserInfo;
import java.sql.*;

public class UserUpdate
{ private Statement stm;

  public UserUpdate()
    { ContactBean contact=new ContactBean();
       stm=contact.getStm();
  }

/* Update()方法中的形参userinfo为要修改用户的信息userid为要修改用户的名称*/
   public void Update(UserInfo userinfo,String userid)
   {
     String name=userinfo.getUserName();
     String sex=userinfo.getUserSex();
     String pwd=userinfo.getUserPwd();
     String pwdno=userinfo.getPwdNotice() ;
     String pwdan=userinfo.getPwdAnswer() ;
     String email=userinfo.getUserEmail();
     String comefrom=userinfo.getUserComeFrom();
     String sign=userinfo.getUserSign();
    int face =userinfo.getFaceNum() ;

    try
     {
      stm.executeUpdate("update userinfo set username='"+name+"',usersex='"+sex+"',userpwd='"+pwd+"',pwdnotice='"+pwdno+"',pwdanswer='"+pwdan+"',useremail='"+email+"',usercomefrom='"+comefrom+"',usersign='"+sign+"',facenum="+face+" where username='"+userid+"'");
     }
    catch(Exception e)
     {e.printStackTrace() ;
     }
   }
}