📄 diaocha.asp
字号:
<%@ LANGUAGE="VBSCRIPT"%>
<%
id=request("id")
if (len(request("yj"))<>0 and len(request("yj"))>150) then
response.write "对不起,您输入的内容太长!"
end if
set conn=server.createObject("ADODB.Connection")
dbpath=server.mappath("diaocha.mdb")
conn.open "driver={Microsoft Access Driver (*.mdb)};dbq="&dbpath
set rs1=server.createobject("adodb.recordset")
rs1.LockType=2
sqlstr="select * from diaoc1 where id="& id &" order by tm desc "
rs1.open sqlstr,conn
if (not rs1.eof) then
select case cstr(request("slt"))
case "db1"
rs1("db01")=rs1("db01")+1
case "db2"
rs1("db02")=rs1("db02")+1
case "db3"
rs1("db03")=rs1("db03")+1
case "db4"
rs1("db04")=rs1("db04")+1
end select
rs1.update
total=rs1("db01")+rs1("db02")+rs1("db03")+rs1("db04")
if total=0 then
total=1
%>
<SCRIPT ID=clientEventHandlersJS LANGUAGE=javascript>
<!--
alert( "此条调查信息为最新信息,请给予裁决!");
window.location.href="default.asp";
//-->
</SCRIPT>
<%
end if
yj=request("yj")
if yj<>"" then
sqlstr2="insert into diaoc2 (id,yj,riqi) values ("&id&",'"&replace(replace(yj,"'","''"),vbcrlf,"<br>")&"',now())"
conn.execute sqlstr2
set conn=nothing
end if
end if
%>
<HTML>
<HEAD>
<TITLE>Zhao1Zhao网上调查</TITLE>
<META content="text/html; charset=gb2312" http-equiv=Content-Type>
<link rel="stylesheet" href="3508.css">
<style type="text/css">
<!--
.red { color: #FF0000}
-->
</style>
</HEAD>
<BODY bgColor=#ffffff leftMargin=0 topMargin=0 marginheight="0" marginwidth="0" >
<FORM name=form1>
<TABLE border=0 cellPadding=0 cellSpacing=0 class=normal width="600" align="center">
<TR valign="bottom">
<TD height="36"> 【调查结果】</TD>
</TR>
<TR>
<TD>
<TABLE border=1 cellPadding=0 cellSpacing=0 width="580" bordercolorlight="#FF66CC" bordercolordark="#FFFFFF" align="center">
<TBODY>
<TR>
<TD colSpan=3> ★★★★★<span class="red"><%=rs1("sb")%>？</span>★★★★★</TD>
</TR>
<TR>
<TD class=normal><%=rs1("db1")%></TD>
<TD class=normal><%=rs1("db01")%></TD>
<TD class=normal><%=FormatPercent(rs1("db01")/total)%></TD>
</TR>
<TR>
<TD class=normal bgcolor="#ffffff"><%=rs1("db2")%></TD>
<TD class=normal bgcolor="#ffffff"><%=rs1("db02")%></TD>
<TD class=normal bgcolor="#ffffff"><%=FormatPercent(rs1("db02")/total)%></TD>
</TR>
<TR>
<TD class=normal><%=rs1("db3")%></TD>
<TD class=normal><%=rs1("db03")%></TD>
<TD class=normal><%=FormatPercent(rs1("db03")/total)%></TD>
</TR>
<TR>
<TD class=normal bgcolor="#ffffff"><%=rs1("db4")%></TD>
<TD class=normal bgcolor="#ffffff"><%=rs1("db04")%></TD>
<TD class=normal bgcolor="#ffffff"><%=FormatPercent(rs1("db04")/total)%></TD>
</TR>
<TR>
<TD class=normal colSpan=3 bgcolor="#ffffff" align="center">投票总人数：<%=total%>人</TD>
</TR>
</TBODY>
</TABLE>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr align="right">
<td> </td>
</tr>
<tr align="right">
<td><A class=blue9
href="default.asp">更多调查>></A></td>
</tr>
<tr>
<td bgcolor="ff0000" height="1"></td>
</tr>
<tr>
<td width="95%"> </td>
</tr>
<%
set conn=server.createObject("ADODB.Connection")
dbpath=server.mappath("diaocha.mdb")
conn.open "driver={Microsoft Access Driver (*.mdb)};dbq="&dbpath
set rs=server.createobject("adodb.recordset")
'rs.LockType=2
sqlstr="select top 10 yj from diaoc2 where id="&id
rs.open sqlstr,conn,1,1
num=rs.recordCount
if not rs.eof then
for i=0 to num-1
%>
<tr>
<td width="95%"> ◆<%=rs("yj")%></td>
</tr>
<%
rs.movenext
if rs.eof then exit for
next
if yj<>"" then
%>
<tr>
<td width="95%"> ◆<%=yj%></td>
</tr>
<%end if
%>
</table>
<%
end if
set conn=nothing
%>
</TD>
</TR>
</TABLE>
</FORM>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -