Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package com.example.cesar.airsoft;
- import android.content.ContentValues;
- import android.content.Context;
- import android.database.Cursor;
- import android.database.sqlite.SQLiteDatabase;
- import android.database.sqlite.SQLiteOpenHelper;
- import java.util.ArrayList;
- import java.util.List;
- /**
- * Created by cesar on 18/3/16.
- */
- public class DatabaseHandler extends SQLiteOpenHelper {
- // All Static variables
- // Database Version
- private static final int DATABASE_VERSION = 1;
- // Database Name
- private static final String DATABASE_NAME = "userManager";
- // Contacts table name
- private static final String TABLE_USERS = "Users";
- // Contacts Table Columns names
- private static final String KEY_ID = "id";
- private static final String KEY_NAME = "fullname";
- private static final String KEY_EMAIL = "email";
- private static final String KEY_NICK = "nickname";
- private static final String KEY_PASS = "password";
- public DatabaseHandler(Context context) {
- super(context, DATABASE_NAME, null, DATABASE_VERSION);
- }
- // Creating Tables
- @Override
- public void onCreate(SQLiteDatabase db) {
- String CREATE_USERS_TABLE = "CREATE TABLE " + TABLE_USERS + "("
- + KEY_ID + " INTEGER PRIMARY KEY," + KEY_NAME + " TEXT,"
- + KEY_EMAIL + " TEXT" + KEY_NICK + "TEXT" + KEY_PASS + "TEXT" + ")";
- db.execSQL(CREATE_USERS_TABLE);
- }
- // Upgrading database
- @Override
- public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
- // Drop older table if existed
- db.execSQL("DROP TABLE IF EXISTS " + TABLE_USERS);
- // Create tables again
- onCreate(db);
- }
- // Adding new contact
- public void addUser(User user) {
- SQLiteDatabase db = this.getWritableDatabase();
- ContentValues values = new ContentValues();
- values.put(KEY_NAME, user.getFullname()); // User Name
- values.put(KEY_EMAIL, user.getEmail()); // User Phone Number
- values.put(KEY_NICK, user.getNickname()); // User Nickname
- values.put(KEY_PASS, user.getPassword()); // User Password
- // Inserting Row
- db.insert(TABLE_USERS, null, values);
- db.close(); // Closing database connection
- }
- // Getting single contact
- public User getUser(int id) {
- SQLiteDatabase db = this.getReadableDatabase();
- Cursor cursor = db.query(TABLE_USERS, new String[] { KEY_ID,
- KEY_NAME, KEY_EMAIL, KEY_NICK, KEY_PASS }, KEY_ID + "=?",
- new String[] { String.valueOf(id) }, null, null, null, null);
- if (cursor != null)
- cursor.moveToFirst();
- User user = new User(Integer.parseInt(cursor.getString(0)),
- cursor.getString(1), cursor.getString(2),cursor.getString(3),cursor.getString(4));
- // return contact
- return user;
- }
- // Getting All Contacts
- public List<User> getAllUsers() {
- List<User> userList = new ArrayList<User>();
- // Select All Query
- String selectQuery = "SELECT * FROM " + TABLE_USERS;
- SQLiteDatabase db = this.getWritableDatabase();
- Cursor cursor = db.rawQuery(selectQuery, null);
- // looping through all rows and adding to list
- if (cursor.moveToFirst()) {
- do {
- User user = new User();
- user.setID(Integer.parseInt(cursor.getString(0)));
- user.setFullname(cursor.getString(1));
- user.setEmail(cursor.getString(2));
- user.setNickname(cursor.getString(3));
- user.setPassword(cursor.getString(4));
- // Adding contact to list
- userList.add(user);
- } while (cursor.moveToNext());
- }
- // return contact list
- return userList;
- }
- // Getting contacts Count
- public int getUsersCount() {
- String countQuery = "SELECT * FROM " + TABLE_USERS;
- SQLiteDatabase db = this.getReadableDatabase();
- Cursor cursor = db.rawQuery(countQuery, null);
- cursor.close();
- // return count
- return cursor.getCount();
- }
- // Updating single contact
- public int updateUser(User user) {
- SQLiteDatabase db = this.getWritableDatabase();
- ContentValues values = new ContentValues();
- values.put(KEY_NAME, user.getNickname());
- values.put(KEY_EMAIL, user.getEmail());
- values.put(KEY_NICK, user.getNickname());
- values.put(KEY_PASS, user.getPassword());
- // updating row
- return db.update(TABLE_USERS, values, KEY_ID + " = ?",
- new String[] { String.valueOf(user.getID()) });
- }
- // Deleting single contact
- public void deleteUser(User user) {
- SQLiteDatabase db = this.getWritableDatabase();
- db.delete(TABLE_USERS, KEY_ID + " = ?",
- new String[] { String.valueOf(user.getID()) });
- db.close();
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement