/*
 * Copyright 1998-2010 Linux.org.ru
 *    Licensed under the Apache License, Version 2.0 (the "License");
 *    you may not use this file except in compliance with the License.
 *    You may obtain a copy of the License at
 *
 *        http://www.apache.org/licenses/LICENSE-2.0
 *
 *    Unless required by applicable law or agreed to in writing, software
 *    distributed under the License is distributed on an "AS IS" BASIS,
 *    WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 *    See the License for the specific language governing permissions and
 *    limitations under the License.
 */

package ru.org.linux.site;

import org.springframework.jdbc.support.JdbcUtils;

import java.sql.*;

public class BanInfo {
  private final Timestamp date;
  private final String reason;
  private final User moderator;

  public BanInfo(Timestamp date, String reason, User moderator) {
    this.date = date;
    this.reason = reason;
    this.moderator = moderator;
  }

  @Deprecated
  public static BanInfo getBanInfo(Connection db, User user) throws SQLException {
    Statement st = null;

    try {
      st = db.createStatement();
      ResultSet rs = st.executeQuery("SELECT * FROM ban_info WHERE userid="+user.getId());

      if (!rs.next()) {
        return null;
      } else {
        try {
          Timestamp date = rs.getTimestamp("bandate");
          String reason = rs.getString("reason");
          User moderator = User.getUserCached(db, rs.getInt("ban_by"));

          return new BanInfo(date, reason, moderator);
        } catch (UserNotFoundException e) {
          throw new RuntimeException(e);
        }
      }
    } finally {
      JdbcUtils.closeStatement(st);
    }
  }

  public Timestamp getDate() {
    return date;
  }

  public String getReason() {
    return reason;
  }

  public User getModerator() {
    return moderator;
  }
}

@@ -658,70 +658,26 @@
 ort 
-org.springframework.jdbc.support.JdbcUtils;%0A%0Aimport java.sql.*
+java.sql.Timestamp
 ;%0A%0Ap
@@ -908,16 +908,16 @@
 reason;%0A
+
     this
@@ -949,739 +949,8 @@
  %7D%0A%0A
-  @Deprecated%0A  public static BanInfo getBanInfo(Connection db, User user) throws SQLException %7B%0A    Statement st = null;%0A%0A    try %7B%0A      st = db.createStatement();%0A      ResultSet rs = st.executeQuery(%22SELECT * FROM ban_info WHERE userid=%22+user.getId());%0A%0A      if (!rs.next()) %7B%0A        return null;%0A      %7D else %7B%0A        try %7B%0A          Timestamp date = rs.getTimestamp(%22bandate%22);%0A          String reason = rs.getString(%22reason%22);%0A          User moderator = User.getUserCached(db, rs.getInt(%22ban_by%22));%0A%0A          return new BanInfo(date, reason, moderator);%0A        %7D catch (UserNotFoundException e) %7B%0A          throw new RuntimeException(e);%0A        %7D%0A      %7D%0A    %7D finally %7B%0A      JdbcUtils.closeStatement(st);%0A    %7D%0A  %7D%0A%0A
   pu

remove unised @deprecated method