生成文件很简单初学者

<%

 


Response.Buffer=true

function chan_time(shijian)'转换日期时间函数
    s_year=year(shijian)
    if len(s_year)=2 then s_year="20"&s_year
    s_month=month(shijian)
    if s_month<10 then s_month="0"&s_month
    s_day=day(shijian)
    if s_day<10 then s_day="0"&s_day
    s_hour=hour(shijian)
    if s_hour<10 then s_hour="0"&s_hour
    s_minute=minute(shijian)
    if s_minute<10 then s_minute="0"&s_minute
    chan_time=s_year & s_month & s_day & s_hour & s_minute
end function

function chan_data(shijian) '转换日期时间函数
    s_year=year(shijian)
    if len(s_year)=2 then s_year="20"&s_year
    s_month=month(shijian)
    if s_month<10 then s_month="0"&s_month
    s_day=day(shijian)
    if s_day<10 then s_day="0"&s_day
    chan_data=s_year & s_month & s_day
end function


function chan_file(shijian)'转换日期时间函数
    s_month=month(shijian)
    if s_month<10 then s_month="0"&s_month
    s_day=day(shijian)
    if s_day<10 then s_day="0"&s_day
    s_hour=hour(shijian)
    if s_hour<10 then s_hour="0"&s_hour
    s_minute=minute(shijian)
    if s_minute<10 then s_minute="0"&s_minute
    s_ss=second(shijian)
    if s_ss<10 then s_ss="0"&s_ss
    chan_file = s_month & s_day & s_hour & s_minute & s_ss
end function

Dim conn
Dim sql
Set conn=Server.CreateObject("ADODB.Connection")
conn.Open "Provider=SQLOleDb.1;Data Source=(local);User ID=sa;Password=;Initial Catalog=Pubs"

sql="Select * From NC_News Where ID="&Request("ID")

Dim Rs1
set Rs1=conn.excute(sql)
if not Rs1.eof then
    Title=Rs1("Title")
    Content=Rs1("Content")
   
End

 

top="<html><head><title>"&Title&"</title></head><body>"
botom="</body></html>"
msg=Content
msg=replace(msg,vbcrlf,"")
msg=replace(msg,chr(9),"")
msg=replace(msg," ","&nbsp;")
msg=replace(msg,"\r\n","<br>")
msg=replace(msg,"\n","<br>")
msg=top&msg&botom
Set fs=Server.CreateObject("Scripting.FileSystemObject")
all_tree2=server.mappath("..\news")
if (fs.FolderExists(all_tree2)) then'判断今天的文件夹是否存在
else
    fs.CreateFolder(all_tree2)
end if
    'pass=chan_file(now)
    'randomize '使用系统计时器来初始化乱数产生器
    'pass=rnd(pass)
    'pass=get_pass(pass)
    'pass=left(pass,10) file1=pass
    files=Request("ID")&".txt"
    filez=all_tree2&files
set ts = fs.createtextfile(filez,true) '写文件
for z=1 to len(msg)
    write_now=mid(msg,z,1)
    ts.write(write_now)
next
' ts.writeline(all_msg)
ts.close
set ts=nothing '文件生成

if err.number<>0 or err then
%>
<script language="javascript">
    alert("不能完成")
</script>
<%else%>
<script language="javascript">
    alert("已完成")
    history.back();
</script>
<%end if
Set MyFile = fs.GetFile(filez)
'all_tree2=server.mappath("../news")&"\"&chan_data(now)
'if (fs.FolderExists(all_tree2)) then
'else
'   fs.CreateFolder(all_tree2)
'end if


MyFile.name= Request("ID")&".htm"
set MyFile=nothing
set fs=nothing
set fdir=nothing
function get_pass(pass)
    pass=cstr(pass)
    pass=replace(pass," ","")
    pass=replace(pass," ","")
    pass=replace(pass,"-","")
    pass=replace(pass," ","")
    pass=replace(pass,":","")
    pass=replace(pass,".","")
    pass=replace(pass,"+","")
    pass=replace(pass,"_","")
    pass=replace(pass,"<","")
    pass=replace(pass,">","")
    pass=replace(pass,"!","")
    pass=replace(pass,"@","")
    pass=replace(pass,"#","")
    pass=replace(pass,"$","")
    pass=replace(pass,"%","")
    pass=replace(pass,"^","")
    pass=replace(pass,"&","")
    pass=replace(pass,"*","")
    pass=replace(pass,"(","")
    pass=replace(pass,")","")
    pass=replace(pass,"=","")
    pass=replace(pass,"\","")
    pass=replace(pass,"/","")
    pass=replace(pass,"|","")
    get_pass=pass
end function

 

 

 


%>

posted on 2012-12-25 10:32  tom_xsb  阅读(214)  评论(0编辑  收藏  举报

导航