In this Post I will discuss about creating your own database and
writing functions for Insertion, Deletion and Updation of Data in
Table.
and overside the methods onCreate, onUpgrade
public class DataBaseHelper extends SQLiteOpenHelper
{
public DataBaseHelper (Context context, String name,CursorFactory factory, int version)
{
super(context, name, factory, version);
}
// Called when no database exists in disk and the helper class needs
// to create a new one.
@Override
public void onCreate(SQLiteDatabase _db)
{
// statement to create the Table
_db.execSQL(SMSBlockerDataBaseAdapter.DATABASE_CREATE);
}
// Called when there is a database version mismatch meaning that the version
// of the database on disk needs to be upgraded to the current version.
@Override
public void onUpgrade(SQLiteDatabase _db, int _oldVersion, int _newVersion)
{
// Log the version upgrade.
Log.w("TaskDBAdapter", "Upgrading from version " +_oldVersion + " to " +_newVersion + ", which will destroy all old data");
// Upgrade the existing database to conform to the new version. Multiple
// previous versions can be handled by comparing _oldVersion and _newVersion
// values.
// The simplest case is to drop the old table and create a new one.
_db.execSQL("DROP TABLE IF EXISTS " + "SMSTABLE");
// Create a new one.
onCreate(_db);
}
}
We create a DataBaseAdpater class and write the functions for following tasks
In the example Code given below I have created a Table to store SMSes with following Columns
Id: Primary Key of the Table
Sender Name: Name of SMS Sender
Sender Number: Phone Number of the Sender
Time: date and time (In Miliseconds) at which SMS is received
To Insert a new Record in Table we need to create an Object of ContentValues class and put the Values in this like:
ContentValues newValues = new ContentValues();
// Assign values for each row.
newValues.put("COLUMN_NAME1", values);
newValues.put("COLUMN_NAME2", values);
and so on
then
// Insert the row into your table
db.insert("TABLENAME", null, newValues);
we can delete a row from the Table with delete method
delete("TABLE ANME",String where, String[] valuesForWhere)
for Ex:
String where="ID=?";
int numberOFEntriesDeleted= db.delete("BLOCKEDSMSTABLE", where, new String[]{ID}) ;
will delete the Record containing IDs in new String[]{ID} array.
public Cursor getAllEntries ()
{
return db.query("BLOCKEDSMSTABLE", null,null, null, null, null, "TIME DESC");
}
TIME DESC will fetch in descending order of Time , Pass null to fetch in Ascending Order because by Deafault it fetches in ascending Order
Task task=new Task();
Cursor cursor=db.query("BLOCKEDSMSTABLE", null, " ID=?", new String[]{ID}, null, null, null);
"ID=?" at RunTime ? will be replaced by string in the Array OF String passed as 4th parameter
the above query will fetch all the records containing the IDs in String Array(4th parameter)
Updating The Table
Updating is little similar to Inserting a record in Table
to update the table we need to create an Object of ContentValues and put the new Values in ContentValues object
ContentValues updatedValues = new ContentValues();
// Assign new values for each row.
updatedValues.put("TIME", taskToBeUpdated.time);
updatedValues.put("MESSAGE",taskToBeUpdated.message);
updatedValues.put("RECIPIENTNUMBER",taskToBeUpdated.recipientNumber);
updatedValues.put("RECIPIENTNAME", taskToBeUpdated.recipientName);
String where="ID = ?";
db.update("SMSTABLE",updatedValues, where, new String[]{ID});
You can Modify the where variable as per your requirement like where "EMP_ID=" etc.
Create an Instance of DataBaseAdapter
Open the DataAbse
Call the Functions/Methods
SMSSchedulerDataBaseAdapter smsSchedulerDataBaseAdapter =new SMSSchedulerDataBaseAdapter(this);
smsSchedulerDataBaseAdapter=smsSchedulerDataBaseAdapter.open();
smsSchedulerDataBaseAdapter.insertEntry(yourParameter);
smsSchedulerDataBaseAdapter.getAllEntries();
public class SMSBlockerDataBaseAdapter
{
// Name of the database
static final String DATABASE_NAME = "SMSBLOCKERDATABASE.db";
// database version if creating first time it should be 1
static final int DATABASE_VERSION = 1;
public static final int NAME_COLUMN = 1;
// TODO: Create public field for each column in your table.
// SQL Statement to create a new database.
static final String DATABASE_CREATE = "create table BLOCKEDSMSTABLE " +
"( " +"ID integer primary key autoincrement,MESSAGE text, SENDERNUMBER text, SENDERNAME text, TIME integer ); ";
// Variable to hold the database instance
public SQLiteDatabase db;
// Context of the application using the database.
private final Context context;
// Database open/upgrade helper
private DataBaseHelper dbHelper;
public SMSBlockerDataBaseAdapter(Context _context)
{
context = _context;
dbHelper = new DataBaseHelper(context, DATABASE_NAME, null, DATABASE_VERSION);
}
// Open the Database
public SMSBlockerDataBaseAdapter open() throws SQLException
{
db = dbHelper.getWritableDatabase();
return this;
}
// Close the Database
public void close()
{
db.close();
}
public SQLiteDatabase getDatabaseInstance()
{
return db;
}
// to Insert A record in Table
public void insertEntry(Task taskToInsert)
{
// TODO: Create a new ContentValues to represent the row
// and insert it into the database.
ContentValues newValues = new ContentValues();
// Assign values for each row.
newValues.put("MESSAGE", taskToInsert.message);
newValues.put("SENDERNUMBER",taskToInsert.senderNumber);
newValues.put("SENDERNAME", taskToInsert.senderName);
newValues.put("TIME",taskToInsert.time);
// Insert the row into your table
db.insert("BLOCKEDSMSTABLE", null, newValues);
}
public int deleteEntry(String ID)
{
String where="ID=?";
int numberOFEntriesDeleted= db.delete("BLOCKEDSMSTABLE", where, new String[]{ID}) ;
return numberOFEntriesDeleted;
}
public void deleteOlderEntries()
{
String olderTime=String.valueOf(new GregorianCalendar().getTimeInMillis()-7*24*60*60*1000);
String where="TIME < ?";
int numberOFEntriesDeleted= db.delete("BLOCKEDSMSTABLE", where, new String[]{olderTime}) ;
Toast.makeText(context, "Number Of Entries Deleted "+numberOFEntriesDeleted, Toast.LENGTH_LONG).show();
}
public Cursor getAllEntries ()
{
return db.query("BLOCKEDSMSTABLE", null,null, null, null, null, "TIME DESC");
}
public Task getSinlgeEntry(String ID)
{
Task task=new Task();
Cursor cursor=db.query("BLOCKEDSMSTABLE", null, " ID=?", new String[]{ID}, null, null, null);
if(cursor.getCount()==0)
{
return null;
}
cursor.moveToFirst();
task.id= cursor.getString(cursor.getColumnIndex("ID"));
task.message = cursor.getString(cursor.getColumnIndex("MESSAGE"));
task.senderNumber = cursor.getString(cursor.getColumnIndex("SENDERNUMBER"));
task.senderName = cursor.getString(cursor.getColumnIndex("SENDERNAME"));
task.time = Long.parseLong(cursor.getString(cursor.getColumnIndex("TIME")));
task.reason=cursor.getString(cursor.getColumnIndex("REASON"));
//Log.i("getSingle Entry ID: "+"PhoneNumber "+task.senderName+" "+task.message,ID);
cursor.close();
return task;
}
}
DataBaseHelper:
We will use SQLiteOpenHelper class and extend this classand overside the methods onCreate, onUpgrade
public class DataBaseHelper extends SQLiteOpenHelper
{
public DataBaseHelper (Context context, String name,CursorFactory factory, int version)
{
super(context, name, factory, version);
}
// Called when no database exists in disk and the helper class needs
// to create a new one.
@Override
public void onCreate(SQLiteDatabase _db)
{
// statement to create the Table
_db.execSQL(SMSBlockerDataBaseAdapter.DATABASE_CREATE);
}
// Called when there is a database version mismatch meaning that the version
// of the database on disk needs to be upgraded to the current version.
@Override
public void onUpgrade(SQLiteDatabase _db, int _oldVersion, int _newVersion)
{
// Log the version upgrade.
Log.w("TaskDBAdapter", "Upgrading from version " +_oldVersion + " to " +_newVersion + ", which will destroy all old data");
// Upgrade the existing database to conform to the new version. Multiple
// previous versions can be handled by comparing _oldVersion and _newVersion
// values.
// The simplest case is to drop the old table and create a new one.
_db.execSQL("DROP TABLE IF EXISTS " + "SMSTABLE");
// Create a new one.
onCreate(_db);
}
}
SMSBlockerDataBaseAdapter
We create a DataBaseAdpater class and write the functions for following tasks
- to Open the database
- to close the database
- to insert a new Row/Record in Database
- to delete one or more Records in Database
- to update the database
In the example Code given below I have created a Table to store SMSes with following Columns
Id: Primary Key of the Table
Sender Name: Name of SMS Sender
Sender Number: Phone Number of the Sender
Time: date and time (In Miliseconds) at which SMS is received
Inserting a new Record in table
To Insert a new Record in Table we need to create an Object of ContentValues class and put the Values in this like:
ContentValues newValues = new ContentValues();
// Assign values for each row.
newValues.put("COLUMN_NAME1", values);
newValues.put("COLUMN_NAME2", values);
and so on
then
// Insert the row into your table
db.insert("TABLENAME", null, newValues);
Deleting a Record from Table
we can delete a row from the Table with delete method
delete("TABLE ANME",String where, String[] valuesForWhere)
for Ex:
String where="ID=?";
int numberOFEntriesDeleted= db.delete("BLOCKEDSMSTABLE", where, new String[]{ID}) ;
will delete the Record containing IDs in new String[]{ID} array.
To get All the Record in the Table
public Cursor getAllEntries ()
{
return db.query("BLOCKEDSMSTABLE", null,null, null, null, null, "TIME DESC");
}
TIME DESC will fetch in descending order of Time , Pass null to fetch in Ascending Order because by Deafault it fetches in ascending Order
To get 1 or more records depending on Some Condition
Task task=new Task();
Cursor cursor=db.query("BLOCKEDSMSTABLE", null, " ID=?", new String[]{ID}, null, null, null);
"ID=?" at RunTime ? will be replaced by string in the Array OF String passed as 4th parameter
the above query will fetch all the records containing the IDs in String Array(4th parameter)
Updating The Table
Updating is little similar to Inserting a record in Table
to update the table we need to create an Object of ContentValues and put the new Values in ContentValues object
ContentValues updatedValues = new ContentValues();
// Assign new values for each row.
updatedValues.put("TIME", taskToBeUpdated.time);
updatedValues.put("MESSAGE",taskToBeUpdated.message);
updatedValues.put("RECIPIENTNUMBER",taskToBeUpdated.recipientNumber);
updatedValues.put("RECIPIENTNAME", taskToBeUpdated.recipientName);
String where="ID = ?";
db.update("SMSTABLE",updatedValues, where, new String[]{ID});
You can Modify the where variable as per your requirement like where "EMP_ID=" etc.
How to use this DataBaseAdapter Class in Activities
Create an Instance of DataBaseAdapter
Open the DataAbse
Call the Functions/Methods
See The Code :
SMSSchedulerDataBaseAdapter smsSchedulerDataBaseAdapter =new SMSSchedulerDataBaseAdapter(this);
smsSchedulerDataBaseAdapter=smsSchedulerDataBaseAdapter.open();
smsSchedulerDataBaseAdapter.insertEntry(yourParameter);
smsSchedulerDataBaseAdapter.getAllEntries();
The Complete Code :
public class SMSBlockerDataBaseAdapter
{
// Name of the database
static final String DATABASE_NAME = "SMSBLOCKERDATABASE.db";
// database version if creating first time it should be 1
static final int DATABASE_VERSION = 1;
public static final int NAME_COLUMN = 1;
// TODO: Create public field for each column in your table.
// SQL Statement to create a new database.
static final String DATABASE_CREATE = "create table BLOCKEDSMSTABLE " +
"( " +"ID integer primary key autoincrement,MESSAGE text, SENDERNUMBER text, SENDERNAME text, TIME integer ); ";
// Variable to hold the database instance
public SQLiteDatabase db;
// Context of the application using the database.
private final Context context;
// Database open/upgrade helper
private DataBaseHelper dbHelper;
public SMSBlockerDataBaseAdapter(Context _context)
{
context = _context;
dbHelper = new DataBaseHelper(context, DATABASE_NAME, null, DATABASE_VERSION);
}
// Open the Database
public SMSBlockerDataBaseAdapter open() throws SQLException
{
db = dbHelper.getWritableDatabase();
return this;
}
// Close the Database
public void close()
{
db.close();
}
public SQLiteDatabase getDatabaseInstance()
{
return db;
}
// to Insert A record in Table
public void insertEntry(Task taskToInsert)
{
// TODO: Create a new ContentValues to represent the row
// and insert it into the database.
ContentValues newValues = new ContentValues();
// Assign values for each row.
newValues.put("MESSAGE", taskToInsert.message);
newValues.put("SENDERNUMBER",taskToInsert.senderNumber);
newValues.put("SENDERNAME", taskToInsert.senderName);
newValues.put("TIME",taskToInsert.time);
// Insert the row into your table
db.insert("BLOCKEDSMSTABLE", null, newValues);
}
public int deleteEntry(String ID)
{
String where="ID=?";
int numberOFEntriesDeleted= db.delete("BLOCKEDSMSTABLE", where, new String[]{ID}) ;
return numberOFEntriesDeleted;
}
public void deleteOlderEntries()
{
String olderTime=String.valueOf(new GregorianCalendar().getTimeInMillis()-7*24*60*60*1000);
String where="TIME < ?";
int numberOFEntriesDeleted= db.delete("BLOCKEDSMSTABLE", where, new String[]{olderTime}) ;
Toast.makeText(context, "Number Of Entries Deleted "+numberOFEntriesDeleted, Toast.LENGTH_LONG).show();
}
public Cursor getAllEntries ()
{
return db.query("BLOCKEDSMSTABLE", null,null, null, null, null, "TIME DESC");
}
public Task getSinlgeEntry(String ID)
{
Task task=new Task();
Cursor cursor=db.query("BLOCKEDSMSTABLE", null, " ID=?", new String[]{ID}, null, null, null);
if(cursor.getCount()==0)
{
return null;
}
cursor.moveToFirst();
task.id= cursor.getString(cursor.getColumnIndex("ID"));
task.message = cursor.getString(cursor.getColumnIndex("MESSAGE"));
task.senderNumber = cursor.getString(cursor.getColumnIndex("SENDERNUMBER"));
task.senderName = cursor.getString(cursor.getColumnIndex("SENDERNAME"));
task.time = Long.parseLong(cursor.getString(cursor.getColumnIndex("TIME")));
task.reason=cursor.getString(cursor.getColumnIndex("REASON"));
//Log.i("getSingle Entry ID: "+"PhoneNumber "+task.senderName+" "+task.message,ID);
cursor.close();
return task;
}
}
Your information's are very much helpful for me to clarify my doubts.
ReplyDeletekeep update more information's in future.
Python Training in Chennai
Python course in Chennai
JAVA Training in Chennai
Big data training in chennai
Selenium Training in Chennai
Android Training in Chennai
Python Training in Chennai
Python Training in Anna Nagar
Great article! We will be linking too this great contnt on our site.
ReplyDeleteKeep up the good writing.
Thanks for sharing an informative blog keep rocking bring more details.I like the helpful info you provide in your articles. I’ll bookmark your weblog and check again here regularly. I am quite sure I will learn much new stuff right here! Good luck for the next!
ReplyDeletemobile application development training online
mobile app development course
mobile application development course
learn mobile application development
mobile app development training
I have been reading for the past two days about your blogs and topics, still on fetching! Wondering about your words on each line was massively effective. Techno-based information has been fetched in each of your topics. Sure it will enhance and fill the queries of the public needs. Feeling so glad about your article. Thanks…!
ReplyDeletebest software testing training in chennai
best software testing training institute in chennai with placement
software testing training
courses
software testing training and placement
software testing training online
software testing class
software testing classes in chennai
best software testing courses in chennai
automation testing courses in chennai
php online training in chennai
ReplyDeletephp programming center in chennai
php class in chennnai
php certification course
php developer training institution chennai
php training in chennnai
php mysql course in chennai
php institute in chennnai
php course in chennnai
php training with placement in chennnai
php developer course
appium online training
ReplyDeleteappium training centres in chennai
best appium training institute in chennnai
apppium course
mobile appium in chennnai
mobile training in chennnai
appium training institute in chennnai
7 tips to start a career in digital marketing
ReplyDelete“Digital marketing is the marketing of product or service using digital technologies, mainly on the Internet, but also including mobile phones, display advertising, and any other digital medium”. This is the definition that you would get when you search for the term “Digital marketing” in google. Let’s give out a simpler explanation by saying, “the form of marketing, using the internet and technologies like phones, computer etc”
we have offered to the advanced syllabus course digital marketing for available join now
more details click the link now
[url]https://www.webdschool.com/digital-marketing-course-in-chennai.html [/url]
Web designing trends in 2020
ReplyDeleteWhen we look into the trends, everything which is ruling today’s world was once a start up and slowly begun getting into. But Now they have literally transformed our lives on a tremendous note. To name a few, Facebook, WhatsApp, Twitter can be a promising proof for such a transformation and have a true impact on the digital world.
we have offered to the advanced syllabus course web design and development for available join now
more details click the link now
[url]https://www.webdschool.com/web-development-course-in-chennai.html[/url]
If you plan on whitening your teeth, don't forget that teeth whitening products and procedures whiten only your natural teeth. If you have any implants, veneers, fillings or crowns, their current shade will not be affected by teeth whitening agents.thanks
ReplyDeleteLearning technological skills seems to be the important thing in this modern era. I thank you for being instructive and kind in this write-up keep it up guys
ReplyDeleteAi & Artificial Intelligence Course in Chennai
PHP Training in Chennai
Ethical Hacking Course in Chennai Blue Prism Training in Chennai
UiPath Training in Chennai
Really nice post. Thank you for sharing amazing information.keep up!!
ReplyDeleteandroid training in chennai
android online training in chennai
android training in bangalore
android training in hyderabad
android Training in coimbatore
android training
android online training
I was following your blog regularly and this one is very interesting and knowledge attaining. Great effort ahead. you can also reach us for web development company in chennai website design company in chennai
ReplyDeleteVery interesting blog. Many blogs I see these days do not really provide anything that attracts others, but believe me the way you interact is literally awesome.You can also check my articles as well.
ReplyDelete360DigiTMG Data Science Course In Pune
360DigiTMG Data Science Training In Pune
Thank you..
Very interesting blog. Many blogs I see these days do not really provide anything that attracts others, but believe me the way you interact is literally awesome.You can also check my articles as well.
ReplyDeleteData Science Course In Hyderabad
Data Science Training In Hyderabad
Best Data Science Course In Hyderabad
Thank you..
I am more curious to take an interest in some of them. I hope you will provide more information on these topics in your next articles.
ReplyDeleteBusiness Analytics Course in Bangalore
I will very much appreciate the writer's choice for choosing this excellent article suitable for my topic. Here is a detailed description of the topic of the article that helped me the most.
ReplyDeleteData Analytics Course in Bangalore
Attend The Data Analyst Course From ExcelR. Practical Data Analyst Course Sessions With Assured Placement Support From Experienced Faculty. ExcelR Offers The Data Analyst Course.
ReplyDeleteData Analyst Course
Thank you so much for this innovative post, keep it up for more valuable information. Visit Ogen Infosystem for professional Website Designing and SEO Services in Delhi, India.
ReplyDeleteWeb Designing Company in Delhi
Appslure is an award-winning mobile app development company building feature-packed and interactive mobile applications for startups, medium and large enterprises.
ReplyDelete