sqlife

<?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="com.example.yz.sqlife.MainActivity">


    <EditText
        android:id="@+id/et_input"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:textSize="25sp" />

    <LinearLayout
        android:orientation="horizontal"
        android:layout_width="match_parent"
        android:layout_height="wrap_content">

        <Button
            android:id="@+id/bt_add"
            android:textSize="20sp"
            android:layout_width="0dp"
            android:layout_weight="1"
            android:onClick="onClick"
            android:layout_height="wrap_content"
            android:text="增加一条新纪录"/>

        <Button
            android:id="@+id/bt_delete"
            android:textSize="20sp"
            android:layout_width="0dp"
            android:layout_weight="1"
            android:onClick="onClick"
            android:layout_height="wrap_content"
            android:text="删除第一条纪录"/>
    </LinearLayout>

    <ListView
        android:id="@+id/lv_data"
        android:layout_width="match_parent"
        android:layout_height="wrap_content">

    </ListView>
</LinearLayout>

<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
    android:orientation="vertical"
    android:layout_width="match_parent"
    android:layout_height="match_parent">
    <TextView
        android:id="@+id/tv_name"
        android:textSize="20sp"
        android:layout_width="match_parent"
        android:layout_height="wrap_content" />

</LinearLayout>

package com.example.yz.sqlife;

import android.database.Cursor;
import android.net.Uri;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.view.View;
import android.widget.EditText;
import android.widget.ListView;
import android.widget.Toast;

public class MainActivity extends AppCompatActivity {

    private EditText et_input;
    private ListView lv_data;
    private MyCursorAdapter myCursorAdapter;
    private PersonDAO personDAO;
    private Cursor cursor;


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

        et_input = (EditText) findViewById(R.id.et_input);

        lv_data = (ListView) findViewById(R.id.lv_data);
        personDAO = new PersonDAO(this);
        cursor = personDAO.selectAll();
        if (cursor != null) {
            myCursorAdapter = new MyCursorAdapter(MainActivity.this, cursor);
            lv_data.setAdapter(myCursorAdapter);
        }

    }

    public void onClick(View view) {
        switch (view.getId()) {
            case R.id.bt_add:
                String name = et_input.getText().toString();
                personDAO.insert(name);
                cursor = personDAO.selectAll();
                if (cursor != null) {
                    myCursorAdapter = new MyCursorAdapter(this, cursor);
                    lv_data.setAdapter(myCursorAdapter);
                }
                break;
            case R.id.bt_delete:
                if (cursor != null) {
                    if (cursor.moveToFirst()) {
                        personDAO.delete(cursor.getString(cursor.getColumnIndex("_id")));
                        cursor = personDAO.selectAll();
                    }
                }
                myCursorAdapter = new MyCursorAdapter(this, cursor);
                lv_data.setAdapter(myCursorAdapter);
                break;
        }

    }

package com.example.yz.sqlife;

import android.content.Context;
import android.database.Cursor;
import android.view.LayoutInflater;
import android.view.View;
import android.view.ViewGroup;
import android.widget.CursorAdapter;
import android.widget.TextView;

/**
 *
 * Created by yz on 2017/5/16.
 */

public class MyCursorAdapter  extends CursorAdapter{

    public MyCursorAdapter(Context context, Cursor cursor) {
        super(context, cursor, 0);
    }

    @Override
    public View newView(Context context, Cursor cursor, ViewGroup viewGroup) {
        return LayoutInflater.from(context).inflate(R.layout.item,viewGroup,false);
    }

    @Override
    public void bindView(View view, Context context, Cursor cursor) {
        TextView name = (TextView) view.findViewById(R.id.tv_name);
        name.setText(cursor.getString(cursor.getColumnIndex("name")));
    }
}

package com.example.yz.sqlife;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;


/**
 * Created by yz on 2017/5/16.
 */

public class MyDBHelper extends SQLiteOpenHelper {
    String sql = "create table person(id integer primary key autoincrement,name txt)";

    public MyDBHelper(Context context) {
        super(context,"personInfo",null,1);
    }

    @Override
    public void onCreate(SQLiteDatabase sqLiteDatabase) {
        sqLiteDatabase.execSQL(sql);
    }

    @Override
    public void onUpgrade(SQLiteDatabase sqLiteDatabase, int i, int i1) {
        sqLiteDatabase.execSQL("drop table if exists person");
        onCreate(sqLiteDatabase);
    }
}

package com.example.yz.sqlife;

import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.widget.Toast;



public class PersonDAO {

    private MyDBHelper dbHelper;
    private SQLiteDatabase sqLiteDatabase;

