Databases
StackOverflow2013
Postsdbo
POGet values from database and show it in text view?
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POGet values from database and show it in text view?
    text
    copied!<pre><code>package as.d.d; import java.util.List; import android.app.Activity; import android.content.Intent; import android.os.Bundle; import android.util.Log; import android.view.View; import android.view.View.OnClickListener; import android.widget.Button; import android.widget.EditText; import android.widget.TextView; import android.widget.Toast; public class add extends Activity implements OnClickListener{ Button b1,b2; EditText e2,e3; TextView t1; @Override public void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.add); b1=(Button)findViewById(R.id.button1); b2=(Button)findViewById(R.id.button2); e2=(EditText)findViewById(R.id.editText2); e3=(EditText)findViewById(R.id.editText3); t1=(TextView)findViewById(R.id.AtextView1); b1.setOnClickListener(this); b2.setOnClickListener(this); DatabaseHandler db = new DatabaseHandler(this); List&lt;StudentInfo&gt; studentInfo = db.getAllStudentInfo(); for (StudentInfo cn : studentInfo){ t1.setText("Id:"+(cn.getID()+1)); } } @Override public void onClick(View v) { if(v==b2){ startActivity(new Intent(add.this, FdActivity.class)); } else if(v==b1){ String s2=e2.getText().toString(); String s3=e3.getText().toString(); if(s2.trim().equals("")||s3.trim().equals("")){ Toast.makeText(getApplicationContext(), "Please Submit Student Information",Toast.LENGTH_SHORT).show(); } else{ DatabaseHandler db = new DatabaseHandler(this); Log.d("Insert: ", "Inserting .."); db.addContact(new StudentInfo(s2,s3)); Log.d("Reading: ", "Reading all contacts.."); List&lt;StudentInfo&gt; studentInfo = db.getAllStudentInfo(); for (StudentInfo cn : studentInfo){ t1.setText("Id:"+(cn.getID()+1)); }}}}} </code></pre> <p>In this add class I am using a Textview for autogenerated student id(numerical(int) and two text field for submit student name and phone number into database by pressing a button.Here the Student Id,Name and phone number submitted succesfully.</p> <p>In addmark class I use an autocomplete textview for showing the names which I submitted from add class.When I select a name suppose Farhan(which I already submitted into database and the id is 4 and phone number is 99876 stored in database) then I want to see the id and phone number in two textview(TextView t1,t2;)?</p> <pre><code>package as.d.d; import java.util.ArrayList; import java.util.List; import android.app.Activity; import android.os.Bundle; import android.view.View; import android.widget.AdapterView; import android.widget.AdapterView.OnItemClickListener; import android.widget.ArrayAdapter; import android.widget.AutoCompleteTextView; import android.widget.TextView; import android.widget.Toast; public class addmark extends Activity{ AutoCompleteTextView a1; TextView t1,t2; @Override public void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.addmark); a1=(AutoCompleteTextView)findViewById(R.id.autoCompleteTextView1); t1=(TextView)findViewById(R.id.amtextView1); t2=(TextView)findViewById(R.id.amtextView2); DatabaseHandler db = new DatabaseHandler(this); final List&lt;StudentInfo&gt; studentInfo = db.getAllStudentInfo(); final ArrayList&lt;String&gt; s1 = new ArrayList&lt;String&gt;(); for (StudentInfo cn : studentInfo) { s1.add(cn.getName()); } ArrayAdapter&lt;String&gt; adapter = new ArrayAdapter&lt;String&gt;(this, android.R.layout.simple_dropdown_item_1line,s1); a1.setThreshold(1); a1.setAdapter(adapter); a1.setOnItemClickListener(new OnItemClickListener() { @Override public void onItemClick(AdapterView&lt;?&gt; arg0, View arg1, int arg2, long arg3) { } }); </code></pre>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload