DBhelper

package com.motoharu.cleaningapp;

import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

import java.sql.SQLException;

/**
 * Created by Motoharu on 02.10.2014.
 */
public class DBHelper extends SQLiteOpenHelper {
    //Database information
    public static final String DB_NAME = "CLEANING.DB";
    public static final int DB_VERSION = 1;

    //main id
    public static final String MAIN_ID = "_id";

    //user info table
    public static final String TABLE_USER = "user";
    public static final String USER_NAME = "uName";
    public static final String USER_SECOND_NAME = "uSecName";
    public static final String USER_SURNAME = "uSurname";
    public static final String ACCEPT_ADDRESS_STREET = "acceptStreet";
    public static final String ACCEPT_ADDRESS_BD = "acceptBld";
    public static final String ACCEPT_ADDRESS_AP = "acceptAp";
    public static final String RETURN_ADDRESS_STREET = "returnStreet";
    public static final String RETURN_ADDRESS_BD = "returnBld";
    public static final String RETURN_ADDRESS_AP = "returnAp";

    //table creation statement
    public static final String CREATE_TABLE_USER = "create table "
            + TABLE_USER + "("
            + MAIN_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, "
            + USER_NAME + " TEXT, "
            + USER_SECOND_NAME + " TEXT, "
            + USER_SURNAME + " TEXT, "
            + ACCEPT_ADDRESS_STREET + " TEXT, "
            + ACCEPT_ADDRESS_BD + " TEXT, "
            + ACCEPT_ADDRESS_AP + " TEXT, "
            + RETURN_ADDRESS_STREET + " TEXT, "
            + RETURN_ADDRESS_BD + " TEXT, "
            + RETURN_ADDRESS_AP + " TEXT);";

    public DBHelper(Context context) {
        super(context, DB_NAME, null, DB_VERSION);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
            db.execSQL(CREATE_TABLE_USER);

    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
            db.execSQL("DROP TABLE IF EXISTS " + TABLE_USER);
            onCreate(db);

    }

//CRUD operations
    //Create value
    public long createUser(String userName,String userSecName, String userSurName, String accStr, String accBd, String accAp,
                           String retStr, String retBd, String retAp)
    {
        SQLiteDatabase db = getWritableDatabase();
        ContentValues cv = new ContentValues();
        cv.put(USER_NAME, userName);
        cv.put(USER_SECOND_NAME, userSecName);
        cv.put(USER_SURNAME, userSurName);
        cv.put(ACCEPT_ADDRESS_STREET, accStr);
        cv.put(ACCEPT_ADDRESS_BD, accBd);
        cv.put(ACCEPT_ADDRESS_AP, accAp);
        cv.put(RETURN_ADDRESS_STREET, retStr);
        cv.put(RETURN_ADDRESS_BD, retBd);
        cv.put(RETURN_ADDRESS_AP, retAp);
        long rowID = db.insert(TABLE_USER, null, cv);

        return rowID;

    }
    public Cursor getUser(long rowId) throws SQLException
    {
        SQLiteDatabase db = getReadableDatabase();
        Cursor mCursor = db.query(true, TABLE_USER, new String[]{USER_NAME, USER_SECOND_NAME, USER_SURNAME, ACCEPT_ADDRESS_STREET,
        ACCEPT_ADDRESS_BD, ACCEPT_ADDRESS_AP, RETURN_ADDRESS_STREET, RETURN_ADDRESS_BD, RETURN_ADDRESS_AP}, MAIN_ID + " = " + rowId,
                null, null, null, null, null);
        if (mCursor!=null) {
            mCursor.moveToFirst();
        }
        return mCursor;
    }

    public Cursor getAllUsers()
    {
        SQLiteDatabase db = getReadableDatabase();
        return db.query(TABLE_USER, null, null, null, null, null, null);
    }

    public void close()
    {
        this.close();
    }
}