private void isHalfOfHours(UserInfo user) {
String sql = "select count(*) count from USER_LOGIN_FAIL ulf where ulf.user_id =? and to_char(ulf.last_fail_time,'yyyymmdd HH24:mi') between to_char(sysdate-1/48,'yyyymmdd HH24:mi') and to_char(sysdate,'yyyymmdd HH24:mi')";
/*
String str = jdbcTemplate.execute(sql,new PreparedStatementCallback<String>(){
public String doInPreparedStatement(PreparedStatement ps) throws SQLException, DataAccessException {
ResultSet rs = ps.executeQuery();
String result = null;
if(rs.next()){
result = rs.getString("count");
}
return result;
}
});*/
String str = jdbcTemplate.query(sql,new ResultSetExtractor<String>(){
public String extractData(ResultSet rs) throws SQLException, DataAccessException {
String result = null;
if(rs.next()){
result = rs.getString("count");
}
return result;
}}, user.id);
//0表示上次失败记录已经超过半小时,自动清除历史记录,否则表示上次失败变动未超过半小时,不会自动清除
if(str.equals("0")){
deleteFailRecord(user);
//管理员还需要清除解锁记录
if(user.id.equals("sysadmin") || user.id.equals("syssecurity") || user.id.equals("sysaudit")){
deleteUnlockRecord(user);
}
}
}
String sql = "select count(*) count from USER_LOGIN_FAIL ulf where ulf.user_id =? and to_char(ulf.last_fail_time,'yyyymmdd HH24:mi') between to_char(sysdate-1/48,'yyyymmdd HH24:mi') and to_char(sysdate,'yyyymmdd HH24:mi')";
/*
String str = jdbcTemplate.execute(sql,new PreparedStatementCallback<String>(){
public String doInPreparedStatement(PreparedStatement ps) throws SQLException, DataAccessException {
ResultSet rs = ps.executeQuery();
String result = null;
if(rs.next()){
result = rs.getString("count");
}
return result;
}
});*/
String str = jdbcTemplate.query(sql,new ResultSetExtractor<String>(){
public String extractData(ResultSet rs) throws SQLException, DataAccessException {
String result = null;
if(rs.next()){
result = rs.getString("count");
}
return result;
}}, user.id);
//0表示上次失败记录已经超过半小时,自动清除历史记录,否则表示上次失败变动未超过半小时,不会自动清除
if(str.equals("0")){
deleteFailRecord(user);
//管理员还需要清除解锁记录
if(user.id.equals("sysadmin") || user.id.equals("syssecurity") || user.id.equals("sysaudit")){
deleteUnlockRecord(user);
}
}
}