ramsandroid: SQLiteDatabase in Android(2)

homepage.xml:

<?xml version="1.0" encoding="utf-8"?>

<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"

android:layout_width="match_parent"

android:layout_height="match_parent"

android:orientation="vertical" >

<TextView

android:id="@+id/textView1"

android:layout_width="wrap_content"

android:layout_height="wrap_content"

android:layout_marginLeft="5dp"

android:text="Welcome to student database management system"

android:textAppearance="?android:attr/textAppearanceLarge" />

<Button

android:id="@+id/insertbutton"

android:layout_width="130dp"

android:layout_height="wrap_content"

android:layout_gravity="center"

android:layout_marginTop="20dp"

android:text="Insert"

android:textSize="20dp" />

<Button

android:id="@+id/viewbutton"

android:layout_width="130dp"

android:layout_height="wrap_content"

android:layout_gravity="center"

android:layout_marginTop="20dp"

android:text="View"

android:textSize="20dp" />

</LinearLayout>

insert.xml:

<?xml version="1.0" encoding="utf-8"?>

<ScrollView xmlns:android="http://schemas.android.com/apk/res/android"

android:layout_width="match_parent"

android:layout_height="match_parent" >

<LinearLayout

android:layout_width="match_parent"

android:layout_height="match_parent"

android:orientation="vertical" >

<TextView

android:layout_width="wrap_content"

android:layout_height="wrap_content"

android:text="Enter student name"

android:textAppearance="?android:attr/textAppearanceLarge" />

<EditText

android:id="@+id/studenteditText"

android:layout_width="match_parent"

android:layout_height="wrap_content"

android:ems="10" >

</EditText>

<TextView

android:layout_width="wrap_content"

android:layout_height="wrap_content"

android:text="Enter student rollnumber"

android:textAppearance="?android:attr/textAppearanceLarge" />

<EditText

android:id="@+id/rollnumbereditText"

android:layout_width="match_parent"

android:layout_height="wrap_content"

android:ems="10" >

</EditText>

<TextView

android:layout_width="wrap_content"

android:layout_height="wrap_content"

android:text="Enter student mobile number"

android:textAppearance="?android:attr/textAppearanceLarge" />

<EditText

android:id="@+id/studentmobilenoeditText"

android:layout_width="match_parent"

android:layout_height="wrap_content"

android:ems="10" >

</EditText>

<TextView

android:layout_width="wrap_content"

android:layout_height="wrap_content"

android:text="Enter student email id"

android:textAppearance="?android:attr/textAppearanceLarge" />

<EditText

android:id="@+id/studentemailideditText"

android:layout_width="match_parent"

android:layout_height="wrap_content"

android:ems="10" />

<TextView

android:layout_width="wrap_content"

android:layout_height="wrap_content"

android:text="Enter branch"

android:textAppearance="?android:attr/textAppearanceLarge" />

<EditText

android:id="@+id/studentbrancheditText"

android:layout_width="match_parent"

android:layout_height="wrap_content"

android:ems="10" >

</EditText>

<RadioGroup

android:id="@+id/genderradioGroup"

android:layout_width="wrap_content"

android:layout_height="wrap_content"

android:layout_gravity="center"

android:orientation="horizontal" >

<RadioButton

android:id="@+id/maleradio"

android:layout_width="wrap_content"

android:layout_height="wrap_content"

android:text="Male" />

<RadioButton

android:id="@+id/femaleradio"

android:layout_width="wrap_content"

android:layout_height="wrap_content"

android:text="Female" />

</RadioGroup>

<TableRow

android:id="@+id/tableRow1"

android:layout_width="match_parent"

android:layout_height="wrap_content" >

<Button

android:id="@+id/savebutton"

android:layout_width="wrap_content"

android:layout_height="wrap_content"

android:layout_weight="1"

android:text="Save" />

<Button

android:id="@+id/cancelbutton"

android:layout_width="wrap_content"

android:layout_height="wrap_content"

