〖打印本页〗〖打印选项〗 |
ASP生成文本文件(.txt)的代码 |
<% set conn=server.CreateObject( "adodb.connection" ) set rs=server.CreateObject( "adodb.recordset" ) db= "数据库路径" conn.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &server.MapPath(db) sql= "select * from 表名 order by id desc" set rs=conn.execute(sql) set fileobj=server.CreateObject( "scripting.filesystemobject" ) set textobj=fileobj.createtextfile(server.MapPath("要生成文件的路径和名称")) %> <table width= "90%" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td height="39"> </td> </tr> <tr> <td><font color="#FF0000">生成歌曲列表成功!</font><br> <% while not rs.eof %> <% textobj.writeline( "mkList("""& rs("字段1")&""","""& rs("字段2")&""");") %> <% rs.movenext wend %> </td> </tr> </table> 文章作者:未知 |