Android开发-SQLite数据库-常用操作

一、创建数据库和数据表

        SQLiteDatabase db = openOrCreateDatabase("tonometer.db", Context.MODE_PRIVATE, null);
        try {
            db.execSQL("CREATE TABLE data (id INTEGER PRIMARY KEY AUTOINCREMENT,"
                    + "systolic INTEGER,diastolic INTEGER,pulse INTEGER,"
                    + "time VARCHAR)");
        } catch (Exception e) {
            //e.printStackTrace();
        }
        db.close();

二、打开数据库并插入记录

            SQLiteDatabase db = openOrCreateDatabase("tonometer.db", Context.MODE_PRIVATE, null);
            try {
                db.execSQL("CREATE TABLE data (id INTEGER PRIMARY KEY AUTOINCREMENT,"
                        + "systolic INTEGER,diastolic INTEGER,pulse INTEGER,"
                        + "time VARCHAR)");
            } catch (Exception e) {
                //e.printStackTrace();
            }

            for(int i=0; i<ssp1.length; i++) {
                ssp2 = ssp1[i].split(",");

                int s,d,p;
                String t;
                s = Integer.parseInt(ssp2[0]);
                d = Integer.parseInt(ssp2[1]);
                p = Integer.parseInt(ssp2[2]);
                t = ssp2[3];

                // 插入新数据
                final ContentValues cv = new ContentValues();
                cv.put("systolic", s);
                cv.put("diastolic", d);
                cv.put("pulse", p);
                cv.put("time", t);
                db.insert("data", null, cv);

                new DatasThread(s, d, p, t).start();
            }

            db.close();

三、打开数据库并查询记录

        SQLiteDatabase db = openOrCreateDatabase("tonometer.db", Context.MODE_PRIVATE, null);
        int i;
        // 查询数据库数据条数
        Cursor cursor = db.rawQuery("select count(*)from data",null);
        cursor.moveToFirst();
        int count = cursor.getInt(0);
        if(count <15) {
            i = count-1;
        } else {
            i = 14;
        }
        // 查询最新插入的15条数据
        Cursor c = db.rawQuery("SELECT * FROM data order by id DESC LIMIT 15",null);
        while (c.moveToNext()){
//            System.out.println("ReadData:" + i + " - " +
//                    systolic[i] + "," + diastolic[i] + "," + pulse[i] + "," + time[i]);
            systolic[i] = c.getInt(c.getColumnIndex("systolic"));
            diastolic[i] = c.getInt(c.getColumnIndex("diastolic"));
            pulse[i] = c.getInt(c.getColumnIndex("pulse"));
            time[i] = c.getString(c.getColumnIndex("time"));
            i--;
        }
        db.close();