android:layout_weight="1"

android:text="Cancel" />

</TableRow>

</LinearLayout>

</ScrollView>

viewhistory.xml:

<?xml version="1.0" encoding="utf-8"?>

<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"

android:layout_width="match_parent"

android:layout_height="match_parent"

android:orientation="vertical" >

<ListView

android:id="@+id/listView1"

android:layout_width="match_parent"

android:layout_height="wrap_content" >

</ListView>

</LinearLayout>

update.xml:

<?xml version="1.0" encoding="utf-8"?>

<ScrollView xmlns:android="http://schemas.android.com/apk/res/android"

android:layout_width="match_parent"

android:layout_height="match_parent" >

<LinearLayout

android:layout_width="match_parent"

android:layout_height="match_parent"

android:orientation="vertical" >

<TextView

android:layout_width="wrap_content"

android:layout_height="wrap_content"

android:text="Enter student name"

android:textAppearance="?android:attr/textAppearanceLarge" />

<EditText

android:id="@+id/updatestudenteditText"

android:layout_width="match_parent"

android:layout_height="wrap_content"

android:ems="10" >

</EditText>

<TextView

android:layout_width="wrap_content"

android:layout_height="wrap_content"

android:text="Enter student rollnumber"

android:textAppearance="?android:attr/textAppearanceLarge" />

<EditText

android:id="@+id/updaterollnumbereditText"

android:layout_width="match_parent"

android:layout_height="wrap_content"

android:ems="10" >

</EditText>

<TextView

android:layout_width="wrap_content"

android:layout_height="wrap_content"

android:text="Enter student mobile number"

android:textAppearance="?android:attr/textAppearanceLarge" />

<EditText

android:id="@+id/updatestudentmobilenoeditText"

android:layout_width="match_parent"

android:layout_height="wrap_content"

android:ems="10" >

</EditText>

<TextView

android:layout_width="wrap_content"

android:layout_height="wrap_content"

android:text="Enter student email id"

android:textAppearance="?android:attr/textAppearanceLarge" />

<EditText

android:id="@+id/updatestudentemailideditText"

android:layout_width="match_parent"

android:layout_height="wrap_content"

android:ems="10" />

<TextView

android:layout_width="wrap_content"

android:layout_height="wrap_content"

android:text="Enter branch"

android:textAppearance="?android:attr/textAppearanceLarge" />

<EditText

android:id="@+id/updatestudentbrancheditText"

android:layout_width="match_parent"

android:layout_height="wrap_content"

android:ems="10" >

</EditText>

<RadioGroup

android:id="@+id/updategenderradioGroup"

android:layout_width="wrap_content"

android:layout_height="wrap_content"

android:layout_gravity="center"

android:orientation="horizontal" >

<RadioButton

android:id="@+id/maleradio"

android:layout_width="wrap_content"

android:layout_height="wrap_content"

android:text="Male" />

<RadioButton

android:id="@+id/femaleradio"

android:layout_width="wrap_content"

android:layout_height="wrap_content"

android:text="Female" />

</RadioGroup>

<TableRow

android:id="@+id/tableRow1"

android:layout_width="match_parent"

android:layout_height="wrap_content" >

<Button

android:id="@+id/updatesavebutton"

android:layout_width="wrap_content"

android:layout_height="wrap_content"

android:layout_weight="1"

android:text="Update" />

<Button

android:id="@+id/updatecancelbutton"

android:layout_width="wrap_content"

android:layout_height="wrap_content"

android:layout_weight="1"

android:text="Cancel" />

</TableRow>

</LinearLayout>

</ScrollView>

custom.xml:

<?xml version="1.0" encoding="utf-8"?>

<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"

android:layout_width="match_parent"

android:layout_height="match_parent"

android:orientation="vertical" >

<TextView

android:id="@+id/idtextview"

android:layout_width="wrap_content"

android:layout_height="wrap_content"

android:text=" "

android:textAppearance="?android:attr/textAppearanceLarge" />

