I have created 3 tables in sqlite database i.e 1) College (contains college name, address & contact info), 2) Course (contains all courses with course stream) & 3) CollegeCourse (contains Courses of a particular college). I want to retrieve college name from a database by searching it and displaying it in a listview after the college names will get displayed in a listview and then clicking on a particular college it should retrieve a particular college information in a new activity. please contibute this code i am new to android.
Layout:
<EditText
android:id="@+id/editText1"
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:ems="10"
android:hint="@string/searchtext" >
<requestFocus />
</EditText>
<ListView
android:id="@+id/listView1"
android:layout_width="match_parent"
android:layout_height="match_parent" >
</ListView>
</LinearLayout>
MainActivity.java:
package com.android.collegefinder;
import android.app.Activity;
import android.content.Intent;
import android.os.Bundle;
import android.view.Menu;
import android.view.MenuItem;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
public class MainActivity extends Activity implements OnClickListener{
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
Button b = (Button) findViewById(R.id.searchcollegebtn);
b.setOnClickListener(this);
CollegeTable db = new CollegeTable(this);
db.addCollege(new College(1, "Smt. Chandibai Himathmal Mansukhani College", "Opp. Railway Station, Smt.Chandibai Himathmal Mansukhani road", "Ulhasnagar", "Maharashtra", "421003", "02512734940", "B++", "Dr. Charanjit Kaur Singh", "principalchmc@gmail.com", "www.chm.edu"));
db.addCollege(new College(2, "Vivekanand Education Society's College of Arts, Science & Commerce", "Sindhi Society, Chembur", "Mumbai", "Maharashtra", "400071", "25227470/25284132", "A", "Dr. (Mrs.) J.K. Phadnis", "vesinfo@http://ift.tt/1APTlNv", "www.vesasc.org"));
db.getAllColleges();
db.addCourse(new Course(1, "Economics", "N/A", "Arts", "3", 0));
db.addCourse(new Course(2, "English", "N/A", "Arts", "3", 0));
db.addCourse(new Course(3, "Geography", "N/A", "Arts", "3", 0));
db.addCourse(new Course(4, "Hindi", "N/A", "Arts", "3", 0));
db.addCourse(new Course(5, "History", "N/A", "Arts", "3", 0));
db.addCourse(new Course(6, "Marathi", "N/A", "Arts", "3", 0));
db.addCourse(new Course(7, "Pol. Science", "N/A", "Arts", "3", 0));
db.addCourse(new Course(8, "Psychology", "N/A", "Arts", "3", 0));
db.addCourse(new Course(9, "Sindhi", "N/A", "Arts", "3", 0));
db.addCourse(new Course(10, "Sociology", "N/A", "Arts", "3", 0));
db.addCourse(new Course(11, "Accounts", "N/A", "Commerce", "3", 0));
db.addCourse(new Course(12, "Management", "N/A", "Commerce", "3", 0));
db.addCourse(new Course(13, "Botany", "N/A", "Science", "3", 0));
db.addCourse(new Course(14, "Chemistry", "N/A", "Science", "3", 0));
db.addCourse(new Course(15, "Mathematics", "N/A", "Science", "3", 0));
db.addCourse(new Course(16, "Microbiology", "N/A", "Science", "3", 0));
db.addCourse(new Course(17, "Phisics", "N/A", "Science", "3", 0));
db.addCourse(new Course(18, "Zoology", "N/A", "Science", "3", 0));
db.addCourse(new Course(19, "Mass Media", "N/A", "Arts", "3", 0));
db.addCourse(new Course(20, "Accounting & Finance", "N/A", "Commerce", "3", 0));
db.addCourse(new Course(21, "Banking & Insurance", "N/A", "Commerce", "3", 0));
db.addCourse(new Course(22, "Financial Markets", "N/A", "Commerce", "3", 0));
db.addCourse(new Course(23, "Management Studies", "N/A", "Commerce", "3", 0));
db.addCourse(new Course(24, "Biotechnology", "N/A", "Science", "3", 0));
db.addCourse(new Course(25, "Computer Science", "N/A", "Science", "3", 0));
db.addCourse(new Course(26, "Information Technology", "N/A", "Science", "3", 0));
db.addCourse(new Course(27, "Eco & Com", "N/A", "Arts", "3", 0));
db.addCourse(new Course(28, "B.Com", "N/A", "Commerce", "3", 0));
db.getAllCourses();
db.addCollegeCourse(new CollegeCourse(1, 1, 1, "2015-01-01 00:00:00.000", "9999-01-01 00:00:00.000", 1));
db.addCollegeCourse(new CollegeCourse(2, 1, 2, "2015-01-01 00:00:00.000", "9999-01-01 00:00:00.000", 1));
db.addCollegeCourse(new CollegeCourse(3, 1, 3, "2015-01-01 00:00:00.000", "9999-01-01 00:00:00.000", 1));
db.addCollegeCourse(new CollegeCourse(4, 1, 4, "2015-01-01 00:00:00.000", "9999-01-01 00:00:00.000", 1));
db.addCollegeCourse(new CollegeCourse(5, 1, 5, "2015-01-01 00:00:00.000", "9999-01-01 00:00:00.000", 1));
db.addCollegeCourse(new CollegeCourse(6, 1, 6, "2015-01-01 00:00:00.000", "9999-01-01 00:00:00.000", 1));
db.addCollegeCourse(new CollegeCourse(7, 1, 7, "2015-01-01 00:00:00.000", "9999-01-01 00:00:00.000", 1));
db.addCollegeCourse(new CollegeCourse(8, 1, 8, "2015-01-01 00:00:00.000", "9999-01-01 00:00:00.000", 1));
db.addCollegeCourse(new CollegeCourse(9, 1, 9, "2015-01-01 00:00:00.000", "9999-01-01 00:00:00.000", 1));
db.addCollegeCourse(new CollegeCourse(10, 1, 10, "2015-01-01 00:00:00.000", "9999-01-01 00:00:00.000", 1));
db.addCollegeCourse(new CollegeCourse(11, 1, 11, "2015-01-01 00:00:00.000", "9999-01-01 00:00:00.000", 1));
db.addCollegeCourse(new CollegeCourse(12, 1, 12, "2015-01-01 00:00:00.000", "9999-01-01 00:00:00.000", 1));
db.addCollegeCourse(new CollegeCourse(13, 1, 13, "2015-01-01 00:00:00.000", "9999-01-01 00:00:00.000", 1));
db.addCollegeCourse(new CollegeCourse(14, 1, 14, "2015-01-01 00:00:00.000", "9999-01-01 00:00:00.000", 1));
db.addCollegeCourse(new CollegeCourse(15, 1, 15, "2015-01-01 00:00:00.000", "9999-01-01 00:00:00.000", 1));
db.addCollegeCourse(new CollegeCourse(16, 1, 16, "2015-01-01 00:00:00.000", "9999-01-01 00:00:00.000", 1));
db.addCollegeCourse(new CollegeCourse(17, 1, 17, "2015-01-01 00:00:00.000", "9999-01-01 00:00:00.000", 1));
db.addCollegeCourse(new CollegeCourse(18, 1, 18, "2015-01-01 00:00:00.000", "9999-01-01 00:00:00.000", 1));
db.addCollegeCourse(new CollegeCourse(19, 1, 19, "2015-01-01 00:00:00.000", "9999-01-01 00:00:00.000", 1));
db.addCollegeCourse(new CollegeCourse(20, 1, 20, "2015-01-01 00:00:00.000", "9999-01-01 00:00:00.000", 1));
db.addCollegeCourse(new CollegeCourse(21, 1, 21, "2015-01-01 00:00:00.000", "9999-01-01 00:00:00.000", 1));
db.addCollegeCourse(new CollegeCourse(22, 1, 22, "2015-01-01 00:00:00.000", "9999-01-01 00:00:00.000", 1));
db.addCollegeCourse(new CollegeCourse(23, 1, 23, "2015-01-01 00:00:00.000", "9999-01-01 00:00:00.000", 1));
db.addCollegeCourse(new CollegeCourse(24, 1, 24, "2015-01-01 00:00:00.000", "9999-01-01 00:00:00.000", 1));
db.addCollegeCourse(new CollegeCourse(25, 1, 25, "2015-01-01 00:00:00.000", "9999-01-01 00:00:00.000", 1));
db.addCollegeCourse(new CollegeCourse(26, 1, 26, "2015-01-01 00:00:00.000", "9999-01-01 00:00:00.000", 1));
db.addCollegeCourse(new CollegeCourse(27, 2, 1, "2015-01-01 00:00:00.000", "9999-01-01 00:00:00.000", 1));
db.addCollegeCourse(new CollegeCourse(28, 2, 8, "2015-01-01 00:00:00.000", "9999-01-01 00:00:00.000", 1));
db.addCollegeCourse(new CollegeCourse(29, 2, 10, "2015-01-01 00:00:00.000", "9999-01-01 00:00:00.000", 1));
db.addCollegeCourse(new CollegeCourse(30, 2, 27, "2015-01-01 00:00:00.000", "9999-01-01 00:00:00.000", 1));
db.addCollegeCourse(new CollegeCourse(31, 2, 17, "2015-01-01 00:00:00.000", "9999-01-01 00:00:00.000", 1));
db.addCollegeCourse(new CollegeCourse(32, 2, 14, "2015-01-01 00:00:00.000", "9999-01-01 00:00:00.000", 1));
db.addCollegeCourse(new CollegeCourse(33, 2, 16, "2015-01-01 00:00:00.000", "9999-01-01 00:00:00.000", 1));
db.addCollegeCourse(new CollegeCourse(34, 2, 28, "2015-01-01 00:00:00.000", "9999-01-01 00:00:00.000", 1));
db.addCollegeCourse(new CollegeCourse(35, 2, 19, "2015-01-01 00:00:00.000", "9999-01-01 00:00:00.000", 1));
db.addCollegeCourse(new CollegeCourse(36, 2, 25, "2015-01-01 00:00:00.000", "9999-01-01 00:00:00.000", 1));
db.addCollegeCourse(new CollegeCourse(37, 2, 24, "2015-01-01 00:00:00.000", "9999-01-01 00:00:00.000", 1));
db.addCollegeCourse(new CollegeCourse(38, 2, 26, "2015-01-01 00:00:00.000", "9999-01-01 00:00:00.000", 1));
db.addCollegeCourse(new CollegeCourse(39, 2, 23, "2015-01-01 00:00:00.000", "9999-01-01 00:00:00.000", 1));
db.addCollegeCourse(new CollegeCourse(40, 2, 21, "2015-01-01 00:00:00.000", "9999-01-01 00:00:00.000", 1));
db.addCollegeCourse(new CollegeCourse(41, 2, 22, "2015-01-01 00:00:00.000", "9999-01-01 00:00:00.000", 1));
db.addCollegeCourse(new CollegeCourse(42, 2, 15, "2015-01-01 00:00:00.000", "9999-01-01 00:00:00.000", 1));
db.getAllCollegeCourse();
}
@Override
public boolean onCreateOptionsMenu(Menu menu) {
// Inflate the menu; this adds items to the action bar if it is present.
getMenuInflater().inflate(R.menu.main, menu);
return true;
}
@Override
public boolean onOptionsItemSelected(MenuItem item) {
// Handle action bar item clicks here. The action bar will
// automatically handle clicks on the Home/Up button, so long
// as you specify a parent activity in AndroidManifest.xml.
int id = item.getItemId();
if (id == R.id.action_settings) {
return true;
}
return super.onOptionsItemSelected(item);
}
@Override
public void onClick(View v) {
if(v.getId() == R.id.searchcollegebtn) {
startActivity(new Intent(MainActivity.this, SearchCollege.class));
}
}
}
DBHandler:-
package com.android.collegefinder;
import java.util.LinkedList;
import java.util.List;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.util.Log;
public class CollegeTable extends SQLiteOpenHelper {
private static final int DATABASE_VERSION = 1;
private static final String DATABASE_NAME = "CollegeFinder";
public CollegeTable(Context context) {
super(context, DATABASE_NAME, null, DATABASE_VERSION);
}
@Override
public void onCreate(SQLiteDatabase db) {
String CREATE_COLLEGE_TABLE = "CREATE TABLE College ( " +
"college_id INTEGER PRIMARY KEY, " + "college_name TEXT, " + "college_address TEXT, " + "city TEXT, " + "state TEXT, " +
"pincode TEXT, " + "phone_number TEXT, " + "college_rating TEXT, " + "principal TEXT, " + "email TEXT, " + "website TEXT )";
String CREATE_COURSE_TABLE = "CREATE TABLE Course ( " +
"course_id INTEGER PRIMARY KEY, " + "course_name TEXT, " + "course_description TEXT, " + "course_stream TEXT, " +
"duration TEXT, " + "course_rating REAL )";
String CREATE_COLLEGECOURSE_TABLE = "CREATE TABLE CollegeCourse ( " +
"collegecourse_id INTEGER PRIMARY KEY, " + "college_id INTEGER, " + "course_id INTEGER, " + "effective_start_date TEXT, " + "effective_end_date TEXT," + "effective_flag INTEGER )";
db.execSQL(CREATE_COLLEGE_TABLE);
db.execSQL(CREATE_COURSE_TABLE);
db.execSQL(CREATE_COLLEGECOURSE_TABLE);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
db.execSQL("DROP TABLE IF EXISTS College");
this.onCreate(db);
}
private static final String TABLE_COLLEGE = "College";
private static final String KEY_COLLEGE_ID = "college_id";
private static final String KEY_COLLEGE_NAME = "college_name";
private static final String KEY_COLLEGE_ADDRESS = "college_address";
private static final String KEY_CITY = "city";
private static final String KEY_STATE = "state";
private static final String KEY_PINCODE = "pincode";
private static final String KEY_PHONE_NUMBER = "phone_number";
private static final String KEY_COLLEGE_RATING = "college_rating";
private static final String KEY_PRINCIPAL = "principal";
private static final String KEY_EMAIL = "email";
private static final String KEY_WEBSITE = "website";
private static final String[] COLUMNS = {KEY_COLLEGE_ID,KEY_COLLEGE_NAME,KEY_COLLEGE_ADDRESS,KEY_CITY,KEY_STATE,KEY_PINCODE,KEY_PHONE_NUMBER,KEY_COLLEGE_RATING,KEY_PRINCIPAL,KEY_EMAIL,KEY_WEBSITE};
public void addCollege(College college){
Log.d("addCollege", college.toString());
SQLiteDatabase db = this.getWritableDatabase();
ContentValues values = new ContentValues();
values.put(KEY_COLLEGE_ID, college.getCollegeId());
values.put(KEY_COLLEGE_NAME, college.getCollegeName());
values.put(KEY_COLLEGE_ADDRESS, college.getCollegeAddress());
values.put(KEY_CITY, college.getCity());
values.put(KEY_STATE, college.getState());
values.put(KEY_PINCODE, college.getPincode());
values.put(KEY_PHONE_NUMBER, college.getPhoneNumber());
values.put(KEY_COLLEGE_RATING, college.getCollegeRating());
values.put(KEY_PRINCIPAL, college.getPrincipal());
values.put(KEY_EMAIL, college.getEmail());
values.put(KEY_WEBSITE, college.getWebsite());
db.insert(TABLE_COLLEGE, null, values);
db.close();
}
public College getCollege(int college_id){
SQLiteDatabase db =this.getReadableDatabase();
Cursor cursor =
db.query(TABLE_COLLEGE, COLUMNS, " id = ?", new String[] { String.valueOf(college_id) }, null, null, null, null);
if (cursor != null)
cursor.moveToFirst();
College college = new College();
college.setCollegeId(Integer.parseInt(cursor.getString(0)));
college.setCollegeName(cursor.getString(1));
college.setCollegeAddress(cursor.getString(2));
college.setCity(cursor.getString(3));
college.setState(cursor.getString(4));
college.setPincode(cursor.getString(5));
college.setPhoneNumber(cursor.getString(6));
college.setCollegeRating(cursor.getString(7));
college.setPrincipal(cursor.getString(8));
college.setEmail(cursor.getString(9));
college.setWebsite(cursor.getString(10));
Log.d("getCollege("+college_id+")", college.toString());
return college;
}
public List<College> getAllColleges() {
List<College> college = new LinkedList<College>();
String query = " SELECT * FROM " + TABLE_COLLEGE;
SQLiteDatabase db = this.getWritableDatabase();
Cursor cursor = db.rawQuery(query, null);
College colleges = null;
if (cursor.moveToFirst()) {
do {
colleges = new College();
colleges.setCollegeId(Integer.parseInt(cursor.getString(0)));
colleges.setCollegeName(cursor.getString(1));
colleges.setCollegeAddress(cursor.getString(2));
colleges.setCity(cursor.getString(3));
colleges.setState(cursor.getString(4));
colleges.setPincode(cursor.getString(5));
colleges.setPhoneNumber(cursor.getString(6));
colleges.setCollegeRating(cursor.getString(7));
colleges.setPrincipal(cursor.getString(8));
colleges.setEmail(cursor.getString(9));
colleges.setWebsite(cursor.getString(10));
college.add(colleges);
} while(cursor.moveToNext());
}
Log.d("getAllColleges()", college.toString());
return college;
}
public int updateCollege (College college) {
SQLiteDatabase db = this.getWritableDatabase();
ContentValues values = new ContentValues();
values.put("college_id", college.getCollegeId());
values.put("college_name", college.getCollegeName());
values.put("college_address", college.getCollegeAddress());
values.put("city", college.getCity());
values.put("state", college.getState());
values.put("pincode", college.getPincode());
values.put("phone_number", college.getPhoneNumber());
values.put("college_rating", college.getCollegeRating());
values.put("principal", college.getPrincipal());
values.put("email", college.getEmail());
values.put("website", college.getWebsite());
int i = db.update(TABLE_COLLEGE, values, KEY_COLLEGE_ID+" = ?", new String[] { String .valueOf(college.getCollegeId()) });
db.close();
return i;
}
public void deleteCollege(College college) {
SQLiteDatabase db = this.getWritableDatabase();
db.delete(TABLE_COLLEGE, KEY_COLLEGE_ID+" = ?", new String[] { String.valueOf(college.getCollegeId()) });
db.close();
Log.d("deleteCollege()", college.toString());
}
//----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
//COURSE TABLE
private static final String TABLE_COURSE = "Course";
private static final String KEY_COURSE_ID = "course_id";
private static final String KEY_COURSE_NAME = "course_name";
private static final String KEY_COURSE_DESCRIPTION = "course_description";
private static final String KEY_COURSE_STREAM = "course_stream";
private static final String KEY_DURATION = "duration";
private static final String KEY_COURSE_RATING = "course_rating";
private static final String[] COLUMNS_COURSE = {KEY_COURSE_ID, KEY_COURSE_NAME, KEY_COURSE_DESCRIPTION, KEY_COURSE_STREAM, KEY_DURATION, KEY_COURSE_RATING};
public void addCourse(Course course){
Log.d("addCourse", course.toString());
SQLiteDatabase db = this.getWritableDatabase();
ContentValues values = new ContentValues();
values.put(KEY_COURSE_ID, course.getCourseId());
values.put(KEY_COURSE_NAME, course.getCourseName());
values.put(KEY_COURSE_DESCRIPTION, course.getCourseDescription());
values.put(KEY_COURSE_STREAM, course.getCourseStream());
values.put(KEY_DURATION, course.getDuration());
values.put(KEY_COURSE_RATING, course.getCourseRating());
db.insert(TABLE_COURSE, null, values);
db.close();
}
public Course getCourse(int course_id){
SQLiteDatabase db = this.getReadableDatabase();
Cursor cursor =
db.query(TABLE_COURSE, COLUMNS_COURSE, " id = ?", new String[] { String.valueOf(course_id) }, null, null, null, null);
if (cursor != null)
cursor.moveToFirst();
Course course = new Course();
course.setCourseId(Integer.parseInt(cursor.getString(0)));
course.setCourseName(cursor.getString(1));
course.setCourseDescription(cursor.getString(2));
course.setCourseStream(cursor.getString(3));
course.setDuration(cursor.getString(4));
course.setCourseRating(Float.parseFloat(cursor.getString(5)));
Log.d("getCourse("+course_id+")", course.toString());
return course;
}
public List<Course> getAllCourses() {
List<Course> course = new LinkedList<Course>();
String query = "SELECT * FROM " + TABLE_COURSE;
SQLiteDatabase db = this.getWritableDatabase();
Cursor cursor = db.rawQuery(query, null);
Course courses = null;
if(cursor.moveToFirst()) {
do{
courses = new Course();
courses.setCourseId(Integer.parseInt(cursor.getString(0)));
courses.setCourseName(cursor.getString(1));
courses.setCourseDescription(cursor.getString(2));
courses.setCourseStream(cursor.getString(3));
courses.setDuration(cursor.getString(4));
courses.setCourseRating(Float.parseFloat(cursor.getString(5)));
course.add(courses);
}while (cursor.moveToNext());
}
Log.d("getAllCourses()", course.toString());
return course;
}
public int updateCourse(Course course) {
SQLiteDatabase db = this.getWritableDatabase();
ContentValues values = new ContentValues();
values.put("course_id", course.getCourseId());
values.put("course_name", course.getCourseName());
values.put("course_description", course.getCourseDescription());
values.put("course_stream", course.getCourseStream());
values.put("duration", course.getDuration());
values.put("course_rating", course.getCourseRating());
int j = db.update(TABLE_COURSE, values, KEY_COURSE_ID + " = ?", new String[] { String.valueOf(course.getCourseId()) });
db.close();
return j;
}
public void deleteCourse(Course course) {
SQLiteDatabase db = this.getWritableDatabase();
db.delete(TABLE_COURSE, KEY_COURSE_ID+" + ?", new String[] { String.valueOf(course.getCourseId()) });
db.close();
Log.d("deleteCourse", course.toString());
}
//-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
// college course table
private static final String TABLE_COLLEGECOURSE = "CollegeCourse";
private static final String KEY_COLLEGECOURSE_ID = "collegecourse_id";
private static final String KEY_COLLEGE_ID1 = "college_id";
private static final String KEY_COURSE_ID1 = "course_id";
private static final String KEY_EFFECTIVE_START_DATE = "effective_start_date";
private static final String KEY_EFFECTIVE_END_DATE = "effective_end_date";
private static final String KEY_EFFECTIVE_FLAG = "effective_flag";
private static final String[] COLUMNS_COLLEGECOURSE = {KEY_COLLEGECOURSE_ID,KEY_COLLEGE_ID1,KEY_COURSE_ID1,KEY_EFFECTIVE_START_DATE,KEY_EFFECTIVE_END_DATE,KEY_EFFECTIVE_FLAG};
public void addCollegeCourse(CollegeCourse collegecourse){
Log.d("addCollegeCourse", collegecourse.toString());
SQLiteDatabase db = this.getWritableDatabase();
ContentValues values = new ContentValues();
values.put(KEY_COLLEGECOURSE_ID, collegecourse.getCollegeCourseId());
values.put(KEY_COLLEGE_ID1, collegecourse.getCollegeId());
values.put(KEY_COURSE_ID1, collegecourse.getCourseId());
values.put(KEY_EFFECTIVE_START_DATE, collegecourse.getEffectiveStartDate());
values.put(KEY_EFFECTIVE_END_DATE, collegecourse.getEffectiveEndDate());
values.put(KEY_EFFECTIVE_FLAG, collegecourse.getEffectiveFlag());
db.insert(TABLE_COLLEGECOURSE, null, values);
db.close();
}
public CollegeCourse getCollegeCourse(int collegecourse_id){
SQLiteDatabase db = this.getReadableDatabase();
Cursor cursor = db.query(TABLE_COLLEGECOURSE, COLUMNS_COLLEGECOURSE, " id = ?", new String[] { String.valueOf(collegecourse_id) },
null, null, null, null);
if (cursor != null)
cursor.moveToFirst();
CollegeCourse collegecourse = new CollegeCourse();
collegecourse.setCollegeCourseId(Integer.parseInt(cursor.getString(0)));
collegecourse.setCollegeId(Integer.parseInt(cursor.getString(1)));
collegecourse.setCourseId(Integer.parseInt(cursor.getString(2)));
collegecourse.setEffectiveStartDate(cursor.getString(3));
collegecourse.setEffectiveEndDate(cursor.getString(4));
collegecourse.setEffectiveFlag(Integer.parseInt(cursor.getString(5)));
Log.d("getCollegeCourse("+collegecourse_id+")", collegecourse.toString());
return collegecourse;
}
public List<CollegeCourse> getAllCollegeCourse() {
List<CollegeCourse> collegecourses = new LinkedList<CollegeCourse>();
String query = "SELECT * FROM " + TABLE_COLLEGECOURSE;
SQLiteDatabase db = this.getWritableDatabase();
Cursor cursor = db.rawQuery(query, null);
CollegeCourse collegecourse = null;
if (cursor.moveToFirst()) {
do {
collegecourse = new CollegeCourse();
collegecourse.setCollegeCourseId(Integer.parseInt(cursor.getString(0)));
collegecourse.setCollegeId(Integer.parseInt(cursor.getString(1)));
collegecourse.setCourseId(Integer.parseInt(cursor.getString(2)));
collegecourse.setEffectiveStartDate(cursor.getString(3));
collegecourse.setEffectiveEndDate(cursor.getString(4));
collegecourse.setEffectiveFlag(Integer.parseInt(cursor.getString(5)));
collegecourses.add(collegecourse);
}while (cursor.moveToNext());
}
Log.d("getAllCollegeCourse()", collegecourses.toString());
return collegecourses;
}
public int updateCollegeCourse(CollegeCourse collegecourse) {
SQLiteDatabase db = this.getWritableDatabase();
ContentValues values = new ContentValues();
values.put(KEY_COLLEGECOURSE_ID, collegecourse.getCollegeCourseId());
values.put(KEY_COLLEGE_ID1, collegecourse.getCollegeId());
values.put(KEY_COURSE_ID1, collegecourse.getCourseId());
values.put(KEY_EFFECTIVE_START_DATE, collegecourse.getEffectiveStartDate());
values.put(KEY_EFFECTIVE_END_DATE, collegecourse.getEffectiveEndDate());
values.put(KEY_EFFECTIVE_FLAG, collegecourse.getEffectiveFlag());
int k = db.update(TABLE_COLLEGECOURSE, values, KEY_COLLEGECOURSE_ID+" + ?", new String[] { String.valueOf(collegecourse.getCollegeCourseId()) });
db.close();
return k;
}
public void deleteCollegeCourse(CollegeCourse collegecourse) {
SQLiteDatabase db = this.getWritableDatabase();
db.delete(TABLE_COLLEGECOURSE, KEY_COLLEGECOURSE_ID +" = ?", new String[] { String.valueOf(collegecourse.getCollegeCourseId()) });
db.close();
Log.d("deleteCollegeCourse", collegecourse.toString());
}
}
Aucun commentaire:
Enregistrer un commentaire