jeudi 23 juillet 2015

Passing database to another activity via intent

I am attempting to pass the contents of a database that I have created to another activity via intent using an AsyncTask where the contents of the database will be displayed. A query would be used to specify the data to be displayed using my query button. I was wondering how I could go about passing the database information to the other activity. This is what I have so far.

package com.dwolford.project9;

import android.app.Activity;
import android.content.ContentValues;
import android.content.Context;
import android.content.Intent;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.os.AsyncTask;
import android.os.Bundle;
import android.view.Menu;
import android.view.MenuItem;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.Toast;


public class Main extends Activity {

Button quit;
Button query;
Button create;
String FILENAME = "";
SQLDatabase db;//possibly use asynctask
String sQuery = "";
EditText queryText;

@Override
protected void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.activity_main);

    db = new SQLDatabase(this);//Use asynctask?



    create = (Button)findViewById(R.id.create);
    create.setOnClickListener(new View.OnClickListener() {
        @Override
        public void onClick(View v) {
            boolean isInserted = db.insertDataS("S01", "Smith", "London" );
            if(isInserted == true)
                Toast.makeText(Main.this, "Data inserted", Toast.LENGTH_LONG).show();
            else
                Toast.makeText(Main.this, "Data not inserted", Toast.LENGTH_LONG).show();

            new createTask().execute(FILENAME);
        }
    });

    queryText = (EditText)findViewById(R.id.selectQuery);

    query = (Button)findViewById(R.id.query);
    query.setOnClickListener(new View.OnClickListener() {
        @Override
        public void onClick(View v) {
            Intent intent = new Intent(Main.this,execute_query.class);
            sQuery = queryText.getText().toString();

            //intent.putExtra("database", db);
            intent.putExtra("queryChoice", sQuery);
            startActivity(intent);
        }
    });

    quit = (Button)findViewById(R.id.quit);
    quit.setOnClickListener(new View.OnClickListener() {
        @Override
        public void onClick(View v) {
            finish();
        }
    });
}

@Override
public boolean onCreateOptionsMenu(Menu menu) {
    // Inflate the menu; this adds items to the action bar if it is present.
    getMenuInflater().inflate(R.menu.menu_main, menu);
    return true;
}

@Override
public boolean onOptionsItemSelected(MenuItem item) {
    // Handle action bar item clicks here. The action bar will
    // automatically handle clicks on the Home/Up button, so long
    // as you specify a parent activity in AndroidManifest.xml.
    int id = item.getItemId();

    //noinspection SimplifiableIfStatement
    if (id == R.id.action_settings) {
        return true;
    }

    return super.onOptionsItemSelected(item);
}


public void AddData()//Add to asynctask?
{

}



public class createTask extends AsyncTask<String, Integer, String>
{
    @Override
    protected String doInBackground(String... params)
    {
        return null;
    }

}


public class SQLDatabase extends SQLiteOpenHelper{

    public static final String SPdb = "SPdb.db";
    public static final String s = "s";//First table name
    public static final String sno = "sno";
    public static final String sname = "sname";
    public static final String city = "city";
    public static final String p = "p";
    public static final String pno = "pno";
    public static final String pname = "pname";
    public static final String cost = "cost";
    public static final String sp = "sp";
    public static final String qty = "qty";


    public SQLDatabase(Context context) {
        super(context, SPdb, null, 1);

    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        db.execSQL("CREATE TABLE " + s + "(sno    TEXT     PRIMARY KEY COLLATE NOCASE,\n" +
                "   sname  TEXT     NOT NULL    COLLATE NOCASE,\n" +
                "   city   TEXT     NOT NULL    COLLATE NOCASE\n)");

        db.execSQL("CREATE TABLE " + p + "(pno    TEXT      NOT NULL COLLATE NOCASE,\n" +
                "   pname  TEXT      NOT NULL COLLATE NOCASE,\n" +
                "   cost   REAL      NOT NULL,\n" +
                "   city   TEXT      NOT NULL COLLATE NOCASE,\n" +
                "\n" +
                "   PRIMARY KEY (pno)\n)");

        db.execSQL("CREATE TABLE " + sp + "(sno     TEXT     NOT NULL REFERENCES s(sno) COLLATE NOCASE,\n" +
                "   pno     TEXT     NOT NULL COLLATE NOCASE,\n" +
                "   qty     INTEGER  NOT NULL,\n" +
                "\n" +
                "   FOREIGN KEY (pno) REFERENCES p(pno)\n)");

        //db.execSQL("create table " = );
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        db.execSQL("DROP TABLE IF EXISTS " +s);
        db.execSQL("DROP TABLE IF EXISTS " +p);
        db.execSQL("DROP TABLE IF EXISTS " +sp);
        onCreate(db);//Create table in database
    }


