SQLite数据库存储

因为前面提到xml存储更改文件很麻烦的缘故，最终还是选择了使用数据库存储

一试才觉十分的方便，速度也快

上源码：

1. publicclassDBHelperextendsSQLiteOpenHelper{
3. privatefinalstaticStringDATABASE_NAME="fanliao_db";
4. staticintDATABASE_VERSION=1;
5. staticStringTABLE_NAME="fanliao_chat";
6. staticStringCHAT_ID="_id";
7. staticStringCHAT_Name="chatname";
8. staticStringCHAT_Info="chatinfo";
9. staticStringCHAT_Time="chattime";
11. publicDBHelper(Contextcontext)
12. {
13. super(context,DATABASE_NAME,null,DATABASE_VERSION);
14. }
15. @Override
16. voidonCreate(SQLiteDatabasedb){
17. //CREATETABLEfanliao_chat(_idINTEGERPRIMARYKEYAUTOINCREMENT,
18. //chatnameTEXT,chattimeTEXT,chatinfoTEXT);
19. Stringsql="CREATETABLE"+TABLE_NAME+"("+CHAT_ID+"INTEGERPRIMARYKEYAUTOINCREMENT,"
20. +CHAT_Name+"TEXT,"+CHAT_Time+"TEXT,"+CHAT_Info+"TEXT);";
21. db.execSQL(sql);
22. System.out.println(sql);
23. }
24. @Override
25. voidonUpgrade(SQLiteDatabasedb,153); font-weight:bold; background-color:inherit">intoldVersion,153); font-weight:bold; background-color:inherit">intnewVersion){
26. Stringsql="DROPTABLEIFEXISTS"+TABLE_NAME;
27. onCreate(db);
28. System.out.println(sql);
29. publicCursorselect()
30. SQLiteDatabasedb=this.getReadableDatabase();
31. Cursorcursor=db.query(TABLE_NAME,"_idasc");
32. returncursor;
33. longinsert(Stringchatname,Stringchattime,Stringchatinfo)
34. {
35. SQLiteDatabasedb=this.getWritableDatabase();
36. ContentValuescv=newContentValues();
37. cv.put(CHAT_Name,chatname);
38. cv.put(CHAT_Time,chattime);
39. cv.put(CHAT_Info,chatinfo);
40. longrow=db.insert(TABLE_NAME,cv);
41. returnrow;
42. voiddelete(intid)
43. this.getWritableDatabase();
44. Stringwhere=CHAT_ID+"=?";
45. String[]whereValue={Integer.toString(id)};
46. db.delete(TABLE_NAME,where,whereValue);
47. voidupdate(intid,Stringchatname,Stringchatinfo)
48. ContentValuescv=newContentValues();
49. cv.put(CHAT_Name,chatname);
50. cv.put(CHAT_Time,chattime);
51. cv.put(CHAT_Info,chatinfo);
52. db.update(TABLE_NAME,cv,153); font-weight:bold; background-color:inherit">voiddelall(){
53. this.getReadableDatabase();
54. }

形如“聊天记录”这种虽没有十分复杂的存储结构，也是适宜存在表中，

而xml大概多是用以传输数据或存储少量不常用改动的数据把~

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!