使用JScript构造ASP_NET《ACCESS》操作程序

最新推荐文章于 2024-07-25 16:49:43 发布

youngerch

最新推荐文章于 2024-07-25 16:49:43 发布

阅读量1.3k

点赞数

分类专栏： JavaScript Asp.Net 文章标签： access asp sql function dataset string

Asp.Net 同时被 2 个专栏收录

5 篇文章 0 订阅

订阅专栏

JavaScript

3 篇文章 0 订阅

订阅专栏

DbHelper.js:
以下为程序代码：

import System;
import System.Web;
import System.Data;
import System.Data.OleDb;
import System.Configuration;
package Biyuan {
    class JSDbHelper {
        static var dataCount : int = null;
        private static var connStr : String = ConfigurationSettings.AppSettings["connStr"] + System.Web.HttpContext.Current.Server.MapPath(ConfigurationSettings.AppSettings["mdbPath"]);
        //创建SQL命令对象
        private static function newCommand(sql : String) : OleDbCommand {
            return new OleDbCommand(sql, new OleDbConnection(connStr));
        }
        //返回单个查询
        static function getDataCount(sql : String) : int {
            var command = newCommand(sql);
            command.Connection.Open();
            try {
                return command.ExecuteScalar();
            }
            finally {
                command.Connection.Close();
            }
        }
        //返回数据列表
        static function getData(sql : String, pageSend : Object) : Object {
            var pageCode : int = pageSend.pageCode;
            var pageSize : int = pageSend.pageSize;
            var ds : DataSet = new DataSet();
            var DataAdapter : OleDbDataAdapter = new OleDbDataAdapter(newCommand(sql));
            DataAdapter.Fill(ds, (pageCode - 1) * pageSize, pageSize, "data");
            return ds.Tables[0].Rows;
        }
        //返回分页数据信息
        static function getPageSend(sql : String, pageSize : int, pageCode) : Object {
            if(!dataCount){
                dataCount = getDataCount(sql);
            }
            var pageCount : int = Math.ceil(dataCount / pageSize);
            pageCode = pageCode * 1 || 1;
            pageCode = pageCode > pageCount ? pageCount : pageCode;
            return {"dataCount" : dataCount, "pageCount" : pageCount, "pageSize" : pageSize, "pageCode" : pageCode};
        }
        //执行SQL命令
        static function ExeSql(sql : String) : System.Int32 {
            var command = newCommand(sql);
            command.Connection.Open();
            try {
                return command.ExecuteNonQuery();
            }
            finally {
                command.Connection.Close();
            }
        }
    }
}

select.aspx.js:
以下为程序代码：

import System;
import System.Configuration;
package Biyuan {
    class select_aspx extends System.Web.UI.Page {
        function load() {
            var pageSend : Object = JSDbHelper.getPageSend("select count(id) from test", Convert.ToInt32(ConfigurationSettings.AppSettings["pageSize"]), Request.QueryString["page"]);
            var rs : Object = JSDbHelper.getData("select * from test", pageSend);
            return [rs, pageSend];
        }
    }
}

select.aspx:
以下为程序代码：

<%@ Page Language="JScript" Inherits="Biyuan.select_aspx" %>
<%@ Import Namespace="Biyuan" %>
<%var startTime = new Date;%><html>
<head>
<title>数据查询</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<style type="text/css">
body {
    margin:0px;
    text-align:center;
    font-size:12px;
}
td {
    font-size:12px;
    padding:3px;
}
a:link,a:visited {
    color:#3366cc;
    text-decoration: none;
}
a:hover {
    color:#ff0000;
    text-decoration:underline;
}
.td_title {
    background:#f3f3f3;
}
.tid {
    background:#f9f9f9;
    text-align:center;
}
</style>
</head>
<body>
<h2>数据查询</h2>
<table border='1' bordercolor='#cccccc' width='60%'>
<tr align='center'>
<td class='td_title'>ID</td>
<td class='td_title'>标题</td>
<td class='td_title'>作者</td>
<td class='td_title'>时间</td>
</tr><%
//JSDbHelper.dataCount = null;
//Response.Write(JSDbHelper.ExeSql("update [test] set [user]=replace([user],'biyuan','Rimifon')"));
var arr : Array = load();
for(var rs in arr[0]){
%><tr>
<td class='tid'><%=rs["id"]%></td>
<td><a href='view.php?id=<%=rs["id"]%>'><%=rs["title"]%></a></td>
<td align='center'><%=rs["user"]%></td>
<td align='center'><%=rs["time"]%></td>
</tr><%}%><tr align='right'>
<td colspan='7'>[<%=arr[1].dataCount%>][<%=arr[1].pageCode%>/<%=arr[1].pageCount%>] <a href='?page=1'>首页</a> <a href='?page=<%=arr[1].pageCode - 1%>'>上一页</a> <a href='?page=<%=arr[1].pageCode - 0 + 1%>'>下一页</a> <a href='?page=<%=arr[1].pageCount%>'>尾页</a></td>
</tr></table>
耗时：<%= (new Date - startTime)/1000 %> 秒</body>
</html>

web.config:
以下为程序代码：

<?xml version="1.0" encoding="gb2312" ?>
<configuration>
    <system.web>
        <compilation defaultLanguage="JScript" debug="true" />
        <globalization requestEncoding="gb2312" responseEncoding="gb2312" />
    </system.web>
    <appSettings>
        <add key="connStr" value="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" />
        <add key="mdbPath" value="temp.mdb" />
        <add key="pageSize" value="20" />
    </appSettings>
</configuration>

编译.bat:
以下为程序代码：

%windir%/Microsoft.Net/Framework/v1.1.4322/jsc /t:library /out:Bin/biyuan.dll dbHelper.js select.aspx.js
pause

youngerch

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
1
评论
使用JScript构造ASP_NET《ACCESS》操作程序

DbHelper.js:以下为程序代码：import System;import System.Web;import System.Data;import System.Data.OleDb;import System.Configuration;package Biyuan { class JSDbHelper { static var dataCount : int =
复制链接

扫一扫

专栏目录