MULTIPLE TABLE IN ONE DATABASE IN ANDROID

RELATED LINKS
1.LIST VIEW IN ANDROID
2.BUTTON IN ANROID
http://www.multipletableindatabase.blogspot.in/
http://photogalleryinandroid.blogspot.in/
http://photoalbuminandroid.blogspot.in/

DOWNLOAD
1.database.rar
2.database.zip


SCREEN SHOTS

MainActivity.java

 

package com.example.sd;
import android.os.Bundle;
import android.app.Activity;
import android.content.Intent;
import android.view.Menu;
import android.view.View;
import android.widget.Button;
import android.view.View.OnClickListener;
public class MainActivity extends Activity {
   Button badd, bview,mbadd,mbview;

    @Override
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        badd = (Button)findViewById(R.id.badd);
        bview = (Button)findViewById(R.id.bview);
        mbadd = (Button)findViewById(R.id.mbadd);
        mbview = (Button)findViewById(R.id.mbview);
       
       
       badd.setOnClickListener(new OnClickListener() {

  public void onClick(View v) {
   // TODO Auto-generated method stub
    Intent myIntent = new Intent(MainActivity.this, insert.class);
    startActivity(myIntent);
  }
 });
       bview.setOnClickListener(new OnClickListener() {
  
     public void onClick(View v) {
      // TODO Auto-generated method stub
       Intent myIntent = new Intent(MainActivity.this, view.class);
       startActivity(myIntent);
     }
    });
       mbadd.setOnClickListener(new OnClickListener() {
  
     public void onClick(View v) {
      // TODO Auto-generated method stub
       Intent myIntent = new Intent(MainActivity.this, insert1.class);
       startActivity(myIntent);
     }
    });
          mbview.setOnClickListener(new OnClickListener() {
     
        public void onClick(View v) {
         // TODO Auto-generated method stub
          Intent myIntent = new Intent(MainActivity.this, view1.class);
          startActivity(myIntent);
        }
       });
     
      
    }

}

 

database.java

 

package com.example.sd;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.database.sqlite.SQLiteDatabase.CursorFactory;

public class database {

 public static final String MYDATABASE_NAME = "MY_DATABASE";
 public static final int MYDATABASE_VERSION = 1;


 public static final String MYDATABASE_TABLE = "ST";
 public static final String KEY_ID = "_id";
 public static final String SID = "sid";
 public static final String SNAME = "sname";
 public static final String SROLL = "sroll";

 public static final String MYDATABASE_TABLE1 = "MT";
 public static final String KEY_ID1 = "_id";
    public static final String MSID= "msid";
 public static final String MID= "mid";
 public static final String SUB= "sub";
 public static final String MARK= "mark";

 //create table MY_DATABASE (ID integer primary key, Content text not null);
 private static final String SCRIPT_CREATE_DATABASE =
  "create table " + MYDATABASE_TABLE + " ("
  + KEY_ID + " integer primary key autoincrement, "
  + SID+ " text not null, "
  + SNAME + " text not null,"
     + SROLL+ " text not null);";

 private static final String SCRIPT_CREATE_DATABASE1 =
   "create table " + MYDATABASE_TABLE1 + " ("
   + KEY_ID1 + " integer primary key autoincrement, "
   + MID+ " text not null, "
   + MSID + " text not null,"
   + SUB + " text not null,"
      + MARK+ " text not null);";
 private SQLiteHelper sqLiteHelper;
 private SQLiteDatabase sqLiteDatabase;

 private Context context;

 public database(Context c){
  context = c;
 }

 public database openToRead() throws android.database.SQLException {

  sqLiteHelper = new SQLiteHelper(context, MYDATABASE_NAME, null, MYDATABASE_VERSION);
  sqLiteDatabase = sqLiteHelper.getReadableDatabase();
  return this;
 }

 public database openToWrite() throws android.database.SQLException {
  sqLiteHelper = new SQLiteHelper(context, MYDATABASE_NAME, null, MYDATABASE_VERSION);
  sqLiteDatabase = sqLiteHelper.getWritableDatabase();
  return this;
 }

 public void close(){
  sqLiteHelper.close();
 }

