用法:
s sjk = sj.sjk("iapp.db")
s sjk2 = sj.sjk("%iapp.db")
s sjk3 = sjk.sjk
s sjk5 = sjk.xj
s sjk6 = sjk.scsjk()
s sjk7 = sjk.sfsjk()
s table = "_id integer primary key,url text, filename text,status interger"
s sjk8 = sjk.cjsjb("info", table)
s sjk9 = sjk.czsjb("info")
s sjk10 = sjk.scsjb("info")
s table = "url,filename,status"
s data = "'http://abc.com/abc.apk', 'abc.apk', 1"
s sjk11 = sjk.cjsj("info", table, data)
s sjk12 = sjk.gxsj("info", "status=2", "_id=1")
s sjk13 = sjk.scsj("info", "_id=1")
s table = "_id,url,filename,status"
s sqlx = "status=1 order by _id desc LIMIT 0,1"
s sjk15 = sjk.cxsj("info", table, sqlx)
s sqlx = "select _id,url,filename,status from info where status=1 order by _id desc"
s sjk16 = sjk.cxsj(sqlx)
xh sjk15.xyh()
{
gj.sc(":" + sjk15.sj(0)+ ", " + sjk15.sj(1));
}
s sj1 = sjk15.sj(0)
s sj2 = sjk15.cxls()
s sj3 = sjk15.cxhs()
s sj5 = sjk15.xyh()
s sj6 = sjk15.syh()
s sj7 = sjk15.dyh()
s sj8 = sjk15.zhyh()
s sj9 = sjk15.zdwz(2)
s sj10 = sjk15.hqwz()
s sj11 = sjk15.sf()
s sqlx = "insert into info (url,filename,status) values ('http://abc.com/abc.apk', 'abc.apk', 1)"
s sjk17 = sjk.cxsj(sqlx)
注意:
在执行sql语句的时候,需要注意你的字符串的特殊字符的转义。
/ ->
' -> ''
[ -> /[
] -> /]
% -> /%
& -> /&
_ -> /_
( -> /(
) -> /)