Exercise Database 3 for home Android Create a program that reads and writes in the "information" contained in the database "Studente.db" data: name, address and email.
------------------- ------------------- 
AndroidManifest.xml 
\u0026lt;? xml version = "1.0" encoding = "UTF-8"?> \u0026lt;manifest xmlns: android = "
http://schemas.android.com/apk/res/android" \u0026lt;application>
\u0026lt;activity android:name=".Agenda" android:label="Agenda">
; \u0026lt;intent-filter>
& # 160; \u0026lt;action android:name="android.intent.action.MAIN"/> & # 160; \u0026lt;category android:name="android.intent.category.LAUNCHER"/> ; \u0026lt;/ intent -filter>
\u0026lt;/ Activity>
\u0026lt;activity android:name=".Lista"> \u0026lt; / activity>
\u0026lt;/ application> \u0026lt;/ manifest>
--------------- ---- -------------------
lista.xml
\u0026lt;? xml version = "1.0" encoding = "UTF-8"? >
\u0026lt;relative layout xmlns: android = "
http://schemas.android.com/apk/res/android "
android: orientation =" horizontal "
& # 160; android: layout_width = "fill_parent"
android: layout_height = "fill_parent"
>
\u0026lt;ScrollView android: layout_height = "fill_parent"
android: layout_width = " ; fill_parent>
\u0026lt;LinearLayout ; android: orientation = "vertical" android : layout_width = "fill_parent"
android: layout_height = "fill_parent"
>
; \u0026lt;ListView android: id = "@ + id / listav"
& # 160; android: layout_width = "fill_parent"
android: layout_height = " ; 300sp "
android: drawSelectorOnTop = false &
# 160; android: cacheColorHint = "# ff6a00"
android: divider = "ff8f40"
; android: dividerHeight = "2px"
/>
& # 160; \u0026lt;relative layout
android: layout_width = "fill_parent"
android: layout_height = "fill_parent"
& # 160; android: background = "676 767"
& # 160; android: orientation = "vertical">
\u0026lt;Button
& # 160; android: layout_width = "fill_parent"
; android: layout_height = "fill_parent"
android: id = "@ + id / btnGetMoreResults "
Android: padding = "10px"
; android: text = "Enter new data" />
\u0026lt;/ relative layout>
\u0026lt;relative layout
android: layout_width = "fill_parent"
& # 160; android: layout_height = "fill_parent"
android: background = "676 767"
android: orientation = "vertical">
& # 160; \u0026lt;Button
android: layout_width = "fill_parent"
& # 160; android: layout_height = "fill_parent"
& # 160; android: id = "@ + id/btnGetMoreResults1"
; android: padding = "10px"
& # 160; android: text = "Show detagli" />
\u0026lt;/ RelativeLayout>
; \u0026lt;/ LinearLayout>
\u0026lt;/ ScrollView>
\u0026lt;/ RelativeLayout>
-------------------
main.xml
------------------- \u0026lt;? xml version = "1.0" encoding = "UTF-8"?>
\u0026lt; table layout xmlns: android = "
http://schemas.android.com/apk/res/android"
android: layout_width = "fill_parent"
android: layout_height = "fill_parent"
android: stretch columns = " 1 "
>
\u0026lt;TableRow> ; \u0026lt;TextView Android:text="Nome:"/> \u0026lt;EditText android: id = "@ + id / name"
; android: hint = "Enter your name &
# 160; />
\u0026lt;/ TableRow> \u0026lt;TableRow> \u0026lt;TextView android:text="Indirizzo:"/>
\u0026lt;EditText android: id = "@ + id / via"
& # 160; android:hint="Scrivi il tuo indirizzo"
        />
    </TableRow>
        <TableRow>
        <TextView android:text="E-mail:"/>
        \u0026lt;EditText android: id = "@ + id / email"
