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. 通过CMD 查看android APP数据库表
  2. Android之SQLLite
  3. Android(安卓)简单数据库（增删改查）
  4. android sqlite 一次创建多个表
  5. android中操作SQLite常见错误
  6. Android(安卓)sd卡读取数据库实例代码
  7. Android菜鸟日记10 SQLite 数据库
  8. android实现关键字搜索功能
  9. Android查询短信数据库

随机推荐

  1. Android(安卓)4.0 SDK官方下载
  2. Android(安卓)强制横屏
  3. Android百度地图相关内容汇总
  4. android textview内容超长滚动视图
  5. android:windowSoftInputMode属性详解
  6. Android(安卓)- Android实现定时器的方法
  7. android优秀网站收集中
  8. Android(安卓)5.0 Lollipop SDK下载地址
  9. TextView 滚动
  10. Android(安卓)Button Maker（在线生成andro