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);
最新文章
- githup上传代码
- 模板题 codevs 1993 草地排水 想学习的请看链接
- UI第四节——UIImageView详解
- Validate Binary Search Tree [LeetCode]
- IBATIS动态SQL(转)
- python之字符聊天小工具
- ZOJ Problem Set - 3635
- Android使用adb工具及root权限完成手机抓包
- C51与汇编混合编程详解
- 设计模式14---设计模式之命令模式(Command)(行为型)
- ASP.Net MVC中数据库数据导出Excel,供HTTP下载
- 【分享】SAS统计分析软件学习教程电子书合集下载
- JTAG上有多个设备时,该如何接呢?
- Spring Boot踩坑之路一
- 全本 | iKcamp翻译 | 《JavaScript 轻量级函数式编程》|《你不知道的JS》姊妹篇
- rabbitMQ的安装和配置(一)
- Tomcat更新方法
- html5中JavaScript删除全部节点
- Java 浮点数相加
- JavaScript动态加载资源