applican

Javascript

2014/01/23

simpleStorageについて、ソースコードの誤りを修正しました。

<p>SimpleDataStorage</p>
<textarea id="data" rows="3" cols="30"></textarea><br />
<textarea id="message" rows="3" cols="30"></textarea><br />
<a id="store">記録</a><br />
<a id="display">表示</a><br />
<a id="remove">削除</a><br />
<hr>
<p>DataBaseStorage</p>
<textarea id="dbmessage"	rows="3" cols="30"></textarea><br />
<a id="create">Create Table</a><br />
<a id="insert">Insert Data</a><br />
<a id="update">Update Data</a><br />
<a id="select">Select Data</a><br />
<a id="delete">Delete Data</a><br />

<script type="text/javascript" charset="utf-8" src="/Joomla/applican-0.12.2.js"
<script type="text/javascript" charset="utf-8" src="/Joomla/js/jquery-1.10.1.min.js"
<script type="text/javascript" charset="utf-8"><!--
	// 保存key
	var key = "datakey";
	var sound = null;

	// Database
	var database = null;
	var sql_create = "CREATE TABLE sample(id INTEGER PRIMARY KEY AUTOINCREMENT, name)"
	var sql_insert = "INSERT INTO sample (name) VALUES ('test data')"
	var sql_update = "UPDATE sample SET name = 'update data' WHERE id = 1"
	var sql_select = "SELECT *	FROM sample";
	var sql_delete = "DELETE FROM sample";

	// applican の読み込み完了まで待機
	document.addEventListener("deviceready", onDeviceReady, false);

	// applican 準備完了
	function onDeviceReady ()
		$(function(){
			$("#store").click(function() {
				var value = $("#data").val();
				applican.simpleStorage.set(key, value, onSuccess);
			});
			$("#display").click(function() {
				 applican.simpleStorage.get(key, onSuccess);
			});
			$("#remove").click(function() {
				applican.simpleStorage.remove(key, onSuccess);
			});

			$("#create").click(function() {
				if (database == null) return;
				database.exec(sql_create, create_success, create_error);
			});
			$("#insert").click(function() {
				if (database == null) return;
				database.exec(sql_insert, insert_success, insert_error);
			});
			$("#update").click(function() {
				if (database == null) return;
				database.exec(sql_update, update_success, update_error);});
			$("#select").click(function() {
				if (database == null) return;
				database.query(sql_select, select_success, select_error);
			});
			$("#delete").click(function() {
				if (database == null) return;
				database.exec(sql_delete, delete_success, delete_error);
			});


		});
		// Databaseを開く
		applican.openDatabase('SampleDB', openDB_success, openDB_error);

	}
	function onSuccess(result) {
		$("#message").val("success\n" + result);
	}
	function onError(error) {
		var text = "error\n";
		text += "code=";
		text += error.code;
		text += "/message=";
		text += error.message;
		$("#message").val(text);
	}

	function openDB_success(result) {
		database = result;
		$("#dbmessage").val("success\n" + database.name);
	}
	function openDB_error(result) {
		$("#dbmessage").val("error\n" + result.message);
	}
	function create_success(result) {
		$("#dbmessage").val("success");
	}
	function create_error(e) {
		$("#dbmessage").val("error\n" + e.message);
	}
	function insert_success(result) {
		$("#dbmessage").val("success\n" + result.insertId);
	}
	function insert_error(e) {
		$("#dbmessage").val("error\n" + e.message);
	}
	function update_success(result) {
		$("#dbmessage").val("success\n" + result.insertId);
	}
	function update_error(e) {
		$("#dbmessage").val("error\n" + e.message);
	}
	function select_success(result) {
		var cnt = result.rows.length;
		var dump = "success\n";
		for(var i = 0; i < cnt; i++) {
			dump += "id:"+result.rows[i].id+", name:"+result.rows[i].name+
		}
		$("#dbmessage").val(dump);
	}
	function select_error(e) {
		$("#dbmessage").val("error\n" + e.message);
	}
	function delete_success(result) {
		$("#dbmessage").val("success");
	}
	function delete_error(e) {
		$("#dbmessage").val("error\n" + e.message);
	}
	//-->
</script>