[Android]_ch8.1_SQLite資料庫建置

[Android]_ch8.1_SQLite資料庫建置



1. DBHP.java

package com.derek.ch24_sqlitedb;



import android.content.Context;

import android.database.sqlite.SQLiteDatabase;

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) {

db.execSQL("DROP TABLE IF EXISTS teacher");

onCreate(db);

}



public void insertDB(){

SQLiteDatabase db=getWritableDatabase();

db.execSQL("INSERT INTO teacher VALUES('1','杜仲','0912-345678','新竹');");

db.execSQL("INSERT INTO teacher VALUES('2','張三','0912-345678','台北');");

db.execSQL("INSERT INTO teacher VALUES('3','李四','0912-345678','台中');");

db.execSQL("INSERT INTO teacher VALUES('4','王五','0912-345678','新竹');");

db.execSQL("INSERT INTO teacher VALUES('5','陳二','0912-345678','台南');");

}

}

2.MainActivity.java

package com.derek.ch24_sqlitedb;

import android.app.Activity;

import android.os.Bundle;

import android.view.Menu;

import android.view.MenuItem;

import android.view.View;

import android.view.View.OnClickListener;

import android.widget.Button;

import android.widget.TextView;

import android.widget.Toast;

public class MainActivity extends Activity {

TextView tv1;

Button btn1,btn2,btn3;

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

        else

        Toast.makeText(MainActivity.this, "資料庫已存在", Toast.LENGTH_SHORT).show();

        

        btn1.setOnClickListener(new OnClickListener() {

@Override

public void onClick(View v) {

dbhp.insertDB();

tv1.setText("新增資料完成!");

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

}

});

        btn2.setOnClickListener(new OnClickListener() {

@Override

public void onClick(View v) {

// TODO Auto-generated method stub

}

});

        btn3.setOnClickListener(new OnClickListener() {

@Override

public void onClick(View v) {

tv1.setText("");

}

});        

    }

}