    public boolean insertDataS(String sno, String sname, String city)
    {
        SQLiteDatabase db = this.getWritableDatabase();//Maybe readable
        ContentValues contentValue = new ContentValues();
        contentValue.put(this.sno, sno);
        contentValue.put(this.sname, sname);
        contentValue.put(this.city, city);
        long result = db.insert(s, null, contentValue);
        if(result == -1)
        {
            return false;
        }
        else
        {
            return true;
        }

    }


    public Cursor getData()
    {
        SQLiteDatabase db = this.getWritableDatabase();
        Cursor res = db.rawQuery("select * from " + s, null);//* gets all in the query
        return res;
    }

}
}

Main xml:

<Button
    android:layout_width="wrap_content"
    android:layout_height="wrap_content"
    android:text="Create"
    android:id="@+id/create"
    android:layout_alignParentTop="true"
    android:layout_alignParentLeft="true"
    android:layout_alignParentStart="true"
    android:layout_marginTop="55dp"
    android:layout_alignParentRight="true"
    android:layout_alignParentEnd="true" />

<Button
    android:layout_width="wrap_content"
    android:layout_height="wrap_content"
    android:text="Query"
    android:id="@+id/query"
    android:layout_below="@+id/sqlQuery"
    android:layout_alignParentLeft="true"
    android:layout_alignParentStart="true"
    android:layout_marginTop="45dp"
    android:layout_alignParentRight="true"
    android:layout_alignParentEnd="true" />

<Button
    android:layout_width="wrap_content"
    android:layout_height="wrap_content"
    android:text="quit"
    android:id="@+id/quit"
    android:layout_alignParentBottom="true"
    android:layout_alignParentLeft="true"
    android:layout_alignParentStart="true"
    android:layout_alignRight="@+id/selectQuery"
    android:layout_alignEnd="@+id/selectQuery" />

<TextView
    android:layout_width="wrap_content"
    android:layout_height="wrap_content"
    android:text="sql query"
    android:id="@+id/sqlQuery"
    android:textSize="40dp"
    android:textStyle="bold"
    android:layout_below="@+id/create"
    android:layout_centerHorizontal="true"
    android:layout_marginTop="41dp" />

<EditText
    android:layout_width="wrap_content"
    android:layout_height="wrap_content"
    android:id="@+id/selectQuery"
    android:text="query"
    android:layout_below="@+id/query"
    android:layout_marginTop="56dp"
    android:layout_alignParentLeft="true"
    android:layout_alignParentStart="true"
    android:layout_alignParentRight="true"
    android:layout_alignParentEnd="true" />

Class where database information will be displayed:

package com.dwolford.project9;

import android.support.v7.app.ActionBarActivity;
import android.os.Bundle;
import android.view.Menu;
import android.view.MenuItem;
import android.view.View;
import android.widget.Button;


public class execute_query extends ActionBarActivity {

Button back;
String query = "";

@Override
protected void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.activity_execute_query);

    Bundle extras = getIntent().getExtras();
    if(extras == null)
    {
        return;
    }
    query = extras.getString("queryChoice");

    //query = getIntent().getDataString();

    back = (Button)findViewById(R.id.back);
    back.setOnClickListener(new View.OnClickListener() {
        @Override
        public void onClick(View v) {
            finish();
        }
    });
}

@Override
public boolean onCreateOptionsMenu(Menu menu) {
    // Inflate the menu; this adds items to the action bar if it is present.
    getMenuInflater().inflate(R.menu.menu_execute_query, menu);
    return true;
}

@Override
public boolean onOptionsItemSelected(MenuItem item) {
    // Handle action bar item clicks here. The action bar will
    // automatically handle clicks on the Home/Up button, so long
    // as you specify a parent activity in AndroidManifest.xml.
    int id = item.getItemId();

    //noinspection SimplifiableIfStatement
    if (id == R.id.action_settings) {
        return true;
    }

    return super.onOptionsItemSelected(item);
}
}

query xml:

<Button
    style="?android:attr/buttonStyleSmall"
    android:layout_width="wrap_content"
    android:layout_height="wrap_content"
    android:text="Back"
    android:id="@+id/back"
    android:layout_alignParentBottom="true"
    android:layout_centerHorizontal="true"
    android:height="30dp" />

<HorizontalScrollView
    android:layout_width="wrap_content"
    android:layout_height="wrap_content"
    android:id="@+id/horizontalScrollView"
    android:layout_alignParentTop="true"
    android:layout_alignParentLeft="true"
    android:layout_alignParentStart="true"
    android:layout_above="@+id/back"
    android:fillViewport="true"
    android:layout_alignParentRight="true"
    android:layout_alignParentEnd="true">

    <ListView
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:id="@+id/listView"
        android:layout_alignTop="@+id/horizontalScrollView"

        android:layout_alignParentRight="true"
        android:layout_alignParentEnd="true"
        android:layout_above="@+id/back" />
</HorizontalScrollView>

Aucun commentaire:

Enregistrer un commentaire