public class MainActivity extends AppCompatActivity {
public class dbHelper extends SQLiteOpenHelper {
public dbHelper(Context context) {
super(context, "Calender", null,1);
}
@Override
public void onCreate(SQLiteDatabase sqLiteDatabase) {
sqLiteDatabase.execSQL("CREATE TABLE calender ( Day char(20) PRIMARY KEY," +
"BN char(20)," +
"BC char(20)," +
"LN char(20)," +
"LC char(20)," +
"DN char(20)," +
"DC char(20)," +
"EN char(20)," +
"EC char(20)," +
"SUM char(20));");
}
@Override
public void onUpgrade(SQLiteDatabase sqLiteDatabase, int oldver, int newver) {
sqLiteDatabase.execSQL("DROP TABLE IF EXISTS calender");
onCreate(sqLiteDatabase);
}
}
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
calendarView = (CalendarView) findViewById(R.id.calender);
DBSelect = (TextView) findViewById(R.id.DBSelect);
delete = (Button) findViewById(R.id.Delete);
//delete.setVisibility(View.INVISIBLE);
calendarView.setOnDateChangeListener(new CalendarView.OnDateChangeListener() {
@Override
public void onSelectedDayChange(@NonNull CalendarView calendarView, int year, int month, int day) {
month=month+1;
String Date = year+"년"+month+"월"+day+"일";
Intent intent = new Intent(getApplicationContext(),Add.class);
intent.putExtra("date",Date);
startActivityForResult(intent,1);
}
});
@Override
protected void onActivityResult(int requestCode, int resultCode, Intent data) {
super.onActivityResult(requestCode, resultCode, data);
if(requestCode==1){
database = dBhelper.getWritableDatabase();
database.execSQL(data.getStringExtra("sql"));
database.close();
DBSelect.setText(data.getStringExtra("sql"));
}
}
(글자수때문에생략된 부분있습니다)
다른액티비티에서 sql문을 인텐트로 가져와서 현액티비티DB에
저장하려하는데 튕깁니다. 어디문제인가요?