 public long insert(String sid, String sname,String sroll){

  ContentValues contentValues = new ContentValues();
  contentValues.put(SID, sid);
  contentValues.put(SNAME,sname);
  contentValues.put(SROLL,sroll);
  return sqLiteDatabase.insert(MYDATABASE_TABLE, null, contentValues);

 }
 public long insert1(String mid, String msid ,String sub,String mark){

  ContentValues contentValues1 = new ContentValues();
  contentValues1.put(MID, mid);
  contentValues1.put(MSID,msid);
  contentValues1.put(SUB,sub);
  contentValues1.put(MARK,mark);
  return sqLiteDatabase.insert(MYDATABASE_TABLE1, null, contentValues1);


 }
//public int update(String table, ContentValues values, String whereClause, String[] whereArgs){
public long update(String sid, String sname,String sroll,int id){
 ContentValues contentValues = new ContentValues();
 contentValues.put(SID, sid);
 contentValues.put(SNAME,sname);
 contentValues.put(SROLL,sroll);
 System.out.println(id);

 return sqLiteDatabase.update(MYDATABASE_TABLE, contentValues, KEY_ID+"="+id, null);
}

 public int deleteAll(){
  return sqLiteDatabase.delete(MYDATABASE_TABLE, null, null);
 }

 public void delete_byID(int id){
  sqLiteDatabase.delete(MYDATABASE_TABLE, KEY_ID+"="+id, null);
 }
 public void delete_byID1(int id){
  sqLiteDatabase.delete(MYDATABASE_TABLE1, KEY_ID+"="+id, null);
 }

 public Cursor queueAll1(){
  String[] columns1 = new String[]{KEY_ID1, MID,MSID,SUB,MARK};
  Cursor cursor = sqLiteDatabase.query(MYDATABASE_TABLE1, columns1,
    null, null, null, null, null);

  return cursor;
 }
 public Cursor queueAll(){
  String[] columns = new String[]{KEY_ID, SID,SNAME,SROLL};
  Cursor cursor = sqLiteDatabase.query(MYDATABASE_TABLE, columns,
    null, null, null, null, null);

  return cursor;
 }
 public Cursor queueAll2(int id){

    String a="SELECT * FROM ST WHERE _id = "+id;

    Cursor cursor=sqLiteDatabase.rawQuery(a, null);

  return cursor;
 }
 public Cursor queueAll3(int id){
  //String[] columns = new String[]{KEY_ID, SID,SNAME,SROLL};
    String a="SELECT * FROM MT,ST WHERE _id = "+id;
  //Cursor cursor = sqLiteDatabase.query(MYDATABASE_TABLE, columns,
   // null, null, null, null, null);
    Cursor cursor=sqLiteDatabase.rawQuery(a, null);

  return cursor;
 }

 public class SQLiteHelper extends SQLiteOpenHelper {

  public SQLiteHelper(Context context, String name,
    CursorFactory factory, int version) {
   super(context, name, factory, version);
  }

  @Override
  public void onCreate(SQLiteDatabase db) {
   // TODO Auto-generated method stub
   db.execSQL(SCRIPT_CREATE_DATABASE);
   db.execSQL(SCRIPT_CREATE_DATABASE1);
  }

  

  @Override
  public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
   // TODO Auto-generated method stub

  }

 }

}

insert.java

 

package com.example.sd;
import android.content.Intent;
import android.app.Activity;
import android.content.Intent;
import android.database.Cursor;
import android.os.Bundle;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.SimpleCursorAdapter;
import android.view.View.OnClickListener;

