userregist.java~146~

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

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

public class UserRegist
{
  private Statement stm;

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

    }

/*jsp中使用UserRegist Bean时需要传递一个保存了用户信息的userinfo对象*/


public int Regist(UserInfo userInfo)throws Exception
{ 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();
  Date date=new java.sql.Date(new java.util.Date().getTime());

  int face=userInfo.getFaceNum() ;

  int tag;
  ResultSet result;

   try
   {  result=stm.executeQuery("select * from userinfo where username='"+name+"'");

     if (result.next() ==false)
       { result=stm.executeQuery("select userid from userinfo where userid=(select max(userid) from userinfo)");
         int id=1;
         if(result.next())
         id=1+result.getInt(1);

        String sql="insert into userinfo(userid,username,usersex,userpwd,pwdnotice,pwdanswer,"+
        "useremail,usercomefrom,usersign,logins,online,plans,registerdate,lastlogdate,facenum) values("+id+",'"+
        name+"','"+sex+"','"+pwd+"','"+pwdno+"','"+pwdan+"','"+email+"','"+
        comefrom+"','"+sign+"',0,0,0,'"+registerdate+"','"+lastlogdate+"',"+face+")";

       stm.executeUpdate(sql);
       tag=1;//1表示用户注册成功！
     }
       else
       {tag=0;//0表示数据库中已有相同名称的用户！
       }
  }
   catch(Exception e)
    {
      e.printStackTrace();
     throw e;
     }
     stm.close();
     return tag;
}
}