源码网商城,靠谱的源码在线交易网站 我的订单 购物车 帮助

源码网商城

as3+xml+asp+access做的有奖问答

  • 时间:2021-03-02 10:34 编辑: 来源: 阅读:
  • 扫一扫,手机访问
摘要:as3+xml+asp+access做的有奖问答
XML部份
[u]复制代码[/u] 代码如下:
<?xml version="1.0" encoding="utf-8"?> <li> <id> <pp>1、中国114黄页贵港站的网址是?</pp> <aa>www.gg114chn.com</aa> <aa>gg.114chn.com</aa> <aa>www.114chn.com</aa> <aa>www.114.com</aa> </id> <id> <pp>2、中国114黄页的联系电话号码是多少?</pp> <aa>0775—4320568</aa> <aa>0775—4553709</aa> <aa>0775—4563709</aa> <aa>114</aa> </id> <id> <pp>3、中国114黄页贵港运营中心客服QQ是?</pp> <aa>10000</aa> <aa>380463801</aa> <aa>1015651717</aa> <aa>854512401</aa> </id> <id> <pp>4、中国114黄页的总公司是?</pp> <aa>中国移动</aa> <aa>中国电信</aa> <aa>中国114号码百事通</aa> <aa>北京互联星空文化传播有限公司</aa> </id> </li>
AS3类-myform,放在一个myfirst包里。生成一个主要由ComboBox组件组的表单,
[u]复制代码[/u] 代码如下:
package myfirst{ import flash.display.Sprite; import flash.events.*; import flash.net.*; import flash.text.TextField; import flash.text.TextFieldType; import fl.data.DataProvider; import fl.controls.Button; import fl.controls.ComboBox; import fl.controls.SelectableList; import flash.system.System; public class myform extends Sprite { System.useCodePage = true; var a_form:String=""; var a_num:int; var a_array:Array=new Array(); public function myform():void { var loader:URLLoader=new URLLoader; configureListeners(loader); var request:URLRequest=new URLRequest("pa.xml"); try { loader.load(request); } catch (error:Error) { trace("Unable to load requested document."); } } private function configureListeners(dispatcher:IEventDispatcher):void { dispatcher.addEventListener(Event.COMPLETE,completeHandler); } private function completeHandler(event:Event):void { XML.ignoreProcessingInstructions=true; var loader:URLLoader=URLLoader(event.target); var myxml:XML=XML(loader.data.toString()); a_num=myxml.id.pp.length(); for (var i:int=0; i <= a_num - 1; i++) { var p_text:TextField=new TextField(); p_text.text=myxml.id[i].pp; p_text.width=250; p_text.y=i*50; addChild(p_text); var mycombobox:ComboBox=new ComboBox(); mycombobox.dropdownWidth =180; mycombobox.move(20,20+i*50); mycombobox.prompt="选择答案"; mycombobox.addEventListener(Event.CHANGE, cardSelected); addChild(mycombobox); for (var j:int=0; j<=3; j++) { mycombobox.addItem({label:myxml.id[i].aa[j]}); } } } private function cardSelected(event:Event):void { var cb:ComboBox=event.currentTarget as ComboBox; var cbindex:int=getChildIndex(cb)/2; var aa:int=cb.selectedIndex; a_array[cbindex]=(String(aa)); } public function mm(event:Event):void { for (var k:int=0; k<=a_num-1; k++) { a_form+=String(a_array[k]); } trace(a_form); } } }
同样放在myfirst包里的另一个类url_asp,主要用于连接ASP文件
[u]复制代码[/u] 代码如下:
package myfirst{ import flash.display.Sprite; import flash.events.*; import flash.net.*; import flash.text.TextField; import flash.text.TextFieldType; import fl.controls.Button; import fl.controls.TextInput; import flash.system.System; public class url_asp extends Sprite { public function url_asp() { System.useCodePage=true; var form_name:TextField=new TextField(); var form_tel:TextField=new TextField(); form_name.text="姓名:"; form_tel.text="电话:"; form_name.x=100; form_name.y=350; form_tel.x=100; form_tel.y=300; addChild(form_name); addChild(form_tel); var form_value=new myform(); form_value.x=10; form_value.y=10; addChild(form_value); var myname:String=""; var telephone:String=""; var a_form:String =""; var variables:URLVariables=new URLVariables(); var myrequest:URLRequest=new URLRequest("save.asp"); var loader:URLLoader = new URLLoader(); var mybutton1:Button=new Button(); mybutton1.x=180; mybutton1.y=250; mybutton1.label="确认答案"; mybutton1.addEventListener(MouseEvent.CLICK,form_value.mm); addChild(mybutton1); var myname_input:TextInput=new TextInput(); myname_input.x=180; myname_input.y=350; addChild(myname_input); var telephone_input:TextInput=new TextInput(); telephone_input.x=180; telephone_input.y=300; addChild(telephone_input); var mybutton:Button=new Button(); mybutton.x=180; mybutton.y=400; mybutton.label="提交信息"; addChild(mybutton); mybutton.addEventListener(MouseEvent.CLICK,onclik); function onclik(event:Event):void { variables.myname=myname_input.text; variables.telephone=telephone_input.text; variables.a_form= form_value.a_form; trace( form_value.a_form); myrequest.data=variables; myrequest.method=URLRequestMethod.POST;//指定 URLRequest 对象为 POST。 loader.dataFormat = URLLoaderDataFormat.TEXT; loader.load(myrequest);//发送数据 } } } }
建一个FLA,言文档类就写myfirst.url_asp。 ASP部份,三个文件。 ---conn.asp--- asp文件1数据库连接
[u]复制代码[/u] 代码如下:
<% Dim conn Set conn=Server.CreateObject("ADODB.Connection") conn.Open "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & server.mappath("msg.mdb") %>
--save.asp---- asp文件2保存数据
[u]复制代码[/u] 代码如下:
<!-- #include file=conn.asp --> <% if request("myname")="" then response.Write("no data") response.End() else myname=Request("myname") telephone=Request("telephone") a_form=Request("a_form") sql="Insert into data (myname,telephone,a_form) values ('"&myname&"','"&telephone&"','"&a_form&"')" conn.Execute(sql) conn.close Set conn=Nothing Response.Write "ok" end if %>
----list.asp------ asp文件3查看答题者
[u]复制代码[/u] 代码如下:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>无标题文档</title> <style type="text/css"> <!-- body { background-color: #B57202; } --> </style></head> <!-- #include file="conn.asp" --> <body> <% dim rs_zl set rs_zl =server.createobject("adodb.recordset") rs_zl.open "select * from data",conn,1,1 rs_zl.pagesize=15 if request("page")<>"" then epage=cint(request("page")) if epage<1 then epage=1 if epage>rs_zl.pagecount then epage=rs_zl.pagecount else epage=1 end if rs_zl.absolutepage=epage %> <table width="750" border="0" cellpadding="2" cellspacing="2"> <tr bgcolor="#666666"> <td>ID</td> <td>姓名</td> <td>电话</td> <td>答案</td> <td> </td> </tr> <% for i=0 to rs_zl.pagesize-1 if rs_zl.eof then exit for %> <tr bgcolor="#666666"> <td><%=rs_zl("id")%></td> <td><%=rs_zl("myname")%></td> <td><%=rs_zl("telephone")%></td> <td><%=rs_zl("a_form")%></td> <td> </td> </tr> <% rs_zl.movenext next %> </table> <table width="530"> <tr> <td width="124" height="38"> </td> <td width="259"> <p align="center"> <a href="list.asp">首页</a>  <a href="list.asp?page=<%=epage-1%>">前一页</a>  <a href="list.asp?page=<%=epage+1%>">后一页</a>  <a href="list.asp?page=<%=rs_zl.pagecount%>">末页</a> </p> <p align="center">现在是第<%=epage%>页一共有<%=rs_zl.pagecount%>页</p> </td> <td width="131"> </td> </tr> </table> <% rs_zl.close set rs_zl = nothing conn.close() %> </body> </html>
  • 全部评论(0)
联系客服
客服电话:
400-000-3129
微信版

扫一扫进微信版
返回顶部