· 7 years ago · Sep 19, 2018, 01:30 AM
1package com.demo.android.remeber;
2
3import javax.security.auth.PrivateCredentialPermission;
4
5import android.R;
6import android.R.anim;
7import android.R.string;
8import android.app.Activity;
9import android.content.Context;
10import android.database.Cursor;
11import android.database.sqlite.SQLiteDatabase;
12import android.os.Bundle;
13import android.util.Printer;
14import android.view.View;
15import android.view.View.OnClickListener;
16import android.widget.Button;
17import android.widget.EditText;
18import android.widget.ListView;
19
20public class main extends Activity {
21 /** Called when the activity is first created. */
22 private static final String DBNAME = "MY_DB";
23 private static final String TABLENAME = "MY_TABLE";
24 private static final String FIELD01_NAME = "_id";
25 private static final String FIELD02_NAME = "_text1";
26 private SQLiteDatabase dataBase;
27 private android.database.Cursor cursor;
28 private int _id = -1 ;
29 private EditText EditText01;
30 private Button Button01;
31 private Button Button02;
32 private Button Button03;
33 private ListView ListView01;
34
35 @Override
36 public void onCreate(final Bundle savedInstanceState) {
37 super.onCreate(savedInstanceState);
38 setContentView(R.layout.main);
39
40 EditText01 = (EditText) findViewById(R.id.EditText01);
41 Button01 = (Button) findViewById(R.id.BtnAdd);
42 Button02 = (Button) findViewById(R.id.BtnUpdate);
43 Button03 = (Button) findViewById(R.id.BtnDelete);
44 ListView01 = (ListView) findViewById(R.id.ListView01);
45
46 Button02.setEnabled(false);
47 Button03.setEnabled(false);
48
49 String CREATE_SQL = "create table if not exists " + TABLENAME + " ("
50 + FIELD01_NAME + " integer primary key autoincrement, "
51 + FIELD02_NAME + " varchar not null);";
52
53 createDatabase(CREATE_SQL);
54
55 cursor = this.getAll();
56 cursor.moveToFirst();
57
58 android.widget.SimpleCursorAdapter adapter = new android.widget.SimpleCursorAdapter(
59 this, R.layout.list, cursor, new String[] { FIELD02_NAME },
60 new int[] { R.id.CheckedTextView01 });
61
62 Button01.setOnClickListener(new View.OnClickListener() {
63
64 @Override
65 public void onClick(View arg0) {
66 // TODO Auto-generated method stub
67 if (!EditText01.getText().equals("")) {
68 insert("" + EditText01.getText());
69 }
70 onCreate(savedInstanceState);
71 }
72 });
73 Button02.setOnClickListener(new View.OnClickListener() {
74
75 @Override
76 public void onClick(View arg0) {
77 // TODO Auto-generated method stub
78 if (_id != -1 && !EditText01.getText().equals("")) {
79 update(_id, "" + EditText01.getText());
80 Button02.setEnabled(false);
81 Button03.setEnabled(false);
82 }
83 onCreate(savedInstanceState);
84
85 }
86 });
87 Button03.setOnClickListener(new View.OnClickListener() {
88
89 @Override
90 public void onClick(View arg0) {
91 // TODO Auto-generated method stub
92 if (_id != -1) {
93 delete(_id);
94 Button02.setEnabled(false);
95 Button03.setEnabled(false);
96 }
97 onCreate(savedInstanceState);
98
99 }
100 });
101
102
103 }
104
105 private void createDatabase(String CREATE_SQL) {
106 dataBase= openOrCreateDatabase(DBNAME,Context.MODE_PRIVATE,null);
107 dataBase.execSQL(CREATE_SQL);
108
109 }
110
111 public Cursor getAll()
112 {
113 cursor=dataBase.query(TABLENAME,//資料者å稱
114
115 new String[]{"_id,_text1"},//欄ä½å稱
116 null,//WHERE
117 null,//WHEREåƒæ•¸
118 null,//GROUP BY
119 null,//HAVING
120 null//ORDER BY
121 );
122 return cursor;
123
124 }
125
126 private void insert(String text) {
127
128 }
129
130 private void update(int id, String text) {
131
132
133 }
134
135 private void delete(int id) {
136
137 }
138}