使用方法: 保存为 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 辅助工具 </title>
<style> ร่างกาย {ตัวอักษรขนาด: 12px} </style>
<HTA: แอปพลิเคชัน
id = "asptools"
ApplicationName = "Asptools"
Scroll = "ไม่"
singleinstance = "ใช่"
WindowState = "ปกติ"
-
</head>
<body>
<div>
<input type = "file" id = "txtFile" onChange = "createTeTableSelect ('access')" style = "display: none" />
ip: <อินพุต type = "text" name = "ip" size = "16" style = "Border: 1px Solid Green" value = "./ SQL2005" />
登录名: <อินพุต type = "text" name = "userId" size = "10" style = "Border: 1px Solid Green" value = "SA" />
密码: <อินพุต type = "รหัสผ่าน" 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 = "ปุ่ม" 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 = "button" type = "ปุ่ม" id = "ปุ่ม" onclick = "c ()" value = "转换" style = "border: 1px solid green">>
<HR />
<textarea id = "s" rows = "10" cols = "80"> </textarea>
<อินพุต type = "ปุ่ม" onclick = "madesql ()" value = "生成 sql 语句" 语句 "style =" border: 1px solid green " />
<textarea id = "d" rows = "10" cols = "80"> </textarea>
</div>
<pre id = "sqldemo" style = "จอแสดงผล: ไม่มี" อินโทร = "通用建表结构">
-通用建表结构
สร้างตาราง [dbo]. [tablename] (
[ID] INT IDEDITY หลัก (1,1),-ID, 主键,, 自动号
[txttitle] Varchar (255),-标题
[txtContent] ข้อความ-内容
[Puttime] DateTime Default (getDate ()),-提交时间
[Moditime] DateTime Default (getDate ()),-修改时间
[HITS] Int Default (0),-点击数
[Flags] int default (0),-标识
[orderId] int default (0),-排序号
-
</der>
<pre id = "sdemo" style = "แสดง: ไม่มี" อินโทร = "初始源测试数据">