DatabaseSetDao extends BaseDao { public List<DatabaseSetView> getAllDatabaseSetByProjectId(Long projectId) throws SQLException { String sql = "SELECT t1.id, t1.name, t1.db_type,t1.strategy_type, t1.strategy_source, t1.dynamic_strategy_id, t1.class_name, t1.group_id, t1.update_user_no, t1.update_time ,t3.group_name, t1.pattern " + "FROM databaseset t1 " + "inner join project_dbset_relation t2 on t2.dbset_id = t1.id " + "inner join dal_group t3 on t1.group_id = t3.id " + "where t2.project_id = " + projectId; if (projectId == null) { sql = "SELECT t1.id, t1.name, t1.db_type, t1.strategy_source, t1.dynamic_strategy_id, t1.class_name, t1.group_id, t1.update_user_no, t1.update_time FROM databaseset t1 order by t1.name"; } return this.queryBySql(sql, DatabaseSetView.class); }  Long insertDatabaseSet(DatabaseSet dbset); int updateDatabaseSet(DatabaseSet dbset); int deleteDatabaseSetById(Long dbsetId); int deleteDatabaseSetEntryByDbsetId(Long dbsetId); DatabaseSet getDatabaseSetById(Long id); DatabaseSet getDatabaseSetByName(String name); List<DatabaseSet> getAllDatabaseSetByName(String name); List<DatabaseSet> getAllDatabaseSetByNames(List<String> names); List<DatabaseSet> getAllDatabaseSetById(Long id); List<DatabaseSetView> getAllDatabaseSetByProjectId(Long projectId); List<DatabaseSet> getAllDatabaseSetByGroupId(Long groupId); DatabaseSetEntry getMasterDatabaseSetEntryByDatabaseSetId(Long dbset_id); Long getDbSetTotalCount(Paging<DatabaseSet> paging); List<DatabaseSetView> findDbSetPageList(Paging<DatabaseSet> paging); Long getDbSetTotalCountByAppid(Paging<DatabaseSet> paging); List<DatabaseSetView> findDbSetPageListByAppid(Paging<DatabaseSet> paging);  }
@Test public void getAllDatabaseSetByProjectId() throws Exception { List<DatabaseSetView> list = databaseSetDao.getAllDatabaseSetByProjectId(50L); System.out.println("getAllDatabaseSetByProjectId :-------> " + list); Assert.assertTrue(list.size() > 0); }