AIRアプリケーション作成講座 Vol.4

			//追加ボタンを押したときのBookmarkへの追加処理
			add_btn.addEventListener(MouseEvent.CLICK, addData);
			function addData(event:MouseEvent):void {
				var urlString:String = html.location;
				var pageTitle:String = html.window.document.title;
				BookmarkWin= new DBList_mc;
				BookmarkWin.add(urlString, pageTitle);

				//親のウィンドウを監視し閉じられたら処理を実行
				stage.nativeWindow.addEventListener(Event.CLOSE, onClose);
			}

			//子のウィンドウを閉じる処理
			function onClose(evt:Event) {
				BookmarkWin.close();
			}
		}

		省略

	import DBManage;
	import DBEdit_mc;

	public class DBList_mc extends Sprite {

		//プロパティ設定
		private var ListWindow:NativeWindow;
		private var dp:DataProvider;
		private var Database:DBManage;
		private var EditMC:DBEdit_mc;

		//コンストラクタ
		public function DBList_mc() {

		中略

		}
		//メソッド
		public function add(urlString, pageTitle) {
			Database.insertData(urlString,pageTitle);
			ListWindow.stage.addChild(this);
			ListWindow.activate();
			refresh();
		}

		public function close() {
			ListWindow.close();
		}

		//データベースのリロード処理
		public function refresh() {

			var resultArray:Array = new Array();
			resultArray = Database.reloadData();

			dp=new DataProvider(resultArray);
			dg.dataProvider = dp;
		}
	}
}

		//INSERT処理
		public function insertData(locationStr:String, titleStr:String):void {
        
			var insertState= new SQLStatement();
			insertState.sqlConnection = dbCon;

			var InsertSql:String = 
			"INSERT INTO EdgeBookmarks (urlStr, pageTitle) "+
			"VALUES (@urlString, @pageTitle)";

			insertState.parameters["@urlString"] = locationStr;
			insertState.parameters["@pageTitle"] = titleStr;

			insertState.text = InsertSql;

			insertState.execute();

		}
        
        //RELOAD処理
		public function reloadData():Array {
			var SQLState:SQLStatement= new SQLStatement();
			SQLState.sqlConnection = dbCon;
            
			var selectSql:String ="SELECT * FROM EdgeBookmarks";
            
			SQLState.text = selectSql;
			SQLState.execute();
			var result:SQLResult = SQLState.getResult();
			return result.data;
		}

this.DropZone_mc.addEventListener(NativeDragEvent.NATIVE_DRAG_ENTER, onDragEnter);
this.DropZone_mc.addEventListener(NativeDragEvent.NATIVE_DRAG_DROP, onDragDrop);
}
	//メソッド
	private function onDragEnter(event:NativeDragEvent):void {
		var dropData:Clipboard  = event.clipboard;
		if (dropData.hasFormat(ClipboardFormats.BITMAP_FORMAT)) {
		NativeDragManager.acceptDragDrop(this.DropZone_mc);
		}
	}

	private function onDragDrop(event:NativeDragEvent):void {
		NativeDragManager.dropAction = NativeDragActions.COPY;
		droppedData=event.clipboard.getData(ClipboardFormats.BITMAP_FORMAT);

		var thumbImage:Bitmap = new Bitmap(droppedData);

		this.DropZone_mc.addChild(thumbImage);
	}

//JPEGEncoder from ActionScript 3 corelib Project
//http://code.google.com/p/as3corelib/
//
// Additional info  ActionScript 3:resources:apis:libraries 
//http://labs.adobe.com/wiki/index.php/ActionScript_3:resources:apis:libraries

import com.adobe.images.JPGEncoder;


public class DBEdit_mc extends Sprite {

	//プロパティ設定
	private var droppedData;
	private var ID:Number;
	private var Database:DBManage;

	中略

