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

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



package com.example.sqlitedb;



import android.content.Context;

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');");

}



}









package com.example.sqlitedb;



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;

    @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);

}

public void show3(View v){

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

    tv1.setText(msg);

}





}