动态手势识别--操作数据库（一）

package com.example.gesture.database;import java.util.ArrayList;import java.util.List;import com.example.gesture.SensorData;//import 包名.类名import android.content.Context;import android.database.Cursor;import android.database.sqlite.SQLiteDatabase;public class OperateDatabase {private CreateDatabase linkedDatabase;private SQLiteDatabase sdb;public OperateDatabase(Context context1) {linkedDatabase = new CreateDatabase(context1);//类CreateDatabasesdb = linkedDatabase.getWritableDatabase();}/** * 添加sampleCollection数据到t_sampleCollection数据表中 * * */public void addsampleCollection(List<List<sensordata>> sampleCollection) {int n = sampleCollection.size();for (int i = 0; i < n; i++) {int m = sampleCollection.get(i).size();for (int j = 0; j < m; j++) {String sql = "insert into t_sampleCollection(belongId,acc1,acc2,acc3,gyro1,gyro2,gyro3) values('"+ i+ "','"+ sampleCollection.get(i).get(j).getAcc1()+ "','"+ sampleCollection.get(i).get(j).getAcc2()+ "','"+ sampleCollection.get(i).get(j).getAcc3()+ "','"+ sampleCollection.get(i).get(j).getGyro1()+ "','"+ sampleCollection.get(i).get(j).getGyro2()+ "','"+ sampleCollection.get(i).get(j).getGyro3() + "')";sdb.execSQL(sql);}}}/** * 从t_sampleCollection数据表中读取sampleCollection数据 * * */public List<List<sensordata>> getSampleCollection(int sampleCollectionSize) {List<List<sensordata>> sampleCollection = new ArrayList<List<sensordata>>();String Sql = "select * from t_sampleCollection";for (int i = 0; i < sampleCollectionSize; i++) { //String Sql = "select * from t_sampleCollection"; //上处语句 每次循环时sql都会被重新赋值，则会导致后面的result.moveToNext()出错Cursor result = sdb.rawQuery(Sql, null);List<sensordata> sensorDatas = new ArrayList<sensordata>();while (result.moveToNext()) {if (result.getInt(result.getColumnIndex("belongId")) == i) {float acc1 = result.getFloat(result.getColumnIndex("acc1"));float acc2 = result.getFloat(result.getColumnIndex("acc2"));float acc3 = result.getFloat(result.getColumnIndex("acc3"));float gyro1 = result.getFloat(result.getColumnIndex("gyro1"));float gyro2 = result.getFloat(result.getColumnIndex("gyro2"));float gyro3 = result.getFloat(result.getColumnIndex("gyro3"));SensorData sensorData = new SensorData(acc1, acc2, acc3,gyro1, gyro2, gyro3);sensorDatas.add(sensorData);}}sampleCollection.add(sensorDatas);}return sampleCollection;}/** * 添加model数据到t_model数据表中 * * */public void addModel(List<sensordata> model){int n = model.size();for(int i=0;i<n;i++){String sql = "insert into t_model(acc1,acc2,acc3,gyro1,gyro2,gyro3) values('"+ model.get(i).getAcc1()+ "','"+ model.get(i).getAcc2()+ "','"+ model.get(i).getAcc3()+ "','"+ model.get(i).getGyro1()+ "','"+ model.get(i).getGyro2()+ "','"+ model.get(i).getGyro3() + "')";sdb.execSQL(sql);}}/** * 从t_model数据表中读取model数据 * * */public List<sensordata> getModel(){String Sql = "select * from t_model";Cursor result = sdb.rawQuery(Sql, null);List<sensordata> model = new ArrayList<sensordata>();while (result.moveToNext()) {float acc1 = result.getFloat(result.getColumnIndex("acc1"));float acc2 = result.getFloat(result.getColumnIndex("acc2"));float acc3 = result.getFloat(result.getColumnIndex("acc3"));float gyro1 = result.getFloat(result.getColumnIndex("gyro1"));float gyro2 = result.getFloat(result.getColumnIndex("gyro2"));float gyro3 = result.getFloat(result.getColumnIndex("gyro3"));SensorData sensorData = new SensorData(acc1, acc2, acc3,gyro1, gyro2, gyro3);model.add(sensorData);}return model;}}