: : 保存为 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">
<голова>
<meta http-equiv = "content-type" content = "text /html; charset = gb2312" />
<meta name = "Автор" content = "柳永法" />
<title> asp 辅助工具 </title>
<style> body {font-size: 12px} </style>
<HTA: Приложение
Id = "asptools"
ApplicationName = "Asptools"
Scroll = "Нет"
SingleInstance = "Да"
WindowState = "Нормальный"
>
</head>
<тело>
<div>
<input type = "file" id = "txtfile" onchange = "createableselect ('access')" style = "Display: none" />
Ip : <input type = "text" name = "ip" size = "16" style = "border: 1px solid green" value = "./ sql2005" />
登录名 : <input type = "text" name = "userId" size = "10" style = "border: 1px solid green" value = "sa" />
密码 : <input type = "пароль" name = "pwd" size = "10" style = "border: 1px solid green" value = "yongfa365" />
数据库名 : <input 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 = "createletableselect
('Mssql') "value =" 连接 sql 数据库 " />
<input type = "кнопка" id = "btnfromfile" onclick = "txtfile.click ()" value = "连接 Access 数据库" style = "Граница: 1px solid
зеленый » />
<span id = "таблицы"> </span>
<HR />
模板 :
<input type = "text" id = "opt" value = "" size = "40" />
<select size = "1" id = "fz" onchange = "opt.value = this.value"> </select>
<input name = "кнопка" type = "кнопка" id = "кнопка" onclick = "c ()" value = "转换" style = "border: 1px solid green">
<HR />
<textarea id = "s" row = "10" cols = "80"> </textarea>
<input type = "button" onclick = "madesql ()" value = "生成 sql 语句" стиль = "граница: 1px solid green" />
<textarea id = "d" row = "10" cols = "80"> </textarea>
</div>
<pre id = "sqldemo" style = "display: none" intro = "通用建表结构">
-通用建表结构
Создать таблицу [DBO]. [TableName] (
[ID] INT Первичный ключ идентичность (1,1),-id , 主键 , 自动号
[txttitle] varchar (255),-标题
[txtContent] Текст,-内容
[Puttime] datetime default (getDate ()),-提交时间
[MODITIME] DateTime Default (getDate ()),-修改时间
[Hits] int по умолчанию (0),-点击数
[Флаги] int по умолчанию (0),-标识
[Orderid] int по умолчанию (0),-排序号
)
</pre>
<pre id = "sdemo" style = "display: none" intro = "初始源测试数据">