/** 修改班级 */ public boolean modifyClass(Classes classes, String id) { ContentValues values = new ContentValues(); values.put("class_id", classes.getClass_id()); values.put("class_name", classes.getClass_name()); values.put("class_date", classes.getClass_date()); long l = db.update("class", values, "class_id=?", new String[] {id}); return l == 1; }
/** * 保存classes到数据库 * * @param classes */ public boolean saveClass(Classes classes) { if (classes != null) { ContentValues values = new ContentValues(); values.put("class_id", classes.getClass_id()); values.put("class_name", classes.getClass_name()); values.put("class_date", classes.getClass_date()); values.put("major_id", classes.getMajor_id()); long l = db.insert("class", null, values); if (l == -1) { return false; } else { return true; } } return false; }
/** * 返回对应专业的所有班级 * * @param major_name * @return */ public List<Classes> getClasses(String major_id) { List<Classes> list = new ArrayList<Classes>(); Cursor cursor = db.query("class", null, "major_id=?", new String[] {major_id}, null, null, null); while (cursor.moveToNext()) { Classes classes = new Classes(); classes.setClass_id(cursor.getString(cursor.getColumnIndex("class_id"))); classes.setClass_date(cursor.getString(cursor.getColumnIndex("class_date"))); classes.setClass_name(cursor.getString(cursor.getColumnIndex("class_name"))); list.add(classes); } if (cursor != null) { cursor.close(); } return list; }