<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%> <%set Conn=Server.CreateObject("ADODB.Connection") Conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & Server.MapPath("jd100.asp")%> <% const MaxPerPage=10 dim totalPut dim CurrentPage dim TotalPages dim i,j dim sql dim rs if not isempty(request("page")) then currentPage=cint(request("page")) else currentPage=1 end if %> <%''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' if request("action")="Add" then '添加新留言到数据库 If Request.Form("name")="" Then Response.Write "姓名不能为空" Response.Write "
" Response.Write "返回" Response.End End If If Len(Request.Form("name"))>20 Then Response.Write "姓名不能太长" Response.Write "
" Response.Write "返回" Response.End End If If Request.Form("email")<>"" Then If instr(Request.Form("email"),"@")=0 or instr(Request.Form("email"),"@")=1 or instr(Request.Form("email"),"@")=len(email) then Response.Write "电子信箱格式填写不正确" Response.Write "
" Response.Write "返回" Response.End End If End If If Request.Form("words")="" Then Response.Write "留言不能为空" Response.Write "
" Response.Write "返回" Response.End End If Set Rs = Server.CreateObject("ADODB.RecordSet") Sql="Select * From words where words not like ('%http%') order by id desc" Rs.Open Sql,Conn,2,3 Rs.AddNew Rs("name")=Server.HTMLEncode(Request.Form("name")) Rs("sex")=Server.HTMLEncode(Request.Form("sex")) Rs("head")=Server.HTMLEncode(Request.Form("head")) Rs("web")=Server.HTMLEncode(Request.Form("web")) Rs("email")=Server.HTMLEncode(Request.Form("email")) Rs("words")=Server.HTMLEncode(Request.Form("words")) Rs("qq")=Server.HTMLEncode(Request.Form("qq")) Rs("head")=Server.HTMLEncode(Request.Form("Image")) Rs("date")=Now() Rs("ip")=request.servervariables("remote_addr") Rs("come")=Server.HTMLEncode(Request.Form("come")) Rs.Update Rs.Close Set Rs = Nothing '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' end if %> <% if request("pass")="long" then username = Server.HTMLEncode(Request.Form("username")) password = Server.HTMLEncode(Request.Form("password")) If username = "" OR password = "" Then Response.Write "用户名或者密码为空" Response.End End If Set Rs = Server.CreateObject("ADODB.RecordSet") Sql="Select * From admin" Rs.Open Sql,Conn,1,1 If username = Rs("username") AND password = Rs("password") Then Session("Admin") = "Login" Else Response.Write "用户名或者密码不对,登陆失败" End If Rs.Close Set Rs = Nothing end if %> <% if request("action")="Delete" then If Session("Admin")="" Then Response.Write "连接超时,请重新登录" Response.End end if '删除数据 Conn.Execute("Delete * From words Where id="&Request.QueryString("id")) end if %> <% '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' '回复留言添加到数据库 if request("huai")="fu"then Set Rs = Server.CreateObject("ADODB.RecordSet") Sql="Select * From words Where id="&Request.Form("id") Rs.Open Sql,Conn,2,3 Rs("view") = Request.Form("view") Rs("reply") = Server.HTMLEncode(Request.Form("reply")) Rs.Update Rs.Close end if %> <% if request("action")="Exit" then session("Admin")="" end if %> 天津医科大学代谢病医院
网站首页 | 新闻动态| 医院介绍| 科室介绍 |专家介绍 |科研教学 | 糖尿病教育| 就医指南 | 专家问 | 国内外交流 | 联系我们
您现在所在的位置:首页 -> 专家问答

 
 
<% If Session("Admin")="Login" Then %> 退出管理 <% Else %> 管理留言 <% End If %> <% If Session("Admin")="Login" Then %> 修改密码 <% End If %>
<% if request("action")="Edit" then Set Rs = Server.CreateObject("ADODB.RecordSet") Sql="Select * From words Where id="&Request.QueryString("id") Rs.Open Sql,Conn,1,1 view2="" if rs("view")=1 then view2="checked" end if %>
编辑留言内容及回复
留言内容:
回复

