آموزش : کار با دیتابیس SQLite به زبان ساده بدون نیاز به کلاس DataBaseHelper

[rainbow17]

کد های دیتابیسم...

import java.io.FileOutputStream;

import java.io.IOException;

import java.io.InputStream;

import java.io.OutputStream;





import android.content.Context;

import android.database.Cursor;

import android.database.SQLException;

import android.database.sqlite.SQLiteDatabase;

import android.database.sqlite.SQLiteOpenHelper;





public class DatabaseHandler extends SQLiteOpenHelper {





    public final String path = "data/data/com.kheirimohammad.full_heart/databases/";

    private static final String DATABASE_NAME = "full_h";

    public SQLiteDatabase mydb;

    private final Context mycontext;





    // //////table field////////

    public final String TABLE ="tbl";

    public final String ID = "id";

    public final String NAME = "name";

    public final String SUB = "sub";

    public final String FATHER = "father";

    public final String FATHERNAME = "fathername";

    public final String NAMEHTML = "namehtml";

    public final String PICTURE = "picture";

    public final String FAV = "fav";





    

    public DatabaseHandler(Context context) {

        super(context, "full_h", null, 1);

        mycontext = context;

    }





    @Override

    public void onCreate(SQLiteDatabase arg0) {





    }





    @Override

    public void onUpgrade(SQLiteDatabase arg0, int arg1, int arg2) {





    }





    public void useable() {

        boolean checkdb = checkdb();

        if (checkdb) {





        } else {

            this.getReadableDatabase();

            try {

                copydatabase();

            } catch (IOException e) {





            }

        }

    }





    public void open() throws SQLException {

        mydb = SQLiteDatabase.openDatabase(path + DATABASE_NAME, null,

                SQLiteDatabase.OPEN_READONLY);

    }





    @Override

    public void close() {

        mydb.close();

    }





    public boolean checkdb() {

        SQLiteDatabase db = null;

        try {

            db = SQLiteDatabase.openDatabase(path + DATABASE_NAME, null,

                    SQLiteDatabase.OPEN_READONLY);

        } catch (SQLException e) {





        }

        return db != null ? true : false;

    }





    public void copydatabase() throws IOException {





        OutputStream myOutput = new FileOutputStream(path + DATABASE_NAME);

        byte[] buffer = new byte[1024];

        int lenght;

        InputStream myInput = mycontext.getAssets().open(DATABASE_NAME);

        while ((lenght = myInput.read(buffer)) > 0) {

            myOutput.write(buffer, 0, lenght);

        }

        myInput.close();

        myOutput.flush();

        myOutput.close();

    }





////





    public String[] GetListMain(String field) {





        Cursor c = mydb.rawQuery("select * from " + TABLE + " where " + FATHER + " = '0' ORDER BY " + ID , null);





        String[] list = new String[c.getCount()];





        if (c.moveToFirst()) {

            for (int i = 0; i < c.getCount(); i++) {

                c.moveToPosition(i);

                list[i] = c.getString(c.getColumnIndex(field)).toString();

            }

        }

        

        

        return list;

    }

    

    public Integer shomaresh_field(String table,String field){

        Cursor Cursor = mydb.rawQuery("SELECT * FROM "+TABLE+" group by "+field, null);

        int i = Cursor.getCount();

        return i ;

    }

    

    public String namayesh_field (String table , int row){

        Cursor Cursor = mydb.rawQuery("SELECT * FROM "+TABLE+" group by name",null);

        Cursor.moveToPosition(row);

        String save = Cursor.getString(1);

        return save;

        

    }

    

    public Integer shomaresh_dastan (String table , String name){

        Cursor Cursor = mydb.rawQuery("SELECT * FROM "+TABLE+" where season='"+name+"' group by name", null);

        int s = Cursor.getCount();

        return s;

        

    }

}