Android - SQLite Tips

Android sqlite check if inserted new value

insert() method returns the row ID of the newly inserted row, or -1 if an error occurred.

Like this:

long rowInserted = db.insert(AddNewPhysicalPerson, null, newValues);
if(rowInserted != -1)
    Toast.makeText(myContext, "New row added, row id: " + rowInserted, Toast.LENGTH_SHORT).show();
else
    Toast.makeText(myContext, "Something wrong", Toast.LENGTH_SHORT).show();

Called from main activity for save item record to SQLite table and return status true or false.

public boolean insertItem(HashMap<String, String> queryValues) {


    SQLiteDatabase database = this.getWritableDatabase();
    ContentValues values = new ContentValues();


    values.put("edate",queryValues.get("edate"));
    values.put("item",queryValues.get("item"));
    values.put("amount",queryValues.get("amount"));
    values.put("number",queryValues.get("number"));
    values.put("count",queryValues.get("count"));

        long rowInserted = database.insert("customerentries", null, values);

        if(rowInserted != -1) {
            database.close();
            return true;
        }
        else{
            database.close();
            return false;
        }

}

Click Here

Android SQLite find for max value in a field

How to get the Max value SQLite Android

The SQLite MAX function is an aggregate function that returns the maximum value of all values in a group. 


    public int getMaxid(){

        String selectQuery = "SELECT max(id) as id FROM customerentries";
        SQLiteDatabase database = this.getWritableDatabase();
        Cursor cursor = database.rawQuery(selectQuery, null);

        cursor.moveToFirst();

        int maxid = cursor.getInt(cursor.getColumnIndex("id"));

        return maxid;
       
    }

Solution for - 

How to find the maximum value of the column in sqlite database

Related Links

Saving Data With SQLite

Android SQLite Database example

Reset auto increment after deleting a table row (Android-SQLite)

Show menu items in action bar

Android Long Press Event

Transfer Data Between Activities Using Intent

Add a row to the table

Adding Table rows Dynamically in Android

Display Data in GridView in Android

How to use TextView to display GridView item text in Android ?

Output Form like this

Solutions:

Layout file like:


<?xml version="1.0" encoding="utf-8"?>
<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"
    xmlns:tools="http://schemas.android.com/tools"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    android:paddingBottom="@dimen/activity_vertical_margin"
    android:paddingLeft="@dimen/activity_horizontal_margin"
    android:paddingRight="@dimen/activity_horizontal_margin"
    android:paddingTop="@dimen/activity_vertical_margin"
    tools:context="com.example.root.mymysqlapp.Table2Activity">


<ScrollView
android:id="@+id/scrollView1"
android:layout_width="fill_parent"
android:layout_height="wrap_content"
android:background="#3d455b"
android:layout_alignParentLeft="true" >

<HorizontalScrollView
    android:id="@+id/hscrll1"
    android:layout_width="fill_parent"
    android:layout_height="wrap_content" >

    <RelativeLayout
        android:id="@+id/RelativeLayout1"
        android:layout_width="fill_parent"
        android:layout_gravity="center"
        android:layout_height="fill_parent"
        android:orientation="vertical" >

        <TableLayout
            android:id="@+id/table_main"
            android:layout_width="wrap_content"
            android:layout_height="wrap_content"
            android:layout_centerHorizontal="true" >
        </TableLayout>
    </RelativeLayout>
</HorizontalScrollView>
</ScrollView>


</RelativeLayout>


Code like this :

Create an init() function and point the table layout. Then create the needed rows and columns. Call init function in your onCreate method:

package com.example.root.mymysqlapp;

import android.graphics.Color;

import android.support.v7.app.AppCompatActivity;

import android.os.Bundle;

import android.view.Gravity;

import android.widget.TableLayout;

import android.widget.TableRow;

import android.widget.TextView;

public class Table2Activity extends AppCompatActivity {

    @Override

    protected void onCreate(Bundle savedInstanceState) {

        super.onCreate(savedInstanceState);

        setContentView(R.layout.activity_table2);

        init();

    }

    public void init() {

        TableLayout stk = (TableLayout) findViewById(R.id.table_main);

        TableRow tbrow0 = new TableRow(this);

        TextView tv0 = new TextView(this);

        tv0.setText(" Sl.No ");

        tv0.setTextColor(Color.WHITE);

        tbrow0.addView(tv0);

        TextView tv1 = new TextView(this);

        tv1.setText(" Student Name ");

        tv1.setTextColor(Color.WHITE);

        tbrow0.addView(tv1);

        TextView tv2 = new TextView(this);

        tv2.setText(" Class ");

        tv2.setTextColor(Color.WHITE);

        tbrow0.addView(tv2);

        TextView tv3 = new TextView(this);

        tv3.setText(" Total Fee ");

        tv3.setTextColor(Color.WHITE);

        tbrow0.addView(tv3);

        stk.addView(tbrow0);

        for (int i = 1; i <= 25; i++) {

            TableRow tbrow = new TableRow(this);

            TextView t1v = new TextView(this);

            t1v.setText(""+i);

            t1v.setTextColor(Color.WHITE);

            t1v.setGravity(Gravity.CENTER);

            tbrow.addView(t1v);

            TextView t2v = new TextView(this);

            t2v.setText("Student " + i);

            t2v.setTextColor(Color.WHITE);

            t2v.setGravity(Gravity.CENTER);

            tbrow.addView(t2v);

            TextView t3v = new TextView(this);

            t3v.setText("1-A");

            t3v.setTextColor(Color.WHITE);

            t3v.setGravity(Gravity.CENTER);

            tbrow.addView(t3v);

            TextView t4v = new TextView(this);

            t4v.setText("1500.00");

            t4v.setTextColor(Color.WHITE);

            t4v.setGravity(Gravity.CENTER);

            tbrow.addView(t4v);

            stk.addView(tbrow);

        }

    }

}

