2012-12-07から1日間の記事一覧
使い方 インスタンス生成 open sql close instance SqlDbConnection conn = new SqlDbConnection(context); open ReadOnly conn.openReadOnly(); Writable conn.openWritable(); sql insert , update , delete conn.execSQL(sql); select Cursor c = conn.se…
context.getPackageName()
sdcardfile.getPath()
private boolean isTableExists() { boolean ret = false; String kakunin_sql = "select count(*) from sqlite_master where type='table' and name= '" + DbConnection.DBTABLE + "';"; Log.v("DbConnection", "kakunin_sql=" + kakunin_sql); db = dbHelp…
// 乱数の生成 private static int getIntRand(int min, int max) { int ret = (int) Math.floor(Math.random() * (max - min + 1)) + min; // Log.v("ret","min="+min+",max="+max+",ret="+ret); return ret; }
MMapViwe.java package com.efolab.t201; import android.content.Context; import android.content.Intent; import android.database.Cursor; import android.os.Bundle; import android.util.Log; import android.view.Gravity; import android.view.View;…
TIMESTAMPカラムのセット , update_date TIMESTAMP DEFAULT (DATETIME('now','localtime'))