	//メソッド
    private function onDragDrop(event:NativeDragEvent):void {
	NativeDragManager.dropAction = NativeDragActions.COPY;
	droppedData=event.clipboard.getData(ClipboardFormats.BITMAP_FORMAT);

	var thumbImage:Bitmap = new Bitmap(droppedData);

	this.DropZone_mc.addChild(thumbImage);
	}

    
	private function saveDroppedBitmap(bmd:BitmapData):String {

		if (bmd ==null) {

			return null;
		} else {
			//JPEGデータとして書き出し
			//var file = File.desktopDirectory;
			var file = File.applicationStorageDirectory;
			file = file.resolvePath("images/" + ID + ".jpg");
			var stream = new FileStream;
			stream.open(file, FileMode.WRITE);
			var data:ByteArray = makeJPEG(bmd);
			stream.writeBytes(data, 0, data.length);
			stream.close();
			return file.nativePath;
		}
	}
	private function makeJPEG(bmd:BitmapData):ByteArray {
		var jpg:JPGEncoder = new JPGEncoder(80);
		return jpg.encode(bmd);
	}

	//レコード編集用ウィンドウ内にあるUPDATEボタンの処理
	private function updateButtonHandler(e:MouseEvent) {
		var pageURL:String=  this.edit_UrlStr_txt.text;
		var pageTITLE:String =this.edit_PageTitle_txt.text;

		//保存処理したビットマップのファイルパスの取得
		var jpegPath:String = saveDroppedBitmap(droppedData);

		//データベースの更新
		Database.updateData(ID,pageURL,pageTITLE, jpegPath);

		this.close();
	}

	//接続してテーブルが存在しない場合は作成
	function onSQLConnectSuccess(event:SQLEvent):void {
		SQLState= new SQLStatement();
		SQLState.sqlConnection = dbCon;
		var tblCreateSql:String = 
		   "CREATE TABLE IF NOT EXISTS EdgeBookmarks (" + 
		    "    linkId INTEGER PRIMARY KEY AUTOINCREMENT, " + 
		    "    urlStr TEXT, " + 
		    "    pageTitle TEXT," + 
		    "    data TEXT" + 
		    ")";

			中略

//UPDATE処理
public function updateData(ID:Number,URLString:String,pageTitle:String, imagePath:String) {
	var updateState:SQLStatement= new SQLStatement();
	updateState.sqlConnection = dbCon;
	var updateSql:String;
	if (imagePath ==null) {

		updateSql = 
		"UPDATE EdgeBookmarks "+
		"SET urlStr=@urlString, pageTitle=@pageTitle "+
		"WHERE linkId = @ID";

		updateState.parameters["@ID"] = ID;
		updateState.parameters["@urlString"] =URLString;
		updateState.parameters["@pageTitle"] = pageTitle;
	} else {
		updateSql = 
		"UPDATE EdgeBookmarks "+
		"SET urlStr=@urlString, pageTitle=@pageTitle, data=@imagePath "+
		"WHERE linkId = @ID";

		updateState.parameters["@ID"] = ID;
		updateState.parameters["@urlString"] =URLString;
		updateState.parameters["@pageTitle"] = pageTitle;
		updateState.parameters["@imagePath"] = imagePath;
	}
	updateState.text = updateSql;
	updateState.execute();
}

//データグリッドの設定
var jpegCol:DataGridColumn = new DataGridColumn("data");
jpegCol.cellRenderer = LoaderCellRenderer;

dg.columns = [ "linkId","pageTitle", "urlStr",jpegCol];
dg.getColumnAt(0).sortOptions = Array.NUMERIC;
dg.getColumnAt(0).width = 30;
Database=new DBManage();

this.DBList_BG.addEventListener(MouseEvent.MOUSE_DOWN, windowMove);
this.close_btn.addEventListener(MouseEvent.CLICK, CloseButtonHandler);
this.dg.addEventListener(ListEvent.ITEM_DOUBLE_CLICK, sendDBEdit_ID);