Above application expline working of TableLayout .

How add and delete rows to table layout in java programically

How to delete table row in table layout in android

Layout:

<?xml version="1.0" encoding="utf-8"?>
<TableLayout xmlns:android="http://schemas.android.com/apk/res/android"
             android:id="@+id/table"
             android:layout_width="match_parent"
             android:layout_height="match_parent">

</TableLayout>

Activity:

public class TableLayoutActivity extends Activity {

@Override
protected void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.table_layout);
    final TableLayout tableLayout = (TableLayout) findViewById(R.id.table);

    for (int i = 0; i < 5; i++) {
        // Creation row
        final TableRow tableRow = new TableRow(this);
        tableRow.setLayoutParams(new TableLayout.LayoutParams(TableLayout.LayoutParams.WRAP_CONTENT, TableLayout.LayoutParams.WRAP_CONTENT));

        // Creation textView
        final TextView text = new TextView(this);
        text.setText("Test" + i);
        text.setLayoutParams(new TableRow.LayoutParams(TableRow.LayoutParams.WRAP_CONTENT, TableRow.LayoutParams.WRAP_CONTENT));

        // Creation  button
        final Button button = new Button(this);
        button.setText("Delete");
        button.setLayoutParams(new TableRow.LayoutParams(TableRow.LayoutParams.WRAP_CONTENT, TableRow.LayoutParams.WRAP_CONTENT));
        button.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                final TableRow parent = (TableRow) v.getParent();
                tableLayout.removeView(parent);
            }
        });

        tableRow.addView(text);
        tableRow.addView(button);

        tableLayout.addView(tableRow);
    }

}
}

Inserting table row beginning of table layout in java programmatically

tbl.addView(View child, int index)

child contains rows object and index contains for add row position in table layout.

Example

tbl.addView(row,0);  // added first row

tbl.addView(row,1);  // added second row

.
.

tbl.addView(row);  // added row in end of table layout.

Dynamically add imagebutton programatically android

ImageButton b1 = new ImageButton(this);
b1.setImageResource(R.drawable.delete);
b1.setLayoutParams(new TableRow.LayoutParams(TableRow.LayoutParams.WRAP_CONTENT, TableRow.LayoutParams.WRAP_CONTENT));
b1.setOnClickListener(new View.OnClickListener() {
    @Override
    public void onClick(View v) {
        final TableRow parent = (TableRow) v.getParent();
        stk.removeView(parent);
    }
});

tbrow.addView(b1);

How do I get values from a dynamically created android TableRow?

getChildAt to get a hold of the two TextViews and get the data:

tr.setOnClickListener(new View.OnClickListener() {
   public void onClick(View view) {
      TableRow t = (TableRow) view;
      TextView firstTextView = (TextView) t.getChildAt(0);
      TextView secondTextView = (TextView) t.getChildAt(1);
      String firstText = firstTextView.getText().toString();
      String secondText = secondTextView.getText().toString();
   }
});

Solution for the get values of selected row on clicked button in table row.

ImageButton b1 = new ImageButton(EntriesActivity.this);
b1.setImageResource(R.drawable.delete);
b1.setLayoutParams(new TableRow.LayoutParams(TableRow.LayoutParams.WRAP_CONTENT, TableRow.LayoutParams.WRAP_CONTENT));
b1.setOnClickListener(new View.OnClickListener() {
    @Override    public void onClick(View v) {
        final TableRow parent = (TableRow) v.getParent();

        //code for remove concerned row
        //stk.removeView(parent);
        TextView items = (TextView) parent.getChildAt(7);

        Toast.makeText(getApplicationContext(), items.getText().toString() ,Toast.LENGTH_SHORT).show();


    }
});

row.addView(b1);

How to hide a particular column in Android TableRow

Try to Use setVisibility(View.GONE); 

t3v.setVisibility(View.GONE);

TextView id = new TextView(EntriesActivity.this);
id.setText(content.get("id").toString());
id.setTextColor(Color.WHITE);
id.setVisibility(View.GONE);
row.addView(id);

Get total RowCount for TableLayout in Android

Through this code you can get the total rowCount for TableLayout

TableLayoutName.getChildCount();

Examples

TableLayout tb = (TableLayout) findViewById(R.id.table_main);

if(tb.getChildCount()>1){

.....Code Here.....

}

Adding space between columns of a TableLayout

 Programetically  add

  TextView count = new TextView(RptsalesreportdisplayActivity.this);
  count.setText(obj.get("count").toString());
  count.setTextColor(Color.WHITE);
  count.setPadding(0,0,30,0);
  row.addView(count);

<TableRow
    android:layout_width="fill_parent"
    android:layout_height="wrap_content" >

    <TextView
        android:layout_width="0"
        android:layout_height="wrap_content"
        android:layout_weight=".25"
        android:gravity="center"
        android:text="col1" />   ...........

Set tablelayout row background color programmatically

tbrow0.setBackgroundResource(R.color.cgreen);

Update data From Other Table

Update one MySQL table with values from another

My customer table looks like:

And the customer_rate table looks like:

I want to update prize in customer with the id from customer_rate based on prize 

Action : customer.prize = customer.qty * customer_rate.prize

The updated table will hopefully look like:

I have a query that works

UPDATE customerINNER JOIN customer_rate ON (customer.cus_id = customer_rate.id)SET customer.prize = customer.qty * customer_rate.prize

add where condition 

UPDATE customerINNER JOIN customer_rate ON (customer.cus_id = customer_rate.id)SET customer.prize = customer.qty * customer_rate.prize where customer.id = 1