繁體中文当前位置: 首页 > 图文教程 > 网络编程 > ASP > 创建一个Web投票系统
- ASP
- 一种比较方便的ASP分页程序
- 用一套论坛程序架设多个论坛
- ASP与ASP.NET在COOKIE方面的区别
- 较长数据无法在Asp页面中取出的三种解决方法
- 初试WAP之wml＋ASP查询
- 动态网站首页的静态生成方法
- 使用正则表达式实现模式图片新闻.ASP
- 让你的WAP网站有更好的兼容性
- WAP版的手机号码所在地查询
- asp模仿 Lotus Notes 的界面程序
- ORACLE920与ASP的连接问题的解决办法
- 利用SQLSERVER存储过程实现ASP用户身份验证
- 在ASP中自动创建多级文件夹的函数(使用FSO)
- 利用instr()函数防止SQL注入攻击
- 利用XSL和ASP实现XML文档在线编辑
- 表单对象textarea内容的格式控制（回车、换行、空格）
- 针对select写了一个通用的option输出函数
- ASP无组件BMP汉字生成类+汉字点阵库
- 时间、空间性能极优的asp无组件上传类
- 无组件生成BMP验证码
ASP 中的 创建一个Web投票系统
出处:互联网 整理: 软晨网（RuanChen.com） 发布: 2009-11-03 浏览: 103 ::
收藏到网摘: n/a
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
评论 (0) All
