sqlite数据库如何插入以及修改date类型的字段

sqlite数据库中插入date类型用string类型，如下：

public void insert(String dailyGuid, String dailyCreateDate, String dailyUpdateDate, String dailyContactGuid,

String dailyEmployeeGuid, String dailyContent, String dailyType, String dailyTypeValue,

String dailyEstimateRate, String dailyRealRate, String dailyMemo, String dailyApproval,

String dailyExecuteDate, String dailyRemindSign, String dailyTime, String dailyIsdel){

SQLiteDatabase db=this.getWritableDatabase()

db.execSQL("INSERT INTO TBL_DAILY(dailyGuid, dailyCreateDate, dailyUpdateDate, dailyContactGuid, " +

"dailyEmployeeGuid, dailyContent, dailyType, dailyTypeValue, " +

"dailyEstimateRate, dailyRealRate, dailyMemo, dailyApproval, " +

"dailyExecuteDate, dailyRemindSign, dailyTime, dailyIsdel) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)",

new String[]{dailyGuid, dailyCreateDate, dailyUpdateDate, dailyContactGuid,

dailyEmployeeGuid, dailyContent, dailyType, dailyTypeValue,

dailyEstimateRate, dailyRealRate, dailyMemo, dailyApproval,

dailyExecuteDate, dailyRemindSign, dailyTime, dailyIsdel})

}

更新动作如下：

public void update(String dailyGuid, String dailyCreateDate, String dailyUpdateDate, String dailyContactGuid,

String dailyEmployeeGuid, String dailyContent, String dailyType, String dailyTypeValue,

String dailyEstimateRate, String dailyRealRate, String dailyMemo, String dailyApproval,

String dailyExecuteDate, String dailyRemindSign, String dailyTime, String dailyIsdel){

SQLiteDatabase db=this.getWritableDatabase()

ContentValues cv=new ContentValues()

cv.put("dailyGuid", dailyGuid)

cv.put("dailyCreateDate", dailyCreateDate)

cv.put("dailyUpdateDate", dailyUpdateDate)

cv.put("dailyContactGuid", dailyContactGuid)

cv.put("dailyEmployeeGuid", dailyEmployeeGuid)

cv.put("dailyContent", dailyContent)

cv.put("dailyType", dailyType)

cv.put("dailyTypeValue", dailyTypeValue)

cv.put("dailyEstimateRate", dailyEstimateRate)

cv.put("dailyRealRate", dailyRealRate)

cv.put("dailyMemo", dailyMemo)

cv.put("dailyApproval", dailyApproval)

cv.put("dailyExecuteDate", dailyExecuteDate)

cv.put("dailyRemindSign", dailyRemindSign)

cv.put("dailyTime", dailyTime)

cv.put("dailyIsdel", dailyIsdel)

db.update("TBL_DAILY", cv, "dailyGuid=?", new String[]{dailyGuid})

}

public void delete(String dailyGuid){

SQLiteDatabase db=this.getWritableDatabase()

db.delete("TBL_DAILY", "dailyGuid=?", new String[]{dailyGuid})

}

注意：sqlite其中的数据 类型是可以很容易的进行转换的，提取的时候如果需要可以将String在转为date类型就可以了。

android sqlite写入存储时间的方法如下：

第一，在你的SQL上写入以下代码。

SimpleDateFormat formatter = new SimpleDateFormat ("yyyy-MM-dd")

Date curDate = new Date(System.currentTimeMillis())//获取当前时间

String str = formatter.format(curDate)

这样str里就是年月日字符型记录

db.execSQL("create table date(date1 varchar(20)")

定义一个数据库

DatabaseHelper dbHelper1 = new DatabaseHelper(MainActivity.this,"date",null,1)

SQLiteDatabase db1 = dbHelper2.getReadableDatabase()

ContentValues values1 = new ContentValues()

values1.put("date1",str)//将str内容存入date1中

db1.insert("date", null, values1)//把values1内容加入数据库

db1.close()

第二，关闭数据库，存放数据即可。

---