RQPnYQBz

1String CREATE_USER_CONTACTS_TABLE = "CREATE TABLE " + TABLE_USER + "("
2            + USER_ID + " INTEGER PRIMARY KEY   AUTOINCREMENT," + USER_NAME 
3       + " TEXT,"
4            + USER_PH_NO + " TEXT" + USER_DISPLAY_NAME + " TEXT" +  
5            USER_DISPLAY_PICTURE + " TEXT" + ")";
6    db.execSQL(CREATE_USER_CONTACTS_TABLE);
7
8
9public void addUser(Database_Contact contact) {
10    SQLiteDatabase db = this.getWritableDatabase();
11
12    ContentValues values = new ContentValues();
13    values.put(USER_NAME, contact.get_owner_name());
14    values.put(USER_PH_NO, contact.get_owner_phone_number());
15
16    // Inserting Row
17    db.insert(TABLE_USER, null, values);
18    db.close(); // Closing database connection
19}
20public List<Database_Contact> getAllDatabase_Users() {
21    List<Database_Contact> userList = new ArrayList<Database_Contact>();
22    // Select All Query
23    String selectQuery = "SELECT  * FROM " + TABLE_USER;
24
25    SQLiteDatabase db = this.getWritableDatabase();
26    Cursor cursor = db.rawQuery(selectQuery, null);
27
28    // looping through all rows and adding to list
29    if (cursor.moveToFirst()) {
30        do {
31            Database_Contact contact = new Database_Contact();
32            contact.set_user_id(Integer.parseInt(cursor.getString(0)));
33            contact.set_owner_name(cursor.getString(1));
34            contact.set_owner_phone_number(cursor.getString(2));
35            // Adding contact to list
36            userList.add(contact);
37        } while (cursor.moveToNext());
38    }
39
40    // return contact list
41    return userList;
42}
43public int setDisplayImage(long id,String path) {
44    SQLiteDatabase db = this.getWritableDatabase();
45    ContentValues values = new ContentValues();
46    values.put(USER_DISPLAY_PICTURE, path);
47    // updating row
48    return db.update(TABLE_USER, values, USER_ID +"="+id,null);
49}
50	
51public class Database_Contact {
52
53//private variables
54
55
56int _user_id;
57String _display_name;
58String _display_picture;
59String _owner_phone_number;
60String _owner_name;
61
62
63
64public int get_user_id() {
65    return _user_id;
66}
67
68public void set_user_id(int _user_id) {
69    this._user_id = _user_id;
70}
71
72
73
74
75public String get_display_name() {
76    return _display_name;
77}
78
79public void set_display_name(String _display_name) {
80    this._display_name = _display_name;
81}
82
83public String get_display_picture() {
84    return _display_picture;
85}
86
87public void set_display_picture(String _display_picture) {
88    this._display_picture = _display_picture;
89}
90
91public String get_owner_phone_number() {
92    return _owner_phone_number;
93}
94
95public void set_owner_phone_number(String _owner_phone_number) {
96    this._owner_phone_number = _owner_phone_number;
97}
98
99public String get_owner_name() {
100    return _owner_name;
101}
102
103public void set_owner_name(String _owner_name) {
104    this._owner_name = _owner_name;
105}
106
107}
108	
109mydb = new DBHelper(this);
110    List<Database_conytact> images = mydb.getAllDatabase_Users();
111    mydb.setDisplayImage(images.get(0).get_user_id(), "String");
112	
113String CREATE_USER_CONTACTS_TABLE = "CREATE TABLE " + TABLE_USER + "("
114        + USER_ID + " INTEGER PRIMARY KEY   AUTOINCREMENT," + USER_NAME 
115   + " TEXT,"
116        + USER_PH_NO + " TEXT" + USER_DISPLAY_NAME + " TEXT" +  
117        USER_DISPLAY_PICTURE + " TEXT" + ")";
118	
119String CREATE_USER_CONTACTS_TABLE = "CREATE TABLE " + TABLE_USER + " (" +
120        USER_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " + USER_NAME +
121        " TEXT, " + USER_PH_NO + " TEXT, " + USER_DISPLAY_NAME + " TEXT, " +  
122        USER_DISPLAY_PICTURE + " TEXT)";
123	
124return db.update(TABLE_USER, values, USER_ID  + "='" + id +"'", null);
125	
126String where="USER_ID =?";
127 return db.update(TABLE_USER,values,where,new String[]{""+id});
128	
129String CREATE_USER_CONTACTS_TABLE = "CREATE TABLE IF NOT EXISTS " +     TABLE_USER + "("
130    + USER_ID + " INTEGER PRIMARY KEY   AUTOINCREMENT," + USER_NAME +" TEXT,"
131    + USER_PH_NO + " TEXT" + USER_DISPLAY_NAME + " TEXT" +  
132    USER_DISPLAY_PICTURE + " TEXT" + ")";
133	
134"SET Display Image=?"