<TextView

android:id="@+id/studentnametextview"

android:layout_width="wrap_content"

android:layout_height="wrap_content"

android:text=" "

android:textAppearance="?android:attr/textAppearanceLarge" />

<TextView

android:id="@+id/rollnumbertextView"

android:layout_width="wrap_content"

android:layout_height="wrap_content"

android:text=" "

android:textAppearance="?android:attr/textAppearanceLarge" />

<TextView

android:id="@+id/mobilenumbertextview"

android:layout_width="wrap_content"

android:layout_height="wrap_content"

android:text=" "

android:textAppearance="?android:attr/textAppearanceLarge" />

<TextView

android:id="@+id/emailidtextview"

android:layout_width="wrap_content"

android:layout_height="wrap_content"

android:text=" "

android:textAppearance="?android:attr/textAppearanceLarge" />

<TextView

android:id="@+id/branchtextview"

android:layout_width="wrap_content"

android:layout_height="wrap_content"

android:text=" "

android:textAppearance="?android:attr/textAppearanceLarge" />

<TextView

android:id="@+id/gendertextview"

android:layout_width="wrap_content"

android:layout_height="wrap_content"

android:text=" "

android:textAppearance="?android:attr/textAppearanceLarge" />

</LinearLayout>

StudentDatabase.java:

package com.studentdbmsys.ram;

import android.content.ContentValues;

import android.content.Context;

import android.database.Cursor;

import android.database.sqlite.SQLiteDatabase;

import android.database.sqlite.SQLiteOpenHelper;

import android.widget.Toast;