> 通过审批
">  
<%end if%>

<% if request("ac")="Admin_Login" then %>

管理登陆
用户名:
密 码:

 

<% end if %>   <% if request("action")="cx" then%>

查询系统
查询内容

<% end if %> <% if request("action")="Add_New" then%>

留 言
姓名:
*10个字内 选择头像:
性别:
QQ:
主页:
来自:
电子邮箱: *
粗体 斜体 下划线 居中 字体大小  颜色:
留言内容: *
  最多字数: 已用字数: 剩余字数:

<%end if%>
<% nr=request("cxnr") if nr="" then dim nr nr=request.form("cxnr") 'sql="select COUNT(*) as gbcount From words where title like " + nr+ " or words like " +nr 'sql="select COUNT(*) as gbcount From words " sql="select * from words where words not like ('%http%') order by id desc" set rs=server.createobject("adodb.recordset") rs.open sql,conn,3,2 else sql="select * from [words] Where words not like ('%http%') and words like '%"&trim(nr)&"%'order by id DESC" set rs=server.createobject("adodb.recordset") rs.open sql,conn,3,2 end if if rs.eof and rs.bof then 'response.write "

还 没 有 任 何 留 言

" %> 对 不 起,没 有 找 到 您 想 要 的< <%=nr%>>  留 言 <% else totalPut=rs.recordcount totalPut=rs.recordcount if currentpage<1 then currentpage=1 end if if (currentpage-1)*MaxPerPage>totalput then if (totalPut mod MaxPerPage)=0 then currentpage=totalPut \ MaxPerPage else currentpage=totalPut \ MaxPerPage + 1 end if end if if currentPage=1 then showContent showpage totalput,MaxPerPage,"zjwd.asp" else if (currentPage-1)*MaxPerPage1 then lou=currentPage*10 end if do while not rs.eof lou=lou+1 words=rs("words") %>
【<%=rs.recordcount-lou+1%>】<%=rs("name")%>
<% If Rs("sex")=1 Then Response.Write "你点到帅哥了" Else Response.Write "你点到美女了 " End If %> "><%=qq%> "><%=email%> " target="_blank"><%=web%> <%=Rs(来自:<%=Rs("come")%>" width="16" height="16"> <%=year(Rs("date"))%>年<%=month(Rs("date"))%>月<%=day(Rs("date"))%>日  <% If Session("Admin") = "Login" Then %> <%=Rs("ip")%> &Page=<%=CurrentPage%>">编辑回复 " onClick="return confirm('确定要删除吗?\n\n该操作不可恢复!')">删除留言 <% end if %>  
<%if rs("head")="" then %> <% else %> .gif"> <% end if %> <% if rs("view")=1 then %> <%xx= words xx =replace(words,"[/url]","") xx =replace(xx,"[url","") response.write xx %>
斑竹回复:
<%=rs("reply")%>
<% else%> 本留言需要经过审批才能查看 <%end if %>


<% i=i+1 if i>=MaxPerPage then exit do rs.movenext loop end sub %> <% function showpage(totalnumber,maxperpage,filename) dim n if totalnumber mod maxperpage=0 then n=totalnumber \ maxperpage else n=totalnumber \ maxperpage + 1 end if response.write "

" response.write "

 " response.write ""&totalnumber&"条行业信息 " if CurrentPage<2 then response.write "首页 上一页 " else response.write "首页 " response.write "上一页 " end if if n-currentpage<1 then response.write "下一页 尾页" else response.write "下一页 " response.write "尾页" end if response.Write " 页次:"& CurrentPage &"/"& n &"页 "& maxperpage &"条/页" response.write " 转到:" response.write "

" end function %>

 
 
<% function unHtml(content) unHtml=content if content <> "" then unHtml=replace(unHtml,"&","&") unHtml=replace(unHtml,"<","<") unHtml=replace(unHtml,">",">") unHtml=replace(unHtml,chr(34),""") unHtml=replace(unHtml,chr(13),"
") unHtml=replace(unHtml,chr(32)," ") '使用数组 返回值数组 = Split("字符串","分割符") 'IsArray()判断是否数组的函数,LBound()取数组的下标,UBound()取数组的上标。 unhtmlgl=split(webgl,"|") if IsArray(unhtmlgl) then for i=0 to UBound(unhtmlgl) unhtml=replace(unhtml,unhtmlgl(i),"***") next end if 'unHtml=ubb(unHtml) end if end function function ubb(content) ubb=content nowtime=now() UBB=Convert(ubb,"code") UBB=Convert(ubb,"html") UBB=Convert(ubb,"url") UBB=Convert(ubb,"color") UBB=Convert(ubb,"font") UBB=Convert(ubb,"size") UBB=Convert(ubb,"quote") UBB=Convert(ubb,"email") UBB=Convert(ubb,"img") UBB=Convert(ubb,"swf") ubb=convert(ubb,"cen") ubb=convert(ubb,"rig") ubb=convert(ubb,"lef") ubb=convert(ubb,"center") UBB=AutoURL(ubb) ubb=replace(ubb,"[b]","",1,-1,1) ubb=replace(ubb,"[/b]","",1,-1,1) ubb=replace(ubb,"[i]","",1,-1,1) ubb=replace(ubb,"[/i]","",1,-1,1) ubb=replace(ubb,"[u]","",1,-1,1) ubb=replace(ubb,"[/u]","",1,-1,1) ubb=replace(ubb,"[blue]","",1,-1,1) ubb=replace(ubb,"[/blue]","",1,-1,1) ubb=replace(ubb,"[red]","",1,-1,1) ubb=replace(ubb,"[/red]","",1,-1,1) for i=1 to 28 ubb=replace(ubb,"{:em"&i&"}","",1,6,1) ubb=replace(ubb,"{:em"&i&"}","",1,-1,1) next ubb=replace(ubb,"["&chr(176),"[",1,-1,1) ubb=replace(ubb,chr(176)&"]","]",1,-1,1) ubb=replace(ubb,"/"&chr(176),"/",1,-1,1) ' ubb=replace(ubb,"{;em","{:em",1,-1,1) end function function Convert(ubb,CovT) cText=ubb startubb=1 do while Covt="url" or Covt="color" or Covt="font" or Covt="size" startubb=instr(startubb,cText,"["&CovT&"=",1) if startubb=0 then exit do endubb=instr(startubb,cText,"]",1) if endubb=0 then exit do Lcovt=Covt startubb=startubb+len(lCovT)+2 text=mid(cText,startubb,endubb-startubb) codetext=replace(text,"[","["&chr(176),1,-1,1) codetext=replace(codetext,"]",chr(176)&"]",1,-1,1) 'codetext=replace(codetext,"{:em","{;em",1,-1,1) codetext=replace(codetext,"/","/"&chr(176),1,-1,1) select case CovT case "color" cText=replace(cText,"[color="&text&"]","",1,1,1) cText=replace(cText,"[/color]","",1,1,1) case "font" cText=replace(cText,"[font="&text&"]","",1,1,1) cText=replace(cText,"[/font]","",1,1,1) case "size" if IsNumeric(text) then if text>6 then text=6 if text<1 then text=1 cText=replace(cText,"[size="&text&"]","",1,1,1) cText=replace(cText,"[/size]","",1,1,1) end if case "url" cText=replace(cText,"[url="&text&"]","",1,1,1) cText=replace(cText,"[/url]","",1,1,1) case "email" cText=replace(cText,"["&CovT&"="&text&"]","",1,1,1) cText=replace(cText,"[/"&CovT&"]","",1,1,1) end select loop startubb=1 do startubb=instr(startubb,cText,"["&CovT&"]",1) if startubb=0 then exit do endubb=instr(startubb,cText,"[/"&CovT&"]",1) if endubb=0 then exit do Lcovt=Covt startubb=startubb+len(lCovT)+2 text=mid(cText,startubb,endubb-startubb) codetext=replace(text,"[","["&chr(176),1,-1,1) codetext=replace(codetext,"]",chr(176)&"]",1,-1,1) 'codetext=replace(codetext,"{:em","{;em",1,-1,1) codetext=replace(codetext,"/","/"&chr(176),1,-1,1) select case CovT case "center" cText=replace(cText,"[center]","
",1,1,1) cText=replace(cText,"[/center]","
",1,1,1) case "url" cText=replace(cText,"["&CovT&"]"&text,""&codetext,1,1,1) cText=replace(cText,""&codetext&"[/"&CovT&"]",""&codetext&"",1,1,1) case "email" cText=replace(cText,"["&CovT&"]","",1,1,1) cText=replace(cText,"[/"&CovT&"]","",1,1,1) case "html" codetext=replace(codetext,"
",chr(13),1,-1,1) codetext=replace(codetext," ",chr(32),1,-1,1) Randomize rid="temp"&Int(100000 * Rnd) cText=replace(cText,"[html]"&text,"代码片断如下: ",1,1,1) case "img" '一般显示的图片 cText=replace(cText,"[img]"&text,""&chr(34)&" target=_blank>::点击图片在新窗口中打开::",1,1,1) case "cen" '图片居中 cText=replace(cText,"[cen]"&text,"
"&chr(34)&" target=_blank>::点击图片在新窗口中打开::
",1,1,1) case "rig" '图片居右,文字绕排 cText=replace(cText,"[rig]"&text,""&chr(34)&" target=_blank>::点击图片在新窗口中打开::",1,1,1) case "lef" '图片居左,文字绕排 cText=replace(cText,"[lef]"&text,""&chr(34)&" target=_blank>::点击图片在新窗口中打开::",1,1,1) case "code" cText=replace(cText,"[code]"&text,"以下内容为程序代码
"&codetext,1,1,1) cText=replace(cText,"以下内容为程序代码
"&codetext&"[/code]","以下内容为程序代码
"&codetext&"
",1,1,1) case "quote" atext=replace(text,"[cen]","",1,-1,1) atext=replace(text,"[/cen]","",1,-1,1) atext=replace(text,"[img]","",1,-1,1) atext=replace(atext,"[/img]","",1,-1,1) atext=replace(atext,"[swf]","",1,-1,1) atext=replace(atext,"[/swf]","",1,-1,1) atext=replace(atext,"[html]","",1,-1,1) atext=replace(atext,"[/html]","",1,-1,1) ' atext=replace(atext,"{:em","{;em",1,-1,1) atext=SplitWords(atext,350) atext=replace(atext,chr(32)," ",1,-1,1) cText=replace(cText,"[quote]"&text,"

"&atext,1,1,1) cText=replace(cText,"

"&atext&"[/quote]","

"&atext&"
",1,1,1) case "swf" cText=replace(cText,"[swf]"&text,"",1,1,1) cText=replace(cText,""&"[/swf]",""&"",1,1,1) end select loop Convert=cText end function function AutoURL(ubb) cText=ubb startubb=1 do startubb=1 endubb_a=0 endubb_b=0 endubb=0 startubb=instr(startubb,cText,"http://",1) if startubb=0 then exit do endubb_b=instr(startubb,cText,"<",1) endubb_a=instr(startubb,cText," ",1) endubb=endubb_a if endubb=0 then endubb=endubb_b end if if endubb_b0 then endubb=endubb_b end if if endubb=0 then lenc=ctext endubb=len(lenc)+1 end if 'response.write startubb&","&endubb if startubb>endubb then exit do text=mid(cText,startubb,endubb-startubb) 'response.write text 'codetext=replace(text,"/","/"&chr(176),1,-1,1) codetext=text 'response.write text&"," urllink=""&codetext&" " 'response.write urllink urllink=replace(urllink,"/","/"&chr(176),1,-1,1) cText=replace(cText,text,urllink,1,1,1) loop AutoURL=cText end function %> <% %>