Пример #1
0
 /** {@inheritDoc} */
 public String retrieve(long id, Connection conn)
     throws EntityDoesNotExistException, SQLException {
   if (cache != null && id < cache.length) {
     String value = cache[(int) id];
     if (value != null) {
       return value;
     }
   }
   Statement stmt = conn.createStatement();
   ResultSet rs = null;
   try {
     rs = stmt.executeQuery("SELECT data FROM " + getTable() + " WHERE data_key = " + id);
     if (!rs.next()) {
       throw new EntityDoesNotExistException(
           "Item #" + id + " does not exist in table " + getTable());
     }
     String value = unescape(rs.getString(1));
     if (cache != null && id < cache.length) {
       cache[(int) id] = value;
     }
     return value;
   } finally {
     DatabaseUtils.close(rs);
     DatabaseUtils.close(stmt);
   }
 }
Пример #2
0
  /** {@inheritDoc} */
  public long create(String value, Connection conn) throws SQLException {
    String str = value;
    if (str.length() > 255) {
      throw new IllegalArgumentException(
          "maximum lenght of string attributes "
              + "is 255 characters. Use text attributes "
              + "wherever greater capacity is desired");
    }

    long id = getNextId();
    Statement stmt = conn.createStatement();
    try {
      stmt.execute(
          "INSERT INTO "
              + getTable()
              + "(data_key, data) VALUES ("
              + id
              + ", '"
              + escape(str)
              + "')");
      return id;
    } finally {
      DatabaseUtils.close(stmt);
    }
  }
Пример #3
0
 /** {@inheritDoc} */
 public void preload(Connection conn) throws SQLException {
   Statement stmt = conn.createStatement();
   ResultSet rs = null;
   try {
     rs = stmt.executeQuery("SELECT max(data_key) from " + getTable());
     rs.next();
     int count = rs.getInt(1);
     cache = new String[count + 1];
     rs.close();
     rs = stmt.executeQuery("SELECT data_key, data from " + getTable());
     while (rs.next()) {
       cache[rs.getInt(1)] = unescape(rs.getString(2));
     }
   } finally {
     DatabaseUtils.close(rs);
     DatabaseUtils.close(stmt);
   }
 }
Пример #4
0
 /** {@inheritDoc} */
 public void update(long id, String value, Connection conn)
     throws EntityDoesNotExistException, SQLException {
   String str = value;
   if (str.length() > 255) {
     throw new IllegalArgumentException(
         "maximum lenght of string attributes "
             + "is 255 characters. Use text attributes "
             + "wherever greater capacity is desired");
   }
   if (cache != null && id < cache.length) {
     cache[(int) id] = str;
   }
   Statement stmt = conn.createStatement();
   try {
     checkExists(id, stmt);
     stmt.execute(
         "UPDATE " + getTable() + " SET data = '" + escape(str) + "' WHERE data_key = " + id);
   } finally {
     DatabaseUtils.close(stmt);
   }
 }