Android 使用SQLite

1、添加SQLite 帮助类

public class MyHelper extends SQLiteOpenHelper {
    private static String DB_NAME = "mydata.db";
    public static String TABLE_NAME = "testresulr";
    public static String MySetting = "mydata";

    public MyHelper(Context context) {
        super(context, DB_NAME, (CursorFactory)null, 2);
    }

    public void onCreate(SQLiteDatabase db) {
        String sql = "CREATE TABLE " + TABLE_NAME + "(" + "_id INTEGER PRIMARY KEY," + "bc TEXT,"+ "lR TEXT,"+ "rR TEXT,"+ "tTime TEXT,"+ "St TEXT" + ");";
           db.execSQL(sql);
        sql = "CREATE TABLE " + MySetting + "(" + "_id INTEGER PRIMARY KEY," + "Ip TEXT,"+ "Db TEXT,"+ "Un TEXT,"+ "Pw TEXT,"+ "Port TEXT" + ");";
        db.execSQL(sql);
    }

2、创建实体类

public class TestResult {
    private int id;
    private String bc;
    private String lR;
    private String rR;
    private String tTime;
    private String St;
    public TestResult() {
    }

    public TestResult(String bc, String lR,String rR,String St){
        SimpleDateFormat sDateFormat= new    SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
       this.tTime  =    sDateFormat.format(new    java.util.Date());
        this.bc=bc;
        this.lR=lR;
        this.rR=rR;
        this.St=St;
    }

    public String GetBc()
    {
        return  this.bc;
    }
    public void  Setbc(String bc) {
        this.bc= bc;
    }
    public String GetlR()
    {
        return  this.lR;
    }
    public void  SetlR(String lR) {
        this.lR = lR;
    }
    public String GetrR()
    {
        return  this.rR;
    }
    public void  SetrR(String rR) {
        this.rR= rR;
    }
    public String GettTime()
    {
        return  this.tTime;
    }
    public void  SettTime(String tTime) {
        this.tTime = tTime;
    }

    public String GetSt()
    {
        return  this.St;
    }
    public void  SetSt(String St) {
        this.St= St;
    }

}

3、创建SQLite 服务类

public class DatabaseUtil {
    private MyHelper helper;

    public DatabaseUtil(Context context) {
        this.helper = new MyHelper(context);
    }
    public boolean Insert(TestResult person) {
        SQLiteDatabase db = this.helper.getWritableDatabase();
        String sql = "insert into " + MyHelper.TABLE_NAME + "(bc,lr,rr,tTime,st) values (" + "\'" + person.GetBc() + "\' ," + "\'" + person.Getlr() + "\',"
                + "\'" + person.GetrR() + "\',"  + "\'" + person.GettTime() + "\'," + "\'" + person.GetSt() + "\'"+ ")";

        try {
            db.execSQL(sql);
            return true;
        } catch (SQLException var8) {
            Log.e("err", "insert failed");
        } finally {
            db.close();
        }

        return false;
    }

    public void Update(TestResult person, int id) {
        SQLiteDatabase db = this.helper.getWritableDatabase();
        ContentValues values = new ContentValues();
        values.put("lResult", person.GetlR());
        values.put("rResult", person.GetrR());
        db.update(MyHelper.TABLE_NAME, values, "_id=?", new String[]{String.valueOf(id)});
        db.close();
    }

    public void Delete(String barcode,String selecttype) {
        SQLiteDatabase db = this.helper.getWritableDatabase();
        db.delete(MyHelper.TABLE_NAME, "barCode=? and SelectType=?", new String[]{String.valueOf(barcode),selecttype});
        db.close();
    }

    public List<TestResult> queryAll() {
        SQLiteDatabase db = this.helper.getReadableDatabase();
        ArrayList list = new ArrayList();
        Cursor cursor = db.query(MyHelper.TABLE_NAME, (String[])null, (String)null, (String[])null, (String)null, (String)null, (String)null);

        while(cursor.moveToNext()) {
            TestResult person = new TestResult();
            person.SetlR(cursor.getString(cursor.getColumnIndex("lR")));
            person.SetrR(cursor.getString(cursor.getColumnIndex("rR")));
            person.SetBc(cursor.getString(cursor.getColumnIndex("bc")));
            person.SettTime(cursor.getString(cursor.getColumnIndex("tTime")));
            person.SetSt(cursor.getString(cursor.getColumnIndex("St")));
            list.add(person);
        }

        db.close();
        return list;
    }

}