繁體中文当前位置: 首页 > 图文教程 > 脚本技术 > VBScript > vbs生成ACCESS数据里所有表的字段
- VBScript
- vbs 列出该目录下所有文件和文件夹的类型,大小,和所有者
- 雷客图 站长安全助手 vbs版代码(asp 木马查找)
- discuz 任意管理员密码漏洞利用工具 vbs代码
- 添加网站到安全站点.设置安全站点打开ActiveX时提示.去页眉页脚的vbs代码
- 文件夹定时自动备份 AutoBackUpFolder.vbs
- iis PHP安装脚本 PHPInstall.vbs V3.1
- HTA文件去除html控件认证和接收命令行参数
- vbs 更改环境变量
- excel2access vbs脚本
- VBS 下载方法(CDO.MESSAGE)
- vbs实现myipneighbors 域名查询结果整理
- 修改 Gateway和DNS的vbs脚本
- VBS sendkeys 模拟击键操作 问题解决
- 用vbscript来添加ip策略 自动封IP
- vbs,hta中选择文件夹对话框实现代码
- WMI 脚本高手不完全手册
- vbscript语句中“&H”专用于16进制数表示
- URL 筛选小工具 提取网页中的链接地址
- VBScript 文件操作代码小结
- vbs 错误捕获器，用于捕获内部错误并进行手工处理
VBScript 中的 vbs生成ACCESS数据里所有表的字段
出处:互联网 整理: 软晨网（RuanChen.com） 发布: 2009-09-11 浏览: 66 ::
收藏到网摘: n/a
<job id ="生成ACCESS数据库里所有表及所有字段并生成一定格式的字符组合">
<script language ="vbscript">
databasename ="access.mdb"''数据库地址
tablename ="blogarticle"''要处理的表名
Set conn = CreateObject("ADODB.Connection")
connstr ="provider=microsoft.jet.oledb.4.0;data source="&databasename
conn.Open connstr
Set rs_all = CreateObject("adodb.recordset")
sql_all ="select name from MSysObjects where type=1 and flags=0"
rs_all.Open sql_all, conn,1,1
DoWhileNot rs_all.EOF
tablename = rs_all(0)
Set rs = CreateObject("adodb.recordset")
sql ="select * from "& tablename &" where 1<>1"
rs.Open sql, conn,1,1
j = rs.Fields.Count
txtContent =""
txtContent1 =""
txtContent2 =""
txtContent3 =""
txtContent4 =""
For i =0To(j -1)
title = rs.Fields(i).Name
txtContent = txtContent & title &"|"
txtContent1 = txtContent1 & title&"=trim(request("""&title&"""))"&"<br>"
txtContent2 = txtContent2 & title&"=rs("""&title&""")<br>"
txtContent3 = txtContent3 &"rs("""&title&""")=trim(request("""&title&"""))<br>"
txtContent4 = txtContent4 & title&"=rs("""&title&""")<br>"
Next
yongfa365 ="<div align=center><a href=""http://www.yongfa365.com"" class=""titlink"" title=""柳永法(yongfa365)'Blog http://www.yongfa365.com"">柳永法(yongfa365)'Blog</a>制作</div>"&title&"里的字段<br><br>"
CreateFile tablename&".html", yongfa365 & txtContent &"<br><br>"& txtContent1 &"<br><br>"& txtContent2 &"<br><br>"& txtContent3 &"<br><br>"& txtContent4
rs_all.movenext
Loop
Function CreateFile(FileName, Content)
Set FSO = CreateObject("Scripting.FileSystemObject")
Set fd = FSO.CreateTextFile(FileName,True)
fd.WriteLine Content
EndFunction
</script>
</job>
<job id ="生成ACCESS数据库里指定表的所有字段并生成一定格式的字符组合">
<script language ="vbscript">
databasename ="access.mdb"''数据库地址
tablename ="blogarticle"''要处理的表名
Set conn = CreateObject("ADODB.Connection")
connstr ="provider=microsoft.jet.oledb.4.0;data source="&databasename
conn.Open connstr
''Set rs_all = CreateObject("adodb.recordset")
''sql_all = "select name from MSysObjects where type=1 and flags=0"
''rs_all.Open sql_all, conn, 1, 1
''Do While Not rs_all.EOF
'' tablename = rs_all(0)
Set rs = CreateObject("adodb.recordset")
sql ="select * from "& tablename &" where 1<>1"
rs.Open sql, conn,1,1
j = rs.Fields.Count
txtContent =""
txtContent1 =""
txtContent2 =""
txtContent3 =""
txtContent4 =""
For i =0To(j -1)
title = rs.Fields(i).Name
txtContent = txtContent & title &"|"
txtContent1 = txtContent1 & title&"=trim(request("""&title&"""))"&"<br>"
txtContent2 = txtContent2 & title&"=rs("""&title&""")<br>"
txtContent3 = txtContent3 &"rs("""&title&""")=trim(request("""&title&"""))<br>"
txtContent4 = txtContent4 & title&"=rs("""&title&""")<br>"
Next
yongfa365 ="<div align=center><a href=""http://www.yongfa365.com"" class=""titlink"" title=""柳永法(yongfa365)'Blog http://www.yongfa365.com"">柳永法(yongfa365)'Blog</a>制作</div>"&title&"里的字段<br><br>"
CreateFile tablename&".html", yongfa365 & txtContent &"<br><br>"& txtContent1 &"<br><br>"& txtContent2 &"<br><br>"& txtContent3 &"<br><br>"& txtContent4
'' rs_all.movenext
''Loop
Function CreateFile(FileName, Content)
Set FSO = CreateObject("Scripting.FileSystemObject")
Set fd = FSO.CreateTextFile(FileName,True)
fd.WriteLine Content
EndFunction
</script>
</job>
评论 (0) All
