SQLite——Android学习笔记

 

 1 import java.util.ArrayList;
 2 import java.util.HashMap;
 3 
 4 import android.content.Context;
 5 import android.database.Cursor;
 6 import android.database.sqlite.SQLiteDatabase;
 7 import android.database.sqlite.SQLiteOpenHelper;
 8 
 9 public class MyDBHelper extends SQLiteOpenHelper {
10     private final static String DB_NAME = "alarm_db";
11     private final static int DATABASE_VESION = 1;
12 
13     public String ALARM_ID = "_id";
14     public String ALARM_TIME = "alarmtime";
15     public String ALARM_REPEAT = "alarmrepeat";
16     public String ALARM_ISOPEN = "alarmisopen";
17 
18     public ArrayList list;
19     public int[] id ;
20     public String[] alarm_time;
21     public String[] alarm_repeat;
22     public String[] alarm_isopen;
23     
24     public MyDBHelper(Context context) {
25         super(context, DB_NAME, null, DATABASE_VESION);
26     }
27 
28     @Override
29     public void onCreate(SQLiteDatabase db) {
30         String str = "create table " +DB_NAME + "(" +ALARM_ID +
31                 " integer primary key autoincrement,"+
32                 ALARM_TIME +" text,"+ALARM_REPEAT+" text,"+ ALARM_ISOPEN+" text)";
33         System.out.println(str.toString());
34         db.execSQL(str);
35     }
36 
37     @Override
38     public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
39         String sql = "drop table if exists " + DB_NAME;
40         System.out.println(sql.toString());
41         db.execSQL(sql);
42     }
43     
44     public ArrayList getAllInfo(SQLiteDatabase sqliteDB){
45         list = new ArrayList();
46         Cursor cursor = sqliteDB.rawQuery("select * from alarm_db", null);
47         while(cursor.moveToNext()){
48             HashMap<String,Object> item = new HashMap<String,Object>();
49             item.put("_id","日期提醒"+String.valueOf(cursor.getInt(cursor.getColumnIndex("_id"))));
50             item.put("alarmtime", cursor.getString(cursor.getColumnIndex("alarmtime")));
51             item.put("alarmrepeat",cursor.getString(cursor.getColumnIndex("alarmrepeat")));
52             item.put("alarmisopen",cursor.getString(cursor.getColumnIndex("alarmisopen")));
53             item.put("image", R.drawable.alarm_dialog);
54             list.add(item);
55         }        
56         return list;
57     }
58     
59 }

 

 1 private MyDBHelper dbHelper;
 2 private SQLiteDatabase db;
 3 
 4 dbHelper = new MyDBHelper(MainActivity.this);
 5 db = dbHelper.getReadableDatabase();
 6 
 7 ContentValues values = new ContentValues();                        
 8  values.put(dbHelper.ALARM_TIME,tv_alarm_time.getText().toString());
 9  values.put(dbHelper.ALARM_REPEAT,tv_alarm_repeat.getText().toString());
10  values.put(dbHelper.ALARM_ISOPEN,"isopen");
11  db.insert("alarm_db", null, values);

 

posted on 2012-11-14 10:47  liyajun2012  阅读(177)  评论(0)  编辑  收藏  举报

导航