آموزش : کار با دیتابیس 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;

        

    }

}

[rainbow17]

اینم کد های main activity:

import android.os.Bundle;

import android.view.LayoutInflater;

import android.view.View;

import android.view.ViewGroup;

import android.widget.ArrayAdapter;

import android.widget.ImageView;

import android.widget.ListView;

import android.widget.TextView;

import android.widget.Toast;

import android.app.Activity;

import android.app.ListActivity;

import android.content.Context;

import android.content.Intent;

import android.content.res.Configuration;





public class MainActivity extends ListActivity {





    private DatabaseHandler db;

    private ListView listview;

    private String[] mainlist;

    private ArrayAdapter<String> adabter;

    





    @Override

    protected void onCreate(Bundle savedInstanceState) {

        super.onCreate(savedInstanceState);

        setContentView(R.layout.activity_main);





        db = new DatabaseHandler(this);

        db.getReadableDatabase();

        db.useable();

        refresher();

        setListadapter(new AA());





    }





    private void setListadapter(AA aa) {

                

    }





    





    

    

    

    class AA extends ArrayAdapter<String> {

        public AA() {





            super(MainActivity.this,R.layout.item_item_main,ma  inlist);





        }





        @Override

        public View getView(int position, View convertView, ViewGroup parent) {





            LayoutInflater bazkonande = getLayoutInflater();

            View radif = bazkonande.inflate(R.layout.item_item_main, parent,

                    false);





            TextView name = (TextView) radif.findViewById(R.id.tv_nameMaine);

            ImageView ax = (ImageView) radif.findViewById(R.id.img_axMaine);





            //if (isTablet(getApplicationContext())) {





            //}





            name.setText(mainlist[position]);

            





            db.open();

            String[] axhaName = db.GetListMain(db.PICTURE);

            db.close();





            int[] cod = new int[axhaName.length];

            for (int i = 0; i < axhaName.length; i++) {





                cod[i] = Integer.parseInt("R.drawable." + axhaName[i]);

            }





            ax.setImageResource(cod[position]);





            return radif;

        }

    }





    

    private void refresher(){

        db.open();

        int save = db.shomaresh_field("tbl", "name");

        mainlist = new String[save];

        

        for (int i = 0; i <save; i++) {

            mainlist[i] = db.namayesh_field("tbl", i);

        }

        db.close();

    }