/* insert */
public static int insert(DatabaseHelper databaseHelper, system_messageVo system_messageVo) {
RuntimeExceptionDao<system_messageVo, Integer> system_messageDao =
databaseHelper.getSystem_messageDao();
if (exist(databaseHelper, system_messageVo)) {
return 0;
}
return system_messageDao.create(system_messageVo);
}
/* select by id */
public static system_messageVo select(DatabaseHelper databaseHelper, int id) {
RuntimeExceptionDao<system_messageVo, Integer> system_messageDao =
databaseHelper.getSystem_messageDao();
try {
return system_messageDao.queryForId(id);
} catch (Exception e) {
e.printStackTrace();
}
return null;
}
/* selectRaw */
public static List<system_messageVo> selectRaw2(DatabaseHelper databaseHelper) {
RuntimeExceptionDao<system_messageVo, Integer> system_messageDao =
databaseHelper.getSystem_messageDao();
QueryBuilder<system_messageVo, Integer> queryBuilder = system_messageDao.queryBuilder();
try {
return queryBuilder.query();
} catch (SQLException e) {
e.printStackTrace();
}
return null;
}
public static int delete(
DatabaseHelper databaseHelper, String columnvalue, String originalvalue) {
RuntimeExceptionDao<system_messageVo, Integer> system_messageDao =
databaseHelper.getSystem_messageDao();
DeleteBuilder<system_messageVo, Integer> deleteBuilder = system_messageDao.deleteBuilder();
try {
// 判斷式 哪一欄 = 值
deleteBuilder.where().eq(columnvalue, originalvalue);
return deleteBuilder.delete();
} catch (Exception e) {
e.printStackTrace();
}
return 0;
}
/* exist */
public static boolean exist(DatabaseHelper databaseHelper, system_messageVo system_messageVo) {
RuntimeExceptionDao<system_messageVo, Integer> system_messageDao =
databaseHelper.getSystem_messageDao();
QueryBuilder<system_messageVo, Integer> queryBuilder = system_messageDao.queryBuilder();
try {
queryBuilder.where().eq(system_messageVo.FIELD_Id, String.valueOf(system_messageVo.getId()));
// .and()
// .eq(AccountVo.FIELD_Device, aAccountVo.getDevice());
return queryBuilder.query().size() > 0 ? true : false;
} catch (SQLException e) {
e.printStackTrace();
}
return false;
}
/* selectRaw */
public static system_messageVo getSystem_messageVo(DatabaseHelper databaseHelper) {
RuntimeExceptionDao<system_messageVo, Integer> system_messageDao =
databaseHelper.getSystem_messageDao();
QueryBuilder<system_messageVo, Integer> queryBuilder = system_messageDao.queryBuilder();
try {
List<system_messageVo> data = queryBuilder.where().raw("1=1").query();
if (data.size() > 0) {
return data.get(0);
}
return null;
} catch (Exception e) {
e.printStackTrace();
}
return null;
}
/* update */
public static int update(
DatabaseHelper databaseHelper,
String columnvalue,
String originalvalue,
String column,
String value) {
RuntimeExceptionDao<system_messageVo, Integer> system_messageDao =
databaseHelper.getSystem_messageDao();
UpdateBuilder<system_messageVo, Integer> updateBuilder = system_messageDao.updateBuilder();
try {
// 判斷式 哪一欄 = 值
updateBuilder.where().eq(columnvalue, originalvalue);
// update the value of your field(s)
updateBuilder.updateColumnValue(column, value);
return updateBuilder.update();
} catch (Exception e) {
e.printStackTrace();
}
return 0;
}
