使用Jscript之代码生成工具篇

zyug zyug 墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年,写一次发全网 我也要 + 加入社区
之前是学习ASP之后才学习ASP.NET
后来人变的越来越懒,后来看到ASP.NET能用生成工具生成相应的代码.ASP可以吗?
于是有了下面的内容

现在只能生成一些简单的,如有人感兴趣...放出代码
生成的实体类代码


function JCModels() {
this.ID = 0;
this.ModelName = "";
this.CreateDate = formatDate(new Date());
this.Url = "";
this.keyWord = "";
this.pagesize = 20;
this.pageno = 1;
this.recordscount = 0;

this.insert = function() {
var sql = " insert into [Models]([ModelName],[CreateDate],[Url]) values(?,?,?)";
var connection = Server.CreateObject("adodb.connection");
connection.ConnectionString = MDBCONNECTIONSTRING;
connection.Open();
var command = Server.CreateObject("adodb.command");
command.ActiveConnection = connection;
command.CommandText = sql;
var par_ModelName = command.CreateParameter("ModelName", 202, 1, 50, this.ModelName);
command.Parameters.Append(par_ModelName);
var par_CreateDate = command.CreateParameter("CreateDate", 202, 1, 20, this.CreateDate);
command.Parameters.Append(par_CreateDate);
var par_Url = command.CreateParameter("Url", 202, 1, 100, this.Url);
command.Parameters.Append(par_Url);
command.Execute();
connection.Close();
}

this.update = function() {
var sql = "update [Models] set [ModelName]=?,[CreateDate]=?,[Url]=? where [ID] = ? ";
var connection = Server.CreateObject("adodb.connection");
connection.ConnectionString = MDBCONNECTIONSTRING;
connection.Open();
var command = Server.CreateObject("adodb.command");
command.ActiveConnection = connection;
command.CommandText = sql;
var par_ModelName = command.CreateParameter("ModelName", 202, 1, 50, this.ModelName);
command.Parameters.Append(par_ModelName);
var par_CreateDate = command.CreateParameter("CreateDate", 202, 1, 20, this.CreateDate);
command.Parameters.Append(par_CreateDate);
var par_Url = command.CreateParameter("Url", 202, 1, 100, this.Url);
command.Parameters.Append(par_Url);
var par_ID = command.CreateParameter("ID", 3, 1, 4, this.ID);
command.Parameters.Append(par_ID)
command.Execute();
connection.Close();
}

this.deleteentity = function() {
var sql = "delete from [Models] where [ID] = ?";
var connection = Server.CreateObject("adodb.connection");
connection.ConnectionString = MDBCONNECTIONSTRING;
connection.Open();
var command = Server.CreateObject("adodb.command");
command.ActiveConnection = connection;
command.CommandText = sql;
var par_ID = command.CreateParameter("ID", 3, 1, 4, this.ID);
command.Parameters.Append(par_ID);
command.Execute();
command.CommandText = "delete from [ModelContent] where [ModelID]=?";
//var par_ModelID = command.CreateParameter("ModelID", 3, 1, 4, this.ID);
//command.Parameters.Append(par_ModelID);
command.Execute();

connection.Close();
}

this.getentity = function(entityid) {
var sql = "select * from [Models] where [ID] = ?";
var connection = Server.CreateObject("adodb.connection");
connection.ConnectionString = MDBCONNECTIONSTRING;
connection.Open();
var command = Server.CreateObject("adodb.command");
command.ActiveConnection = connection;
command.CommandText = sql;
var par_ID = command.CreateParameter("ID", 3, 1, 4, entityid);
command.Parameters.Append(par_ID);
var rsEntity = command.Execute();
if (!rsEntity.Eof) {
this.ID = new String(rsEntity("ID")).replace(/(^[\s]*)|([\s]*$)/g, "");
this.ModelName = new String(rsEntity("ModelName")).replace(/(^[\s]*)|([\s]*$)/g, "");
this.CreateDate = formatDate(new Date(rsEntity("CreateDate")));
this.Url = new String(rsEntity("Url")).replace(/(^[\s]*)|([\s]*$)/g, "");
}
connection.Close();
}

this.doQuery = function() {
var connection = Server.CreateObject("adodb.connection");
connection.Open(MDBCONNECTIONSTRING);
var order = " order by [ID] desc ";
var condition = " where 1=1 ";
var sql = "select top " + this.pagesize + " * from [Models] ";
sql += condition;
var rsCount = connection.Execute("select count(1) from [Models] " + condition);
this.recordscount = new Number(rsCount(0));
if (this.pageno > 1) {
var notIncludeCount = (this.pageno - 1) * this.pagesize;
var notInclude = " select top " + notIncludeCount + " [ID] from [Models] " + condition + order;
sql += " and [ID] not in ( " + notInclude + " ) ";
}
sql += order;
var rsContent = connection.Execute(sql);
var arrayResult = new Array();
if (rsContent.Eof) {
;
}
while (!rsContent.Eof) {
var newentity = new JCModels();
newentity.ID = new String(rsContent("ID")).replace(/(^[\s]*)|([\s]*$)/g, "");
newentity.ModelName = new String(rsContent("ModelName")).replace(/(^[\s]*)|([\s]*$)/g, "");
newentity.CreateDate = formatDate(new Date(rsContent("CreateDate")));
newentity.Url = new String(rsContent("Url")).replace(/(^[\s]*)|([\s]*$)/g, "");
arrayResult.push(newentity);
rsContent.MoveNext();
}
connection.Close();
return arrayResult;
}

function formatDate(s) {
s = new Date(s);
var Format = "YYYY-MM-DD hh:mm:ss";
Format = Format.replace("YYYY", s.getYear());
var m = s.getMonth() + 1;
Format = Format.replace("MM", m > 9 ? m : "0" + m);
Format = Format.replace("DD", s.getDate() > 9 ? s.getDate() : "0" + s.getDate());
Format = Format.replace("hh", s.getHours() > 9 ? s.getHours() : "0" + s.getHours());
Format = Format.replace("mm", s.getMinutes() > 9 ? s.getMinutes() : "0" + s.getMinutes());
Format = Format.replace("ss", s.getSeconds() > 9 ? s.getSeconds() : "0" + s.getSeconds());
return Format;
}
}



