[Java認證題庫]_1Z0-804題庫詳解_4

[Java認證題庫]_1Z0-804題庫詳解_4



package com.example.sqlitedb;



import java.util.ArrayList;



import android.content.Context;

import android.database.Cursor;

import android.database.sqlite.SQLiteDatabase;

import android.database.sqlite.SQLiteDatabase.CursorFactory;

import android.database.sqlite.SQLiteOpenHelper;



public class DBHP extends SQLiteOpenHelper{



public DBHP(Context context) {

super(context, "Gjun", null, 1);

}



@Override

public void onCreate(SQLiteDatabase db) {

db.execSQL("CREATE TABLE teacher(id TEXT,name TEXT,phoneNo TEXT,address TEXT);");

}



@Override

public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

// TODO Auto-generated method stub



}



public void insertDB(){

SQLiteDatabase db=getWritableDatabase();

db.execSQL("INSERT INTO teacher VALUES('1','王小明','0912-345678','Taipei');");

db.execSQL("INSERT INTO teacher VALUES('2','陳大為','0952-261258','Taipei');");

db.execSQL("INSERT INTO teacher VALUES('3','張三','0918-349527','Hsinchu');");

db.execSQL("INSERT INTO teacher VALUES('4','李四','0934-598741','Taipei');");

db.execSQL("INSERT INTO teacher VALUES('5','王武','0909-125348','Hsinchu');");

}

public ArrayList<String> queryDB(){

SQLiteDatabase db=getWritableDatabase();

Cursor cursor=db.rawQuery("SELECT * FROM teacher;", null);

ArrayList<String> list=new ArrayList<String>();

while(cursor.moveToNext()){

String id=cursor.getString(0);

String name=cursor.getString(1);

String phoneNo=cursor.getString(2);

String address=cursor.getString(3);

String result=id+"\t"+name+"\t"+phoneNo+"\t"+address+"\n";

list.add(result);

}

return list;

}





}

package com.example.sqlitedb;



import java.util.ArrayList;



import android.app.Activity;

import android.os.Bundle;

import android.view.Menu;

import android.view.MenuItem;

import android.view.View;

import android.widget.Button;

import android.widget.TextView;

import android.widget.Toast;





public class MainActivity extends Activity {

Button btn1,btn2,btn3;

TextView tv1;

DBHP dbhp;

ArrayList<String> AL;

    @Override

    protected void onCreate(Bundle savedInstanceState) {

        super.onCreate(savedInstanceState);

        setContentView(R.layout.activity_main);  //載入版面

        btn1=(Button)findViewById(R.id.button1);

        btn2=(Button)findViewById(R.id.button2);

        btn3=(Button)findViewById(R.id.button3);

        tv1=(TextView)findViewById(R.id.textView1);

        if(dbhp==null)

        dbhp=new DBHP(MainActivity.this);

       

    }

   

    public void show1(View v){

    String msg=btn1.getText().toString();

    tv1.setText(msg);

    dbhp.insertDB();

    Toast.makeText(MainActivity.this, "新增成功!", Toast.LENGTH_SHORT).show();

    }

public void show2(View v){

String msg=btn2.getText().toString();

    tv1.setText(msg);

    AL=dbhp.queryDB();

    StringBuilder sb=new StringBuilder("查詢結果如下:\n");

    for(int i=0;i<AL.size();i++){

    sb.append(AL.get(i).toString());

    }

    tv1.setText(sb);

}

public void show3(View v){

String msg=btn3.getText().toString();

    tv1.setText("");

}







}