Android Open Source - SandB-Android Image Table

From Project

Back to project page SandB-Android.
License

The source code is released under:
GNU General Public License
If you think the Android project SandB-Android listed in this page is inappropriate, such as containing malicious code/tools or violating the copyright, please email info at java2s dot com, thanks.
Java Source Code

package edu.grinnell.sandb.img;
/*  w w w  .  j a va2  s  . co m*/
import java.util.ArrayList;
import java.util.List;


import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;
import android.util.Log;

public class ImageTable {

  private static final String TAG = "ImageTable";

  // Database fields
  private SQLiteDatabase database;
  private ImageStorageHelper dbHelper;
  private String[] allColumns = { 
      ImageStorageHelper.COLUMN_ID,
      ImageStorageHelper.COLUMN_ARTICLEID, 
      ImageStorageHelper.COLUMN_URL,
      ImageStorageHelper.COLUMN_IMAGE,
      ImageStorageHelper.COLUMN_IMGTITLE, };

  public ImageTable(Context context) {
    dbHelper = new ImageStorageHelper(context);
  }

  public void open() throws SQLException {
    database = dbHelper.getWritableDatabase();
  }

  public void close() {
    dbHelper.close();
  }

  public void deleteImage(Image image) {
    long id = image.getId();
    Log.i(TAG, "Image deleted with id: " + id);
    database.delete(ImageStorageHelper.TABLE_IMAGES,
        ImageStorageHelper.COLUMN_ID + " = " + id, null);
  }

  public List<Image> getAllImages() {
    List<Image> images = new ArrayList<Image>();

    Cursor cursor = database.query(ImageStorageHelper.TABLE_IMAGES,
        allColumns, null, null, null, null, null);
    // SELECT allColumns.toString() from images where ISH.Column_URL = "http://im.a.ur/l;

    cursor.moveToFirst();
    while (!cursor.isAfterLast()) {
      Image image = cursorToImage(cursor);
      images.add(image);
      cursor.moveToNext();
    }
    // Make sure to close the cursor
    cursor.close();
    return images;
  }
  
  public Image findByUrl(String url) {
    Log.i("ImageTable.findByUrl", "url: " + url);
    Cursor cursor = database.query(ImageStorageHelper.TABLE_IMAGES,
        allColumns, ImageStorageHelper.COLUMN_URL + " = '" + url + "'", null, null, null, null);
    
    Image img = null;
    cursor.moveToFirst();
    if (!cursor.isAfterLast())
      img = cursorToImage(cursor);
    
    // Make sure to close the cursor
    cursor.close();
    return img;
  }
  
  public Image findByArticleId(int articleId) {
    Cursor cursor = database.query(ImageStorageHelper.TABLE_IMAGES,
        allColumns, ImageStorageHelper.COLUMN_ARTICLEID + " = " + articleId, null, null, null, null);
    
    Image img = null;
    cursor.moveToFirst();
    if (!cursor.isAfterLast())
      img = cursorToImage(cursor);
    
    // Make sure to close the cursor
    cursor.close();
    return img;
  }
  
  public String[] findUrlsByArticleId(int articleId) {
    Cursor cursor = database.query(ImageStorageHelper.TABLE_IMAGES,
        allColumns, ImageStorageHelper.COLUMN_ARTICLEID + " = " + articleId, null, null, null, null);
    
    String imgURLS[] = null;
      imgURLS = new String[20];
      int i = 0;
    
      cursor.moveToFirst();
    while (!cursor.isAfterLast()) {
      imgURLS[i] = cursorToURL(cursor);
      i++;
      cursor.moveToNext();
    }
    
    if (i > 0) {
    String resizedURLS[] = new String[i];
    for (int j=0; j < i; j++)
      resizedURLS[j] = imgURLS[j];
    return resizedURLS;
    }
    else return null;
    
  }
  
  public String[] findTitlesbyArticleId(int articleId) {
    Cursor cursor = database.query(ImageStorageHelper.TABLE_IMAGES,
        allColumns, ImageStorageHelper.COLUMN_ARTICLEID + " = " + articleId, null, null, null, null);
    
    String titles[] = null;
      titles = new String[20];
      int i = 0;
    
      cursor.moveToFirst();
    while (!cursor.isAfterLast()) {
      titles[i] = cursorToTitle(cursor);
      i++;
      cursor.moveToNext();
    }
    
    String resizedTitles[] = new String[i];
    for (int j=0; j < i; j++)
      resizedTitles[j] = titles[j];
    
    return resizedTitles;
  }

  public Image createImage(int articleID, String url, byte[] image, String imgTitle) {


    ContentValues values = new ContentValues();
    values.put(ImageStorageHelper.COLUMN_ARTICLEID, articleID);
    values.put(ImageStorageHelper.COLUMN_URL, url);
    values.put(ImageStorageHelper.COLUMN_IMAGE, image);
    values.put(ImageStorageHelper.COLUMN_IMGTITLE, imgTitle);
        
    long insertId = database.insert(ImageStorageHelper.TABLE_IMAGES, null,
        values);
    
    Cursor cursor = database.query(ImageStorageHelper.TABLE_IMAGES,
        allColumns, ImageStorageHelper.COLUMN_ID + " = " + insertId,
        null, null, null, null);

    cursor.moveToFirst();
    Image newImage = cursorToImage(cursor);
    cursor.close();
    return newImage;
  }

  private Image cursorToImage(Cursor cursor) {

    return new Image(cursor.getInt(0), cursor.getInt(1), cursor.getString(2), cursor.getBlob(3),
        cursor.getString(4));
  }
  
  private String cursorToURL(Cursor cursor) {
    return new String(cursor.getString(2));
  }
  
  private String cursorToTitle(Cursor cursor) {
    return new String(cursor.getString(4));
  }

  public void clearTable() {
    database.execSQL("DROP TABLE IF EXISTS "
        + ImageStorageHelper.TABLE_IMAGES);
    database.execSQL(ImageStorageHelper.DATABASE_CREATE);
  }
}
Java Source Code List
