android数据库
http://blog.csdn.net/nieweilin/article/details/5919013/#comments
这位大侠写得相当清楚明白,我就不乱贴了。我下面用的就是他的代码。
只是把Query用一个Button监听,Add一次后清空EditText。
一、建一个DBHelper类用来实现数据库的操作(建立,查询,插入,删除,更新。。)
package com.mine.databasedemo2;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
public class DBHelper extends SQLiteOpenHelper {
private static final String DB_NAME = "coll.db";
private static final String TBL_NAME = "CollTbl";
private static final String CREATE_TBL = " create table "
+ " CollTbl(_id integer primary key autoincrement,name text,url text, desc text) ";
/*android.database.sqlite.SQLiteOpenHelper.SQLiteOpenHelper(Context context, String name, CursorFactory factory, int version)
*Create a helper object to create, open, and/or manage a database
*factory to use for creating cursor objects, or null for the default
* */
private SQLiteDatabase db;
DBHelper(Context c) {
super(c, DB_NAME, null, 2);
}
@Override
public void onCreate(SQLiteDatabase db) {
this.db = db;
db.execSQL(CREATE_TBL);
}
public void insert(ContentValues values) {
SQLiteDatabase db = getWritableDatabase();
db.insert(TBL_NAME, null, values);
db.close();
}
public Cursor query() {
SQLiteDatabase db = getWritableDatabase();
Cursor c = db.query(TBL_NAME, null, null, null, null, null, null);
return c;
}
public void del(int id) {
if (db == null)
db = getWritableDatabase();
db.delete(TBL_NAME, "_id=?", new String[] { String.valueOf(id) });
}
@Override
public void close() {
if (db != null)
db.close();
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
}
}
二、AddActivity(主Activity)里面三个EditText,两个Button。Xml很简单。点BtnAdd将EditText内容添加到数据库。BtnQuery查询所有数据(这里要用到ListView,见本文后半段),在一个新的Activity中展示,注意在Manifest文件中添加此Activity标签。
主ActivityJava代码
package com.mine.databasedemo2;
import android.app.Activity;
import android.content.ContentValues;
import android.content.Intent;
import android.os.Bundle;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.EditText;
public class AddActivity extends Activity {
private EditText et1, et2, et3;
private Button b1,b2;
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.add);
this.setTitle("添加收藏信息");
et1 = (EditText) findViewById(R.id.editTextName);
et2 = (EditText) findViewById(R.id.editTextUrl);
et3 = (EditText) findViewById(R.id.editTextDesc);
b1 = (Button) findViewById(R.id.buttonAdd);
b2=(Button) findViewById(R.id.buttonQuery);
b1.setOnClickListener(new OnClickListener() {
@Override
public void onClick(View v) {
String name = et1.getText().toString();
String url = et2.getText().toString();
String desc = et3.getText().toString();
ContentValues values = new ContentValues();
values.put("name", name);
values.put("url", url);
values.put("desc", desc);
DBHelper helper = new DBHelper(getApplicationContext());
//思考中,怎么实现当输入值不正确时不执行insert方法?
helper.insert(values);
et1.setText("");
et2.setText("");
et3.setText("");
}
});
b2.setOnClickListener(new OnClickListener() {
@Override
public void onClick(View v) {
// TODO Auto-generated method stub
Intent intent = new Intent(AddActivity.this,
QueryActivity.class);
startActivity(intent);
}
});
}
}
查询的Activity的Java代码
package com.mine.databasedemo2;
import android.app.AlertDialog;
import android.app.ListActivity;
import android.content.DialogInterface;
import android.database.Cursor;
import android.os.Bundle;
import android.view.View;
import android.widget.AdapterView;
import android.widget.AdapterView.OnItemClickListener;
import android.widget.ListView;
import android.widget.SimpleCursorAdapter;
public class QueryActivity extends ListActivity {
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
this.setTitle("浏览收藏信息");
//注意此处不需要setContentView(INt id);
final DBHelper helpter = new DBHelper(this);
final int flag=1;
Cursor c = helpter.query();
String[] from = { "_id", "name", "url", "desc" };
int[] to = { R.id.text0, R.id.text1, R.id.text2, R.id.text3 };
SimpleCursorAdapter adapter = new SimpleCursorAdapter(this,
R.layout.row, c, from, to,flag);
ListView listView = getListView();
listView.setAdapter(adapter);
final AlertDialog.Builder builder = new AlertDialog.Builder(this);
listView.setOnItemClickListener(new OnItemClickListener() {
@Override
//ListView的Item的点击事件
public void onItemClick(AdapterView<?> arg0, View arg1, int arg2,
long arg3) {
final long temp = arg3;
builder.setMessage("真的要删除该记录吗?").setPositiveButton("是",
new DialogInterface.OnClickListener() {
@Override
public void onClick(DialogInterface dialog,
int which) {
helpter.del((int)temp);
Cursor c = helpter.query();
String[] from = { "_id", "name", "url", "desc" };
int[] to = { R.id.text0, R.id.text1, R.id.text2, R.id.text3 };
SimpleCursorAdapter adapter = new SimpleCursorAdapter(getApplicationContext(),
R.layout.row, c, from, to,flag);
ListView listView = getListView();
listView.setAdapter(adapter);
}
}).setNegativeButton("否",
new DialogInterface.OnClickListener() {
@Override
public void onClick(DialogInterface dialog,
int which) {
}
});
AlertDialog ad = builder.create();
ad.show();
}
});
helpter.close();
}
}
下面这里是ListView的Xml文件。其实这个文件相当于ListView的一个Item的布局。要实现在其他布局中加入Listview,可以用一个include标签把这个布局加入,当然也可以加一个ListView标签即可。
<?xml version="1.0" encoding="utf-8"?>
<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"
android:layout_width="match_parent"
android:layout_height="wrap_content" >
<TextView
android:id="@+id/text0"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_alignParentLeft="true"
android:layout_alignParentTop="true"
android:text="TextView"
android:textSize="24sp" />
<TextView
android:id="@+id/text1"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_alignParentLeft="true"
android:layout_below="@id/text0"
android:text="TextView"
android:textSize="24sp" />
<TextView
android:id="@+id/text2"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_alignParentLeft="true"
android:layout_below="@id/text1"
android:text="TextView"
android:textSize="24sp" />
<TextView
android:id="@+id/text3"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_alignParentLeft="true"
android:layout_below="@id/text2"
android:text="TextView"
android:textSize="24sp"/>
<CheckBox
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_alignParentRight="true"
android:layout_centerVertical="true"
android:focusable="false" />
</RelativeLayout>
这个布局是没有问题的,四行textView一个CheckBox,然而问题在于:
1)当对ListView的Item删除时,剩余的变成灰色,只是重新加载了一遍布局,不应该啊!(一脸黑线啊!)
2)不删除的情况下,发现选中一个CheckBox的时候,往下拉会有其他的被选中!(这里有一个小问题,就是CheckBox中这一句android:focusable=”false”,如果不加就会无法实现对Item的删除,这是因为CheckBox的点击事件优先级高。)
后一个我在篇文章中找到了解答。
http://www.apkbus.com/android-19271-1-1.html
文章比较长,很详细。
*第一条还不知道怎么解决。
求哪位大侠指点迷津*