/* 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; }