package io.github.hidroh.calendar;
import android.content.Intent;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.view.View;
import android.widget.EditText;
import static android.R.attr.id;
public class NoticeActivity extends AppCompatActivity {
private String dtTitle = "";
private String dtText = "";
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_notice);
final Intent intent = getIntent();
final EditText etTitle = (EditText) findViewById(R.id.et_title_notice);
final EditText etText = (EditText) findViewById(R.id.et_text_notice);
SQLiteDatabase db = openOrCreateDatabase("notice.db", MODE_PRIVATE, null);
String sql = "select " +
" _id, Title, writer, content " +
"from board where _id = '" + id + "'";
Cursor cursor = db.rawQuery(sql, null);
if (cursor.moveToNext()) {
etTitle.setText(cursor.getString(1));
etText.setText(cursor.getString(2));
dtTitle = cursor.getString(1);
dtText = cursor.getString(2);
}
findViewById(R.id.activity_notice).setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {
String stretTitle = etTitle.getText().toString();
String stretText = etText.getText().toString();
SQLiteDatabase db = openOrCreateDatabase("notice.db", MODE_PRIVATE, null);
String sql = "update notice set \n" +
"title= '" + stretTitle + "' ,\n" +
"text= '" + stretText + "' ,\n" +
"where _id = " + "id";
db.execSQL(sql);
Intent intent = new Intent();
setResult(RESULT_OK, intent);
finish();
}
});
}
}