演示地址:http://fengyun.org/Down/db.asp
源码下载:http://fengyun.org/Down/sqlce.js
VBS 调用(insert 方法 需要 js 格式数据,暂不支持):
<job>
<!-- Filename test.wsf -->
<script src="http://fengyun.org/Down/sqlce.js" language="livescript"></script>
<script language="vbscript">
set rows = db().table("guestbook").where("nick=?"). _
orderby("id desc").select("top 4 *"). _
query(array("hacker"))
rows.forEach(getRef("eachRows"))
sub eachRows(row, i)
WSH.Echo row.nick
end sub
</script>
</job>
创建表,插入数据:
<%@ language="livescript" codepage="65001" %>
<script src="sqlce.js" language="livescript" runat="server"></script>
<%
var dbName = "www.sdf";
db().create("users", [
["id int", null, true],
"username nvarchar(32)",
"password nvarchar(32)",
["regtime datetime", "getdate()"]
]);
db().insert("users", [
{ username: "user1", password: "******" },
{ username: "user2", password: "******" },
{ username: "user3", password: "******" },
{ username: "user4", password: "******" },
{ username: "user5", password: "******" }
]);
var data = new Object;
data.lastId = db().scalar("select @@identity");
data.rows = db().query("select top 3 * from users order by id desc");
Response.Write(data);
%>
数据分页方法
var par = { clsid: 2001 };
var rows = db().table("students").select("userid").
where("classid=@clsid").
// userid 倒序,每页10条,查询第3页
page("userid desc", 10, 3, par).
// 分页后根据当前页数据 继续统计所有历史考试平均分
astable('a').join('test b on b.userid=a.userid').
select('a.userid, avg(b.score) as score').
groupby('a.userid').astable('a').
// 查询学生信息
join('students b on b.userid=a.userid').
select('b.*, a.score').orderby('a.userid').
// 返回所有数据
query(par);
// 查询时使用 page 方法后能得到以下参数
var rownum = db().rownum; // 总记录数
var pagenum = db().pagenum; // 总页数
var curpage = db().curpage; // 当前页码
Response.Write(rows);
基于 Microsoft.Windows.SqlLite.OleDb.4.0 组件开发,2012以上系统自带,如果缺少驱动,可点击下面链接下载。
SqlCe 4.0 组件下载:https://download.csdn.net/download/Rimifon/12693698