: : 保存为 asptools.hta 然后再运行
代码如下:
<! doctype html public "-// w3c // dtd xhtml 1.0 transitional // en" "http://www.w3.org/tr/xhtml1/dtd/xhtml1-
transitional.dtd ">
<html xmlns = "http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv = "content-type" content = "text /html ؛ charset = gb2312" />
<meta name = "المؤلف" content = "柳永法" />
<title> ASP 辅助工具 </itlem>
<style> body {font-size: 12px} </style>
<hta: التطبيق
id = "asptools"
ApplicationName = "Asptools"
Scroll = "لا"
SingleInstance = "نعم"
WindowState = "Normal"
>
</head>
<body>
<viv>
<type type = "file" id = "txtfile" onChange = "CreateTableselect ('Access')" style = "display: none" />
IP : <input type = "text" name = "ip" size = "16" style = "الحدود: 1px صلبة خضراء" value = "./ SQL2005" />
: : <إدخال type = "text" name = "userId" size = "10" style = "border: 1px solid green" value = "sa" />
: : <input type = "password" name = "pwd" size = "10" style = "border: 1px solid green" value = "yongfa365" />
: : <إدخال type = "text" name = "dbname" size = "10" style = "border: 1px solid green" value = "hb605-8-8" /> <br />
<input name = "button2" type = "button" id = "button2" style = "border: 1px solid Green" OnClick = "CreateTablesElect
('mssql') "value =" 连接 sql 数据库 " />
<type type = "button" id = "btnfromfile" onClick = "txtfile.click ()" value = "连接 Access 数据库" 数据库
الأخضر " />
<span id = "tables"> </span>
<hr />
: :
<إدخال type = "text" id = "opt" value = "" size = "40" />
<select size = "1" id = "fz" onChange = "Opt.Value = this.value"> </rection>
<name input = "button" type = "button" id = "button" onClick = "c ()" value = "转换" style = "border: 1px solid green">
<hr />
<textarea id = "s" rows = "10" cols = "80"> </textarea>
<type type = "button" onClick = "madesql ()" value = "生成 sql 语句" style = "border: 1px Solid Green" />
<textarea id = "d" rows = "10" cols = "80"> </textarea>
</div>
<pre id = "sqldemo" style = "display: none" intro = "通用建表结构">
-通用建表结构
إنشاء جدول [DBO]. [tablename] (
[ID] INT INT الأساسي الهوية (1،1) ،-معرف , 主键 , 自动号
[txttitle] varchar (255) ،-标题
[txtcontent] النص ،-内容
[puttime] DateTime Default (getDate ()) ،-提交时间
[Moditime] DateTime Default (getDate ()) ،-修改时间
[HITS] Int Default (0) ،-点击数
[Flags] Int Default (0) ،-标识
[orderid] int default (0) ،-排序号
)
</pre>
<pre id = "sdemo" style = "display: none" intro = "初始源测试数据">