class GroupDao extends BaseDao {

    public List<DasGroup> getAllGroupsByAppoid(String appid) throws SQLException {
        String sql = "select t1.id, t1.group_name, t1.group_comment, t1.update_user_no, t1.insert_time from dal_group t1\n" +
                "inner join project t2 on t2.dal_group_id = t1.id\n" +
                "where t2.app_id = '" + appid + "'";
        return this.queryBySql(sql, DasGroup.class);
    }

}