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


public class UserLogin
{ private Statement stm;
  private String[] str=new String[3];

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

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 = stm.executeQuery("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=stm.executeQuery("select logins from userinfo where username='"+str[1]+"'");
            rst.next();
            stm.executeQuery("update userinfo set logins=" + (1+rst.getInt(1)) +",online=1,lastlogdate='" + date +"' where username='" + str[1] + "'");
            tag = 2; //2表示登錄成功
            rst.close();
          }
        }
        else
         tag=1;//1表示用戶密碼不正確
      }
      else
        tag=0;//0表示數據庫中沒有該用戶
        result.close();
      }
      catch(Exception e)
      { e.printStackTrace() ;
        throw e;
      }
  return tag;
  }
}