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}@Overridepublic 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"});}@Overridepublic 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;}}