/**
* 创建 短信用户组
*
* @param id
* @return deleted count
*/
public Messgroup createMessgroup(Messgroup messgroup) throws SQLException {
if (messgroup.getId() > 0) {
throw new SQLException("ID must <= 0.");
}
messgroup.setId(
DBTools.getID(getSqlMapClientTemplate().getDataSource().getConnection(), "T_MESSGROUP"));
getSqlMapClientTemplate().insert("createMessgroup", messgroup);
return messgroup;
}
/**
* 修改 短信用户组但忽略空值
*
* @param id
* @return
*/
public int updateMessgroupIgnoreNull(Messgroup messgroup) {
Messgroup tmp = findMessgroup(messgroup.getId());
int flag = 0;
if (messgroup.getMessname() != null) {
tmp.setMessname(messgroup.getMessname());
flag++;
}
if (messgroup.getMessnums() != null) {
tmp.setMessnums(messgroup.getMessnums());
flag++;
}
if (messgroup.getCreatetime() != null) {
tmp.setCreatetime(messgroup.getCreatetime());
flag++;
}
if (messgroup.getCreateuserid() != null) {
tmp.setCreateuserid(messgroup.getCreateuserid());
flag++;
}
if (messgroup.getParam1() != null) {
tmp.setParam1(messgroup.getParam1());
flag++;
}
if (messgroup.getParam2() != null) {
tmp.setParam2(messgroup.getParam2());
flag++;
}
if (messgroup.getParam3() != null) {
tmp.setParam3(messgroup.getParam3());
flag++;
}
if (flag == 0) {
return 0;
} else {
return getSqlMapClientTemplate().update("updateMessgroup", tmp);
}
}