class ProjectDao extends BaseDao {

    public List<Project> getProjectByGroupId(Long groupId) throws SQLException {
        String sql = "SELECT id, name, namespace, dal_group_id, dal_config_name, app_scene, update_user_no, update_time FROM project WHERE dal_group_id = ? order by name";
        return this.queryBySql(sql, Project.class, Parameter.integerOf(StringUtils.EMPTY, groupId));
    }

}