数据库导出xml、htm、csv、sql

时间：2022-06-30 10:44:55 编辑：袖梨来源：一聚教程网

<%
'数据库导出记录代码
'作者海娃,haiwa#，http://www.51windows.Net
'用法：
'ExportDB.asp?sql=select语句&tablename=表名(可选)&filetype=导出格式(xml,htm,csv,sql)&pid=自动编号字段名(仅当导出sql类型时有用)
dim tablename,filetype,fieldPid
sql     = request("sql")
tablename = request("tablename")
filetype = lcase(request("filetype"))
fieldPid = request("pid")
if fieldPid = "" then
fieldPid = "id"
end if
fieldPid = lcase(fieldPid)
if lcase(left(sql,6))<>"select" then
Response.write "sql语句必须为select * from [table] where ......."
Response.end
end if
if tablename = "" then
tablename = "数据导出结果"
end if
function HTMLEncode(fString)
if not isnull(fString) then
    fString = Server.HTMLEncode(fString)
    fString = Replace(fString, CHR(10) & CHR(10), "

")
    fString = Replace(fString, CHR(10), "
")
    fString = Replace(fString, CHR(9), "  ")
    HTMLEncode = fString
end if
end function
function Myreplace(str)
if not isnull(str) then
    fString = Replace(fString,"""", """""")
    Myreplace = str
else
    Myreplace = ""
end if
end function
function Myreplace2(str)
if not isnull(str) then
    fString = Replace(fString,"'", "''")
    Myreplace2 = str
else
    Myreplace2 = ""
end if
end function
dim def_export_sep,def_export_val
def_export_sep = ","
def_export_val = """"
Set rs = Conn.Execute(sql)

推荐专题

最新下载

热门教程

数据库导出xml、htm、csv、sql

相关文章

热门栏目

php教程

asp.net教程

手机开发

css教程

网页制作

办公数码

jsp教程