方法调用示例
增删改查



//操作增加模块
if (Request.Form("act") == "addmodel") {
// validateAdmin();
var model = Request.Form("model");
var url = Request.Form("url");
var entity = new JCModels();
entity.ModelName = model;
entity.Url = url;
entity.insert();
Response.Write("成功添加");
Response.End();
}

//更新模块
if (Request.Form("act") == "editmodel") {
//validateAdmin();
var id = Request.Form("id");
var model = Request.Form("model");
var url = Request.Form("url");
var entity = new JCModels();
entity.ID = id;
entity.ModelName = model;
entity.Url = url;
entity.update();
Response.Write("成功更新");
Response.End();
}

//后台管理
if (Request.Form("act") == "showdesktop") {
//validateAdmin();
var t = new JCModels();
if (Request.Form("pageno").Count > 0) {
t.pageno = Request.Form("pageno");
}
var items = t.doQuery();
var tableHTML = "";
if (t.recordscount <= 0) {
tableHTML = "暂时没有自定义模块";
}
else {
var label = ReadFile("/templates/modelsTemplate.txt");

var header = ReadHeader(label);
var template = ReadTemplate(label);
var footer = ReadFooter(label);

tableHTML = header;
for (var i = 0; i < items.length; i++) {
var temp = template.replace(/[$][$]ID/g, items[i].ID)
temp = temp.replace(/[$][$]ID/g, items[i].ID); //URL
temp = temp.replace(/[$][$]ModelName/g, items[i].ModelName); //URL
temp = temp.replace(/[$][$]URL/g, items[i].Url); //URL
tableHTML += temp; //$$Ispublish
}
tableHTML += footer;
}
tableHTML += "<script>var CalledObject = new Object();CalledObject.recordscount =" + t.recordscount + ";CalledObject.keyWord='" + t.keyWord + "';CalledObject.pagesize =" + t.pagesize + ";CalledObject.pageno=" + t.pageno + "</script>"; //回调告知分页事件
Response.Write(tableHTML);
Response.End();
}

