mercredi 14 octobre 2015

how to get data on blank activity from sqlite database on view button click

package com.example.trackrecord;

import android.animation.AnimatorSet;
import android.app.AlertDialog;
import android.content.Context;
import android.content.Intent;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.support.design.widget.FloatingActionButton;
import android.support.design.widget.Snackbar;
import android.support.v7.app.AppCompatActivity;
import android.support.v7.widget.Toolbar;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;

public class Admin extends AppCompatActivity implements View.OnClickListener {

    EditText editPartName,editPartCategory;
    Button btnAdd,btnView;

    //SQLiteDatabase dbTrecord;
    SQLiteDatabase dbTrecRec;
    @Override
    protected void onCreate(Bundle savedInstanceState)
    {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_admin);

       // editPartID=(EditText) findViewById(R.id.editPartId);
        editPartName=(EditText)findViewById(R.id.editPartName);
        editPartCategory=(EditText)findViewById(R.id.editCategoryt);
        btnAdd=(Button)findViewById(R.id.btnAdd);
        btnView=(Button)findViewById(R.id.btnView);

        btnAdd.setOnClickListener(this);
        btnView.setOnClickListener(new View.OnClickListener(){
            public void onClick(View v){
                Intent i = new Intent(Admin.this,Display.class);
                startActivity(i);

            }
        });

        dbTrecRec=openOrCreateDatabase("TracDBTRECREC", Context.MODE_PRIVATE,null);
        dbTrecRec.execSQL("CREATE TABLE IF NOT EXISTS tRec(_id INTEGER PRIMARY KEY AUTOINCREMENT , parts_name VARCHAR NOT NULL, category VARCHAR);");


        Toolbar toolbar = (Toolbar) findViewById(R.id.toolbar);
        setSupportActionBar(toolbar);

        FloatingActionButton fab = (FloatingActionButton) findViewById(R.id.fab);
        fab.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View view) {
                Snackbar.make(view, "Replace with your own action", Snackbar.LENGTH_LONG)
                         .setAction("Action", null).show();
            }
        });
    }

    @Override
    public void onClick(View v)
    {
        if(v==btnAdd) {
            if(editPartName.getText().toString().trim().length()==0||
               editPartCategory.getText().toString().trim().length()==0)
               {
                    showMessage("Error","please enter all values");
                   return;
                }
            dbTrecRec.execSQL("INSERT INTO tRec (parts_name,category)VALUES('" + editPartName.getText() + "','" + editPartCategory.getText() + "');");
            showMessage("success", "Record added");
            clearText();
        }
      /*  if(v==btnView)
        {
            Cursor c=dbTrecRec.rawQuery("SELECT * FROM tRec",null);
            if(c.getCount()==0)
            {
                showMessage("Error","no record found");
                return;
            }
            StringBuffer buffer=new StringBuffer();
            while (c.moveToNext())
            {
               buffer.append("Part_id: "+c.getString(0)+"\n");
                buffer.append("Part_name: "+c.getString(1)+"\n");
                buffer.append("Category: "+c.getString(2)+"\n\n");
            }
            showMessage("Prats details",buffer.toString());
        }*/
    }
    public void showMessage(String title,String message){
        AlertDialog.Builder builder = new AlertDialog.Builder(this);
        builder.setCancelable(true);
        builder.setTitle(title);
        builder.setMessage(message);
        builder.show();
    }
    public void clearText()
    {
        //editPartID.setText("");
        editPartName.setText("");
        editPartCategory.setText("");

        editPartName.requestFocus();
    }
}

MY DISPLAY.JAVA FILE

public class Display extends AppCompatActivity {

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

        Toolbar toolbar = (Toolbar) findViewById(R.id.toolbar);
        setSupportActionBar(toolbar);

        FloatingActionButton fab = (FloatingActionButton) findViewById(R.id.fab);
        fab.setOnClickListener(new View.OnClickListener()
        {
            @Override
            public void onClick(View view)
            {
               // Snackbar.make(view, "Replace with your own action", Snackbar.LENGTH_LONG)
                 //       .setAction("Action", null).show();


            }
        });
        getSupportActionBar().setDisplayHomeAsUpEnabled(true);

    }

}

my admin.xml file

<?xml version="1.0" encoding="utf-8"?>
<RelativeLayout xmlns:android="http://ift.tt/nIICcg"
    xmlns:tools="http://ift.tt/LrGmb4"
    xmlns:app="http://ift.tt/GEGVYd" android:layout_width="match_parent"
    android:layout_height="match_parent" android:paddingLeft="@dimen/activity_horizontal_margin"
    android:paddingRight="@dimen/activity_horizontal_margin"
    android:paddingTop="@dimen/activity_vertical_margin"
    android:paddingBottom="@dimen/activity_vertical_margin"
    app:layout_behavior="@string/appbar_scrolling_view_behavior"
    tools:showIn="@layout/activity_admin" tools:context="com.example.trackrecord.Admin">

    <Button
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:text="@string/add"
        android:id="@+id/btnAdd"
        android:layout_marginLeft="34dp"
        android:layout_marginStart="34dp"
        android:layout_below="@+id/editCategoryt"
        android:layout_alignParentLeft="true"
        android:layout_alignParentStart="true"
        android:layout_marginTop="79dp" />

    <Button
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:text="@string/view"
        android:id="@+id/btnView"
        android:layout_alignTop="@+id/btnAdd"
        android:layout_alignRight="@+id/editCategoryt"
        android:layout_alignEnd="@+id/editCategoryt"
        android:layout_marginRight="64dp"
        android:layout_marginEnd="64dp" />

    <EditText
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:id="@+id/editPartName"
        android:layout_marginTop="42dp"
        android:layout_alignParentRight="true"
        android:layout_alignParentEnd="true"
        android:hint="@string/part_name"
        android:layout_alignLeft="@+id/btnAdd"
        android:layout_alignStart="@+id/btnAdd" />

    <EditText
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:id="@+id/editCategoryt"
        android:layout_below="@+id/editPartName"
        android:layout_alignLeft="@+id/editPartName"
        android:layout_alignStart="@+id/editPartName"
        android:layout_marginTop="34dp"
        android:layout_alignParentRight="true"
        android:layout_alignParentEnd="true"
        android:hint="@string/category"/>

</RelativeLayout>

my display.xml file

    <?xml version="1.0" encoding="utf-8"?>
    <RelativeLayout 
xmlns:android="http://ift.tt/nIICcg"
xmlns:tools="http://ift.tt/LrGmb4"
xmlns:app="http://ift.tt/GEGVYd" android:layout_width="match_parent"
        android:layout_height="match_parent" android:paddingLeft="@dimen/activity_horizontal_margin"
        android:paddingRight="@dimen/activity_horizontal_margin"
        android:paddingTop="@dimen/activity_vertical_margin"
        android:paddingBottom="@dimen/activity_vertical_margin"
        app:layout_behavior="@string/appbar_scrolling_view_behavior"
        tools:showIn="@layout/activity_display" tools:context="com.example.trackrecord.Display">

        <ListView
            android:layout_width="wrap_content"
            android:layout_height="wrap_content"
            android:id="@+id/listView"
            android:layout_alignParentTop="true"
            android:layout_alignParentLeft="true"
            android:layout_alignParentStart="true" />
    </RelativeLayout>

Aucun commentaire:

Enregistrer un commentaire