& # 160; android: hint = "Enter your e-mail"
& # 160; />
\u0026lt;/ TableRow>
& # 160; \u0026lt;Button android: id = "@ + id / salva"
& # 160; android: layout_width = "fill_parent"
; android: layout_height = " ; wrap_content "
& # 160; android: text = "Salva"
; />
\u0026lt;Button android: id = "@ + id / impegni "
; android: layout_width = "fill_parent"
& # 160; android: layout_height = "wrap_content"
& # 160; android: text = "visualizza i dati"
& # 160; />
</TableLayout>
-------------------
Agenda.java
-------------------
/*
* To change this template, choose Tools *
* @author Lorenzo Millucci
*/
public class Agenda extends Activity {
    private final String DB_NAME="Studente.db";
    private SQLiteDatabase database = null;
    /** Called when the activity is first created. */
    @Override     public void onCreate(Bundle savedInstanceState)     {
         super.onCreate (savedInstanceState)
setContentView (R.layout.main)
creaDB ();
& # 160; creaTabella ();
Button save = (Button) findViewById (R. id.salva)
Button lista=(Button)findViewById(R.id.impegni);
        salva.setOnClickListener(salva1);
        lista.setOnClickListener(onLista);
    }
    private View.OnClickListener onLista=new View.OnClickListener(){
         public void onClick(View v){
             Intent i=new Intent(v.getContext(),Lista.class);
             startActivity(i);
             }
         };
    public void creaDB(){
        try{
            database=openOrCreateDatabase(DB_NAME,SQLiteDatabase.CREATE_IF_NECESSARY,null);
        }catch(SQLiteException e){
            e.printStackTrace();
        }
    }
    public void creaTabella(){
        try{
            if (database.isOpen()){
                         database.execSQL("CREATE TABLE IF NOT EXISTS dati (_id integer primary key autoincrement, nome varchar(20), via varchar(50), email varchar(50));");
            }
        }catch(SQLiteException e){
            e.printStackTrace();
        }
    }
    private View.OnClickListener salva1=new View.OnClickListener(){
         public void onClick (View v) {&
# 160; appunto1 = alt text (alt text) findViewById (R.id.nome)
; dove1 = edit text (alt text) findViewById (R.id.via)
& # 160; quando1 = edit text (alt text) findViewById (R.id.email)
& # 160; appunto1.getText String nome = (). toString ();
& # 160; String = dove1.getText by (). toString ();
& # 160; Quando1.getText String email = (). ToString ();
/ / dove1.setText ("");
& # 160; String insert = "INSERT INTO data (name, street name, email) values \u200b\u200b('" + name + "', '"+ +"','"+ via email +"');";
/ / ; String insert = "INSERT INTO data (name, street name, email) values \u200b\u200b('" + name +"',"+ via email +",'"+ +"');";
/ / , & # 160; String insert = "INSERT INTO vote (datavoto, mark, pattern, material, depth, name) values \u200b\u200b('" +
/ / datavoto +"',"+ vote +",'"+ +"','"+ plea on behalf +"','"+ Professor +"','"+ +"');";
try {
; database.execSQL (post);
& # 160;} catch (SQLiteException e) {
; e.printStackTrace();
             }
         }
     };
     @Override
     public void onDestroy() {
          super.onDestroy();
          database.close();
     }
}
-------------------
Lista.java
-------------------
package org.me.dbstudente;
import android.app.Activity;
import android.os.Bundle;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteException;
import android.content.Context;
import android.widget.*;
import android.view.View;
android.widget.ListView import, import
android.widget.AdapterView;
import android.database.Cursor;
import java.util.ArrayList;
import android.util.Log;
import android.content.Intent;
public class List
extends Activity {private final String DB_NAME = "Studente.db"
SQLiteDatabase private database = null;
private ListView votes
& # 160; ArrayList rows = new ArrayList \u0026lt;String> \u0026lt;String> ();
private String LVOT []={" 5 computer 10/02/2010 "" , 7 Italian 31/01/2010 "," 9 physical education 25/03/2010 "," 7 English 28/02/2010 "};
, / ** Called When the activity is first created. * / @ Override
public void onCreate (Bundle savedInstanceState)
    {
         super.onCreate(savedInstanceState);          setContentView(R.layout.lista);          creaDatabase();
         leggiTabellaVoto ();
votes = (ListView) findViewById (R.id.listav) ;
/ / By using setAdpater method in listview we add an string array list.
/ / log. ("votes =" + rating);
voti.setAdapter (new ArrayAdapter \u0026lt;String> (this, android.R.layout.simple_list_item_1, rows));
& # 160; Button enter = (Button) findViewById (R.id.btnGetMoreResults)
; inserisci.setOnClickListener (onInserisci);}
creaDatabase public void () {
try{          
                    database=openOrCreateDatabase(DB_NAME,SQLiteDatabase.CREATE_IF_NECESSARY, null);
          } Catch (SQLiteException e) {
& # 160; System.out.println ("did not create the database student") ;
e.printStackTrace ();}
& # 160;} public void
leggiTabellaVoto () {
& # 160; Cursor c = database.query ("dati", null, null, null, null, null, null, null);
& # 160; int numRows = c.getCount ();
& # 160; ; c.moveToFirst ();
& # 160; for (int i = 0; i < numRows; ++i) {
                              Riga r = new Riga();
                              r._id = c.getLong(0);
                              r.nome = c.getString(1);
                              r.via = c.getString(2);
                              r.email = c.getString(3);
                              String r.nome rr = + "" + r.via + "" + r.email;
& # 160; System.out.println (rr) ;
& # 160; righe.add (str);
& # 160; c.moveToNext ();
; & # 160;
}} class Line {
& # 160; public long _id;
; public String name;
public String street;
public String email;
     }
     private View.OnClickListener onInserisci=new View.OnClickListener(){
         public void onClick(View v) {
            Intent i = new Intent(v.getContext(), Agenda.class);
            startActivity(i);
         }
      };  
     @Override
     public void onDestroy() {
          super.onDestroy();
          database.close ();}
}
--- ------------------ --------------------- main.xml 
http://schemas.android.com/apk/res/android" 
android: layout_height = "fill_parent" > 
---------------- ----------------- - 
android.app.Activity import, import 
main.xml 
\u0026lt;? xml version = " 1.0 "encoding =" utf-8 "?> 
android: layout_width =" fill_parent " ; 
![clip_image002[4]](http://lh5.ggpht.com/_e6EI37sHhmk/S-2d3_TEz6I/AAAAAAAAAXo/tOsmTZ0iK9s/s1600-h/clip_image002%5B4%5D%5B2%5D.jpg "clip_image002[4]")
android.os.Bundle; 
android.content.Context; 
AndroidManifest.xml 
\u0026lt;? xml version = "1.0" encoding = "UTF-8"?> 
& # 160; package = "org.me.dbstudente"> 
/> 
android: layout_height = "wrap_content" 
: layout_width = "fill_parent" 