public class insert extends Activity{
 Button ib,ib1;
 EditText ie1,ie2,ie3;
 private database mySQLiteAdapter;
 SimpleCursorAdapter cursorAdapter;
 Cursor cursor;
  public void onCreate(Bundle savedInstanceState) {
         super.onCreate(savedInstanceState);
         setContentView(R.layout.insert);

         ie1=(EditText)findViewById(R.id.ie1);
         ie2=(EditText)findViewById(R.id.ie2);
         ie3=(EditText)findViewById(R.id.ie3);
         ib=(Button)findViewById(R.id.ib);
         ib1=(Button)findViewById(R.id.ib1);
              ib1.setOnClickListener(new OnClickListener() {

    public void onClick(View v) {
     // TODO Auto-generated method stub
     Intent intent=new Intent(insert.this,MainActivity.class);
     startActivity(intent);
 
    }
   });
         mySQLiteAdapter = new database(this);
         mySQLiteAdapter.openToWrite();
         cursor = mySQLiteAdapter.queueAll();
        
         ib.setOnClickListener(new OnClickListener() {

    public void onClick(View v) {
     // TODO Auto-generated method stub
     String data1 = ie1.getText().toString();
     String data2 = ie2.getText().toString();
     String data3 = ie3.getText().toString();
     mySQLiteAdapter.insert(data1, data2,data3);
     updateList();
     Intent myIntent = new Intent(insert.this, MainActivity.class);
        startActivity(myIntent);
 
    }
   });
        
        
  }
  private void updateList(){
   cursor.requery();
     }

}






insert1.java

 

package com.example.sd;
import android.content.Intent;
import android.app.Activity;
import android.content.Intent;
import android.database.Cursor;
import android.os.Bundle;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.SimpleCursorAdapter;
import android.view.View.OnClickListener;

public class insert1 extends Activity{
 Button i1b,i1b1;
 EditText i1e1,i1e2,i1e3,i1e4;
 private database mySQLiteAdapter;
 SimpleCursorAdapter cursorAdapter;
 Cursor cursor;
  public void onCreate(Bundle savedInstanceState) {
         super.onCreate(savedInstanceState);
         setContentView(R.layout.insert1);

         i1e1=(EditText)findViewById(R.id.i1e1);
         i1e2=(EditText)findViewById(R.id.i1e2);
         i1e3=(EditText)findViewById(R.id.i1e3);
         i1e4=(EditText)findViewById(R.id.i1e4);
         i1b=(Button)findViewById(R.id.i1b);
         i1b1=(Button)findViewById(R.id.i1b1);
              i1b1.setOnClickListener(new OnClickListener() {

    public void onClick(View v) {
     // TODO Auto-generated method stub
     Intent intent=new Intent(insert1.this,MainActivity.class);
     startActivity(intent);
 
    }
   });
         mySQLiteAdapter = new database(this);
         mySQLiteAdapter.openToWrite();
         cursor = mySQLiteAdapter.queueAll1();
        
         i1b.setOnClickListener(new OnClickListener() {

    public void onClick(View v) {
     // TODO Auto-generated method stub
     String data11 = i1e1.getText().toString();
     String data21 = i1e2.getText().toString();
     String data31 = i1e3.getText().toString();
     String data41 = i1e4.getText().toString();
     mySQLiteAdapter.insert1(data11, data21,data31,data41);
     updateList();
     Intent myIntent = new Intent(insert1.this, MainActivity.class);
        startActivity(myIntent);
 
    }
   });
        
        
  }
  private void updateList(){
   cursor.requery();
     }

}


sdetails.java

 

package com.example.sd;

import android.app.Activity;
import android.database.Cursor;
import android.os.Bundle;
import android.widget.ListView;
import android.widget.SimpleCursorAdapter;

public class sdetails extends Activity{
 private database mySQLiteAdapter;
 ListView listContent;
 SimpleCursorAdapter cursorAdapter;
 Cursor cursor;
 static int sdid;

  void sdid(int id ) {
   sdid=id;
 System.out.println("upid"+sdid);

  }
  public void onCreate(Bundle savedInstanceState) {
         super.onCreate(savedInstanceState);
         setContentView(R.layout.sdetails);
         listContent = (ListView)findViewById(R.id.sdvl);
         mySQLiteAdapter = new database(this);
         mySQLiteAdapter.openToWrite();

         cursor = mySQLiteAdapter.queueAll2(sdid);
       
         String[] from = new String[]{database.KEY_ID, database.SID, database.SNAME,database.SROLL};
         int[] to = new int[]{R.id.sdrid, R.id.sdrt1, R.id.sdrt2,R.id.sdrt3};
         cursorAdapter =
          new SimpleCursorAdapter(this, R.layout.sdrow, cursor, from, to);
         listContent.setAdapter(cursorAdapter);
       
}
}









update.java

 

package com.example.sd;