    public PersonDAO(Context context){
        dbHelper = new MyDBHelper(context);
    }

    public void insert(String name){
        sqLiteDatabase = dbHelper.getWritableDatabase();
        String sql = "insert into person(name) values('"+name+"')";
        sqLiteDatabase.execSQL(sql);
    }

    public Cursor selectAll() {
        sqLiteDatabase = dbHelper.getReadableDatabase();
        Cursor cursor = sqLiteDatabase.query("person", null, null, null, null, null, null);
        return cursor;
    }

    public void delete(String id){
        sqLiteDatabase = dbHelper.getWritableDatabase();
        String sql = "delete from person where _id="+String.valueOf(id);//"delete from student where _id="+id
        sqLiteDatabase.execSQL(sql);
    }
}

package com.example.yz.sqlife;

import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.widget.Toast;



public class PersonDAO {

    private MyDBHelper dbHelper;
    private SQLiteDatabase sqLiteDatabase;

    public PersonDAO(Context context){
        dbHelper = new MyDBHelper(context);
    }

    public void insert(String name){
        sqLiteDatabase = dbHelper.getWritableDatabase();
        String sql = "insert into person(name) values('"+name+"')";
        sqLiteDatabase.execSQL(sql);
    }

    public Cursor selectAll() {
        sqLiteDatabase = dbHelper.getReadableDatabase();
        Cursor cursor = sqLiteDatabase.query("person", null, null, null, null, null, null);
        return cursor;
    }

    public void delete(String id){
        sqLiteDatabase = dbHelper.getWritableDatabase();
        String sql = "delete from person where _id="+String.valueOf(id);//"delete from student where _id="+id
        sqLiteDatabase.execSQL(sql);
    }
}

package com.example.yz.sqlife;

import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.widget.Toast;



public class PersonDAO {

    private MyDBHelper dbHelper;
    private SQLiteDatabase sqLiteDatabase;

    public PersonDAO(Context context){
        dbHelper = new MyDBHelper(context);
    }

    public void insert(String name){
        sqLiteDatabase = dbHelper.getWritableDatabase();
        String sql = "insert into person(name) values('"+name+"')";
        sqLiteDatabase.execSQL(sql);
    }

    public Cursor selectAll() {
        sqLiteDatabase = dbHelper.getReadableDatabase();
        Cursor cursor = sqLiteDatabase.query("person", null, null, null, null, null, null);
        return cursor;
    }

    public void delete(String id){
        sqLiteDatabase = dbHelper.getWritableDatabase();
        String sql = "delete from person where _id="+String.valueOf(id);//"delete from student where _id="+id
        sqLiteDatabase.execSQL(sql);
    }
}

package com.example.yz.sqlife;

import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.widget.Toast;



public class PersonDAO {

    private MyDBHelper dbHelper;
    private SQLiteDatabase sqLiteDatabase;

    public PersonDAO(Context context){
        dbHelper = new MyDBHelper(context);
    }

    public void insert(String name){
        sqLiteDatabase = dbHelper.getWritableDatabase();
        String sql = "insert into person(name) values('"+name+"')";
        sqLiteDatabase.execSQL(sql);
    }

    public Cursor selectAll() {
        sqLiteDatabase = dbHelper.getReadableDatabase();
        Cursor cursor = sqLiteDatabase.query("person", null, null, null, null, null, null);
        return cursor;
    }

    public void delete(String id){
        sqLiteDatabase = dbHelper.getWritableDatabase();
        String sql = "delete from person where _id="+String.valueOf(id);//"delete from student where _id="+id
        sqLiteDatabase.execSQL(sql);
    }
}

package com.example.yz.sqlife;

import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.widget.Toast;



public class PersonDAO {

    private MyDBHelper dbHelper;
    private SQLiteDatabase sqLiteDatabase;

    public PersonDAO(Context context){
        dbHelper = new MyDBHelper(context);
    }

    public void insert(String name){
        sqLiteDatabase = dbHelper.getWritableDatabase();
        String sql = "insert into person(name) values('"+name+"')";
        sqLiteDatabase.execSQL(sql);
    }

    public Cursor selectAll() {
        sqLiteDatabase = dbHelper.getReadableDatabase();
        Cursor cursor = sqLiteDatabase.query("person", null, null, null, null, null, null);
        return cursor;
    }

    public void delete(String id){
        sqLiteDatabase = dbHelper.getWritableDatabase();
        String sql = "delete from person where _id="+String.valueOf(id);//"delete from student where _id="+id
        sqLiteDatabase.execSQL(sql);
    }
}

 

转载于:https://www.cnblogs.com/CCyz/p/6864077.html