qinghu's blog

import fl.controls.dataGridClasses.DataGridColumn;
import fl.events.DataGridEvent;
import fl.data.DataProvider;
import flash.data.SQLConnection;
import flash.data.SQLStatement;
import flash.data.SQLResult;
import flash.events.SQLErrorEvent;
import flash.events.SQLEvent;
import flash.filesystem.File;
var conn:SQLConnection = new SQLConnection();
var sqlStatement:SQLStatement = new SQLStatement();
sqlStatement.sqlConnection = conn;
conn.addEventListener(SQLEvent.OPEN, openHandler);
conn.addEventListener(SQLErrorEvent.ERROR, errorHandler);
sqlStatement.addEventListener(SQLEvent.RESULT, sqlStatementResultHander);
sqlStatement.addEventListener(SQLErrorEvent.ERROR, sqlStatementErrorHander);
var dbFile:File = File.applicationDirectory.resolvePath("data.db");
conn.open(dbFile);
var sql:String ="Insert INTO news (news_title) VALUES ('我是庆虎^_^')";
sqlStatement.text = sql;
sqlStatement.execute();
sql ="select * from news";
sqlStatement.text = sql;
sqlStatement.execute();
conn.close();
function openHandler(event:SQLEvent):void {
    trace("the database was opened successfully");
}
function errorHandler(event:SQLErrorEvent):void {    
    trace("Details:", event.error.message);
}
function sqlStatementResultHander(event:SQLEvent):void {
    var re:SQLResult=event.target.getResult();
    var aDP_array:Array = new Array();
    if (re.data!=null) {
        for (var i:int = 0; i < re.data.length; i++) {
            aDP_array.push({id:re.data[i]["id"], news_title:re.data[i]["news_title"]});
        }
        my_dg.dataProvider = new DataProvider(aDP_array);        
    }
}
function sqlStatementErrorHander(event:SQLErrorEvent):void {
    trace(event.error.message);
}

import flash.events.Event;
     import com.google.maps.*;
    
     import com.google.maps.interfaces.IProjection;
     import com.google.maps.interfaces.IMapType;
     import com.google.maps.controls.MapTypeControl;
     import com.google.maps.controls.ZoomControl;
     import com.google.maps.controls.PositionControl;     
    
    
    
     private var map:Map;
     public function startMap(event:Event):void {
             map = new Map();
             map.addEventListener(MapEvent.MAP_READY, onMapReady);
             mapContainer.addChild(map);
     }        
     public function resizeMap(event:Event):void {
             map.setSize(new Point(mapContainer.width, mapContainer.height));
     }    
     private function onMapReady(event:MapEvent):void {
             map.setCenter(new LatLng(40.736072,-73.992062), 14, MapType.NORMAL_MAP_TYPE);
             map.addControl(new ZoomControl());
             map.addControl(new PositionControl());
             map.addControl(new MapTypeControl());
             addEventListener(MapMouseEvent.CLICK, onMapClick);
     }

     private function onMapClick(event:MapEvent):void {
        map.openInfoWindow(event.target.latLng , new InfoWindowOptions({title: "Click Event", content: "You clicked the map!"}));
    
    }