import android.app.Activity;
import android.content.Intent;
import android.database.Cursor;
import android.os.Bundle;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.EditText;
import android.widget.SimpleCursorAdapter;

 

public class update extends Activity{
 Button aib,aib1;
 EditText aie1,aie2,aie3;
 private database mySQLiteAdapter;
 SimpleCursorAdapter cursorAdapter;
 Cursor cursor;
  static int upid;

 void id(int id ) {
  upid=id;
System.out.println("upid"+upid);

 }

  public void onCreate(Bundle savedInstanceState) {
         super.onCreate(savedInstanceState);
         setContentView(R.layout.upadate);
        

        aie1=(EditText)findViewById(R.id.aie1);
         aie2=(EditText)findViewById(R.id.aie2);
         aie3=(EditText)findViewById(R.id.aie3);
         aib=(Button)findViewById(R.id.aib);
         aib1=(Button)findViewById(R.id.aib1);
              aib1.setOnClickListener(new OnClickListener() {

    public void onClick(View v) {
     // TODO Auto-generated method stub
     Intent intent=new Intent(update.this,MainActivity.class);
     startActivity(intent);
 
    }
   });
         mySQLiteAdapter = new database(this);
         mySQLiteAdapter.openToWrite();
         cursor = mySQLiteAdapter.queueAll();
        
         aib.setOnClickListener(new OnClickListener() {

    public void onClick(View v) {
     // TODO Auto-generated method stub
     String data1 = aie1.getText().toString();
     String data2 = aie2.getText().toString();
     String data3 = aie3.getText().toString();
     //System.out.println("upid1"+upid);
     mySQLiteAdapter.update(data1, data2,data3,upid);
     updateList();
     Intent myIntent = new Intent(update.this, MainActivity.class);
        startActivity(myIntent);
 
    }
   });
        
        
  }
  private void updateList(){
   cursor.requery();
     }

 

 

}


view.java

package com.example.sd;

import android.app.Activity;
import android.app.AlertDialog;
import android.content.DialogInterface;
import android.content.Intent;
import android.database.Cursor;
import android.os.Bundle;
import android.view.View;
import android.widget.AdapterView;
import android.widget.ListView;
import android.widget.SimpleCursorAdapter;
import android.widget.AdapterView.OnItemClickListener;

public class view extends Activity{
 private database mySQLiteAdapter;
 private update up=new update();
 private sdetails sdid=new sdetails();
 ListView listContent;
 SimpleCursorAdapter cursorAdapter;
 Cursor cursor;
  public void onCreate(Bundle savedInstanceState) {
         super.onCreate(savedInstanceState);
         setContentView(R.layout.view);
         listContent = (ListView)findViewById(R.id.vl);
         mySQLiteAdapter = new database(this);
         mySQLiteAdapter.openToWrite();

         cursor = mySQLiteAdapter.queueAll();
      
 
         String[] from = new String[]{database.KEY_ID, database.SID, database.SNAME,database.SROLL};
         int[] to = new int[]{R.id.rid, R.id.rt1, R.id.rt2,R.id.rt3};
                
         cursorAdapter =
          new SimpleCursorAdapter(this, R.layout.row, cursor, from, to);
         listContent.setAdapter(cursorAdapter);
     /*    listContent.setOnItemClickListener(new OnItemClickListener() {

    public void onItemClick(AdapterView<?> arg0, View arg1,
      int arg2, long arg3) {

     Cursor cursor = (Cursor) arg0.getItemAtPosition(arg2);
     final int item_id = cursor.getInt(cursor.getColumnIndex(database.KEY_ID));
     sdid.sdid(item_id);
     Intent intent=new Intent(view.this,sdetails.class);
     startActivity(intent);
    }

    });
        */
       listContent.setOnItemClickListener(new OnItemClickListener() {

    public void onItemClick(AdapterView<?> arg0, View arg1,
      int arg2, long arg3) {
 
     // TODO Auto-generated method stub

     Cursor cursor = (Cursor) arg0.getItemAtPosition(arg2);
     final int item_id = cursor.getInt(cursor.getColumnIndex(database.KEY_ID));
       AlertDialog.Builder myDialog  = new AlertDialog.Builder(view.this);
       myDialog.setTitle("Delete?");
       myDialog.setPositiveButton("OK", new DialogInterface.OnClickListener() {
                   // do something when the button is clicked
                   public void onClick(DialogInterface arg0, int arg1) {
                    mySQLiteAdapter.delete_byID(item_id);
              updateList();
              Intent intent=new Intent(view.this,MainActivity.class);
        startActivity(intent);
                    }
                   });
              
               myDialog.setNegativeButton("edit", new DialogInterface.OnClickListener() {
                   // do something when the button is clicked
                   public void onClick(DialogInterface arg0, int arg1) {
                    up.id(item_id);
                  
                    Intent intent=new Intent(view.this,update.class);
        startActivity(intent);
                  
           
                    }
                   });
              
               myDialog.show();
              
     //mySQLiteAdapter.delete_byID(item_id);
     //Intent intent=new Intent(view.this,MainActivity.class);
     //startActivity(intent);
 
 
 
    }
        
   });
  }
  private void updateList(){
   cursor.requery();
     }

}


