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
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;
}
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;
<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>
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;
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);
}
});
}
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;
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 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 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);
}
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);
}
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
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;
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);
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();
}
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;
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);
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();
}
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;
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;
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();
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);
}
}
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;
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;
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);
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();
}
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;
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();
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() {
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) {
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() {
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();
}
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();
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() {
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);
}
});
}
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>
Hey can u sed me the code please
ReplyDeleteGreat Work sir.. Can you send me the source code please.
ReplyDeleteswapnil18_1991@yahoo.in
did u need?
ReplyDeletehttp://downloads.ziddu.com/download/21049442/multipletablesinonedatabase.zip.html/eng
ReplyDeletegood
ReplyDelete