not allowing to insert date values

Question

I have following code to insert values in database:

import java.util.Date;

import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;

public class HNT {


    public static final String KEY_ROWID="_id";
    public static final String KEY_FName="person_Fname";
    public static final String KEY_LName="person_Lname";
    public static final String KEY_Gender="person_Gender";
    public static final String KEY_DOB="person_DOB"; 

    private static final String Database_Name="DBPersonInfo2";
    private static final String Database_Table="DBTable2";
    private static final int Database_Version=1;        


    private DBHelper  ourHelper;
    private final Context ourContext;
    private SQLiteDatabase ourDB;


    private static class DBHelper extends SQLiteOpenHelper{

        public DBHelper(Context context) {
            super(context, Database_Name, null, Database_Version);
            // TODO Auto-generated constructor stub
        }

        @Override
        public void onCreate(SQLiteDatabase db) {
            // TODO Auto-generated method stub

            db.execSQL( "create table "+Database_Table+ "("+
                    KEY_ROWID+" integer primary key autoincrement,"  +           
                    KEY_FName+" TEXT NOT NULL, "+
                    KEY_LName+" TEXT NOT NULL, "+
                    KEY_Gender+" TEXT NOT NULL, "+
                    KEY_DOB+" Date NOT NULL);");

        }

        @Override
        public void onUpgrade(SQLiteDatabase db, int oldVersion, int arg2) {
            // TODO Auto-generated method stub

            db.execSQL("drop table if exists"+ Database_Table );
            onCreate(db);
        }

    }

    public HNT (Context c)
    {
        ourContext=c;

    }

    public HNT open() throws SQLException
    {
        ourHelper=new DBHelper(ourContext);
        ourDB=ourHelper.getWritableDatabase();
        return this;    
    }

    public void close()
    {
        ourHelper.close();
    }

    public long createEntry(String fName, String lName, String gender, Date date) {
        // TODO Auto-generated method stub


        ContentValues cv=new ContentValues();
        cv.put(KEY_FName, fName);
        cv.put(KEY_LName, lName);
        cv.put(KEY_Gender, gender);
        cv.put(KEY_DOB, date);

        return ourDB.insert(Database_Table, null, cv);

    }

    public String getData() {
        // TODO Auto-generated method stub
        String[] columns=new String[]{KEY_ROWID,KEY_FName,KEY_LName};

        Cursor c=ourDB.query(Database_Table, columns, null, null, null, null, null);
        String result="";

        int iRow=c.getColumnIndex(KEY_ROWID);
        int iFName=c.getColumnIndex(KEY_FName);
        int iLName=c.getColumnIndex(KEY_LName);
        int iGender=c.getColumnIndex(KEY_Gender);
        int iDOB=c.getColumnIndex(KEY_DOB);

        for(c.moveToFirst();!c.isAfterLast();c.moveToNext())
        {
            result=result+c.getString(iRow)+ " " + c.getString(iFName)+ " " + c.getString(iLName)+  c.getString(iGender)+ " " +  c.getString(iDOB)+ " "+"\n";
        }
        return result;
    }

}

This code is showing me error at line: cv.put(KEY_DOB, date); stating that method put(string,string) is not applicable for arguments (String,Date)

Please help me to insert Date datatype in Database.

its a data object. http://stackoverflow.com/questions/5683728/convert-java-util-date-to-string. convert date to string — Raghunandan, Aug 19 '13 at 06:29

score 3 · Accepted Answer · answered Aug 19 '13 at 06:28

3

Convert your date into the String formate then insert into the db

String date = new SimpleDateFormat("yyyy/MM/dd").format(new Date()).toString().trim();

then it will work

answered Aug 19 '13 at 06:28

Naresh Sharma

4,283
7
45
68

No. Alternatively, you can convert it to long if you don't care about readability of the data in your database. – Eric Aug 19 '13 at 06:30
ohh, thanks for support, i am new with this technology @EricTobias – C Sharper Aug 19 '13 at 06:31

not allowing to insert date values

1 Answers1