| <!-- |
| Licensed to the Apache Software Foundation (ASF) under one or more |
| contributor license agreements. See the NOTICE file distributed with |
| this work for additional information regarding copyright ownership. |
| The ASF licenses this file to You under the Apache License, Version 2.0 |
| (the "License"); you may not use this file except in compliance with |
| the License. You may obtain a copy of the License at |
| |
| http://www.apache.org/licenses/LICENSE-2.0 |
| |
| Unless required by applicable law or agreed to in writing, software |
| distributed under the License is distributed on an "AS IS" BASIS, |
| WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. |
| See the License for the specific language governing permissions and |
| limitations under the License. |
| --> |
| <!-- saved from url=(0014)about:internet -->
|
| <!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>SampleSimpleDB.mxml</title>
|
| <link rel="stylesheet" type="text/css" href="../SourceStyles.css"/>
|
| </head>
|
|
|
| <body>
|
| <pre><span class="MXMLProcessing_Instruction"><?xml version="1.0" encoding="utf-8"?></span>
|
| <span class="MXMLComponent_Tag"><s:View</span><span class="MXMLDefault_Text"> xmlns:fx="</span><span class="MXMLString">http://ns.adobe.com/mxml/2009</span><span class="MXMLDefault_Text">"
|
| xmlns:s="</span><span class="MXMLString">library://ns.adobe.com/flex/spark</span><span class="MXMLDefault_Text">" title="</span><span class="MXMLString">SampleSimpleDB</span><span class="MXMLDefault_Text"></span><span class="MXMLDefault_Text">"
|
| creationComplete="<span class="MXMLString">view1_creationCompleteHandler(event)</span>"</span><span class="MXMLComponent_Tag">></span>
|
| <span class="MXMLSpecial_Tag">
|
| <fx:Script></span>
|
| <![CDATA[
|
| <span class="ActionScriptReserved">import</span> <span class="ActionScriptDefault_Text">mx</span><span class="ActionScriptOperator">.</span><span class="ActionScriptDefault_Text">collections</span><span class="ActionScriptOperator">.</span><span class="ActionScriptDefault_Text">ArrayCollection</span>;
|
| <span class="ActionScriptReserved">import</span> <span class="ActionScriptDefault_Text">mx</span><span class="ActionScriptOperator">.</span><span class="ActionScriptDefault_Text">events</span><span class="ActionScriptOperator">.</span><span class="ActionScriptDefault_Text">FlexEvent</span>;
|
|
|
| <span class="ActionScriptReserved">protected</span> <span class="ActionScriptvar">var</span> sqlConnection:SQLConnection;
|
|
|
| <span class="ActionScriptReserved">protected</span> <span class="ActionScriptfunction">function</span> <span class="ActionScriptDefault_Text">view1_creationCompleteHandler</span><span class="ActionScriptBracket/Brace">(</span><span class="ActionScriptDefault_Text">event</span>:<span class="ActionScriptDefault_Text">FlexEvent</span><span class="ActionScriptBracket/Brace">)</span>:<span class="ActionScriptReserved">void</span>
|
| <span class="ActionScriptBracket/Brace">{</span>
|
| sqlConnection = <span class="ActionScriptReserved">new</span> SQLConnection();
|
| sqlConnection.open(File.applicationStorageDirectory.resolvePath(<span class="ActionScriptString">"giberish.db"</span>));
|
| <span class="ActionScriptvar">var</span> stmt:SQLStatement = <span class="ActionScriptReserved">new</span> SQLStatement();
|
| stmt.sqlConnection = sqlConnection;
|
| stmt.text = <span class="ActionScriptString">"CREATE TABLE IF NOT EXISTS giberish (label TEXT)"</span>;
|
| stmt.execute();
|
| getAllGiberish();
|
| <span class="ActionScriptBracket/Brace">}</span>
|
|
|
| <span class="ActionScriptReserved">protected</span> <span class="ActionScriptfunction">function</span> <span class="ActionScriptDefault_Text">getAllGiberish</span><span class="ActionScriptBracket/Brace">(</span><span class="ActionScriptBracket/Brace">)</span>:<span class="ActionScriptReserved">void</span>
|
| <span class="ActionScriptBracket/Brace">{</span>
|
| <span class="ActionScriptvar">var</span> stmt:SQLStatement = <span class="ActionScriptReserved">new</span> SQLStatement();
|
| stmt.sqlConnection = sqlConnection;
|
| stmt.text = <span class="ActionScriptString">"SELECT label FROM giberish"</span>;
|
| stmt.execute();
|
| l.dataProvider = <span class="ActionScriptReserved">new</span> ArrayCollection(stmt.getResult().data);
|
| <span class="ActionScriptBracket/Brace">}</span>
|
|
|
| <span class="ActionScriptReserved">protected</span> <span class="ActionScriptfunction">function</span> <span class="ActionScriptDefault_Text">onAdd</span><span class="ActionScriptBracket/Brace">(</span><span class="ActionScriptBracket/Brace">)</span>:<span class="ActionScriptReserved">void</span>
|
| <span class="ActionScriptBracket/Brace">{</span>
|
| <span class="ActionScriptvar">var</span> stmt:SQLStatement = <span class="ActionScriptReserved">new</span> SQLStatement();
|
| stmt.sqlConnection = sqlConnection;
|
| stmt.text = <span class="ActionScriptString">"INSERT into giberish values(:giberish)"</span>;
|
| stmt.parameters[<span class="ActionScriptString">":giberish"</span>] = g.text;
|
| stmt.execute();
|
| getAllGiberish();
|
| g.text = "";
|
| <span class="ActionScriptBracket/Brace">}</span>
|
| <span class="ActionScriptBracket/Brace">]</span><span class="ActionScriptBracket/Brace">]</span><span class="ActionScriptOperator">></span>
|
|
|
| <span class="MXMLSpecial_Tag"></fx:Script></span>
|
|
|
| <span class="MXMLComponent_Tag"><s:layout></span>
|
| <span class="MXMLComponent_Tag"><s:VerticalLayout</span><span class="MXMLDefault_Text"> paddingTop="</span><span class="MXMLString">5</span><span class="MXMLDefault_Text">" paddingBottom="</span><span class="MXMLString">5</span><span class="MXMLDefault_Text">" paddingLeft="</span><span class="MXMLString">5</span><span class="MXMLDefault_Text">" paddingRight="</span><span class="MXMLString">5</span><span class="MXMLDefault_Text">" gap="</span><span class="MXMLString">5</span><span class="MXMLDefault_Text">"
|
| horizontalAlign="</span><span class="MXMLString">left</span><span class="MXMLDefault_Text">" verticalAlign="</span><span class="MXMLString">top</span><span class="MXMLDefault_Text">"</span><span class="MXMLComponent_Tag">/></span>
|
| <span class="MXMLComponent_Tag"></s:layout></span>
|
|
|
| <span class="MXMLComponent_Tag"><s:Form</span><span class="MXMLDefault_Text"> width="</span><span class="MXMLString">100%</span><span class="MXMLDefault_Text">"</span><span class="MXMLComponent_Tag">></span>
|
| <span class="MXMLComponent_Tag"><s:FormItem</span><span class="MXMLDefault_Text"> label="</span><span class="MXMLString">Enter text</span><span class="MXMLDefault_Text">" skinClass="</span><span class="MXMLString">spark.skins.spark.StackedFormItemSkin</span><span class="MXMLDefault_Text">"</span><span class="MXMLComponent_Tag">></span>
|
| <span class="MXMLComponent_Tag"><s:TextInput</span><span class="MXMLDefault_Text"> id="</span><span class="MXMLString">g</span><span class="MXMLDefault_Text">"</span><span class="MXMLComponent_Tag">/></span>
|
| <span class="MXMLComponent_Tag"></s:FormItem></span>
|
| <span class="MXMLComponent_Tag"><s:Button</span><span class="MXMLDefault_Text"> label="</span><span class="MXMLString">Save text</span><span class="MXMLDefault_Text">" enabled="</span><span class="MXMLString">{</span><span class="ActionScriptDefault_Text">g</span><span class="ActionScriptOperator">.</span><span class="ActionScriptDefault_Text">text</span><span class="ActionScriptOperator">.</span><span class="ActionScriptDefault_Text">length</span> <span class="ActionScriptOperator">!=</span> 0<span class="MXMLString">}</span><span class="MXMLDefault_Text">" click="</span><span class="ActionScriptDefault_Text">onAdd</span><span class="ActionScriptBracket/Brace">(</span><span class="ActionScriptBracket/Brace">)</span><span class="MXMLDefault_Text">"</span><span class="MXMLComponent_Tag">/></span>
|
| <span class="MXMLComponent_Tag"></s:Form></span>
|
|
|
| <span class="MXMLComponent_Tag"><s:List</span><span class="MXMLDefault_Text"> id="</span><span class="MXMLString">l</span><span class="MXMLDefault_Text">" width="</span><span class="MXMLString">100%</span><span class="MXMLDefault_Text">" height="</span><span class="MXMLString">100%</span><span class="MXMLDefault_Text">"</span><span class="MXMLComponent_Tag">/></span>
|
| <span class="MXMLComponent_Tag"></s:View></span></pre></body>
|
| </html>
|