@Test public void getProjectByDbId() throws Exception { List<Project> list = projectDao.getProjectByDbId(430); System.out.println("getProjectByDbId :-------> " + list); Assert.assertTrue(project != null); }
public List<Project> getProjectByDbId(Integer dbId) throws SQLException { String sql = "SELECT t1.id, t1.name, t1.namespace, t1.dal_group_id, t1.dal_config_name, t1.update_user_no, t1.app_id, t1.update_time FROM project t1\n" + "inner join project_dbset_relation t2 on t2.project_id = t1.id\n" + "inner join databasesetentry t3 on t3.dbset_id = t2.dbset_id\n" + "where t3.db_Id = ? "; return this.queryBySql(sql, Project.class, Parameter.integerOf(StringUtils.EMPTY, dbId)); }
ProjectDao extends BaseDao { public List<Project> getProjectByDbId(Integer dbId) throws SQLException { String sql = "SELECT t1.id, t1.name, t1.namespace, t1.dal_group_id, t1.dal_config_name, t1.update_user_no, t1.app_id, t1.update_time FROM project t1\n" + "inner join project_dbset_relation t2 on t2.project_id = t1.id\n" + "inner join databasesetentry t3 on t3.dbset_id = t2.dbset_id\n" + "where t3.db_Id = ? "; return this.queryBySql(sql, Project.class, Parameter.integerOf(StringUtils.EMPTY, dbId)); } }
ProjectDao extends BaseDao { public List<Project> getProjectByDbId(Integer dbId) throws SQLException { String sql = "SELECT t1.id, t1.name, t1.namespace, t1.dal_group_id, t1.dal_config_name, t1.update_user_no, t1.app_id, t1.update_time FROM project t1\n" + "inner join project_dbset_relation t2 on t2.project_id = t1.id\n" + "inner join databasesetentry t3 on t3.dbset_id = t2.dbset_id\n" + "where t3.db_Id = ? "; return this.queryBySql(sql, Project.class, Parameter.integerOf(StringUtils.EMPTY, dbId)); }  }
ProjectDao extends BaseDao { public List<Project> getProjectByDbId(Integer dbId) throws SQLException { String sql = "SELECT t1.id, t1.name, t1.namespace, t1.dal_group_id, t1.dal_config_name, t1.update_user_no, t1.app_id, t1.update_time FROM project t1\n" + "inner join project_dbset_relation t2 on t2.project_id = t1.id\n" + "inner join databasesetentry t3 on t3.dbset_id = t2.dbset_id\n" + "where t3.db_Id = ? "; return this.queryBySql(sql, Project.class, Parameter.integerOf(StringUtils.EMPTY, dbId)); }  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 List<Project> getProjectByDbId(Integer dbId) throws SQLException { String sql = "SELECT t1.id, t1.name, t1.namespace, t1.dal_group_id, t1.dal_config_name, t1.update_user_no, t1.app_id, t1.update_time FROM project t1\n" + "inner join project_dbset_relation t2 on t2.project_id = t1.id\n" + "inner join databasesetentry t3 on t3.dbset_id = t2.dbset_id\n" + "where t3.db_Id = ? "; return this.queryBySql(sql, Project.class, Parameter.integerOf(StringUtils.EMPTY, dbId)); }  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);  }