\n\u30b9\u30de\u30db\u306e\u30a2\u30d7\u30ea\u3092\u4f5c\u308b\u5834\u5408\u306f\u307b\u3068\u3093\u3069Cloud\u306b\u30c7\u30fc\u30bf\u3092\u7f6e\u304f\u306e\u304c\u4e00\u822c\u7684\u3060\u304c\u3001
\nAndroid\u306e\u30ed\u30fc\u30ab\u30eb\u30b9\u30c8\u30ec\u30fc\u30b8\u306b\u30c7\u30fc\u30bf\u3092\u7f6e\u304d\u305f\u3044\u5834\u5408\u304c\u3042\u308b\u3068\u601d\u3046\u3002\n<\/p>\n
\n\u305d\u306e\u305f\u3081\u306e\u51e6\u7406\u3092Java\u3067\u5b9f\u88c5\u3057\u305f\u306e\u3067\u3001\u5099\u5fd8\u306e\u305f\u3081\u306b\u307e\u3068\u3081\u3066\u304a\u304f\u3002\n<\/p>\n
<\/p>\n
[java]
\nimport android.content.Context;
\nimport android.database.sqlite.SQLiteDatabase;
\nimport android.database.sqlite.SQLiteOpenHelper;<\/p>\n
public class MySQLiteOpenHelper extends SQLiteOpenHelper {
\n static final String DB_NAME = “testdb”; \/\/ DB\u540d
\n static final int DB_VERSION = 1; \/\/ DB\u306eVersion
\n static final String DB_TABLE = “testtable”;<\/p>\n
public MySQLiteOpenHelper(Context context) {
\n super(context, DB_NAME, null, DB_VERSION);
\n }<\/p>\n
@Override
\n public void onCreate(SQLiteDatabase db) {
\n db.execSQL(“create table if not exists ” + DB_TABLE +
\n “(id integer primary key, somenumer integer)”);
\n }<\/p>\n
@Override
\n public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
\n db.execSQL(“drop table if exists ” + DB_TABLE);
\n onCreate(db);
\n }
\n}
\n[\/java]<\/p>\n
[java]<\/p>\n
MySQLiteOpenHelper mydb = new MySQLiteOpenHelper(this);
\n db = mydb.getWritableDatabase();<\/p>\n
public void writeDB(Integer id, Integer somenumber){
\n ContentValues values = new ContentValues();
\n values.put(“id”,id);
\n values.put(“somenumber”, somenumber);<\/p>\n
int colNum = db.update(MySQLiteOpenHelper.DB_TABLE, values, “id = ” + id, null);
\n \/\/ update\u3055\u308c\u306a\u304b\u3063\u305f\u3089\u3002
\n if (colNum == 0){
\n db.insert(MySQLiteOpenHelper.DB_TABLE, “”, values);
\n }<\/p>\n
}
\n[\/java]<\/p>\n
[java]
\n\tpublic class Completedb {
\n \t public Integer id;
\n \tpublic Integer somenumber = 0;
\n\t}<\/p>\n
public Completedb readDB(Integer id) throws Exception {
\n Completedb cdb = new Completedb();
\n Cursor c = db.query(MySQLiteOpenHelper.DB_TABLE, new String[]{“id”, “somenumber”},
\n “id=” + id, null, null, null, null);
\n if (c.getCount() == 0){
\n cdb.somenumber = -1;
\n c.close();
\n return cdb;
\n }
\n c.moveToFirst();
\n cdb.id = c.getInt(0);
\n cdb.somenumber = c.getInt(1);
\n c.close();<\/p>\n
return cdb;
\n }
\n[\/java]<\/p>\n
\nDelete\u306f\u3044\u307e\u3064\u304f\u3063\u3066\u3044\u308b\u30a2\u30d7\u30ea\u3067\u306f\u4f7f\u308f\u306a\u3044\u304b\u3089\u307e\u305f\u4f7f\u3046\u30bf\u30a4\u30df\u30f3\u30b0\u306b\u307e\u3068\u3081\u3088\u3046\u3068\u601d\u3046\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u30b9\u30de\u30db\u306e\u30a2\u30d7\u30ea\u3092\u4f5c\u308b\u5834\u5408\u306f\u307b\u3068\u3093\u3069Cloud\u306b\u30c7\u30fc\u30bf\u3092\u7f6e\u304f\u306e\u304c\u4e00\u822c\u7684\u3060\u304c\u3001 Android\u306e\u30ed\u30fc\u30ab\u30eb\u30b9\u30c8\u30ec\u30fc\u30b8\u306b\u30c7\u30fc\u30bf\u3092\u7f6e\u304d\u305f\u3044\u5834\u5408\u304c\u3042\u308b\u3068\u601d\u3046\u3002 \u305d\u306e\u305f\u3081\u306e\u51e6\u7406\u3092Java\u3067\u5b9f\u88c5\u3057\u305f\u306e\u3067\u3001\u5099\u5fd8\u306e\u305f\u3081\u306b\u307e\u3068\u3081\u3066\u304a\u304f\u3002<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[20,7],"tags":[],"class_list":["post-1280","post","type-post","status-publish","format-standard","hentry","category-20","category-7"],"_links":{"self":[{"href":"http:\/\/ts-engine.net\/index.php?rest_route=\/wp\/v2\/posts\/1280","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/ts-engine.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/ts-engine.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/ts-engine.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/ts-engine.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1280"}],"version-history":[{"count":0,"href":"http:\/\/ts-engine.net\/index.php?rest_route=\/wp\/v2\/posts\/1280\/revisions"}],"wp:attachment":[{"href":"http:\/\/ts-engine.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1280"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/ts-engine.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1280"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/ts-engine.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1280"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}