数据库增删改查

package com.example.db;

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

import com.example.data.User;

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

public class MyManger {
    MyHepler hepler;
    
    SQLiteDatabase db;

    public MyManger(Context context) {
        super();
        
        hepler=new MyHepler(context, "User", null, 1);
        db=hepler.getWritableDatabase();
    }
    //添加
    public void Inser(List<User> list){
        
        
        try {
            db.beginTransaction();
            
            for(User u : list){
                
                ContentValues values = new ContentValues();
                values.put("uface", u.getUface());
                values.put("uid", u.getUid());
                values.put("uname", u.getUname());
                values.put("urealname", u.getUrealname());
                values.put("ustate", u.getUstate());

                db.insert("user", null, values);
            }
            db.setTransactionSuccessful();
        } catch (Exception e) {
            // TODO: handle exception
        }finally{
            db.endTransaction();
        }
    }
    //查询
    public List<User> findAll(){
        List<User> list=new ArrayList<User>();
        Cursor cursor=db.query("user", null, null, null, null, null, null);
        while (cursor.moveToNext()) {
            User user = new User();
            user.setUface(cursor.getString(cursor.getColumnIndex("uface"))) ;
            user.setUid(cursor.getString(cursor.getColumnIndex("uid")));
            user.setUname(cursor.getString(cursor.getColumnIndex("uname")));
            user.setUstate(cursor.getString(cursor.getColumnIndex("ustate")));
            user.setId(cursor.getString(cursor.getColumnIndex("id")));
            user.setUrealname(cursor.getString(cursor.getColumnIndex("urealname")));    
            list.add(user);
        }
        cursor.close();

        return list;
    }
    public User findid(String id){
        User u=null;
        Cursor cursor=db.query("user", null, "id=?", new String[]{id}, null, null, null);
        while (cursor.moveToNext()) {
            u=new User();
            u.setUface(cursor.getString(cursor.getColumnIndex("uface"))) ;
            u.setUid(cursor.getString(cursor.getColumnIndex("uid")));
            u.setUname(cursor.getString(cursor.getColumnIndex("uname")));
            u.setUstate(cursor.getString(cursor.getColumnIndex("ustate")));
            u.setId(cursor.getString(cursor.getColumnIndex("id")));
            u.setUrealname(cursor.getString(cursor.getColumnIndex("urealname")));    
        }
        
        return u;
    }
    //删除
    public void Delete(String id){
        db.delete("user", "id=?", new String[]{id});
    }
    //修改
    public void updateByid(User u){
        ContentValues values = new ContentValues();
        values.put("uface", u.getUface());
        values.put("uid", u.getUid());
        values.put("uname", u.getUname());
        values.put("urealname", u.getUrealname());
        values.put("ustate", u.getUstate());

        db.update("user", values, "id=?", new String[]{u.getId()});
    }
}