Android : How do you check if a record already exists?

on Saturday, September 6, 2014


How do you check to see if a Record (ContentValues) already exists in the Database?



public void insertData(String ActId,String Dstcode,String Mandicode,String Traderlicno,String licenseId,String licensename,String Gatepassno,String FarmerId,String Farmername,String FarmerFatherName,String CommodityGrpCode,String CommodityCode,String VartyCode,String Cwght,String UntCode,String FnlPrice,String lgndate,String Ip,String dte,String IEMIN0,String ModelNo,String BoardName,String BrandName,String SIMNo)
{

ContentValues cv = new ContentValues();

cv.put(DatabaseHandler.AUCTIONINFO_ActId, ActId);
cv.put(DatabaseHandler.AUCTIONINFO_Dstcode, Dstcode);
cv.put(DatabaseHandler.AUCTIONINFO_Mandicode, Mandicode);
cv.put(DatabaseHandler.AUCTIONINFO_Traderlicno, Traderlicno);
cv.put(DatabaseHandler.AUCTIONINFO_licenseId, licenseId);
cv.put(DatabaseHandler.AUCTIONINFO_licensename, licensename);
cv.put(DatabaseHandler.AUCTIONINFO_Gatepassno, Gatepassno);
cv.put(DatabaseHandler.AUCTIONINFO_FarmerId, FarmerId);
cv.put(DatabaseHandler.AUCTIONINFO_Farmername, Farmername);
cv.put(DatabaseHandler.AUCTIONINFO_FarmerFatherName, FarmerFatherName);
cv.put(DatabaseHandler.AUCTIONINFO_CommodityGrpCode, CommodityGrpCode);
cv.put(DatabaseHandler.AUCTIONINFO_CommodityCode, CommodityCode);
cv.put(DatabaseHandler.AUCTIONINFO_VartyCode, VartyCode);
cv.put(DatabaseHandler.AUCTIONINFO_Cwght, Cwght);
cv.put(DatabaseHandler.AUCTIONINFO_UntCode, UntCode);
cv.put(DatabaseHandler.AUCTIONINFO_FnlPrice, FnlPrice);
cv.put(DatabaseHandler.AUCTIONINFO_lgndate, lgndate);
cv.put(DatabaseHandler.AUCTIONINFO_Ip, Ip);
cv.put(DatabaseHandler.AUCTIONINFO_dte, dte);
cv.put(DatabaseHandler.AUCTIONINFO_IEMIN0, IEMIN0);
cv.put(DatabaseHandler.AUCTIONINFO_ModelNo, ModelNo);
cv.put(DatabaseHandler.AUCTIONINFO_BoardName, BoardName);
cv.put(DatabaseHandler.AUCTIONINFO_BrandName, BrandName);
cv.put(DatabaseHandler.AUCTIONINFO_SIMNo, SIMNo);

database.insert(DatabaseHandler.TABLE_AUCTIONINFO, null, cv);


}


0 comments:

Post a Comment