· 8 years ago · Aug 25, 2018, 05:20 PM
1Format date in the EditText (MM-dd-yyyy) to (yyyy-MM-dd) and write it in sqlite
2public class AuxGlucDbAdapter {
3
4public static final String KEY_IDPACIENTE = "IdPaciente";
5public static final String KEY_FECHA = "Fecha";
6public static final String KEY_EVE1 = "Eve1";
7public static final String KEY_EVE2 = "Eve2";
8public static final String KEY_EVE3 = "Eve3";
9public static final String KEY_EVE4 = "Eve4";
10public static final String KEY_EVE5 = "Eve5";
11public static final String KEY_EVE6 = "Eve6";
12public static final String KEY_EVE7 = "Eve7";
13public static final String KEY_ID = "_id";
14SimpleDateFormat sdf = new SimpleDateFormat("dd-MM-yyyy");
15Date date = sdf.parse(KEY_FECHA);
16private static final String TAG = "AuxGlucDbAdapter";
17private DatabaseHelper mDbHelper;
18private SQLiteDatabase mDb;
19
20
21private static final String DATABASE_CREATE =
22 "create table AuxGluc (_id integer primary key autoincrement, "
23 + "IdPaciente numeric not null, Fecha datetime not null, Eve1 numeric not null, Eve2 numeric not null, Eve3 numeric not null, Eve4 numeric not null, Eve5 numeric not null, Eve6 numeric not null, Eve7 numeric not null);";
24
25private static final String DATABASE_NAME = "data";
26private static final String DATABASE_TABLE = "AuxGluc";
27private static final int DATABASE_VERSION = 2;
28
29private final Context mCtx;
30
31private static class DatabaseHelper extends SQLiteOpenHelper {
32
33 DatabaseHelper(Context context) {
34 super(context, DATABASE_NAME, null, DATABASE_VERSION);
35 }
36
37 @Override
38 public void onCreate(SQLiteDatabase db) {
39
40 db.execSQL(DATABASE_CREATE);
41 }
42
43 @Override
44 public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
45 Log.w(TAG, "Upgrading database from version " + oldVersion + " to "
46 + newVersion + ", which will destroy all old data");
47 db.execSQL("DROP TABLE IF EXISTS AuxGluc");
48 onCreate(db);
49 }
50}
51
52public AuxGlucDbAdapter(Context ctx) {
53 this.mCtx = ctx;
54}
55
56public AuxGlucDbAdapter open() throws SQLException {
57 mDbHelper = new DatabaseHelper(mCtx);
58 mDb = mDbHelper.getWritableDatabase();
59 return this;
60}
61
62public void close() {
63 mDbHelper.close();
64}
65
66public long createNote(String IdPaciente, String Fecha, String Eve1, String Eve2, String Eve3, String Eve4, String Eve5, String Eve6, String Eve7) {
67 ContentValues initialValues = new ContentValues();
68 initialValues.put(KEY_IDPACIENTE, IdPaciente);
69 initialValues.put(KEY_FECHA, Fecha);
70 initialValues.put(KEY_EVE1, Eve1);
71 initialValues.put(KEY_EVE2, Eve2);
72 initialValues.put(KEY_EVE3, Eve3);
73 initialValues.put(KEY_EVE4, Eve4);
74 initialValues.put(KEY_EVE5, Eve5);
75 initialValues.put(KEY_EVE6, Eve6);
76 initialValues.put(KEY_EVE7, Eve7);
77
78 return mDb.insert(DATABASE_TABLE, null, initialValues);
79}
80
81public boolean deleteNote(long Id) {
82
83 return mDb.delete(DATABASE_TABLE, KEY_ID + "=" + Id, null) > 0;
84}
85
86public Cursor fetchAllNotes() {
87
88 return mDb.query(DATABASE_TABLE, new String[] {KEY_ID, KEY_IDPACIENTE, KEY_FECHA,
89 KEY_EVE1, KEY_EVE2, KEY_EVE3, KEY_EVE4, KEY_EVE5, KEY_EVE6, KEY_EVE7}, null, null, null, null, null, null);
90}
91
92public Cursor fetchNote(long Id) throws SQLException {
93
94 Cursor mCursor =
95
96 mDb.query(true, DATABASE_TABLE, new String[] {KEY_ID, KEY_IDPACIENTE,
97 KEY_FECHA, KEY_EVE1, KEY_EVE2, KEY_EVE3, KEY_EVE4, KEY_EVE5, KEY_EVE6, KEY_EVE7}, KEY_ID + "=" + Id, null,
98 null, null, null, null);
99 if (mCursor != null) {
100 mCursor.moveToFirst();
101 }
102 return mCursor;
103
104}
105
106public boolean updateNote(long Id, String IdPaciente, String Fecha, String Eve1, String Eve2, String Eve3, String Eve4, String Eve5, String Eve6, String Eve7) {
107 ContentValues args = new ContentValues();
108 args.put(KEY_IDPACIENTE, IdPaciente);
109 args.put(KEY_FECHA, Fecha);
110 args.put(KEY_EVE1, Eve1);
111 args.put(KEY_EVE2, Eve2);
112 args.put(KEY_EVE3, Eve3);
113 args.put(KEY_EVE4, Eve4);
114 args.put(KEY_EVE5, Eve5);
115 args.put(KEY_EVE6, Eve6);
116 args.put(KEY_EVE7, Eve7);
117
118 return mDb.update(DATABASE_TABLE, args, KEY_ID + "=" + Id, null) > 0;
119}
120}
121
122public class NoteEdit extends Activity {
123
124private EditText mIdPacienteText;
125private EditText mFechaText;
126private EditText mEve1Text;
127private EditText mEve2Text;
128private EditText mEve3Text;
129private EditText mEve4Text;
130private EditText mEve5Text;
131private EditText mEve6Text;
132private EditText mEve7Text;
133private Long mId;
134private AuxGlucDbAdapter mDbHelper;
135
136@Override
137
138protected void onCreate(Bundle savedInstanceState) {
139 super.onCreate(savedInstanceState);
140 mDbHelper = new AuxGlucDbAdapter(this);
141 mDbHelper.open();
142
143 setContentView(R.layout.note_edit);
144 setTitle(R.string.edit_note);
145
146 mIdPacienteText = (EditText) findViewById(R.id.IdPaciente);
147 mFechaText = (EditText) findViewById(R.id.Fecha);
148 mEve1Text = (EditText) findViewById(R.id.Eve1);
149 mEve2Text = (EditText) findViewById(R.id.Eve2);
150 mEve3Text = (EditText) findViewById(R.id.Eve3);
151 mEve4Text = (EditText) findViewById(R.id.Eve4);
152 mEve5Text = (EditText) findViewById(R.id.Eve5);
153 mEve6Text = (EditText) findViewById(R.id.Eve6);
154 mEve7Text = (EditText) findViewById(R.id.Eve7);
155
156 Button confirmButton = (Button) findViewById(R.id.confirm);
157
158 mId = (savedInstanceState == null) ? null :
159 (Long) savedInstanceState.getSerializable(AuxGlucDbAdapter.KEY_ID);
160 if (mId == null) {
161 Bundle extras = getIntent().getExtras();
162 mId = extras != null ? extras.getLong(AuxGlucDbAdapter.KEY_ID)
163 : null;
164 }
165
166 populateFields();
167
168 confirmButton.setOnClickListener(new View.OnClickListener() {
169
170 public void onClick(View view) {
171 setResult(RESULT_OK);
172 finish();
173 }
174
175 });
176}
177
178private void populateFields() {
179 if (mId != null) {
180 Cursor note = mDbHelper.fetchNote(mId);
181 startManagingCursor(note);
182 mIdPacienteText.setText(note.getString(
183 note.getColumnIndexOrThrow(AuxGlucDbAdapter.KEY_IDPACIENTE)));
184 mFechaText.setText(note.getString(
185 note.getColumnIndexOrThrow(AuxGlucDbAdapter.KEY_FECHA)));
186 mEve1Text.setText(note.getString(
187 note.getColumnIndexOrThrow(AuxGlucDbAdapter.KEY_EVE1)));
188 mEve2Text.setText(note.getString(
189 note.getColumnIndexOrThrow(AuxGlucDbAdapter.KEY_EVE2)));
190 mEve3Text.setText(note.getString(
191 note.getColumnIndexOrThrow(AuxGlucDbAdapter.KEY_EVE3)));
192 mEve4Text.setText(note.getString(
193 note.getColumnIndexOrThrow(AuxGlucDbAdapter.KEY_EVE4)));
194 mEve5Text.setText(note.getString(
195 note.getColumnIndexOrThrow(AuxGlucDbAdapter.KEY_EVE5)));
196 mEve6Text.setText(note.getString(
197 note.getColumnIndexOrThrow(AuxGlucDbAdapter.KEY_EVE6)));
198 mEve7Text.setText(note.getString(
199 note.getColumnIndexOrThrow(AuxGlucDbAdapter.KEY_EVE7)));
200
201 }
202}
203
204@Override
205protected void onSaveInstanceState(Bundle outState) {
206 super.onSaveInstanceState(outState);
207 saveState();
208 outState.putSerializable(AuxGlucDbAdapter.KEY_ID, mId);
209}
210
211@Override
212protected void onPause() {
213 super.onPause();
214 saveState();
215}
216
217@Override
218protected void onResume() {
219 super.onResume();
220 populateFields();
221}
222
223private void saveState() {
224 String IdPaciente = mIdPacienteText.getText().toString();
225 String Fecha = mFechaText.getText().toString();
226 String Eve1 = mEve1Text.getText().toString();
227 String Eve2 = mEve2Text.getText().toString();
228 String Eve3 = mEve3Text.getText().toString();
229 String Eve4 = mEve4Text.getText().toString();
230 String Eve5 = mEve5Text.getText().toString();
231 String Eve6 = mEve6Text.getText().toString();
232 String Eve7 = mEve7Text.getText().toString();
233
234 if (mId == null) {
235 long Id = mDbHelper.createNote(IdPaciente, Fecha, Eve1, Eve2, Eve3, Eve4, Eve5, Eve6, Eve7);
236 if (Id > 0) {
237 mId = Id;
238 }
239 } else {
240 mDbHelper.updateNote(mId, IdPaciente, Fecha, Eve1, Eve2, Eve3, Eve4, Eve5, Eve6, Eve7);
241 }
242}
243
244}
245
246private static final String DATABASE_CREATE =
247 "create table AuxGluc (_id integer primary key autoincrement, "
248 + "IdPaciente numeric not null, Fecha integer not null, Eve1 numeric not null, Eve2 numeric not null, Eve3 numeric not null, Eve4 numeric not null, Eve5 numeric not null, Eve6 numeric not null, Eve7 numeric not null);";
249
250public long createNote(String IdPaciente, int Fecha, String Eve1, String Eve2, String Eve3, String Eve4, String Eve5, String Eve6, String Eve7) {...}