数据库导出xml、htm、csv、sql-xml教程
转载自：互联网 作者：cd3c.com
您正在看的xml教程是:数据库导出xml、htm、csv、sql。
<%
'数据库导出记录代码
'作者海娃,haiwa#blueidea.com，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文件
if filetype="XML" then
Response.contenttype="text/XML"
Response.Charset = "gb2312"
Response.AddHeader "Content-Disposition", "attachment;filename="&tablename&".XML"
Response.write "" & vbnewline
Response.write "
strLine=""
dim thefield(50)
i = 0
For each x in rs.fields
thefield(i)=x.name
i=i+1
Next
While rs.EOF =false
strLine= vbnewline&chr(9)&"
k=0
For each x in rs.fields
strLine= strLine & vbnewline&chr(9)&chr(9)&"<"&thefield(k)&">"
if instr(x.value,"<")>0 or instr(x.value,">")>0 or instr(x.value,"&")>0 or len(x.value)>255 then
strLine= strLine &""
else
strLine= strLine & x.value
end if
strLine= strLine &""
k=k+1
Next
rs.MoveNext
Response.write strLine &vbnewline& chr(9)&""
Wend
Response.write vbnewline&""
'导出sql文件
elseif filetype="sql" then
Response.contenttype="text/sql"
Response.AddHeader "Content-Disposition", "attachment;filename="&tablename&".sql"
strLine=""
dim sql_insert
For each x in rs.fields
if lcase(x.name)<>fieldPid then '如果是自动编号
strLine= strLine & def_export_val & x.name & def_export_val & def_export_sep
end if
Next
strLine = replace(left(strLine,len(strLine)-1),"""","")
strLine = "insert int
[1] [2] [3] 下一篇
