ProjectDao extends BaseDao { public Long getCountByIdAndAppId(Long id, String app_id) throws SQLException { return getCount("SELECT count(1) FROM project WHERE app_id='" + app_id + "' and id = " + id); }  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 getCountByIdAndAppId() throws Exception { Long count = projectDao.getCountByIdAndAppId(182L, "10000000007"); System.out.println("getCountByIdAndAppId :-------> " + count); Assert.assertTrue(count > 0); }