if (Request.Form("act") == "edit") {
var t = new JCModels();
t.getentity(Request.Form("id"));
//json返回
var s = "var t = {";
for (var property in t) {
s += "\"" + property + "\":\"" + escape(t[property]) + "\"";
s += ",";
}
s += "\"Coder\":\"zyg\"";
s += "};";
Response.Write(s);
Response.End();
}

//删除
if (Request.Form("act") == "delete") {
var t = new JCModels();
t.ID = Request.Form("id");
t.deleteentity();
Response.End();
}



由于doQuery事件中使用了正序排倒序排再分页,使用参数查询有一定难度.故没有使用参数查询,不知有何解决方案.
...全文

相关推荐

JEP30-PX100A PartModel Product Guidelines for Electronic-Device Substrates and Assemblies – XML Requ

JEP30-PX100A PartModel Product Guidelines for Electronic-Device Substrates and Assemblies – XML Requirements

cdming

基于Matlab的自动睡眠粒状结构检测算法,从脑电信号中进行。.zip

1.版本:matlab2014a/2019b/2024b 2.附赠案例数据可直接运行。 3.代码特点:参数化编程、参数可方便更改、代码编程思路清晰、注释明细。 4.适用对象:计算机,电子信息工程、数学等专业的大学生课程设计、期末大作业和毕业设计。

海神之光

JEP375 2.5D_3D Silicon thinned wafers with Through Silicon Vias (TSV’s) and Backside Redistribution

JEP375 2.5D_3D Silicon thinned wafers with Through Silicon Vias (TSV’s) and Backside Redistribution Layer (RDL).pdf

Red Car

考虑供电可靠性与算力柔性的数据中心园区源‑储‑荷一体化规划研究(Matlab代码实现)

考虑供电可靠性与算力柔性的数据中心园区源‑储‑荷一体化规划研究(Matlab代码实现)内容概要:本文围绕“考虑供电可靠性与算力柔性的数据中心园区源-储-荷一体化规划”展开研究,提出了一种综合能源系统优化规划方法。该方法充分考虑数据中心对供电可靠性的高要求以及算力负载的灵活性特征,将电力供应、储能配置与计算负荷进行协同优化。通过建立数学模型,整合光伏发电、储能系统与数据中心负荷调度,利用Matlab代码实现优化求解,旨在提升能源利用效率、降低运营成本并增强系统韧性。研究涵盖了对新能源出力不确定性、负荷波动以及储能动态行为的建模与仿真分析,最终验证了所提一体化规划方案在提高供电可靠性和实现算力资源柔性调度方面的有效性。; 适合人群:具备一定电气工程、能源系统或计算机科学背景,从事数据中心、智能电网、综合能源系统等相关领域研究的研究生、科研人员及工程技术人员。; 使用场景及目标:① 为数据中心园区的绿色低碳与高可靠运行提供规划设计方案;② 实现可再生能源的高效消纳与储能系统的优化配置;③ 探索算力作为柔性负荷参与电力系统互动的潜力,支撑新型电力系统建设。; 阅读建议:此资源以Matlab代码为核心,辅以理论模型,建议读者在理解基本原理的基础上,动手运行和调试所提供的代码,通过修改参数和场景设置来深入掌握一体化规划的优化逻辑与关键技术细节。

@橘柑橙柠桔柚

歌曲爆款传播预测数据集10000首曲目Spotify音频特征机器学习

本数据集为合成音乐数据,包含2010至2025年间10000首曲目的Spotify风格音频特征与明确的爆款(viral)目标标签。现有音乐数据集常缺少可用建模目标或存在授权限制,本数据集提供了干净、字段完整、可直接用于监督学习的基准语料。字段涵盖节奏、能量、可舞性、声学度、效价等音频属性,以及曲目元数据与年份信息,目标列viral基于传播表现定义,可直接用于二分类建模。适合开展爆款歌曲预测、音频特征与传播关系分析、年代音乐风格演变可视化、特征重要性排序等分析任务,也可作为分类、回归与特征工程教学的演示数据。数据结构清晰、无缺失值,适合数据科学课程、音乐媒体分析与推荐算法原型验证使用。

licy__
评论 3
收藏 已收藏
分享
返回顶部
zyug
ASP 28,401 成员 356,940 内容