import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;
import android.util.Log;

public class DBservice extends SQLiteOpenHelper{
    SQLiteDatabase _db;
    public DBservice(Context context, String name, CursorFactory factory, int version) {
        //super(context, name, factory, version);
        super(context, "Gesture", factory, 2);
        _db = this.getReadableDatabase();
    }
    public void insert(String title, String number, String string){
        String sql = "INSERT INTO test(title, number, string) values('" + title + "','" + number + "','" + string + "');";
        _db.execSQL(sql);
    }
    public void update(int id ,String title, String number, String string){
        String sql =
            "UPDATE test SET " +
                "title = '" + title + "', " +
                "number = '" + number + "', " +
                "string = '" + string + "' " +
            "WHERE _id = " + id + ";";
        _db.execSQL(sql);
    }
    public void delete(int id){
        String sql = "DELETE FROM test WHERE _id = " + id + ";";
        _db.execSQL(sql);
    }
    public Cursor select(){
        return _db.query("test", null, null, null, null, null, null);
    }
    public Cursor select(int id){
        return _db.query("test", null, "_id = " + id, null, null, null, null);
    }
    public Cursor select_check_double(int id){
        return _db.query("test", null, "_id <> " + id, null, null, null, null);
    }
    @Override
    public void onCreate(SQLiteDatabase db) {
        db.execSQL("CREATE TABLE test(" +
                "_id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT," +
                "title TEXT," +
                "number TEXT," +
                "string TEXT" +
                ");");
    }
    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        db.execSQL("DROP TABLE IF EXISTS test");
        onCreate(db);
    }

}