Java代码

1. packagecom.shawn.test;
3. importandroid.content.ContentValues;
4. importandroid.content.Context;
5. importandroid.database.Cursor;
6. importandroid.database.sqlite.SQLiteDatabase;
7. importandroid.database.sqlite.SQLiteOpenHelper;
8. importandroid.util.Log;
10. publicclassDatabaseAdapter{
12. privatestaticfinalStringDB_NAME="Test.db";//数据库名
13. privatestaticfinalintDB_VERSION=1;//数据库版本
15. privatestaticfinalStringDB_TABLE="my_order";//表名
16. privatestaticfinalStringKEY_ID="_id";//id
17. privatestaticfinalStringKEY_ORDER_ID="order_id";//订单号
18. privatestaticfinalStringKEY_TYPE="_type";//订单类型
19. privatestaticfinalStringKEY_STATE="_state";//订单状态
21. privateContextcontext;
22. privateDatabaseHelpermDatabaseHelper;
23. privateSQLiteDatabasemSQLiteDatabase;
25. privatestaticclassDatabaseHelperextendsSQLiteOpenHelper{
26. //创建数据库语句
27. privatestaticfinalStringDB_CREAT="CREATETABLE"
28. +DB_TABLE
29. +"("+KEY_ID+"INTEGERPRIMARYKEY,"
30. +KEY_ORDER_ID+"TEXT,"
31. +KEY_TYPE+"INTEGER,"
32. +KEY_STATE+"INTEGER)";
34. publicDatabaseHelper(Contextcontext){
35. super(context,DB_NAME,null,DB_VERSION);
36. }
37. @Override
38. publicvoidonCreate(SQLiteDatabasedb){
39. //TODOAuto-generatedmethodstub
40. db.execSQL(DB_CREAT);
41. }
42. @Override
43. publicvoidonUpgrade(SQLiteDatabasedb,intoldVersion,intnewVersion){
44. //TODOAuto-generatedmethodstub
45. db.execSQL("DROPTABLEIFEXISTS"+DB_TABLE);
46. onCreate(db);
47. }
48. }
50. publicDatabaseAdapter(Contextcontext){
51. this.context=context;
52. }
53. //开启
54. publicvoidopen(){
55. mDatabaseHelper=newDatabaseHelper(context);
56. mSQLiteDatabase=mDatabaseHelper.getWritableDatabase();
57. }
58. //关闭
59. publicvoidclose(){
60. mSQLiteDatabase.close();
61. mDatabaseHelper.close();
62. }
64. //增
65. publiclonginsertData(StringorderId,inttype){
66. ContentValuesvalues=newContentValues();
67. values.put(KEY_ORDER_ID,orderId);
68. values.put(KEY_TYPE,type);
69. values.put(KEY_STATE,Config.STATE_APPLY);
70. longid=mSQLiteDatabase.insert(DB_TABLE,KEY_ID,values);
71. returnid;
72. }
73. //删
74. publicbooleandeleteData(Contextcontext,longid){
75. booleandelete=mSQLiteDatabase.delete(DB_TABLE,KEY_ID+"="+id,null)>0;
76. returndelete;
77. }
78. //改
79. publicbooleanupdateData(longid,intstate){
80. ContentValuesvalues=newContentValues();
81. values.put(KEY_STATE,""+state);
82. booleanupdate=mSQLiteDatabase.update(DB_TABLE,values,KEY_ID+"="+id,null)>0;
83. returnupdate;
84. }
85. //查
86. publicCursorfetchData(Stringselection){
87. CursormCursor=mSQLiteDatabase.query(DB_TABLE,newString[]{KEY_ID,KEY_ORDER_ID,KEY_TYPE,KEY_STATE},selection,null,null,null,null);
88. if(mCursor!=null)
89. mCursor.moveToFirst();
90. returnmCursor;
91. }
92. }

更多相关文章

1. Android APP 版本更新通知代码
2. Android图片放大修改代码
3. Android获取基站坐标代码
4. Android——实现在纯Java代码里写布局
5. 通过CMD 查看android APP数据库表
6. Android 简单数据库（增删改查）
7. Android(Java):jni源代码

随机推荐

1. selector的使用
2. Android自学笔记之短信发送器
3. Android在eclipse开发出现打开main.xml就
4. Type View requires API level 14 (curre
5. Android - Failure delivering result Re
6. 多线程实现android更新进度条
7. In Android how to display one view as
8. android 生成圆角和带倒影图片
9. Android 读写XML文件(使用pull解析)
10. Android(安卓)11版本号仍有甜点名称 只是