делаю зарплатный календарь, создал базу данных, но почему то не могу в не ничего записать, хотя база создается database.query возвращает таблицу, а cursor.getColumnIndex возвращает индексы.
так выглядит DBHelper
Код:
public class DBHelper extends SQLiteOpenHelper {
public static final int DATABASE_VERSION = 1;
public static final String DATABASE_NAME = "calendarDb";
public static final String TABLE_CALENDAR = "calendar";
public static final String MOUTHS = "mouths";
public static final String DAY_1 = "day1";
public static final String DAY_2 = "day2";
public static final String DAY_3 = "day3";
public static final String DAY_4 = "day4";
public static final String DAY_5 = "day5";
public static final String DAY_6 = "day6";
public static final String DAY_7 = "day7";
public static final String DAY_8 = "day8";
public static final String DAY_9 = "day9";
public static final String DAY_10 = "day10";
public static final String DAY_11 = "day11";
public static final String DAY_12 = "day12";
public static final String DAY_13 = "day13";
public static final String DAY_14 = "day14";
public static final String DAY_15 = "day15";
public static final String DAY_16 = "day16";
public static final String DAY_17 = "day17";
public static final String DAY_18 = "day18";
public static final String DAY_19 = "day19";
public static final String DAY_20 = "day20";
public static final String DAY_21 = "day21";
public static final String DAY_22 = "day22";
public static final String DAY_23 = "day23";
public static final String DAY_24 = "day24";
public static final String DAY_25 = "day25";
public static final String DAY_26 = "day26";
public static final String DAY_27 = "day27";
public static final String DAY_28 = "day28";
public static final String DAY_29 = "day29";
public static final String DAY_30 = "day30";
public static final String DAY_31 = "day31";
public static final String TOTAL = "total";
public DBHelper(Context context) {
super(context, DATABASE_NAME, null, DATABASE_VERSION);
}
@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL("create table " + TABLE_CALENDAR + "(" + MOUTHS + " text," + DAY_1 + " text," + DAY_2 + " text,"+ DAY_3 + " text,"
+ DAY_4 + " text," + DAY_5 + " text," + DAY_6 + " text," + DAY_7 + " text," + DAY_8 + " text," + DAY_9 + " text," + DAY_10 + " text,"
+ DAY_11 + " text," + DAY_12 + " text," + DAY_13 + " text," + DAY_14 + " text," + DAY_15 + " text," + DAY_16 + " text," + DAY_17 + " text,"
+ DAY_18 + " text," + DAY_19 + " text," + DAY_20 + " text," + DAY_21 + " text," + DAY_22 + " text," + DAY_23 + " text," + DAY_24 + " text,"
+ DAY_25 + " text," + DAY_26 + " text," + DAY_27 + " text," + DAY_28 + " text," + DAY_29 + " text," + DAY_30 + " text," + DAY_31 + " text,"
+ TOTAL +" text" + ")");
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
db.execSQL("drop table if exists " + TABLE_CALENDAR);
onCreate(db);
}
}
а тут я пытаюсь записать что ни будь в базу
Код:
public class MonthStat extends AppCompatActivity {
DBHelper dbHelper;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_month_stat);
dbHelper = new DBHelper(this);
SQLiteDatabase database = dbHelper.getWritableDatabase();
ContentValues contentValues = new ContentValues();
ContentValues cv = new ContentValues();
String string = "january";
cv.put(DBHelper.MOUTHS, string);
Cursor cursor = database.query(DBHelper.TABLE_CALENDAR, null, null, null, null, null, null);
int mIndex = cursor.getColumnIndex(DBHelper.DAY_1);
cursor.close();
dbHelper.close();
}
});
}
}