Common component for SQLite Database Access in iPhone/iPad Application Development

I have prepared a reusable component for sqlite, the same can be used as it is by making SVN-LINK to your into your project.

Common Database class includes the basic functionality of Accessing SQLite database, It contain different function that perform different operation on SQLite database.Main functions available in this class are Insert, delete, update record in the database, get total number of record in the table, check for duplication of record in the table and get record list from the table.

Whats New:
–> With resolving memory leaks

When you execute select query from your class. At that time you need to use retain for your resulted Array

For Example:
DataArr = [[ [Database shareDatabase] SelectAllFromTable:@”Select No,Name,Mobile from TestTbl”] retain ];

–> Resolve the crash issue for read Special character percentage(%) from Database

–> Include new function for getting sum of any column records.

You can use this class in your application just by passing your Query as an argument of function. Main functions included in this class are listed below.

- (void)Insert:(NSString )query
- (void)Delete:(NSString *)query
- (void)Update:(NSString *)query
- (BOOL)CheckForRecord:(NSString *)query
- (int)getCount:(NSString *)query
- (int)GetSum:(NSString)query
- (NSMutableArray *)SelectAllFromTable:(NSString *)query

First time when you launch application at that time this method is useful for copy database from application bundle to your Application Document Directory.

-(BOOL) createEditableCopyOfDatabaseIfNeeded

For Getting Database Path use below method

- (NSString *) GetDatabasePath:(NSString *)dbName

For Programming and understanding flow of coding you can go through:

Class Description:

1) Database.h


Code Link:- Database.h Sample Code

This class includes declaration of all objects and methods used in application.

2) Database.m

Code Link:- Database.m Sample Code

This class includes definition of all methods and main logic for Database Operation.

Read Full Post »

Create Reusable Cell UITableViewCell

In iOS Application Development we use custom Table Cell

At time we need to use dequeueReusableCellWithIdentifier for create Cell.

So here i make on class in that i define dequeOrCreateInTable one class method so you can directly call this way in your UITableview delegate cellForRowAtIndexPath method.

TableCell *cell =[TableCell dequeOrCreateInTable:tableView];

you also need to #import “UITableViewCell+NIB.h”

here i attach code for this both file you can create your file and put this code in that file and use.

1) UITableViewCell+Nib.h

Code Link:- UITableViewCell+Nib.h Sample Code

2) UITableViewCell+Nib.m

Code Link:- UITableViewCell+Nib.m Sample Code

Read Full Post »