public class StudentDatabase {

public static final String DATABASE_NAME = "studentdatabase";

public static final String TABLE_NAME = "studenttable";

public static final int DATABASE_VERSION = 1;

public static final String COL_ROWID = "rowid";

public static final String COL_STUDENTNAME = "studentname";

public static final String COL_ROLLNO = "rollno";

public static final String COL_MOBILENUMBER = "mobilenumber";

public static final String COL_EMAILID = "emailid";

public static final String COL_BRANCH = "branch";

public static final String COL_GENDER = "gender";

String CREATE_TABLE = "create table studenttable(rowid integer primary key autoincrement,studentname text not null,rollno text not null,mobilenumber text not null,emailid text not null,branch text not null,gender text not null)";

Context context;

SQLiteDatabase db;

DBHelper dbHelper;

public StudentDatabase(Context c) {

// TODO Auto-generated constructor stub

this.context = c;

dbHelper = new DBHelper(context);

}

StudentDatabase open() {

db = dbHelper.getWritableDatabase();

System.out.println("database opened....");

return this;

}

void close() {

dbHelper.close();

System.out.println("database closed......");

}

void insertValues(String studentname, String rollno, String mobilenumber,

String emailid, String branch, String gender) {

ContentValues con = new ContentValues();

con.put(COL_STUDENTNAME, studentname);

con.put(COL_ROLLNO, rollno);

con.put(COL_MOBILENUMBER, mobilenumber);

con.put(COL_EMAILID, emailid);

con.put(COL_BRANCH, branch);

con.put(COL_GENDER, gender);

System.out.println("values inseted.......");

db.insert(TABLE_NAME, null, con);

}

Cursor getAllValues() {

String[] columns = { COL_ROWID, COL_STUDENTNAME, COL_ROLLNO,

COL_MOBILENUMBER, COL_EMAILID, COL_BRANCH, COL_GENDER };

return db.query(TABLE_NAME, columns, null, null, null, null, null);

}

void deleteAllRecords() {

db.delete(TABLE_NAME, null, null);

}

void deleteOneRecord(String rowid) {

db.delete(TABLE_NAME, rowid + "=" + COL_ROWID, null);

}

long upDateRecord(String rowid, String studentname, String rollno,

String mobilenumber, String emailid, String branch, String gender) {

Toast.makeText(context, studentname, 3000).show();

ContentValues con = new ContentValues();

con.put(COL_STUDENTNAME, studentname);

con.put(COL_ROLLNO, rollno);

con.put(COL_MOBILENUMBER, mobilenumber);

con.put(COL_EMAILID, emailid);

con.put(COL_BRANCH, branch);

con.put(COL_GENDER, gender);

System.out.println("values Updated successfully.......");

return db.update(TABLE_NAME, con, rowid + "=" + COL_ROWID, null);

}

class DBHelper extends SQLiteOpenHelper {

public DBHelper(Context context) {

super(context, DATABASE_NAME, null, DATABASE_VERSION);

// TODO Auto-generated constructor stub

}

@Override

public void onCreate(SQLiteDatabase db) {

// TODO Auto-generated method stub

db.execSQL(CREATE_TABLE);

System.out.println("studenttable created....");

}

@Override

public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

// TODO Auto-generated method stub

}

HomePage.java:

package com.studentdbmsys.ram;

import android.app.Activity;
import android.content.Intent;
import android.os.Bundle;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;

public class HomePage extends Activity {
@Override
protected void onCreate(Bundle savedInstanceState) {
// TODO Auto-generated method stub
super.onCreate(savedInstanceState);
setContentView(R.layout.homepage);

Button insertButton = (Button) findViewById(R.id.insertbutton);

insertButton.setOnClickListener(new OnClickListener() {

@Override
public void onClick(View v) {
// TODO Auto-generated method stub
startActivity(new Intent(getApplicationContext(), Insert.class));
}
});
Button viewHistory = (Button)findViewById(R.id.viewbutton);

viewHistory.setOnClickListener(new OnClickListener() {

@Override
public void onClick(View v) {
// TODO Auto-generated method stub
startActivity(new Intent(getApplicationContext(), ViewHistory.class));

}
});

}
}

Insert.java:

package com.studentdbmsys.ram;

import android.app.Activity;
import android.content.Intent;
import android.os.Bundle;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.EditText;
import android.widget.RadioButton;
import android.widget.RadioGroup;
import android.widget.Toast;

public class Insert extends Activity {
EditText studentname, rollno, mobileno, emailid, branch;
RadioGroup genderGroup;
Button saveButton, cancelButton;
StudentDatabase db;

@Override
protected void onCreate(Bundle savedInstanceState) {
// TODO Auto-generated method stub
super.onCreate(savedInstanceState);
setContentView(R.layout.insert);

db = new StudentDatabase(this);
db.open();

studentname = (EditText) findViewById(R.id.studenteditText);
rollno = (EditText) findViewById(R.id.rollnumbereditText);
mobileno = (EditText) findViewById(R.id.studentmobilenoeditText);
emailid = (EditText) findViewById(R.id.studentemailideditText);
branch = (EditText) findViewById(R.id.studentbrancheditText);

genderGroup = (RadioGroup) findViewById(R.id.genderradioGroup);

saveButton = (Button) findViewById(R.id.savebutton);
cancelButton = (Button) findViewById(R.id.cancelbutton);

saveButton.setOnClickListener(new OnClickListener() {

@Override
public void onClick(View v) {
// TODO Auto-generated method stub
String sname = studentname.getText().toString();
String srollno = rollno.getText().toString();
String smobileno = mobileno.getText().toString();
String smailid = emailid.getText().toString();
String sbranch = branch.getText().toString();

int selectedGenderID = genderGroup.getCheckedRadioButtonId();

RadioButton selectedGender = (RadioButton) findViewById(selectedGenderID);

String gender = selectedGender.getText().toString();

db.insertValues(sname, srollno, smobileno, smailid, sbranch,
gender);

Toast.makeText(getApplicationContext(), "saved successfulluy",
3000).show();

db.close();

finish();

startActivity(new Intent(getApplicationContext(),
HomePage.class));
}
});
cancelButton.setOnClickListener(new OnClickListener() {

@Override
public void onClick(View v) {
// TODO Auto-generated method stub
startActivity(new Intent(getApplicationContext(),
HomePage.class));
}
});
}
}

ViewHistory.java:

package com.studentdbmsys.ram;

import android.app.Activity;
import android.content.Context;
import android.content.Intent;
import android.database.Cursor;
import android.os.Bundle;
import android.view.ContextMenu;
import android.view.LayoutInflater;
import android.view.Menu;
import android.view.MenuInflater;
import android.view.MenuItem;
import android.view.View;
import android.view.ViewGroup;
import android.view.ContextMenu.ContextMenuInfo;
import android.widget.AdapterView;
import android.widget.AdapterView.OnItemLongClickListener;
import android.widget.BaseAdapter;
import android.widget.ListView;
import android.widget.TextView;
import android.widget.Toast;

public class ViewHistory extends Activity {
StudentDatabase db;
ListView studentList;
StudentAdapter studentAdapter;
Cursor c;
int position;

@Override
protected void onCreate(Bundle savedInstanceState) {
// TODO Auto-generated method stub
super.onCreate(savedInstanceState);
setContentView(R.layout.viewhistory);
db = new StudentDatabase(this);
db.open();

studentList = (ListView) findViewById(R.id.listView1);

updateList();

registerForContextMenu(studentList);

studentList.setOnItemLongClickListener(new OnItemLongClickListener() {

@Override
public boolean onItemLongClick(AdapterView<?> arg0, View arg1,
int pos, long arg3) {
position = pos;
// TODO Auto-generated method stub
return false;
}
});

}

@Override
public boolean onCreateOptionsMenu(Menu menu) {
menu.add("delete all history");
return super.onCreateOptionsMenu(menu);
}

@Override
protected void onResume() {
// TODO Auto-generated method stub
updateList();
super.onResume();
}

@Override
public boolean onOptionsItemSelected(MenuItem item) {
// TODO Auto-generated method stub
db.deleteAllRecords();
Toast.makeText(getApplicationContext(), "data deleted successfully",
3000).show();
updateList();

return super.onOptionsItemSelected(item);
}

@Override
public void onCreateContextMenu(ContextMenu menu, View v,
ContextMenuInfo menuInfo) {
// TODO Auto-generated method stub
MenuInflater inflater = getMenuInflater();
inflater.inflate(R.menu.activity_main, menu);
super.onCreateContextMenu(menu, v, menuInfo);
}

@Override
public boolean onContextItemSelected(MenuItem item) {
// TODO Auto-generated method stub
switch (item.getItemId()) {
case R.id.item1:
c.moveToPosition(position);
db.deleteOneRecord(c.getString(0));
updateList();
break;

case R.id.item2:
c.moveToPosition(position);
String rowidposition = c.getString(0);
int rowid = Integer.parseInt(rowidposition);
Bundle b = new Bundle();
b.putInt("recordposition", rowid);
startActivity(new Intent(getApplicationContext(),
UpDateRecord.class).putExtras(b));
break;
}
return super.onContextItemSelected(item);
}

class StudentAdapter extends BaseAdapter {
Context context;

public StudentAdapter(Context c) {
this.context = c;

}

@Override
public int getCount() {
// TODO Auto-generated method stub
return c.getCount();
}

@Override
public Object getItem(int position) {
// TODO Auto-generated method stub
return null;
}

@Override
public long getItemId(int position) {
// TODO Auto-generated method stub
return 0;
}

@Override
public View getView(int position, View convertView, ViewGroup parent) {

LayoutInflater inflater = getLayoutInflater();
convertView = inflater.inflate(R.layout.custom, null);

TextView t1 = (TextView) convertView.findViewById(R.id.idtextview);
TextView t2 = (TextView) convertView
.findViewById(R.id.studentnametextview);
TextView t3 = (TextView) convertView
.findViewById(R.id.rollnumbertextView);
TextView t4 = (TextView) convertView
.findViewById(R.id.mobilenumbertextview);
TextView t5 = (TextView) convertView
.findViewById(R.id.emailidtextview);
TextView t6 = (TextView) convertView
.findViewById(R.id.branchtextview);
TextView t7 = (TextView) convertView
.findViewById(R.id.gendertextview);

c.moveToPosition(position);

t1.setText(c.getString(0));
t2.setText(c.getString(1));
t3.setText(c.getString(2));
t4.setText(c.getString(3));
t5.setText(c.getString(4));
t6.setText(c.getString(5));
t7.setText(c.getString(6));

return convertView;
}

}

void updateList() {
c = db.getAllValues();

studentAdapter = new StudentAdapter(this);
studentList.setAdapter(studentAdapter);

}

@Override
protected void onDestroy() {
// TODO Auto-generated method stub
db.close();
super.onDestroy();
}

}

UpDateRecord.java:

package com.studentdbmsys.ram;

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.RadioButton;

import android.widget.RadioGroup;

import android.widget.Toast;

public class UpDateRecord extends Activity {

EditText studentname, rollno, mobileno, emailid, branch;

RadioGroup genderGroup;

Button updatesaveButton, updatecancelButton;

StudentDatabase db;

String rowid;

@Override

protected void onCreate(Bundle savedInstanceState) {

// TODO Auto-generated method stub

super.onCreate(savedInstanceState);

setContentView(R.layout.update);

db = new StudentDatabase(this);

db.open();

Intent in = getIntent();

Bundle b = in.getExtras();

final int recordPosition = b.getInt("recordposition");

rowid = Integer.toString(recordPosition);

Toast.makeText(getApplicationContext(), rowid, 3000).show();

studentname = (EditText) findViewById(R.id.updatestudenteditText);

rollno = (EditText) findViewById(R.id.updaterollnumbereditText);

mobileno = (EditText) findViewById(R.id.updatestudentmobilenoeditText);

emailid = (EditText) findViewById(R.id.updatestudentemailideditText);

branch = (EditText) findViewById(R.id.updatestudentbrancheditText);

genderGroup = (RadioGroup) findViewById(R.id.updategenderradioGroup);

updatesaveButton = (Button) findViewById(R.id.updatesavebutton);

updatecancelButton = (Button) findViewById(R.id.updatecancelbutton);

updatesaveButton.setOnClickListener(new OnClickListener() {

@Override

public void onClick(View v) {

// TODO Auto-generated method stub

String sname = studentname.getText().toString();

String srollno = rollno.getText().toString();

String smobileno = mobileno.getText().toString();

String smailid = emailid.getText().toString();

String sbranch = branch.getText().toString();

int selectedGenderID = genderGroup.getCheckedRadioButtonId();

RadioButton selectedGender = (RadioButton) findViewById(selectedGenderID);

String gender = selectedGender.getText().toString();

db.upDateRecord(rowid, sname, srollno, smobileno, smailid,

sbranch, gender);

Toast.makeText(getApplicationContext(),

"updated successfulluy", 3000).show();

db.close();

finish();

startActivity(new Intent(getApplicationContext(),

ViewHistory.class));

}

});

updatecancelButton.setOnClickListener(new OnClickListener() {

@Override

public void onClick(View v) {

// TODO Auto-generated method stub

startActivity(new Intent(getApplicationContext(),

ViewHistory.class));

}

});

}

AndroidManifest.xml:

<manifest xmlns:android="http://schemas.android.com/apk/res/android"

package="com.studentdbmsys.ram"

android:versionCode="1"

android:versionName="1.0" >

<uses-sdk

android:minSdkVersion="8"

android:targetSdkVersion="15" />

<application

android:icon="@drawable/ic_launcher"

android:label="@string/app_name"

android:theme="@style/AppTheme" >

<activity

android:name=".HomePage"

android:label="@string/title_activity_main" >

<intent-filter>

</intent-filter>

</activity>

</application>

</manifest>

ramsandroid

Sunday, 27 January 2013

SQLiteDatabase in Android(2)

2 comments: