class GroupDao extends BaseDao {

    public DasGroup getGroupByName(String name) throws SQLException {
        String sql = "select id, group_name, group_comment, update_user_no, insert_time from dal_group where group_name = '" + name + "' limit 1";
        List<DasGroup> list = this.queryBySql(sql, DasGroup.class);
        return CollectionUtils.isNotEmpty(list) ? list.get(0) : null;
    }

}