aWXqcMXP

1package com.example.lovejackknife.dbsumple;
2
3import android.content.Context;
4import android.database.sqlite.SQLiteDatabase;
5import android.database.sqlite.SQLiteOpenHelper;
6import android.database.sqlite.SQLiteStatement;
7
8public class MySqlite extends SQLiteOpenHelper {
9    private SQLiteDatabase db;
10
11    String text1="";
12    double text2;
13    double text3;
14
15    public MySqlite(Context context) {
16        super(context, "mydb", null, 1);
17        // 2番目の引数は、データベース名です。
18        // nullにした場合はメモリ上に、データベース名を指定した場合はデータベースファイルが作成されます。
19    }
20
21    @Override
22    public void onCreate(SQLiteDatabase db) {
23        this.db = db;
24        db.execSQL(
25                "create table locations"
26                        + "( _id integer primary key autoincrement, number text not null, latitude double, longitude double );");
27        /*
28        db.beginTransaction();
29        try {
30            SQLiteStatement stmt =
31                    db.compileStatement(
32                            "insert into locations"
33                                    + "( number, latitude, longitude )"
34                                    + " values ( ?, ?, ? );"
35                    );
36            stmt.bindString(1, "1000000");
37            stmt.bindDouble(2, 34.1250);
38            stmt.bindDouble(3, 135.12);
39            stmt.executeInsert();
40            db.setTransactionSuccessful();
41        } finally {
42            db.endTransaction();
43        }
44        */
45    }
46
47    public void setDB(SQLiteDatabase db) {
48        this.db = db;
49    }
50    public void insertData(String number, double latitude, double longitude) {
51        db.beginTransaction();
52        try {
53            SQLiteStatement stmt =
54                    db.compileStatement(
55                            "insert into locations"
56                                    + "( number, latitude, longitude )"
57                                    + " values ( ?, ?, ? );"
58                    );
59            stmt.bindString(1, number);
60            stmt.bindDouble(2, latitude);
61            stmt.bindDouble(3, longitude);
62            stmt.executeInsert();
63            db.setTransactionSuccessful();
64        } finally {
65            db.endTransaction();
66        }
67    }
68
69    @Override
70    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
71        db.execSQL("drop table if exists locationsE;");
72        onCreate(db);
73    }
74}