7LC1FMHr

1package com.db;
2
3import java.sql.Blob;
4
5import android.content.ContentValues;
6import android.content.Context;
7import android.database.Cursor;
8import android.database.sqlite.SQLiteDatabase;
9import android.database.sqlite.SQLiteDatabase.CursorFactory;
10import android.database.sqlite.SQLiteOpenHelper;
11import android.util.Log;
12
13
14public class ContactDatabase extends SQLiteOpenHelper{
15	
16	// All Static variables
17    // Database Version
18    private static final int DATABASE_VERSION = 1;
19 
20    // Database Name
21    private static final String DATABASE_NAME = "mydatabase.db";
22 
23    // Contacts table name
24    private static final String TABLE_CONTACTS = "contactlist";
25 
26    // Contacts Table Columns names
27    /** The Constant CONTACT_ROWID. */
28	public static final String CONTACT_ROWID = "_id";
29	public static final String NAME = "name";
30	public static final String PHONE_NUMBERS = "numbers";
31	public static final String EMAIL="email";
32	public static final String TEXT= "text";
33	public static final String PHOTO="image";
34
35	public ContactDatabase(Context context) {
36		super(context, DATABASE_NAME, null, DATABASE_VERSION);
37		// TODO Auto-generated constructor stub
38	}
39
40	@Override
41	public void onCreate(SQLiteDatabase db) {
42		/** Database creation sql statement. */
43		String CREATE_CONTACT_TABLE_SQL = "CREATE TABLE "+ TABLE_CONTACTS +"(" + CONTACT_ROWID + " INTEGER PRIMARY KEY AUTOINCREMENT, " +
44				NAME + " TEXT NOT NULL , " + 
45				PHONE_NUMBERS + " TEXT NOT NULL , " +		 
46				EMAIL + " TEXT ," +
47				TEXT+" TEXT ,"+
48				PHOTO + "TEXT)";
49		db.execSQL(CREATE_CONTACT_TABLE_SQL);	
50	}
51
52	
53
54	@Override
55	public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
56		 db.execSQL("DROP TABLE IF EXISTS " + TABLE_CONTACTS);
57		 
58	        // Create tables again
59	        onCreate(db);
60	}
61
62	
63	
64	
65	public void DeleteAllRecord(){
66		SQLiteDatabase db =this.getWritableDatabase();
67		db.delete(TABLE_CONTACTS, null,null);
68	}
69	// Getting single contact
70    public Cursor getNumber(int phone) {
71        
72        SQLiteDatabase db = this.getReadableDatabase();
73        return db.query(TABLE_CONTACTS,null,null,null,null,null,null);
74               
75    }
76    
77
78	public void insertRecord(String name2, String phone, String email2,String text2, String arr) {
79		SQLiteDatabase db =this.getWritableDatabase();
80		ContentValues cv= new ContentValues();
81		cv.put(NAME, name2);
82		cv.put(PHONE_NUMBERS, phone);
83		cv.put(EMAIL, email2);
84		cv.put(TEXT, text2);
85		cv.put(PHOTO, arr);
86		db.insert(TABLE_CONTACTS, null, cv);
87		Log.i("INSERT SINGLE RECORD", "ADDED");
88		db.close();
89	}
90
91	
92	
93}