package com.electric.chargingpile.util;

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

/**
 * Created by Demon on 16/7/8.
 */

public class DBOpenHand extends SQLiteOpenHelper {
    private static final int DB_VERSION = 15;

    public static final String TABLE_NAME_POIINFO = "poiinfo";

    public DBOpenHand(Context paramContext, String paramString) {
        super(paramContext, "poihistory.db", null, DB_VERSION);
    }

    // 数据库名称
    // 表名
    // 创建SQL语句
    private static final String CREATE_TBL = "CREATE TABLE IF NOT EXISTS poiinfo(_id INTEGER primary key autoincrement, time VARCHAR(50),type VARCHAR(500), keyword VARCHAR(500),keyword2 VARCHAR(500),jing VARCHAR(500),wei VARCHAR(500))";
    // SQLiteDatabase实例
    private SQLiteDatabase db;

    // 创建表
    @Override
    public void onCreate(SQLiteDatabase db) {
        // TODO Auto-generated method stub
        this.db = db;
        db.execSQL(CREATE_TBL);
    }

    // 插入方法
    public void insert(ContentValues values) {
        // 获得SQLiteDataBase实例
        SQLiteDatabase db = getWritableDatabase();
        // 插入
        db.insert(TABLE_NAME_POIINFO, null, values);
        db.close();
    }

    // 查询方法
    public Cursor query() {
        // 获取SQLiteDatabase实例
        SQLiteDatabase db = getWritableDatabase();
        // 查询获得Cursor

        Cursor c = db.query(TABLE_NAME_POIINFO, null, null, null, null, null, "_id desc limit 10");
        return c;
    }

    // 查询方法单个
    public Cursor queryOne(String keyword) {
        // 获取SQLiteDatabase实例
        SQLiteDatabase db = getWritableDatabase();
        // 查询获得Cursor
//		Cursor c = db.query(TABLE_NAME_HISTORYINFO, null, null, null, null, null, null);
        Cursor c = db.rawQuery("select * from poiinfo where keyword=?", new String[]{keyword});
        if (c.getCount() > 0) {
            db.delete("poiinfo", " keyword=?", new String[]{keyword});
        }
        return c;
    }

    // 删除方法
    public void del(String keyword) {
        if (db == null)
            // 获取SQLiteDatabase
            db = getWritableDatabase();
        db.delete(TABLE_NAME_POIINFO, "keyword=?", new String[]{keyword});

    }

    // 关闭数据库
    public void close() {
        if (db != null) {
            db.close();
        }
    }

    public void delTable() {
        if (db == null)
            // 获取SQLiteDatabase
            db = getWritableDatabase();
        db.execSQL("drop table poiinfo");
        db.execSQL(CREATE_TBL);

    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int arg1, int arg2) {

    }

}