Click here to Skip to main content
15,891,718 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
Java
package com.example.exe_app;

public class contactcontract {
    private  contactcontract() {}

        public static class contactEntry{
        public static final String TABLE_NAME="contact_info";
            public static final String CONTACT_ID="contact_id";
            public static final String NAME="name";
            public static final String EMAIL="email";

        }
}



Java
package com.example.exe_app;

import android.content.ContentValues;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.util.Log;

public class ContactDbHelper extends SQLiteOpenHelper {
    public static final String DATABASE_NAME="contact_db";
    public static final int DATABASE_VERSION=1;
    public static final String CREATE_TABLE= "create table "+ contactcontract.contactEntry.TABLE_NAME+
            "("+contactcontract.contactEntry.CONTACT_ID+" number,"+contactcontract.contactEntry.NAME+" text,"+contactcontract.contactEntry.EMAIL+" text);";
    public static final String DROP_TABLE="drop table if exists "+contactcontract.contactEntry.TABLE_NAME;

    public ContactDbHelper(Context context)
    {
        super(context,DATABASE_NAME, null,DATABASE_VERSION);
        Log.d("databse crestion ", "databse created...");
    }

    @Override
    public void onCreate(SQLiteDatabase sqLiteDatabase) {
     sqLiteDatabase.execSQL(CREATE_TABLE);
        Log.d("databse crestion ", "table is  created...");

    }

    @Override
    public void onUpgrade(SQLiteDatabase sqLiteDatabase, int i, int i1) {
 sqLiteDatabase.execSQL(DROP_TABLE);
 onCreate(sqLiteDatabase);
    }
    public void addContact(int id, String name,String email,SQLiteDatabase databse){
        ContentValues contentValues=new ContentValues();
        contentValues.put(contactcontract.contactEntry.CONTACT_ID,id);
        contentValues.put(contactcontract.contactEntry.NAME,name);
        contentValues.put(contactcontract.contactEntry.EMAIL,email);
        databse.insert(contactcontract.contactEntry.TABLE_NAME,null,contentValues);
        Log.d("databse crestion ", "one row is inserted...");
    }
}


Java
package com.example.exe_app;

import android.content.ContentValues;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.util.Log;

public class ContactDbHelper extends SQLiteOpenHelper {
    public static final String DATABASE_NAME="contact_db";
    public static final int DATABASE_VERSION=1;
    public static final String CREATE_TABLE= "create table "+ contactcontract.contactEntry.TABLE_NAME+
            "("+contactcontract.contactEntry.CONTACT_ID+" number,"+contactcontract.contactEntry.NAME+" text,"+contactcontract.contactEntry.EMAIL+" text);";
    public static final String DROP_TABLE="drop table if exists "+contactcontract.contactEntry.TABLE_NAME;


    public ContactDbHelper(Context context)
    {
        super(context,DATABASE_NAME, null,DATABASE_VERSION);
        Log.d("databse crestion ", "databse created...");
    }

    @Override
    public void onCreate(SQLiteDatabase sqLiteDatabase) {
     sqLiteDatabase.execSQL(CREATE_TABLE);
        Log.d("databse crestion ", "table is  created...");

    }

    @Override
    public void onUpgrade(SQLiteDatabase sqLiteDatabase, int i, int i1) {
 sqLiteDatabase.execSQL(DROP_TABLE);
 onCreate(sqLiteDatabase);
    }
    public void addContact(int id, String name,String email,SQLiteDatabase databse){
        ContentValues contentValues=new ContentValues();
        contentValues.put(contactcontract.contactEntry.CONTACT_ID,id);
        contentValues.put(contactcontract.contactEntry.NAME,name);
        contentValues.put(contactcontract.contactEntry.EMAIL,email);
        databse.insert(contactcontract.contactEntry.TABLE_NAME,null,contentValues);
        Log.d("databse crestion ", "one row is inserted...");
    }

}



Java
package com.example.exe_app;

public class contactcontract {
    private  contactcontract() {}

        public static class contactEntry{
        public static final String TABLE_NAME="contact_info";
            public static final String CONTACT_ID="contact_id";
            public static final String NAME="name";
            public static final String EMAIL="email";

        }

}


What I have tried:

i have tried to put space between name text email text
Posted
Updated 8-Jul-20 21:38pm
v2
Comments
Richard MacCutchan 8-Jul-20 16:09pm    
Use the debugger to check the generated statements. Also try using the SQLite command tool to display the schema of the created database.

1 solution

From what I could gather in your code at insert, you reference only id although your fieldname is
contact_id
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900