package com.view.dataoption { import com.vo.FlowModel; import com.vo.FmNodes; import com.vo.FmXian; import flash.data.<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>Connection; import flash.data.<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>Result; import flash.data.<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>Statement; import flash.errors.<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>Error; import flash.filesystem.File; import flash.net.FileReference; import mx.collections.ArrayCollection; import mx.controls.Alert; public class Conn { private var conn:<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>Connection; public function Conn() { } public function openConn():void{ var filee : FileReference = new FileReference(); conn = new <a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>Connection(); var file : File = File.applicationStorageDirectory.resolvePath("flowmodel.db"); try{ conn.open(file); }catch(error:<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>Error){ Alert.show(error.message); Alert.show(error.details); } } public function excute<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>(<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>str:String):void{ openConn(); var stmt:<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>Statement = new <a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>Statement(); try{ stmt.<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>Connection = conn; stmt.text = <a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>str; stmt.execute(); }catch(error:<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>Error){ Alert.show(error.message); Alert.show(error.details); } } public function findFlowModel(fmId : Number) : FlowModel{ openConn(); var stmt:<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>Statement = new <a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>Statement(); var <a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>str : String ="select * from flowmodel where fm_id = "+fmId; var flowModel : FlowModel = null; try{ stmt.<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>Connection = conn; stmt.text = <a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>str; stmt.execute(); var result:<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>Result = stmt.getResult(); if(result.data !=null){ flowModel = new FlowModel(result.data[0]); Alert.show(flowModel.fmName); } }catch(error:<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>Error){ Alert.show(error.message); Alert.show(error.details); } return flowModel; } public function findFlowXian(fmId : Number) : ArrayCollection{ openConn(); var stmt:<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>Statement = new <a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>Statement(); var <a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>str : String ="select * from fmxian where fm_id = "+fmId; var arrXian : ArrayCollection; try{ stmt.<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>Connection = conn; stmt.text = <a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>str; stmt.execute(); var result:<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>Result = stmt.getResult(); if(result.data!=null){ arrXian = new ArrayCollection(); var numResults:int = result.data.length; for(var i:int = 0;i<numResults; i++){ var obj:Object = result.data[i]; var xian : FmXian = new FmXian(obj); arrXian.addItem(xian); } } }catch(error:<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>Error){ Alert.show(error.message); Alert.show(error.details); } return arrXian; } public function findFlowNode(fmId : Number) : ArrayCollection{ openConn(); var stmt:<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>Statement = new <a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>Statement(); var <a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>str : String ="select * from fmnodes where fm_id = "+fmId; var arrNode : ArrayCollection ; try{ stmt.<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>Connection = conn; stmt.text = <a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>str; stmt.execute(); var result:<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>Result = stmt.getResult(); if(result.data !=null){ arrNode = new ArrayCollection(); var numResults:int = result.data.length; for(var i:int = 0;i<numResults; i++){ var obj:Object = result.data[i]; var node : FmNodes = new FmNodes(obj); arrNode.addItem(node); } } }catch(error:<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>Error){ Alert.show(error.message); Alert.show(error.details); } return arrNode; } public function insert<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>(<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>str:String) : Number{ openConn(); var stmt:<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>Statement = new <a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>Statement(); try{ stmt.<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>Connection = conn; stmt.text = <a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>str; stmt.execute(); var result : <a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>Result = stmt.getResult(); var primaryKey:Number = result.lastInsertRowID; closeConn(); return primaryKey; }catch(error:<a href="https://www.jb51.cc/tag/sql/" target="_blank" class="keywords">sql</a>Error){ Alert.show(error.message); Alert.show(error.details); } return 0 ; } public function closeConn():void{ conn.close(); } } }