view1.java

package com.example.sd;

import android.app.Activity;
import android.content.Intent;
import android.database.Cursor;
import android.os.Bundle;
import android.view.View;
import android.widget.AdapterView;
import android.widget.ListView;
import android.widget.SimpleCursorAdapter;
import android.widget.AdapterView.OnItemClickListener;

public class view1 extends Activity{
 private database mySQLiteAdapter;
 ListView listContent;
 SimpleCursorAdapter cursorAdapter;
 Cursor cursor;
  public void onCreate(Bundle savedInstanceState) {
         super.onCreate(savedInstanceState);
         setContentView(R.layout.view1);
         listContent = (ListView)findViewById(R.id.v1l);
         mySQLiteAdapter = new database(this);
         mySQLiteAdapter.openToWrite();

         cursor = mySQLiteAdapter.queueAll1();
       
         String[] from = new String[]{database.KEY_ID1, database.MID, database.MSID,database.SUB,database.MARK};
         int[] to = new int[]{R.id.r1id, R.id.r1t1, R.id.r1t2,R.id.r1t3,R.id.r1t4};
         cursorAdapter =
          new SimpleCursorAdapter(this, R.layout.row1, cursor, from, to);
         listContent.setAdapter(cursorAdapter);
         listContent.setOnItemClickListener(new OnItemClickListener() {

    public void onItemClick(AdapterView<?> arg0, View arg1,
      int arg2, long arg3) {
     // TODO Auto-generated method stub
     System.out.println("pos="+arg2);
     Cursor cursor = (Cursor) arg0.getItemAtPosition(arg2);
     final int item_id = cursor.getInt(cursor.getColumnIndex(database.KEY_ID1));
     System.out.println("id="+item_id);
     mySQLiteAdapter.delete_byID(item_id);
     Intent intent=new Intent(view1.this,MainActivity.class);
     startActivity(intent);
 
 
 
    }
        
   });
  }

}


 LAYOUT

 



 activity_main.xml
 <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" >
    <TextView
        android:id="@+id/textView1"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignParentLeft="true"
        android:layout_alignParentTop="true"
        android:text="STUDENT DETAIS" />
    <TextView
        android:id="@+id/textView1"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignParentRight="true"
        android:layout_alignParentTop="true"
        android:layout_marginRight="47dp"
        android:text="MARK DETAIS" />
    <Button
        android:id="@+id/badd"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignParentLeft="true"
        android:layout_below="@+id/textView1"
        android:layout_marginLeft="20dp"
        android:layout_marginTop="18dp"
        android:text="ADD" />
    <Button
        android:id="@+id/bview"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignRight="@+id/badd"
        android:layout_below="@+id/badd"
        android:text="VIEW" />
    <Button
        android:id="@+id/mbadd"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignBottom="@+id/badd"
        android:layout_alignLeft="@+id/textView1"
        android:text="ADD" />
    <Button
        android:id="@+id/mbview"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignBaseline="@+id/bview"
        android:layout_alignBottom="@+id/bview"
        android:layout_alignRight="@+id/mbadd"
        android:text="VIEW" />
