无法在Sqlite Database android中插入数据

Following code is used to insert data in the database.

以下代码用于在数据库中插入数据。

When application is launched, following code is executed.

启动应用程序时,将执行以下代码。

After RecentDBManager is executed, when I PULL database from emulator memory, it shows no record in FavoriteScrip table.

执行RecentDBManager后,当我从仿真器内存中提取数据库时,它在FavoriteScrip表中没有显示任何记录。

When I logged InsertStmt in setData method, it works fine. It shows

当我在setData方法中记录InsertStmt时,它工作正常。表明

insert into FavoriteScrip(sym,cmp,chg) values ('value1','value2','value3')

插入到FavoriteScrip(sym,cmp,chg)值('value1','value2','value3')

but it is not getting inserted in table...

但它没有被插入表格......

In main class

在主要班级

 rdbM = new RecentDBManager(CompanyView.this);
                        try {
                            if (!rdbM.checkDataBase()) {
                                rdbM.createDataBase();
                            }
                            rdbM.openDB();
                            rdbM.setData("value1");
                            rdbM.closeDB();

                        } catch (Exception e) {
                            throw new Error("ERROR in DB Access"+ e.toString());
                    }

RecentDBManager class

    public class RecentDBManager {
    private DatabaseHelper dataHelper;
    private SQLiteDatabase mDb;
    private Context ctx;
    private String DATABASE_PATH = "/data/data/com.mypackage/databases/";
    private static String DATABASE_NAME = "ScripMasterDB";
    private static String TABLE_NAME = "FavoriteScrip";
        private String InsertStmt;
    private static final int DATABASE_VERSION = 1;
    private Cursor cur;

    RecentDBManager(Context ctx) {
        this.ctx = ctx;
        dataHelper = new DatabaseHelper(ctx);
    }

    private static class DatabaseHelper extends SQLiteOpenHelper {
        Context myContext = null;

        public DatabaseHelper(Context context) {
            super(context, DATABASE_NAME, null, DATABASE_VERSION);
            this.myContext = context;
        }

        @Override
        public void onCreate(SQLiteDatabase db) {
        }

        @Override
        public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
            Log.w("DBHelper", "Upgrading database from version " + oldVersion
                    + " to " + newVersion + ", which will destroy all old data");
            onCreate(db);
        }
    }

    public boolean checkDataBase() {
        String myPath = DATABASE_PATH + DATABASE_NAME;
        File f = new File(myPath);
        return f.exists();
    }

    public void createDataBase() {
        openDB();
        try {
            OutputStream myOutput = new FileOutputStream(DATABASE_PATH+ DATABASE_NAME);

            if (mDb.isOpen())
                mDb.close();
            myOutput.flush();
            myOutput.close();

        } catch (Exception e) {
            throw new Error("RecentDbManager Exception - " + e.getMessage());
        }
    }

    public RecentDBManager openDB() throws SQLException {
        mDb = dataHelper.getWritableDatabase();
        return this;
    }

    public void setData(String value1, String value2, String value3) {
                ContentValues cv = new ContentValues();
cv.put("sym", value1);
cv.put("dt_tm", "datetime()");
mDb.insert(TABLE_NAME, null, cv);

        } catch (SQLiteException e) {
            throw new Error("RecentDbManager Exception in inserting data"
                    + e.getMessage());
        }
    }

    public void closeDB() {
        try {
            mDb.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}

EDIT

I have one column which contains current datetime.

我有一列包含当前日期时间。

So query is of the form "insert into " + TABLE_NAME+ " (sym,dt_tm) values ('" + value1 + "',datetime())"

因此查询的形式为“insert into”+ TABLE_NAME +“(sym,dt_tm)values('”+ value1 +“',datetime())”

I tried

    ContentValues cv = new ContentValues();
cv.put("sym", value1);
cv.put("dt_tm", "datetime()");
mDb.insert(TABLE_NAME, null, cv);

value1 column is getting inserted into table but not datetime. What can be the problem?

value1列将插入到表中,但不会插入日期时间。可能是什么问题?

Final edit

DONE... I used following :

完成......我使用了以下内容:

                Calendar date1 = Calendar.getInstance();
                    SimpleDateFormat dateformatter = new SimpleDateFormat(
                            "dd/MM/yyyy HH:mm:ss");

                    String currentdate = dateformatter.format(date1
                            .getTime());

and passed currentdate as second parameter.

并传递currentdate作为第二个参数。

THNX ALL !!!!

ANY HELP WILL BE LIFE-SAVER !!!

任何帮助都将是生命!

3 个解决方案

#1

try

@Override
public void onCreate(SQLiteDatabase db) {
    db.execSQL(Create table Memo (ID INTEGER PRIMARY KEY AUTOINCREMENT, sym TEXT, cmp TEXT, cng TEXT);
}

public void setData(String value1, String value2, String value3) {

            ContentValues cv = new ContentValues();
            cv.put("sym", value1);
            cv.put("cmp", value2);
            cv.put("cng", value3);

            mDb.insert(TABLE_NAME, null, cv);
    }

#2

Try leaving a blank space after tablename of your insert statement:

尝试在insert语句的tablename后留一个空格:

insert into FavoriteScrip (sym,cmp,chg) values ('value1','value2','value3')

InsertStmt="insert into " + TABLE_NAME + " (sym,cmp,chg) values ('" + value1 + "','" + value2                    + "','" + value3 + "')";

#3

try using insert instead of raw query

尝试使用insert而不是raw查询

#1

try

@Override
public void onCreate(SQLiteDatabase db) {
    db.execSQL(Create table Memo (ID INTEGER PRIMARY KEY AUTOINCREMENT, sym TEXT, cmp TEXT, cng TEXT);
}

public void setData(String value1, String value2, String value3) {

            ContentValues cv = new ContentValues();
            cv.put("sym", value1);
            cv.put("cmp", value2);
            cv.put("cng", value3);

            mDb.insert(TABLE_NAME, null, cv);
    }

#2