Sqlite

package com.example.z_zk3Sql;

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

public class MySqlHelper extends SQLiteOpenHelper{

	public MySqlHelper(Context context, String name, CursorFactory factory,
			int version) {
		super(context, name, factory, version);
		// TODO Auto-generated constructor stub
	}
	
	public MySqlHelper(Context context) {
		super(context, "zklx3.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,pwd text)");
		db.execSQL("insert into user (name,pwd) values(?,?)",new String[]{"张三","123123"});
		db.execSQL("insert into user (name,pwd) values(?,?)",new String[]{"李四","123122"});
		
	}

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

}

package com.example.z_zk3Sql;

import java.util.ArrayList;
import java.util.List;

import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;

public class SqlDao {

	private MySqlHelper openHelper;
	List<User> list=new ArrayList<User>();

	public SqlDao(Context c) {
		openHelper = new MySqlHelper(c);
	}
	
	//添加
	public void insert(String name,String pwd){
		//获取可写的数据库
		SQLiteDatabase db = openHelper.getWritableDatabase();
		ContentValues values = new ContentValues();
		values.put("name", name);
		values.put("pwd", pwd);
		//添加
		db.insert("user", null, values);
		db.close();
	
	}
	
	//添加
	public void delete(String name){
		//获取可写的数据库
		SQLiteDatabase db = openHelper.getWritableDatabase();
		db.delete("user","name=?", new String[]{name});
		db.close();
	}
	
	//添加
		public void updata(ContentValues values, String name){
			//获取可写的数据库
			SQLiteDatabase db = openHelper.getWritableDatabase();
			db.update("user", values, "name=?", new String[]{name});
			db.close();
		}
	
	
	//查询
	public List<User> select(){

		//获取可写的数据库
		SQLiteDatabase db = openHelper.getReadableDatabase();
		
		Cursor cursor = db.query("user", null, null, null, null, null, null);
		
		list.clear();
		
		while(cursor.moveToNext()){
			String name = cursor.getString(cursor.getColumnIndex("name"));
			String pwd = cursor.getString(cursor.getColumnIndex("pwd"));
			User user = new User(name, pwd);
			list.add(user);
		}
		
		
		db.close();
		return list;
	}
}