@Test public void getProjectByAppId() throws Exception { Project project = projectDao.getProjectByAppId("10000000008"); System.out.println("getProjectByAppId :-------> " + project); Assert.assertTrue(project != null); }
public Project getProjectByAppId(String appId) throws SQLException { String sql = "SELECT id, name, namespace,dal_group_id,dal_config_name,update_user_no,app_id,token,update_time FROM project WHERE app_id = '" + appId + "' limit 1"; List<Project> list = this.queryBySql(sql, Project.class); return CollectionUtils.isNotEmpty(list) ? list.get(0) : null; }
ProjectDao extends BaseDao { public Project getProjectByAppId(String appId) throws SQLException { String sql = "SELECT id, name, namespace,dal_group_id,dal_config_name,update_user_no,app_id,token,update_time FROM project WHERE app_id = '" + appId + "' limit 1"; List<Project> list = this.queryBySql(sql, Project.class); return CollectionUtils.isNotEmpty(list) ? list.get(0) : null; } }
ProjectDao extends BaseDao { public Project getProjectByAppId(String appId) throws SQLException { String sql = "SELECT id, name, namespace,dal_group_id,dal_config_name,update_user_no,app_id,token,update_time FROM project WHERE app_id = '" + appId + "' limit 1"; List<Project> list = this.queryBySql(sql, Project.class); return CollectionUtils.isNotEmpty(list) ? list.get(0) : null; }  }
ProjectDao extends BaseDao { public Project getProjectByAppId(String appId) throws SQLException { String sql = "SELECT id, name, namespace,dal_group_id,dal_config_name,update_user_no,app_id,token,update_time FROM project WHERE app_id = '" + appId + "' limit 1"; List<Project> list = this.queryBySql(sql, Project.class); return CollectionUtils.isNotEmpty(list) ? list.get(0) : null; }  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); }
ProjectDao extends BaseDao { public Project getProjectByAppId(String appId) throws SQLException { String sql = "SELECT id, name, namespace,dal_group_id,dal_config_name,update_user_no,app_id,token,update_time FROM project WHERE app_id = '" + appId + "' limit 1"; List<Project> list = this.queryBySql(sql, Project.class); return CollectionUtils.isNotEmpty(list) ? list.get(0) : null; }  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);  }