userlogin.java~103~

来自「bbs系统」· JAVA~103~ 代码 · 共 57 行

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


public class UserLogin
{ private ExecuteSqlBean exe;
  private String[] str=new String[3];

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

public String[] getData()
  {
    return this.str;
  }
/*login（）方法中的userinfo对象保存登录成功的用户的信息，在jsp中用到UserLogin Bean时就将userinfo
   中保存的信息再保存到session对象中*/
  public int Login( String name,String pwd)throws Exception
  { int tag;

    try
    {
       ResultSet result = exe.ExecuteSql("select * from userinfo where username='" +name + "'");
      if(result.next()==true)
      { if(result.getString("userpwd").equalsIgnoreCase(pwd) )
        { if(result.getInt("idstop")==1)
          {tag=3;}//3表示用户id被封
          else
          {
            str[0] = result.getString("userid");
            str[1] = name;
            str[2] = pwd;

            Date date = new java.sql.Date(new java.util.Date().getTime());
            ResultSet rst=exe.ExecuteSql("select logins from userinfo where username='"+str[1]+"'");
            rst.next();
            exe.ExecuteSql("update userinfo set logins=" + (1+rst.getInt(1)) +",online=1,lastlogdate='" + date +"' where username='" + str[1] + "'");

            tag = 2; //2表示登录成功
          }
        }
        else
         tag=1;//1表示用户密码不正确
      }
      else
        tag=0;//0表示数据库中没有该用户
      }
      catch(Exception e)
      { e.printStackTrace() ;
        throw e;
      }
  return tag;
  }
}