?? userlogin.java~105~
字號:
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;
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -