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