</RelativeLayout>
insert.xml
<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" >
    <TextView
        android:id="@+id/i1"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignParentLeft="true"
        android:layout_alignParentTop="true"
        android:layout_marginLeft="48dp"
        android:layout_marginTop="16dp"
        android:text="STUDENT DETAIS" />
    <EditText
        android:id="@+id/ie3"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignParentLeft="true"
        android:layout_below="@+id/i1"
        android:layout_marginTop="20dp"
        android:ems="10" />
    <EditText
        android:id="@+id/ie2"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignParentLeft="true"
        android:layout_below="@+id/ie3"
        android:ems="10" />
    <EditText
        android:id="@+id/ie1"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignParentLeft="true"
        android:layout_below="@+id/ie2"
        android:ems="10" >
        <requestFocus />
    </EditText>
    <Button
        android:id="@+id/ib"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_centerHorizontal="true"
        android:layout_centerVertical="true"
        android:text="OK" />
    <Button
        android:id="@+id/ib1"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignBottom="@+id/ib"
        android:layout_alignParentLeft="true"
        android:text="cancel" />
</RelativeLayout>
insert1.xml
<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" >
    <Button
        android:id="@+id/i1b"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignParentBottom="true"
        android:layout_centerHorizontal="true"
        android:layout_marginBottom="168dp"
        android:text="OK" />
    <Button
        android:id="@+id/i1b1"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignBaseline="@+id/i1b"
        android:layout_alignBottom="@+id/i1b"
        android:layout_alignParentLeft="true"
        android:text="cancel" />
    <TextView
        android:id="@+id/i11"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignParentTop="true"
        android:layout_alignRight="@+id/i1b"
        android:layout_marginRight="30dp"
        android:layout_marginTop="22dp"
        android:text="STUDENT DETAIS" />
    <EditText
        android:id="@+id/i1e1"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_above="@+id/i1b"
        android:layout_alignParentLeft="true"
        android:ems="10" >
        <requestFocus />
    </EditText>
    <EditText
        android:id="@+id/i1e2"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_above="@+id/i1e1"
        android:layout_alignParentLeft="true"
        android:ems="10" />
    <EditText
        android:id="@+id/i1e3"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_above="@+id/i1e2"
        android:layout_alignParentLeft="true"
        android:layout_marginBottom="19dp"
        android:ems="10" />
    <EditText
        android:id="@+id/i1e4"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignParentLeft="true"
        android:layout_below="@+id/i1"
        android:layout_marginTop="15dp"
        android:ems="10" />
</RelativeLayout>
row.xml
<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
    android:orientation="vertical"
 android:layout_width="fill_parent"
 android:layout_height="wrap_content">
<LinearLayout
    android:orientation="horizontal"
 android:layout_width="fill_parent"
 android:layout_height="wrap_content">
<TextView
 android:id="@+id/rid"
 android:layout_width="wrap_content"
 android:layout_height="fill_parent"
 android:padding="2dip"
 android:paddingRight="10dip"/>
<TextView
    android:id="@+id/rt1"
    android:layout_width="84dp"
    android:layout_height="fill_parent"
    android:padding="2dip"
    android:paddingRight="10dip" />

<TextView
    android:id="@+id/rt2"
    android:layout_width="110dp"
    android:layout_height="fill_parent"
    android:padding="2dip" />
<TextView
    android:id="@+id/rt3"
    android:layout_width="fill_parent"
    android:layout_height="wrap_content"
    android:padding="2dip" />
</LinearLayout>
</LinearLayout>
row1.xml
<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
    android:orientation="vertical"
 android:layout_width="fill_parent"
 android:layout_height="wrap_content">

    <LinearLayout
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:orientation="horizontal" >
        <TextView
            android:id="@+id/r1id"
            android:layout_width="wrap_content"
            android:layout_height="fill_parent"
            android:padding="2dip"
            android:paddingRight="10dip" />
        <TextView
            android:id="@+id/r1t1"
            android:layout_width="73dp"
            android:layout_height="fill_parent"
            android:padding="2dip"
            android:paddingRight="10dip" />
        <TextView
            android:id="@+id/r1t2"
            android:layout_width="81dp"
            android:layout_height="fill_parent"
            android:padding="2dip" />
        <TextView
            android:id="@+id/r1t3"
            android:layout_width="52dp"
            android:layout_height="wrap_content"
            android:padding="2dip" />
        <TextView
            android:id="@+id/r1t4"
            android:layout_width="83dp"
            android:layout_height="wrap_content"
            android:text="TextView" />
    </LinearLayout>
