用法:
var table = "_id integer primary key,url text, filename text,status interger,createTime datetime"
var b = i.sql(data, "info", "add", table)
var b = i.sql(data, "info", "ip")
syso(b)
var b = i.sql(data, "info", "del")
syso(b)
var table = "url,filename,status,createTime"
var value = "'http://abc.com/abc.apk', 'abc.apk', 1, '" + i.time(0) + "'"
var b = i.sql(data, "info", "add", table, value)
syso(b)
var b = i.sql(sss.data, "info", "up", "status=2", "_id=1")
syso(b)
var b = i.sql(sss.data, "info", "del", "_id=1")
syso(b)
var table = "_id,url,filename,status,createTime"
var sqlx = "status=1 order by _id desc LIMIT 0,1"
var da = i.sql(sss.data, "info", "sele", table, sqlx)
var ee = i.sqlsele(da, "next")
while (ee){
var e = i.sqlsele(data, 0)
syso(e)
var e = i.sqlsele(data, 1)
syso(e)
ee = i.sqlsele(data, "next")
}
var sqlx = "insert into info (url,filename,status,createTime) values ('http://abc.com/abc.apk', 'abc.apk', 1, '2016-7-31 10:31:21')"
i.sql(sqlx, data)
说明:
数据表的操作。
注意:
在执行sql语句的时候,需要注意你的字符串的特殊字符的转义。
/ ->
' -> ''
[ -> /[
] -> /]
% -> /%
& -> /&
_ -> /_
( -> /(
) -> /)