206資料庫讀取(行動裝置應用)

1.strings的xml檔
<?xml version="1.0" encoding="utf-8"?>
<resources>
    <string name="app_name">資料庫讀取</string>
</resources>
2.main的xml檔

<?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];
}
}

沒有留言: