使用方法:保存为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 = "Author" content = "柳永法" />
<title>asp辅助工具</title>
<style> body {font-size:12px} </style>
<HTA:アプリケーション
id = "asptools"
ApplicationName = "Asptools"
scroll = "no"
singleInstance = "はい"
window -state = "normal"
>
</head>
<body>
<div>
<入力型= "file" id = "txtfile" onchange = "createTablesElect( 'access')" style = "display:none" />
IP:<入力タイプ= "テキスト" name = "ip" size = "16" style = "border:1px solid green" value = "./ sql2005" />
登录名:<入力タイプ= "テキスト" name = "userid" size = "10" style = "border:border:solid緑"値= "sa" />
and:<入力タイプ= "パスワード" name = "pwd" size = "10" style = "border:1pxソリッドグリーン"値= "yongfa365" />
and:<入力タイプ= "テキスト" name = "dbname" size = "10" style = "border:" balune "value =" hb605-8-8 " /> <br />
<入力名= "button2" type = "button" id = "button2" style = "border:1px solid green" onclick = "createTablesElect
( 'mssql') "value ="连接sql数据库 " />
<入力型= "button" id = "btnfromfile" onclick = "txtfile.click()" value = "连接アクセス数据库" style = "border:1px solid
緑 " />
<span id = "tables"> </span>
<hr />
模板:
<入力型= "text" id = "opt" value = "" size = "40" />
<select size = "1" id = "fz" onchange = "opt.value = this.value"> </select>
<入力名= "button" type = "button" id = "button" onclick = "c()" value = "转换" style = "border:1px solid緑">
<hr />
<textarea id = "s" rows = "10" cols = "80"> </textarea>
<入力型= "button" onclick = "madesql()" value = "生成sql语句" style = "border:1px solid緑" />
<textarea id = "d" rows = "10" cols = "80"> </textarea>
</div>
<preid = "sqldemo" style = "display:none" intro = "通用建表结构">
- 通用建表结构
テーブルを作成[dbo]。[tablename](
[id] intプライマリキーアイデンティティ(1,1)、 - id、主键、自动号
[txttitle] varchar(255)、 - 标题
[txtcontent]テキスト、 - 内容
[PutTime] DateTime Default(getDate())、 - 提交时间
[Moditime] DateTime Default(getDate())、 - 修改时间
[ヒット] int default(0)、 - 点击数
[flags] int default(0)、 - 标识
[OrderId] int default(0)、 - 排序号
))
</pre>
<preid = "sdemo" style = "display:none" intro = "初始源测试数据">