当前位置: 首页 > 图文教程 > 网络编程 > ASP > 创建一个Web投票系统

ASP
ASP实现不存在的网页就自动发送邮件
多个绑定多域名的ASP代码
ASP导出Excel数据的四种方法
用控件的方式解决问题-在客户端关联WEB控件引用
用ASP建立一个简单的聊天室
用Asp隐藏文件路径,实现防盗链
ASP实例：即时显示当前页面浏览人数
网页视频播放器程序代码通用代码
Cookies 欺骗漏洞的防范(vbs+js 实现)
ASP应用程序设计的Web状态管理分析
ASP中Session技巧
ASP教程：透彻掌握ASP分页技术
ASP获取字符串长度的自定义函数
通过实例讲解来学习ASP中的函数
ASP实例代码：长文章分页代码设置方法
深入理解ASP中FSO的神奇功能
用ASP代码得到客户端IP和当前地址
服务端 VBScript 与 JScript 几个相同特性的写法
JS+DIV模拟SELECT表单域
插入ASP代码让网站数据库成为ASP木马

No. « 4 5 6 7 »

技术文章搜索

关键字

ASP 中的 创建一个Web投票系统

出处:互联网   整理: 软晨网（RuanChen.com）   发布: 2009-11-03   浏览: 33 ::
收藏到网摘: n/a

  下面zip文件：http://www.content.aspdir.co.uk/files/Article-11.zip

During this article you will learn how to construct your own web poll using ASP. The article presumes you
already understand basic database interaction.



The following samples of code allow a user to select one of four options to a question. The user's vote is
then recorded in a database and the user is taken to a page where the results for each option can be
viewed in statistical, numerical and graphical form. Not bad, huh?

The whole application is based on the database itself, so when the values within the database are altered,
the application automatically changes. The database design itself, is not included within this article so
make sure to download a copy of the entire application, including the database before running the code.

The code for the first page is shown as follows: -

Page: default.asp

<%
'Connects to database using recordset method
Function dataConn(database,connection,recordset)
    Set connection = Server.CreateObject("ADODB.Connection")
    Set recordset = Server.CreateObject("ADODB.Recordset")
    connection.Open "DBQ=" & Server.Mappath(database) & ";Driver={Microsoft Access Driver (*.mdb)};"
End Function
%>
<HTML>
<HEAD>
    <TITLE>Poll Example</TITLE>
</HEAD>

<BODY>
    <FORM name="languages" method=post action="pollResults.asp">
    <P>What is your favoutrite language?</P>
<%
'Calls dataConn function to open dbPoll.mdb
dataConn "files/dbPoll.mdb",POdc,LArs

'Selects all fields within tblLanguages
LArs.Open "SELECT * FROM tblLanguages", POdc

'Loop through and display each record within the database as a radio button
Do While Not LArs.EOF
    Response.Write LArs("Language") & ": <INPUT type=radio name='language' value='" & LArs("Language")
& "'><BR>"
    LArs.MoveNext
Loop

'Close database connection
LArs.Close
POdc.Close
Set POdc = Nothing
%>
    <A href="pollResults.asp">View Poll</A>
    <INPUT type=submit value="Vote">
    </FORM>
</BODY>
</HTML>


Once connected to the database the script loops through each record, and displays that option as a radio
button. When the 'Vote' button is pressed, the individual value of the selected radio button is submitted
to the next page.

The code for the next page is shown below: -

Page: pollResults.asp

<%
'Define all variables that will be used
Dim I, Percent

'Connects to database using recordset method
Function dataConn(database,connection,recordset)
    Set connection = Server.CreateObject("ADODB.Connection")
    Set recordset = Server.CreateObject("ADODB.Recordset")
    connection.Open "DBQ=" & Server.Mappath(database) & ";Driver={Microsoft Access Driver (*.mdb)};"
End Function
%>
<HTML>
<HEAD>
    <TITLE>Polling Sample</TITLE>
</HEAD>

<BODY>
<%
'Calls dataConn function to open dbPoll.mdb
dataConn "files/dbPoll.mdb",POdc,LArs

'Selects all fields within tblLanguages
LArs.Open "SELECT * FROM tblLanguages", POdc,1,2

'Loop through and total up number of votes for all records
Do While Not LArs.EOF

    'If record contains voted language then increment votes
    If