android 数据库的使用

1 main_acticity布局

2 新建一个myHelper

3 主界面代码实现

一 main_activity.xml

<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
    xmlns:tools="http://schemas.android.com/tools"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    android:orientation="vertical"
    tools:context=".MainActivity">

    <TextView
        android:id="@+id/textView"
        android:gravity="center"
        android:layout_width="fill_parent"
        android:layout_height="70dp"
        android:text="@string/text" />

    <EditText
        android:id="@+id/editText"
        android:gravity="center"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:hint="@string/edit"/>

    <LinearLayout
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:orientation="horizontal"
        android:gravity="center">
        <Button
            android:id="@+id/insert_button"
            android:layout_width="wrap_content"
            android:layout_height="wrap_content"
            android:text="插入"/>

        <Button
            android:id="@+id/quert_button"
            android:layout_width="wrap_content"
            android:layout_height="wrap_content"
            android:text="查询"/>

    </LinearLayout>


</LinearLayout>

二 MyHelper.java

package com.test.database;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;


public class MyHelper extends SQLiteOpenHelper {
    public MyHelper(Context context) {
        super(context,"Text.db",null,1);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        db.execSQL("create table if not exists MySQL("
                + "id integer primary key,"
                + "text varchar not null)");
    }

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

    }
}

三 main_activity.java

package com.test.database;

import android.content.ContentValues;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.util.Log;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.TextView;

public class MainActivity extends AppCompatActivity implements View.OnClickListener {

    TextView textView;
    EditText editText;
    Button query_button;
    Button insert_button;

    MyHelper myHelper;
    SQLiteDatabase db;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);

        initView();

        myHelper=new MyHelper(MainActivity.this);

    }

    private void initView() {
        textView= (TextView) findViewById(R.id.textView);
        editText= (EditText) findViewById(R.id.editText);
        query_button= (Button) findViewById(R.id.quert_button);
        insert_button= (Button) findViewById(R.id.insert_button);

        query_button.setOnClickListener(this);
        insert_button.setOnClickListener(this);
    }

    @Override
    public void onClick(View v) {
        int id=v.getId();
        switch (id){
            case R.id.quert_button:
                db=myHelper.getReadableDatabase();
                Cursor cursor=db.query("MySQL",null,null,null,null,null,null);
                int textindex=cursor.getColumnIndex("text");
                String display_text="";
                Log.d("MainActivity","cursor:"+cursor.getCount());
                if (cursor.getCount()==0){
                    textView.setText(display_text);
                    return;
                }
                for (cursor.moveToFirst();!cursor.isAfterLast();cursor.moveToNext()){
                    display_text=display_text+cursor.getString(textindex)+"  ";
                }
                textView.setText(display_text);
                cursor.close();
                db.close();
                break;
            case R.id.insert_button:
                db=myHelper.getWritableDatabase();
                ContentValues values=new ContentValues();
                String text=editText.getText().toString();
                values.put("text",text);
                db.insert("MySQL", null, values);
                editText.setText("");
                textView.setText("已插入");
                db.close();
                break;
        }
    }
}