ProjectDao extends BaseDao { public int deleteProjectAppGroupIdById(Long appGroupId) throws SQLException { String sql = "update project set app_group_id = 0 where app_group_id = ?"; return this.updataBysql(sql, Parameter.integerOf(StringUtils.EMPTY, appGroupId)); }  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 deleteProjectAppGroupIdById() throws Exception { int count = projectDao.deleteProjectAppGroupIdById(33L); System.out.println("deleteProjectAppGroupIdById :-------> " + count); Assert.assertTrue(count > 0); }