FilesExpand file tree

 master

/

DBManager.java

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

91 lines (72 loc) · 2.78 KB

 master

/

DBManager.java

Copy path

Top

File metadata and controls

• Code
• Blame

91 lines (72 loc) · 2.78 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

75

76

77

78

79

80

81

82

83

84

85

86

87

88

89

90

91

package com.hussienalrubaye.androiddemowork;

import android.content.ContentValues;

import android.content.Context;

import android.database.Cursor;

import android.database.sqlite.SQLiteDatabase;

import android.database.sqlite.SQLiteOpenHelper;

import android.database.sqlite.SQLiteQueryBuilder;

import android.view.LayoutInflater;

import android.view.View;

import android.view.ViewGroup;

import android.widget.BaseAdapter;

import android.widget.TextView;

import android.widget.Toast;

import java.util.ArrayList;

/**

* Created by hussienalrubaye on 9/8/16.

*/

public class DBManager {

private SQLiteDatabase sqlDB;

static final String DBName="Students";

static final String TableName="Logins";

static final String ColUserName="UserName";

static final String ColPassWord="Password";

static final String ColID="ID";

static final int DBVersion=3;

// create table Logins(ID integer primary key autoincrment, UserName text, Password text)

static final String CreateTable=" CREATE TABLE IF NOT EXISTS " +TableName+

"(ID INTEGER PRIMARY KEY AUTOINCREMENT,"+ ColUserName+

" TEXT,"+ ColPassWord + " TEXT);";

private static class DatabaseHelperUser extends SQLiteOpenHelper{

Context context;

DatabaseHelperUser(Context context){

super(context,DBName,null,DBVersion);

this.context=context;

}

@Override

public void onCreate(SQLiteDatabase db) {

db.execSQL(CreateTable);

Toast.makeText(context,"Table is created",Toast.LENGTH_LONG).show();

}

@Override

public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

db.execSQL("Drop table IF EXISTS "+ TableName);

onCreate(db);

}

}

public DBManager(Context context){

DatabaseHelperUser db=new DatabaseHelperUser(context) ;

sqlDB=db.getWritableDatabase();

}

public long Insert(ContentValues values){

long ID= sqlDB.insert(TableName,"",values);

//could insert id is user id, or fail id is or equal 0

return ID;

}

//select username,Password from Logins where ID=1

public Cursor query(String[] Projection,String Selection,String[] SelectionArgs,String SortOrder){

SQLiteQueryBuilder qb= new SQLiteQueryBuilder();

qb.setTables(TableName);

Cursor cursor=qb.query(sqlDB,Projection,Selection,SelectionArgs,null,null,SortOrder);

return cursor;

}

public int Delete(String Selection,String[] SelectionArgs){

int count=sqlDB.delete(TableName,Selection,SelectionArgs);

return count;

}

public int Update(ContentValues values,String Selection,String[] SelectionArgs)

{

int count=sqlDB.update(TableName,values,Selection,SelectionArgs);

return count;

}

}