package nico.styTool.plus;


import android.app.Activity;
import android.database.Cursor;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteException;

import java.util.ArrayList;
import java.util.HashMap;


public class Bookmark
{
    private final String DBNAME="MyBookmarkDB";
    private final String TABLE_NAME="mybookmark";

    private SQLiteDatabase m_db=null;
    private ArrayList<HashMap<String,String>> m_list=null;

    public void initDB(Activity activity)
    {
	this.openMyBookmark(activity);
	try
	{
	    m_db.execSQL("CREATE TABLE mybookmark(Title TEXT,Url TEXT)");
	}
	catch (SQLException  e)
	{
	    //Log.e("BOOKMARK", e.getMessage());
	}
	this.closeMyBookmark();

	m_list = new ArrayList<HashMap<String,String>>();
    }

    public void insert(final String Title, final String Url)
    {
	String sql="INSERT INTO " + TABLE_NAME + " values (\"" + Title + "\",\"" + Url + "\")";
	try
	{
	    m_db.execSQL(sql);
	}
	catch (SQLException  e)
	{
	    //Log.e("BOOKMARK", e.getMessage());
	}
    }

    public ArrayList<HashMap<String,String>> getList()
    {
	m_list.clear();
	Cursor cur = m_db.rawQuery("select * from " + TABLE_NAME, null);
	if (cur != null)
	{
	    if (cur.moveToFirst())
	    {
		do
		{
		    HashMap<String,String> map=new HashMap<String,String>();
		    map.put("Title", cur.getString(0));
		    map.put("Url", cur.getString(1));
		    m_list.add(map);

		}while(cur.moveToNext());
	    }
	}
	return m_list;
    }

    public void openMyBookmark(Activity activity)
    {
	try
	{
	    m_db = activity.openOrCreateDatabase(DBNAME, 0, null);
	}
	catch (SQLiteException e)
	{
	    m_db = null;
	}
    }

    public void closeMyBookmark()
    {
	m_db.close();
    }

}