使用方法 : 保存为 asptools.hta 然后再运行
代码如下:
<! Doctype html public "-// w3c // dtd xhtml 1.0 transisi // en" "http://www.w3.org/tr/xhtml1/dtd/xhtml1-
transitional.dtd ">
<html xmlns = "http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv = "konten-tipe" content = "text /html; charset = gb2312" />
<meta name = "penulis" konten = "柳永法" />
<title> asp 辅助工具 </iteme>
<tyle> body {font-size: 12px} </style>
<HTA: Aplikasi
Id = "asptools"
ApplicationName = "Asptools"
Gulir = "tidak"
SingleInstance = "Ya"
WindowState = "Normal"
>
</head>
<body>
<div>
<input type = "file" id = "txtfile" onchange = "createTableSelect ('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 = "password" 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 = "createTableselect
('Mssql') "value =" 连接 sql 数据库 " />
<input type = "tombol" id = "btnfromFile" ontClick = "txtfile.click ()" value = "连接 akses 数据库" style = "border: 1px solid
hijau " />
<span id = "Tabel"> </span>
<hr />
模板 :
<input type = "text" id = "opt" value = "" size = "40" />
<Pilih size = "1" id = "fz" onchange = "opt.value = this.value"> </pilih>
<input name = "Tombol" type = "Tombol" id = "tombol" onclick = "c ()" value = "转换" style = "border: 1px solid green">
<hr />
<textarea id = "s" baris = "10" cols = "80"> </textarea>
<input type = "tombol" ontClick = "madesql ()" value = "生成 sql 语句" style = "border: 1px solid green" />
<textarea id = "d" baris = "10" cols = "80"> </textarea>
</div>
<pre id = "sqldemo" style = "display: none" intro = "通用建表结构">
-通用建表结构
Buat tabel [dbo]. [Tablename] (
[Id] int identitas kunci primer (1,1),-id , 主键 , 自动号
[txttitle] varchar (255),-标题
[txtcontent] teks,-内容
[Puttime] DateTime default (getDate ()),-提交时间
[MODITIME] DATETIME Default (getDate ()),-修改时间
[Hits] int default (0),-点击数
[Flag] int default (0),-标识
[OrderId] int default (0),-排序号
)
</per>
<pre id = "sdemo" style = "display: none" intro = "初始源测试数据">