谁有登录bean?Give me

[javawriter]

要实现判断1有无用户，2密码是否正确，3登录日期，4登录次数

[mechiland]

不会吧，这都要人帮你写？

[javawriter]

public int getLoginTimes(){
String sql = null;
String pwd1 = null;
try{
conn = DriverManager.getConnection(dbURL,dbLogin,dbPassword);
Statement stmt = conn.createStatement();
sql = "Select logintimes,true_name,login_pass from user_table where login_name='"+loginId+"'";
rs = stmt.executeQuery(sql);
if (!rs.next())
{
//返回没有此用户！
this.message = "-2";
}
while(rs.next()){
loginTimes = rs.getInt("logintimes");
trueName = rs.getString("true_name");
pwd1 = rs.getString("login_pass");
System.out.print(loginTimes);
}
if (pwd1.equals(passWord)){
//密码错误
this.message = "-1";
}
rs.close();
if(loginTimes!=-1){
sql = "Update user_table set logintimes = logintimes + 1 where login_name = '"+loginId+"'";
stmt.executeUpdate(sql);
}
stmt.close();
conn.close();
}catch(SQLException e){
e.printStackTrace();
}
return loginTimes;
}
提示：
nullpointException

[javawriter]

错在哪了？

[lsj_smile]

if (!rs.next())
{
//返回没有此用户！
this.message = "-2";
}
while(rs.next()){
loginTimes = rs.getInt("logintimes");
trueName = rs.getString("true_name");
pwd1 = rs.getString("login_pass");
System.out.print(loginTimes);
}
因为你用了两个next，导致已经定位到记录后面去了，所以得不到值，应该为
if (!rs.next())
{
//返回没有此用户！
this.message = "-2";
}
else{
do{
loginTimes = rs.getInt("logintimes");
trueName = rs.getString("true_name");
pwd1 = rs.getString("login_pass");
System.out.print(loginTimes);
}while(rs.next());
}

[9soul]

呵呵:)