userupdate.java~14~

来自「bbs系统」· JAVA~14~ 代码 · 共 34 行

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

public class UserUpdate
{ private ExecuteSqlBean exe;


  public UserUpdate()
  { exe=new ExecuteSqlBean();
  }

/* 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
     {
      exe.ExecuteSql("update userinfo set username='"+name+"',usersex='"+sex+"',userpwd='"+pwd+"',pwdnotice='"+pwdno+"',pwdanswer='"+pwdan+"',useremail='"+email+"',usercomefrom='"+comefrom+"',usersign='"+sign+"' where username='"+userid+"'");
     }
    catch(Exception e)
     {e.printStackTrace() ;
     }
   }
}