sql 语句操作

 

插入：insert into table1(field1,field2) values(value1,value2) 

db.execSQL(sql)

db.execSQL(sql, bindArgs)

1）：

str = "insert into UMUserMapStore(StoreID,UserID,LStoreID,IsValid) values("
       + operator.StoreID
       + ","
       + empSetStore.UserID
       + ","
       + operator.LStoreID + ",'Y')";

db.execSQL(str);

2）：

db.execSQL(
      "insert into UMUserMapStore(StoreID,UserID,LStoreID,IsValid) values(?,?,?,?)",
      new Object[] { operator.StoreID, empSetStore.UserID,
        LStoreID, "Y" });

 

更新：update table1 set field1=value1 ,field2=value2 where  范围

        str = "update UMUserMapStore set IsValid='N' where UserId="
            + empSetStore.UserID;

         db.execSQL(str);

 

删除：delete from table1 where 范围

       str = "delete from UMUserMapStore where UserId="
            + empSetStore.UserID;

        db.execSQL(str);

 

 查询：

SELECT column_name(s) FROM table_name  WHERE column_name   IN (value1,value2,..)

select * from table1 where field1 like “%value1%”---like

 

      str=SELECT COUNT(1) FROM M2Store WHERE 1=1 AND MerchantID=44 AND Status='Y' and IsValid='Y';

      db.execSQL(str);