sqlite 를 이용해서 안드로이드 스튜디오에서
배열 값을 생성한 테이블에 저장하고 싶은데 insert 할때 문법에러가 나는데요
ㅠ.ㅠ 답변 부탁합니다.. 저는 잘못한게 없어보이는데 왜그럴까여
val_all = new float[14];
private void createTable(String name) {
db.execSQL("create table if not exists " + name + "("
+ " _id integer PRIMARY KEY autoincrement, "
+ " time float, "
+ " accel_x float, "
+ " accel_y float, "
+ " accel_z float, "
+ " gyro_x float, "
+ " gyro_y float, "
+ " gyro_z float, "
+ " mag_x float, "
+ " mag_y float, "
+ " mag_z float, "
+ " pressure float,"
+ " lat float,"
+ " lon float,"
+ " alt float);");
tableCreated = true;
}
private void insertRecord(String name) {
Log.d(tag, "기록중");
db.execSQL( "insert into " + name +"(time, accel_x, accel_y, accel_z, gyro_x, gyro_y, gyro_z, mag_x,mag_y,mag_z, pressure, lat, lon, alt)" +
" values (val_all[0], val_all[1],val_all[2], val_all[3],val_all[4], val_all[5], val_all[6], val_all[7],val_all[8], val_all[9],val_all[10], val_all[11], val_all[12], val_all[13]);" );
return;
}