Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package database.in;
- import java.util.ArrayList;
- import java.util.List;
- import com.hellovx100.in.Contact;
- import android.R.integer;
- import android.content.ContentValues;
- import android.content.Context;
- import android.database.Cursor;
- import android.database.sqlite.SQLiteDatabase;
- import android.database.sqlite.SQLiteOpenHelper;
- public class ProductDbHandler extends SQLiteOpenHelper{
- public ProductDbHandler(Context context) {
- super(context, database.in.DatabaseAndTableNames.DATABASE_NAME,null,database.in.DatabaseAndTableNames.DATABASE_VERSION);
- }
- @Override
- public void onCreate(SQLiteDatabase db) {
- String CREATE_PRODUCT_TABLE = "CREATE TABLE " + database.in.DatabaseAndTableNames.TABLE_PRODUCT_DETAILS + "("
- + database.in.DatabaseAndTableNames.PRODUCT_SKU_COLUMN + " INTEGER PRIMARY KEY," + database.in.DatabaseAndTableNames.PRODUCT_ID_COLUMN + " TEXT,"
- + database.in.DatabaseAndTableNames.PRODUCT_NAME_COLUMN + " TEXT," +database.in.DatabaseAndTableNames.PRODUCT_THUMBNAIL_IMAGE_COLUMN+" TEXT,"
- + database.in.DatabaseAndTableNames.PRODUCT_DISCRIPTION_COLUMN+"TEXT,"+database.in.DatabaseAndTableNames.PRODUCT_WEIGHT_COLUMN+"TEXT,"
- + database.in.DatabaseAndTableNames.PRODUCT_CREATED_AT_COLUMN+"TEXT,"+database.in.DatabaseAndTableNames.PRODUCT_UPDATED_AT_COLUMN+"TEXT,"
- + database.in.DatabaseAndTableNames.PRODUCT_PRICE_COLUMN+"TEXT,"+database.in.DatabaseAndTableNames.PRODUCT_SPECIAL_PRICE_COLUMN+"TEXT,"
- + database.in.DatabaseAndTableNames.PRODUCT_TEX_ID_COLUMN+"TEXT,"+database.in.DatabaseAndTableNames.PRODUCT_CATEGORY_ID_COLUMN+"TEXT,"
- + database.in.DatabaseAndTableNames.PRODUCT_CATEGORY_NAME_COLUMN+"TEXT"+")";
- db.execSQL(CREATE_PRODUCT_TABLE);
- }
- @Override
- public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
- // Drop older table if existed
- db.execSQL("DROP TABLE IF EXISTS " + database.in.DatabaseAndTableNames.TABLE_PRODUCT_DETAILS);
- // Create tables again
- onCreate(db);
- }
- /**
- * All CRUD(Create, Read, Update, Delete) Operations
- */
- // Adding new contact
- public void addProducts(GetProductInfo getProductInfo) {
- SQLiteDatabase db = this.getWritableDatabase();
- ContentValues values = new ContentValues();
- values.put( database.in.DatabaseAndTableNames.PRODUCT_SKU_COLUMN, getProductInfo.getProductSku());
- values.put( database.in.DatabaseAndTableNames.PRODUCT_ID_COLUMN, getProductInfo.getProductID());
- values.put(database.in.DatabaseAndTableNames.PRODUCT_NAME_COLUMN, getProductInfo.getProductName());
- values.put(database.in.DatabaseAndTableNames.PRODUCT_THUMBNAIL_IMAGE_COLUMN, getProductInfo.getThumbnail());
- values.put(database.in.DatabaseAndTableNames.PRODUCT_DISCRIPTION_COLUMN, getProductInfo.getProductDiscription());
- values.put(database.in.DatabaseAndTableNames.PRODUCT_WEIGHT_COLUMN, getProductInfo.getProductWeight());
- values.put(database.in.DatabaseAndTableNames.PRODUCT_CREATED_AT_COLUMN, getProductInfo.getProductCreatedAt());
- values.put(database.in.DatabaseAndTableNames.PRODUCT_UPDATED_AT_COLUMN, getProductInfo.getProductUpdatedAt());
- values.put(database.in.DatabaseAndTableNames.PRODUCT_PRICE_COLUMN, getProductInfo.getProductPrice());
- values.put(database.in.DatabaseAndTableNames.PRODUCT_SPECIAL_PRICE_COLUMN, getProductInfo.getProductSpecialPrice());
- values.put(database.in.DatabaseAndTableNames.PRODUCT_TEX_ID_COLUMN, getProductInfo.getProductTexId());
- values.put(database.in.DatabaseAndTableNames.PRODUCT_CATEGORY_ID_COLUMN, getProductInfo.getProductCategoryId());
- values.put(database.in.DatabaseAndTableNames.PRODUCT_CATEGORY_NAME_COLUMN, getProductInfo.getProductCategoryName());
- // Inserting Row
- db.insert( database.in.DatabaseAndTableNames.TABLE_PRODUCT_DETAILS, null, values);
- db.close(); // Closing database connection
- }
- // Getting single contact
- GetProductInfo getProducts(int id) {
- SQLiteDatabase db = this.getReadableDatabase();
- Cursor cursor = db.query( database.in.DatabaseAndTableNames.TABLE_PRODUCT_DETAILS, new String[] { database.in.DatabaseAndTableNames.KEY_ID,
- database.in.DatabaseAndTableNames.KEY_NAME, database.in.DatabaseAndTableNames.KEY_PH_NO }, database.in.DatabaseAndTableNames.KEY_ID + "=?",
- new String[] { String.valueOf(id) }, null, null, null, null);
- if (cursor != null)
- cursor.moveToFirst();
- GetProductInfo getProducts = new GetProductInfo();
- // return contact
- return getProducts;
- }
- // Getting All Contacts
- public List<GetProductInfo> getAllProducts() {
- List<GetProductInfo> productList = new ArrayList<GetProductInfo>();
- // Select All Query
- String selectQuery = "SELECT * FROM " + database.in.DatabaseAndTableNames.TABLE_PRODUCT_DETAILS;
- SQLiteDatabase db = this.getWritableDatabase();
- Cursor cursor = db.rawQuery(selectQuery, null);
- try{
- // looping through all rows and adding to list
- if (cursor.moveToFirst()) {
- do {
- GetProductInfo getProductInfo = new GetProductInfo();
- getProductInfo.setProductID(Integer.parseInt(cursor.getString(1)));
- getProductInfo.setProductName(cursor.getString(2));
- getProductInfo.setThumbnail(cursor.getString(3));
- getProductInfo.setProductDiscription(cursor.getString(4));
- getProductInfo.setProductWeight(Float.parseFloat(cursor.getString(5)));
- getProductInfo.setProductCreatedAt(cursor.getString(6));
- getProductInfo.setProductUpdatedAt(cursor.getString(7));
- getProductInfo.setProductPrice(Float.parseFloat(cursor.getString(8)));
- getProductInfo.setProductSpecialPrice(Float.parseFloat(cursor.getString(9)));
- getProductInfo.setProductTexId(Integer.parseInt(cursor.getString(10)));
- getProductInfo.setProductCategoryId((cursor.getString(11)));
- getProductInfo.setProductCategoryName(cursor.getString(12));
- // Adding contact to list
- productList.add(getProductInfo);
- } while (cursor.moveToNext());
- }
- // return contact list
- }
- catch(Exception e){
- }
- finally{
- cursor.close();
- }
- return productList;
- }
- // Getting contacts Count
- public int getContactsCount() {
- String countQuery = "SELECT * FROM " + database.in.DatabaseAndTableNames.TABLE_PRODUCT_DETAILS;
- SQLiteDatabase db = this.getReadableDatabase();
- Cursor cursor = db.rawQuery(countQuery, null);
- cursor.close();
- // return count
- return cursor.getCount();
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement