public void database(View v)
{
//Toast.makeText(getApplicationContext(), "Database", 30).show();
try
{
mdb=openOrCreateDatabase("database", SQLiteDatabase.CREATE_IF_NECESSARY, null);
Toast.makeText(getApplicationContext(), "Database is created", 30).show();
mdb.setLocale(Locale.getDefault());
mdb.setLockingEnabled(true);
mdb.setVersion(1);
}
catch(Exception e)
{
Toast.makeText(getApplicationContext(), e.getMessage().toString(),30).show();
}
}
public void table(View v)
{
try
{
String tab="CREATE TABLE tab(fnm TEXT, lnm TEXT)";
mdb.execSQL(tab);
Toast.makeText(getApplicationContext(), "Table is Created", 30).show();
}
catch(Exception e)
{
Toast.makeText(getApplicationContext(), "Table is already created", 30).show();
}
//Toast.makeText(getApplicationContext(), "Table", 30).show();
}
public void add(View v)
{
ContentValues val=new ContentValues();
val.put("fnm", "abc");
val.put("lnm", "bbc");
long id=mdb.insert("tab", null,val);
Toast.makeText(getApplicationContext(), "Record is inserted"+ id, 30).show();
}
public void update(View v)
{
ContentValues val=new ContentValues();
val.put("fnm", "ccd");
int i=mdb.update("tab", val, "fnm=?", new String[] {"abc"});
Toast.makeText(getApplicationContext(), "Update"+i, 30).show();
}
public void delete(View v)
{
int i=mdb.delete("tab", "fnm=?",new String[] {"ccd"});
Toast.makeText(getApplicationContext(), "Delete"+i, 30).show();
}
public void view(View v)
{
try
{
Cursor c=mdb.query("tab",null,null,null,null,null,null);
c.moveToFirst();
while(c.isAfterLast()==false)
{
String data="::";
for(int i=0;i<c.getColumnCount();i++)
{
data=data.concat(c.getString(i)+"::");
}
Toast.makeText(getApplicationContext(), data,30).show();
c.moveToNext();
}
}
catch(Exception e)
{
Toast.makeText(getApplicationContext(), e.getMessage().toString(), 30).show();
}
}
No comments:
Post a Comment