复制代码 代码如下:
<%
function getConfig(config, args) {
if (args) {
for (var proto in args) {
config[proto] = args[proto];
}
}
return config;
}
function getConnection() {
return new ActiveXObject("ADODB.Connection");
}
function getRecordset() {
return new ActiveXObject("ADODB.Recordset");
}
var DB = {};
DB.ConnectionString = 'Provider=Sqloledb;User ID=sa;Password=sa;Initial Catalog=T;Data Source=WWW-D17F81FA113\\SQLEXPRESS;';
//添加 一条记录
DB.Add = function (table, keyValueCol) {
var returnID=null;
var Conn = getConnection();
Conn.Open(DB.ConnectionString);
var Rs = getRecordset();
Rs.Open('select * from '+table+' where 1=2', Conn, 3, 2);
Rs.AddNew();
for (var key in keyValueCol) {
Rs.Fields.Item(key).Value = keyValueCol[key];
}
Rs.Update();
Rs.Close();
Rs = null;
Conn.Close();
Conn = null;
return DB.Get("select IDENT_CURRENT('"+table+"') as ID")["ID"];
}
//修改一条记录
DB.Upd = function (sql, keyValueCol) {
var Conn = getConnection();
Conn.Open(DB.ConnectionString);
var Rs = getRecordset();
Rs.Open(sql, Conn, 3, 2);
for (var key in keyValueCol) {
Rs.Fields.Item(key).Value = keyValueCol[key];
}
Rs.Update();
Rs.Close();
Rs = null;
Conn.Close();
Conn = null;
}
//执行 无返回结果的查询
DB.Exe = function (sql) {
var Conn = getConnection();
Conn.Open(DB.ConnectionString);
Conn.Execute(sql);
Conn.Close();
Conn = null;
}
//获得 一个查询记录
DB.Get = function (sql) {
var _record = null;
var Conn = getConnection();
Conn.Open(DB.ConnectionString);
var Rs = getRecordset();
Rs.Open(sql, Conn, 1, 1);
if (!Rs.EOF) {
_record = {};
for (var i = 0; i < Rs.Fields.Count; i++) {
_record[Rs.Fields.Item(i).Name] = Rs.Fields.Item(i).Value;
}
}
Rs.Close();
Rs = null;
Conn.Close();
Conn = null;
return _record;
}
//批量 获得/添加 数据
DB.Batch = function () {
var Conn = getConnection();
var Rs = getRecordset();
var _Batch = this;
var _table = null;
_Batch.Open = function (sql) {
Conn.Open(DB.ConnectionString);
Rs.Open(sql, Conn, 3, 2);
}
_Batch.Add = function (table , keyValueCol) {
Rs.AddNew();
for (var key in keyValueCol) {
Rs.Fields.Item(key).Value = keyValueCol[key];
}
Rs.Update();
return DB.Get("Select IDENT_CURRENT('"+ table +"') as ID")["ID"];
}
_Batch.Get = function () {
var record_arr = [];
while (!Rs.EOF) {
var _record = {};
for (var i = 0; i < Rs.Fields.Count; i++) {
_record[Rs.Fields.Item(i).Name] = Rs.Fields.Item(i).Value;
}
record_arr.push(_record);
Rs.MoveNext();
}
return record_arr;
}
_Batch.Close = function () {
Rs.Close();
Rs = null;
Conn.Close();
Conn = null;
}
}
//获得 sql 的某页的数据
DB.List = function () {
var _Config;
var _List = this;
_List.Page = {
PS : 20,
AP : 1,
PC : 1,
RC : 1
};
_List.Query = function () {
_Config = new getConfig({
fields : " * ",
table : null,
where : " 1=1 ",
sort : " ID desc ",
pk : " ID "
}, arguments[0]);
_List.Page.RC = DB.Get("select count(" + _Config.pk + ") as [count] from " +
_Config.table + " where " + _Config.where).count;
_List.Page.PC = Math.ceil(_List.Page.RC / _List.Page.PS);
if(_List.Page.AP>_List.Page.PC) _List.Page.AP = _List.Page.PC;
}
_List.Get = function (p) {
p = isNaN(p) ? 1 : parseInt(p);
_List.Page.AP = p;
var sql = '';
if (p > 1) {
sql = "select top " + _List.Page.PS + " " + _Config.fields +
" from " + _Config.table + " where " + _Config.where +
" and " + _Config.pk +
" not in(select top " + (p - 1) * _List.Page.PS + " " + _Config.pk +
" from " + _Config.table + " where " + _Config.where +
" order by " + _Config.sort + ") order by " + _Config.sort;
} else {
sql = "select top " + _List.Page.PS + " " + _Config.fields +
" from " + _Config.table + " where " + _Config.where + " order by " + _Config.sort;
}
var return_arr = null;
var Batch = new DB.Batch();
Batch.Open(sql);
return_arr = Batch.Get();
Batch.Close();
return return_arr;
}
}
//sql 只读
DB.Reader = function () {
var Conn = getConnection();
var Rs = getRecordset();
var _Reader = this;
_Reader.EOF = false;
_Reader.Open = function (sql) {
Conn.Open(DB.ConnectionString);
Rs.Open(sql, Conn, 1, 1);
_Reader.EOF = Rs.EOF;
}
_Reader.Read = function () {
if (!Rs.EOF) {
var _record = {};
for (var i = 0; i < Rs.Fields.Count; i++) {
_record[Rs.Fields.Item(i).Name] = Rs.Fields.Item(i).Value;
}
Rs.MoveNext();
return _record;
} else {
_Reader.EOF = true;
}
}
_Reader.Close = function () {
Rs.Close();
Rs = null;
Conn.Close();
Conn = null;
}
}
%>
<%
function getConfig(config, args) {
if (args) {
for (var proto in args) {
config[proto] = args[proto];
}
}
return config;
}
function getConnection() {
return new ActiveXObject("ADODB.Connection");
}
function getRecordset() {
return new ActiveXObject("ADODB.Recordset");
}
var DB = {};
DB.ConnectionString = 'Provider=Sqloledb;User ID=sa;Password=sa;Initial Catalog=T;Data Source=WWW-D17F81FA113\\SQLEXPRESS;';
//添加 一条记录
DB.Add = function (table, keyValueCol) {
var returnID=null;
var Conn = getConnection();
Conn.Open(DB.ConnectionString);
var Rs = getRecordset();
Rs.Open('select * from '+table+' where 1=2', Conn, 3, 2);
Rs.AddNew();
for (var key in keyValueCol) {
Rs.Fields.Item(key).Value = keyValueCol[key];
}
Rs.Update();
Rs.Close();
Rs = null;
Conn.Close();
Conn = null;
return DB.Get("select IDENT_CURRENT('"+table+"') as ID")["ID"];
}
//修改一条记录
DB.Upd = function (sql, keyValueCol) {
var Conn = getConnection();
Conn.Open(DB.ConnectionString);
var Rs = getRecordset();
Rs.Open(sql, Conn, 3, 2);
for (var key in keyValueCol) {
Rs.Fields.Item(key).Value = keyValueCol[key];
}
Rs.Update();
Rs.Close();
Rs = null;
Conn.Close();
Conn = null;
}
//执行 无返回结果的查询
DB.Exe = function (sql) {
var Conn = getConnection();
Conn.Open(DB.ConnectionString);
Conn.Execute(sql);
Conn.Close();
Conn = null;
}
//获得 一个查询记录
DB.Get = function (sql) {
var _record = null;
var Conn = getConnection();
Conn.Open(DB.ConnectionString);
var Rs = getRecordset();
Rs.Open(sql, Conn, 1, 1);
if (!Rs.EOF) {
_record = {};
for (var i = 0; i < Rs.Fields.Count; i++) {
_record[Rs.Fields.Item(i).Name] = Rs.Fields.Item(i).Value;
}
}
Rs.Close();
Rs = null;
Conn.Close();
Conn = null;
return _record;
}
//批量 获得/添加 数据
DB.Batch = function () {
var Conn = getConnection();
var Rs = getRecordset();
var _Batch = this;
var _table = null;
_Batch.Open = function (sql) {
Conn.Open(DB.ConnectionString);
Rs.Open(sql, Conn, 3, 2);
}
_Batch.Add = function (table , keyValueCol) {
Rs.AddNew();
for (var key in keyValueCol) {
Rs.Fields.Item(key).Value = keyValueCol[key];
}
Rs.Update();
return DB.Get("Select IDENT_CURRENT('"+ table +"') as ID")["ID"];
}
_Batch.Get = function () {
var record_arr = [];
while (!Rs.EOF) {
var _record = {};
for (var i = 0; i < Rs.Fields.Count; i++) {
_record[Rs.Fields.Item(i).Name] = Rs.Fields.Item(i).Value;
}
record_arr.push(_record);
Rs.MoveNext();
}
return record_arr;
}
_Batch.Close = function () {
Rs.Close();
Rs = null;
Conn.Close();
Conn = null;
}
}
//获得 sql 的某页的数据
DB.List = function () {
var _Config;
var _List = this;
_List.Page = {
PS : 20,
AP : 1,
PC : 1,
RC : 1
};
_List.Query = function () {
_Config = new getConfig({
fields : " * ",
table : null,
where : " 1=1 ",
sort : " ID desc ",
pk : " ID "
}, arguments[0]);
_List.Page.RC = DB.Get("select count(" + _Config.pk + ") as [count] from " +
_Config.table + " where " + _Config.where).count;
_List.Page.PC = Math.ceil(_List.Page.RC / _List.Page.PS);
if(_List.Page.AP>_List.Page.PC) _List.Page.AP = _List.Page.PC;
}
_List.Get = function (p) {
p = isNaN(p) ? 1 : parseInt(p);
_List.Page.AP = p;
var sql = '';
if (p > 1) {
sql = "select top " + _List.Page.PS + " " + _Config.fields +
" from " + _Config.table + " where " + _Config.where +
" and " + _Config.pk +
" not in(select top " + (p - 1) * _List.Page.PS + " " + _Config.pk +
" from " + _Config.table + " where " + _Config.where +
" order by " + _Config.sort + ") order by " + _Config.sort;
} else {
sql = "select top " + _List.Page.PS + " " + _Config.fields +
" from " + _Config.table + " where " + _Config.where + " order by " + _Config.sort;
}
var return_arr = null;
var Batch = new DB.Batch();
Batch.Open(sql);
return_arr = Batch.Get();
Batch.Close();
return return_arr;
}
}
//sql 只读
DB.Reader = function () {
var Conn = getConnection();
var Rs = getRecordset();
var _Reader = this;
_Reader.EOF = false;
_Reader.Open = function (sql) {
Conn.Open(DB.ConnectionString);
Rs.Open(sql, Conn, 1, 1);
_Reader.EOF = Rs.EOF;
}
_Reader.Read = function () {
if (!Rs.EOF) {
var _record = {};
for (var i = 0; i < Rs.Fields.Count; i++) {
_record[Rs.Fields.Item(i).Name] = Rs.Fields.Item(i).Value;
}
Rs.MoveNext();
return _record;
} else {
_Reader.EOF = true;
}
}
_Reader.Close = function () {
Rs.Close();
Rs = null;
Conn.Close();
Conn = null;
}
}
%>
标签:
Javascript,ASP
免责声明:本站文章均来自网站采集或用户投稿,网站不提供任何软件下载或自行开发的软件!
如有用户或公司发现本站内容信息存在侵权行为,请邮件告知! 858582#qq.com
暂无“DB.ASP 用Javascript写ASP很灵活很好用很easy”评论...
P70系列延期,华为新旗舰将在下月发布
3月20日消息,近期博主@数码闲聊站 透露,原定三月份发布的华为新旗舰P70系列延期发布,预计4月份上市。
而博主@定焦数码 爆料,华为的P70系列在定位上已经超过了Mate60,成为了重要的旗舰系列之一。它肩负着重返影像领域顶尖的使命。那么这次P70会带来哪些令人惊艳的创新呢?
根据目前爆料的消息来看,华为P70系列将推出三个版本,其中P70和P70 Pro采用了三角形的摄像头模组设计,而P70 Art则采用了与上一代P60 Art相似的不规则形状设计。这样的外观是否好看见仁见智,但辨识度绝对拉满。
更新动态
2024年05月09日
2024年05月09日
- 《披萨塔,Pizza Tower》基础攻略 简述+配置+下载
- 中唱唱片群星《好歌珍藏-母爱·亲情》2CD[WAV+CUE]
- 中唱唱片群星《好歌珍藏-大地飞歌》2CD[WAV]
- 金海心-那么骄傲[WAV]
- 数毛社分析PS5 Pro规格:GPU主频高达2.35GHz
- 《死侍3》新正片片段:狼叔被死侍硫酸脸恶心到了
- 《地狱潜者2》CEO赞扬社区玩家:你们的意志与合作力让我印象深刻
- 张学友 歌神《等风雨经过3CD》[WAV+CUE][2GB]
- 华语流行《周杰伦 2022最伟大的作品》[FLAC/分轨][1.7GB]
- 孙燕姿《No. 13作品 跳舞的梵谷》[WAV+CUE][400MB]
- 张心柔.2012-吟游诗人【禾广娱乐】【FLAC分轨】
- 关淑怡.1991-恋一世的爱【宝丽金】【WAV+CUE】
- 群星.2010-我的舞台·2010快乐男声【天娱传媒】【WAV+CUE】
- 崩坏星穹铁道最新5月兑换码汇总 崩铁2024年兑换码分享
- 崩坏星穹铁道椒丘是男还是女 崩铁椒丘性别介绍