无法插入在SQLite数据库Android的数据 [英] Unable to insert data in Sqlite Database android
问题描述
继code用于在数据库中插入数据。
Following code is used to insert data in the database.
在启动应用程序时,下面的code被执行。
When application is launched, following code is executed.
在 RecentDBManager
执行时,当我 PULL
从模拟器内存数据库,它显示了在<$ C无记录$ C> FavoriteScrip 表。
After RecentDBManager
is executed, when I PULL
database from emulator memory, it shows no record in FavoriteScrip
table.
当我在使用setData code>方法记录
的insertstmt
,它工作正常。
它显示了
When I logged InsertStmt
in setData
method, it works fine.
It shows
插入FavoriteScrip(符号,CMP,CHG)VALUES('值1','值','VALUE3')
但它没有得到插入表...
在主类
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类
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.
所以,查询的格式为插入+ TABLE_NAME +(符号,dt_tm)VALUES('+值1 +',日期时间())
我试过
ContentValues cv = new ContentValues();
cv.put("sym", value1);
cv.put("dt_tm", "datetime()");
mDb.insert(TABLE_NAME, null, cv);
值1
列是越来越插入到表中,但不是日期时间。可以采取什么问题?
value1
column is getting inserted into table but not datetime. What can be the problem?
完成...我用如下:
Calendar date1 = Calendar.getInstance();
SimpleDateFormat dateformatter = new SimpleDateFormat(
"dd/MM/yyyy HH:mm:ss");
String currentdate = dateformatter.format(date1
.getTime());
并通过的currentdate
作为第二个参数。
日Thnx ALL !!!!
THNX ALL !!!!
任何帮助将生命SAVER !!!
推荐答案
尝试
@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);
}
这篇关于无法插入在SQLite数据库Android的数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!