In my database i have 4 coloumn KEY_id,KEY_NAME, KEY_PH_NO,KEY_DATE this is a bookmark table ,when i add some data that time only it added to book mark ,but my problem is defaultly it hold some data in bookmark table.below mentioned my code,thanks in advance..
table
String CREATE_CONTACTS_TABLE = "CREATE TABLE " + TABLE_BOOKMARK + "("+ KEY_ID + " INTEGER PRIMARY KEY," + KEY_NAME + " TEXT,"+ KEY_PH_NO + " TEXT" +KEY_DATE+"TEXT"+ ")";
SQLiteDatabase db =myDataBase;
db.execSQL(CREATE_CONTACTS_TABLE);
set bookmark
public String setBookMark(int ibook,int ichapter,int iversion,int flag) {
try{
if(iversion==-1)
return "";
int rowid=getRowId(ibook,ichapter,iversion);
if(rowid==-1)
return "";
SQLiteDatabase db =myDataBase;
SQLiteQueryBuilder qb = new SQLiteQueryBuilder();
String strids=rowid+"";//ibook+"@"+ichapter+"@"+iversion+"@"+rowid;
String [] sqlSelect = {"0 _id", KEY_NAME,KEY_PH_NO,KEY_ID};
String sqlTables = TABLE_BOOKMARK;
String strQuery=KEY_NAME+"='" + strids+"'";
String strOrder=KEY_ID + " asc";
String strdate= KEY_DATE+" DESC";
/*long time= System.currentTimeMillis();
SimpleDateFormat formatter = new SimpleDateFormat("dd/MM/yyyy");
String dateString = formatter.format(new Date(time));*/
Calendar cal=Calendar.getInstance();
SimpleDateFormat df = new SimpleDateFormat("dd MMMM yyyy");
String formattedDate = df.format(cal.getTime());
qb.setTables(sqlTables);
Cursor c = qb.query(db, sqlSelect, strQuery, null,null, null, strOrder);
if(c!=null)
{
c.moveToFirst();
if(c.getCount()>=1)
{
String status=c.getString(c.getColumnIndex(KEY_PH_NO));
if(status.equals("1"))
{
if(flag==0)
return "Already Available in Favourite";
else
{
ContentValues values = new ContentValues();
values.put(KEY_NAME, strids);
values.put(KEY_PH_NO, "0");
values.put(KEY_DATE, formattedDate);
db.update(sqlTables, values, KEY_ID + " = ?",new String[] { String.valueOf(c.getString(c.getColumnIndex(KEY_ID))) });
return "Removed from Favourite";
}
}
else
{
ContentValues values = new ContentValues();
values.put(KEY_NAME, strids);
values.put(KEY_PH_NO, "1");
values.put(KEY_DATE, formattedDate);
db.update(sqlTables, values, KEY_ID + " = ?",new String[] { String.valueOf(c.getString(c.getColumnIndex(KEY_ID))) });
return "Added to Favourite";
}
}
else
{
ContentValues values = new ContentValues();
values.put(KEY_NAME, strids);
values.put(KEY_PH_NO, "1");
values.put(KEY_DATE, formattedDate);
db.insert(sqlTables, null, values);
return "Added to bookmark";
}
}
else
{
ContentValues values = new ContentValues();
values.put(KEY_NAME, strids);
values.put(KEY_PH_NO, "1");
values.put(KEY_DATE, formattedDate);
db.insert(sqlTables, null, values);
return "Added to bookmark";
}
}
catch (Exception e) {
Log.e("setBookMark Exception",e.toString());
}
return "";
}
get bookmark
public Cursor getBookMarks() {
try{
SQLiteDatabase db =myDataBase;// getReadableDatabase();
SQLiteQueryBuilder qb1 = new SQLiteQueryBuilder();
String [] sqlSelect1 = {"0 _id", KEY_NAME,KEY_PH_NO,KEY_ID};
String sqlTables1 = TABLE_BOOKMARK;
String strQuery1=KEY_PH_NO+"='1'";
String strOrder1=KEY_ID + " asc";
qb1.setTables(sqlTables1);
String strvalues="";
Cursor curs = qb1.query(db, sqlSelect1, strQuery1, null,null, null, strOrder1);
if(curs!=null)
{
curs.moveToFirst();
if(curs.getCount()>=1)
{
do {
strvalues+=""+curs.getString(curs.getColumnIndex(KEY_NAME))+",";
}
while (curs.moveToNext());
//curs.close();
if(strvalues.length()>=1)
{
strvalues+="-1";
String [] sqlSelect = {"0 _id", "TB","Version","Book","Chapter","NKJ"};
String sqlTables = "hindibible";
SQLiteQueryBuilder qb = new SQLiteQueryBuilder();
qb.setTables(sqlTables);
//String query = "SELECT * FROM "+sqlTables+" WHERE ID IN (" + strvalues + ")";
String query = "ID IN (" + strvalues + ")";
//Cursor bible = db.rawQuery(query, null);
Cursor bible = qb.query(db, sqlSelect, query, null,null, null, null);
bible.moveToFirst();
return bible;
}
}
else
{
}
}
else
{
}
}
catch (Exception e) {
Log.d("setBookMark",e.toString());
}
return null;
}
in aActivity(ListActivity)
private void addBookMark(int pos)
{
try
{
int verse=pos;
if(lIntVerse!=-1)
verse=lIntVerse;
String strret=db.setBookMark(lIntBookId,lIntchapter,verse,0);
if(strret.length()>2){}
Toast.makeText(getApplicationContext(), strret,
Toast.LENGTH_LONG).show();
}
catch (Exception e)
{
// TODO: handle exception
}
}
getBookmark()
private void showFav()
{
try
{
Cursor cursor=db.getBookMarks();
gcursor=cursor;
this.m_adapter = new Bookmark_Adapter(this, cursor,3);
listview.setAdapter(this.m_adapter);
listview.setOnItemLongClickListener(new OnItemLongClickListener() {
@Override
public boolean onItemLongClick(AdapterView<?> arg0, View arg1,
int pos, long arg3)
{ // TODO Auto-generated method stub
contposition=pos;
//registerForContextMenu(listview);
share_verse(pos);
return false;
}
});
}catch (Exception e)
{
Log.d("SSSSS","111="+e.toString());
}
}
ADAPTER CLASS:
book1.setText("AAAA");
short ibook=cursor.getShort(cursor.getColumnIndex("Book"));
short ichap=cursor.getShort(cursor.getColumnIndex("Chapter"));
short ivers=cursor.getShort(cursor.getColumnIndex("Version"));
try
{
String strdata=mathstxt[ibook-1]+" "+ichap+" "+ivers;
book1.setText(strdata);
Aucun commentaire:
Enregistrer un commentaire