</LinearLayout>
sdetails.xml
<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
    android:orientation="vertical"
    android:layout_width="fill_parent"
    android:layout_height="fill_parent"
    >
<TextView 
    android:layout_width="fill_parent"
    android:layout_height="wrap_content"
    android:text="STUDENT DETAILS"
    />
<TextView 
    android:layout_width="fill_parent"
    android:layout_height="wrap_content"
    android:text="       S_ID        S_NAME          S_ROLL"    />
<ListView
 android:id="@+id/sdvl"
 android:layout_width="fill_parent"
 android:layout_height="fill_parent"/>
</LinearLayout>
sdrow.xml
<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
    android:orientation="vertical"
 android:layout_width="fill_parent"
 android:layout_height="wrap_content">
<LinearLayout
    android:orientation="horizontal"
 android:layout_width="fill_parent"
 android:layout_height="wrap_content">
<TextView
 android:id="@+id/sdrid"
 android:layout_width="wrap_content"
 android:layout_height="fill_parent"
 android:padding="2dip"
 android:paddingRight="10dip"/>
<TextView
    android:id="@+id/sdrt1"
    android:layout_width="84dp"
    android:layout_height="fill_parent"
    android:padding="2dip"
    android:paddingRight="10dip" />

<TextView
    android:id="@+id/sdrt2"
    android:layout_width="110dp"
    android:layout_height="fill_parent"
    android:padding="2dip" />
<TextView
    android:id="@+id/sdrt3"
    android:layout_width="fill_parent"
    android:layout_height="wrap_content"
    android:padding="2dip" />
</LinearLayout>
</LinearLayout>
upadate.xml
<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" >
    <TextView
        android:id="@+id/i1"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignParentLeft="true"
        android:layout_alignParentTop="true"
        android:layout_marginLeft="48dp"
        android:layout_marginTop="16dp"
        android:text="UPDATE STUDENT DETAIS" />
    <Button
        android:id="@+id/aib"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_centerHorizontal="true"
        android:layout_centerVertical="true"
        android:text="OK" />
    <Button
        android:id="@+id/aib1"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignParentLeft="true"
        android:layout_centerVertical="true"
        android:layout_marginLeft="21dp"
        android:text="cancel" />
    <EditText
        android:id="@+id/aie3"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_above="@+id/aib"
        android:layout_alignParentLeft="true"
        android:layout_marginBottom="24dp"
        android:ems="10" />
    <EditText
        android:id="@+id/aie1"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_above="@+id/aie3"
        android:layout_alignParentLeft="true"
        android:ems="10" />
    <EditText
        android:id="@+id/aie2"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_above="@+id/aie1"
        android:layout_alignParentLeft="true"
        android:layout_marginBottom="14dp"
        android:ems="10" >
        <requestFocus />
    </EditText>
</RelativeLayout>
view.xml
<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
    android:orientation="vertical"
    android:layout_width="fill_parent"
    android:layout_height="fill_parent"
    >
<TextView 
    android:layout_width="fill_parent"
    android:layout_height="wrap_content"
    android:text="STUDENT DETAILS"
    />
<TextView 
    android:layout_width="fill_parent"
    android:layout_height="wrap_content"
    android:text="       S_ID        S_NAME          S_ROLL"    />
<ListView
 android:id="@+id/vl"
 android:layout_width="fill_parent"
 android:layout_height="fill_parent"/>
</LinearLayout>
view1.xml
<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
    android:orientation="vertical"
    android:layout_width="fill_parent"
    android:layout_height="fill_parent"
    >
<TextView 
    android:layout_width="fill_parent"
    android:layout_height="wrap_content"
    android:text="STUDENT DETAILS"
    />
<TextView 
    android:layout_width="fill_parent"
    android:layout_height="wrap_content"
    android:text="       M_ID         S_ID          SUB           MARK"    />

<ListView
 android:id="@+id/v1l"
 android:layout_width="fill_parent"
 android:layout_height="fill_parent"/>
</LinearLayout>