数据库

package com.example.db;

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

/**
 * Created by Administrator on 2016/6/17.
 */
public class MySqliteOpenHelper extends SQLiteOpenHelper{
    public MySqliteOpenHelper(Context context) {
        super(context, "shopcut_db", null, 1);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        db.execSQL("create table cars(_id integer primary key autoincrement,gid integer,uid integer,gt_name varchar(30),gt_time varchar(30))");
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

    }
}






package com.example.dao;

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

import com.example.db.MySqliteOpenHelper;
import com.example.vo.KC_Info;
import com.example.vo.Shop_Cars;

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

/**
 * Created by Administrator on 2016/6/17.
 */
public class Cars_Dao {

    private final MySqliteOpenHelper helper;

    public Cars_Dao(Context context) {
        helper = new MySqliteOpenHelper(context);
    }
    public void add(int gid,int uid,String gt_name,String gt_time){
        SQLiteDatabase db = helper.getWritableDatabase();
        ContentValues values = new ContentValues();
        values.put("gid",gid);
        values.put("uid",uid);
        values.put("gt_name",gt_name);
        values.put("gt_time",gt_time);
        db.insert("cars",null,values);
    }
    public void delete(int gid){
        SQLiteDatabase db = helper.getWritableDatabase();
        db.execSQL("delete from cars where gid = ?",new String[]{""+gid});
        db.close();
    }
    public void update(){

    }
    public List<Shop_Cars> query(){
        SQLiteDatabase db = helper.getWritableDatabase();
        List<Shop_Cars> list = new ArrayList<Shop_Cars>();
        list.clear();
        Cursor cursor = db.query("cars", null, null, null, null, null, null);

        while (cursor.moveToNext()){
            int gid = cursor.getInt(cursor.getColumnIndex("gid"));
            int uid = cursor.getInt(cursor.getColumnIndex("uid"));
            String gt_name = cursor.getString(cursor.getColumnIndex("gt_name"));
            String gt_time = cursor.getString(cursor.getColumnIndex("gt_time"));

            list.add(new Shop_Cars(gid,uid,gt_name,gt_time));
            db.close();
        }
        return list;
    }
}