SQlite 使用笔记

package com.example.usingsqlite;


import android.os.Bundle;
import android.app.Activity;
import android.app.AlertDialog;
import android.app.Dialog;
import android.app.ListActivity;
import android.content.ContentValues;
import android.content.DialogInterface;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.support.v4.widget.SimpleCursorAdapter;
import android.view.Menu;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.AdapterView;
import android.widget.AdapterView.OnItemLongClickListener;
import android.widget.Button;
import android.widget.EditText;


public class MainActivity extends ListActivity{



private SimpleCursorAdapter adapter;
private EditText etName,etSex;
private Button btnAdd;
private Db db;
private SQLiteDatabase dbRead,dbWrite;

private OnClickListener btnAddListener=new OnClickListener() {

@Override
public void onClick(View v) {

ContentValues cv =new ContentValues();
cv.put("name", etName.getText().toString());
cv.put("sex", etSex.getText().toString());
dbWrite.insert("user", null, cv);
refreshListView();

}
};
private OnItemLongClickListener listViewItemLongClickListener=new OnItemLongClickListener() {


@Override
public boolean onItemLongClick(AdapterView<?> parent, View view,
final int position, long id) {

new AlertDialog.Builder(MainActivity.this).setTitle("提醒").setMessage("您确定要删除该项吗?").setNegativeButton("取消", null)
.setPositiveButton("确定", new DialogInterface.OnClickListener()
{

public void onClick(DialogInterface dialog, int which) {
Cursor c =adapter.getCursor();
c.moveToPosition(position);

int itemId =c.getInt(c.getColumnIndex("_id"));
dbWrite.delete("user", "_id=?", new String[]{itemId+""});
refreshListView();

}
}).show();


return true;
}
};

@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
etName=(EditText)findViewById(R.id.etName);
etSex=(EditText)findViewById(R.id.etSex);
btnAdd=(Button)findViewById(R.id.btnAdd);

btnAdd.setOnClickListener(btnAddListener);

//将数据库查询到的元素呈现到Adapter
Db db =new Db(this);
dbRead =db.getReadableDatabase();
dbWrite =db.getWritableDatabase();




adapter= new SimpleCursorAdapter(this, R.layout.user_list_cell, null, new String[]{"name","sex"}, new int []{R.id.tvName,R.id.tvSex});

setListAdapter(adapter);
refreshListView();



getListView().setOnItemLongClickListener(listViewItemLongClickListener);




/*Db db= new Db(this);
SQLiteDatabase dbwrite =db.getWritableDatabase();
ContentValues cv= new  ContentValues();
cv.put("name", "小张");
cv.put("sex", "男");
dbwrite.insert("user", null, cv);
dbwrite.close();


SQLiteDatabase dbRead =db.getReadableDatabase();
Cursor c = dbRead.query("user", null, null, null, null, null, null);//不指定任何条件
while(c.moveToNext()){
String name = c.getString(c.getColumnIndex("name"));
String sex = c.getString(c.getColumnIndex("sex"));
System.out.println(String.format("name=%s,sex=%s", name,sex));
}
*/



}



private void refreshListView(){
Cursor c=dbRead.query("user", null, null, null, null, null, null);
adapter.changeCursor(c);
}

}

Db.java

package com.example.usingsqlite;


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


public class Db extends SQLiteOpenHelper {


public Db(Context context) {
super(context, "db", null, 1);
// TODO Auto-generated constructor stub
}


@Override
public void onCreate(SQLiteDatabase db) {

db.execSQL("CREATE TABLE user(" + 
"_id INTEGER PRIMARY KEY AUTOINCREMENT,"+
"name TEXT DEFAULT \"\","+
"sex TEXT DEFAULT \"\")");
}


@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
// TODO Auto-generated method stub


}


}