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)); }  Long insertProject(Project project); int deleteProject(Project project); int updateProject(Project project); int updateTokenByAppId(String app_id, String token); int updateProjectGroupById(int groupId, int id); int updateProjectAppGroupIdById(Long appGroupId, Set<Long> projectIds); int deleteProjectAppGroupIdById(Long appGroupId); int deleteProjectAppGroupIdByIdS(Set<Long> projectIds); Project getProjectByID(Long id); Project getProjectByAppId(String appId); ProjectView getProjectViewById(Long id); List<Project> getProjectByDbId(Integer dbId); List<Project> getProjectBydbsetId(Long dbsetId); List<Project> getProjectByGroupId(Long groupId); List<Project> getProjectByAppGroupId(Long appGroupId); Long getCountByName(String name); Long getCountByAppId(String app_id); Long getCountByIdAndName(Long id, String name); Long getCountByIdAndAppId(Long id, String app_id); List<Project> getProjectsListByLikeName(String name); List<Project> getProjectsListBySetName(String name); List<Project> getProjectsNoGroup(Long appGroupId); List<Project> getProjectsByAppGroupId(Long appGroupId); String getfindProjectSql(); Long getProjectTotalCount(Paging<ProjectModel> paging); List<ProjectView> findProjectPageList(Paging<ProjectModel> paging);  }
@Test public void getProjectByGroupId() throws Exception { List<Project> list = projectDao.getProjectByGroupId(58L); System.out.println("getProjectByGroupId :-------> " + list); Assert.assertTrue(list.size() > 0); }