2.main的xml檔<?xml version="1.0" encoding="utf-8"?><resources><string name="app_name">資料庫讀取</string></resources>
<?xml version="1.0" encoding="utf-8"?>
<AbsoluteLayout xmlns:android="http://schemas.android.com/apk/res/android"
android:layout_width="fill_parent"
android:layout_height="fill_parent"
android:orientation="vertical" >
<TextView
android:layout_width="fill_parent"
android:layout_height="wrap_content"
android:text="@string/app_name" />
<ListView
android:id="@+id/listView1"
android:layout_width="142dp"
android:layout_height="208dp"
android:layout_x="25dp"
android:layout_y="37dp" >
</ListView>
<Button
android:id="@+id/ok_button"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_x="203dp"
android:layout_y="52dp"
android:text="OK" />
<Button
android:id="@+id/exit_button"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_x="203dp"
android:layout_y="120dp"
android:text="Exit" />
</AbsoluteLayout>
3.GDD02.java程式碼
import android.app.Activity;
import android.os.Bundle;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.AdapterView;
import android.widget.AdapterView.OnItemClickListener;
import android.widget.Button;
import android.widget.ListView;
import android.database.sqlite.SQLiteDatabase;
import android.database.Cursor;
import android.widget.Toast;
import android.widget.ArrayAdapter;
public class GDD02 extends Activity {
String databaseName = "notes.db";
Button ok, exit;
ListView listView;
SQLiteDatabase sqlite;
String createTable = "create table notes (_id integer primary key,note text not null,created integer);";
String insert = "insert into notes values(1,'BOOK',10)";
String insert2 = "insert into notes values(2,'FOOD',10)";
String insert3 = "insert into notes values(3,'TOOL',10)";
Object[][] data;
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.main);
ok = (Button) this.findViewById(R.id.ok_button);
exit = (Button) this.findViewById(R.id.exit_button);
listView = (ListView) this.findViewById(R.id.listView1);
sqlite = this.openOrCreateDatabase(databaseName, this.MODE_PRIVATE,
null);
try {
sqlite.execSQL(createTable);
sqlite.execSQL(insert);
sqlite.execSQL(insert2);
sqlite.execSQL(insert3);
} catch (Exception io) {
Toast.makeText(this, "Table Really Created", Toast.LENGTH_SHORT)
.show();
}
Cursor c = sqlite.rawQuery("select note from notes;", null);
data = new Object[2][c.getCount()];
while (c.moveToNext()) {
String s = c.getString(c.getColumnIndex("note"));
data[0][c.getPosition()] = s;
data[1][c.getPosition()] = false;
}
ArrayAdapter array = new ArrayAdapter(this,
android.R.layout.simple_list_item_multiple_choice, data[0]);
listView.setAdapter(array);
listView.setChoiceMode(listView.CHOICE_MODE_MULTIPLE);
listView.setOnItemClickListener(new OnItemClickListener() {
@Override
public void onItemClick(AdapterView<?> arg0, View arg1, int point,
long arg3) {
setItem(point);
}
});
ok.setOnClickListener(new OnClickListener() {
@Override
public void onClick(View arg0) {
String s = "";
for (int i = 0; i < data[0].length; i++) {
if ((Boolean) data[1][i]) {
s += data[0][i] + " ";
}
}
GDD02.this.setTitle("{" + s + "}");
}
});
exit.setOnClickListener(new OnClickListener() {
@Override
public void onClick(View arg0) {
GDD02.this.finish();
}
});
}
public void setItem(int point) {
data[1][point] = !(Boolean) data[1][point];
}
}
沒有留言:
張貼留言