@Test public void findDbSetPageListByAppid() throws Exception { databaseSetModel.setApp_id("1000002397"); List<DatabaseSetView> list = databaseSetDao.findDbSetPageListByAppid(paging); System.out.println("findDbSetPageListByAppid :-------> " + list); Assert.assertTrue(list.size() > 0); }
public List<DatabaseSetView> findDbSetPageListByAppid(Paging<DatabaseSet> paging) 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 \n" + "FROM databaseset t1 \n" + "inner join project_dbset_relation t2 on t2.dbset_id = t1.id \n" + "inner join dal_group t3 on t1.group_id = t3.id\n" + "inner join project t4 on t2.project_id = t4.id\n" + "where t4.app_id = " + paging.getData().getApp_id(); return this.queryBySql(sql, DatabaseSetView.class); }
DatabaseSetDao extends BaseDao { public List<DatabaseSetView> findDbSetPageListByAppid(Paging<DatabaseSet> paging) 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 \n" + "FROM databaseset t1 \n" + "inner join project_dbset_relation t2 on t2.dbset_id = t1.id \n" + "inner join dal_group t3 on t1.group_id = t3.id\n" + "inner join project t4 on t2.project_id = t4.id\n" + "where t4.app_id = " + paging.getData().getApp_id(); return this.queryBySql(sql, DatabaseSetView.class); } }
DatabaseSetDao extends BaseDao { public List<DatabaseSetView> findDbSetPageListByAppid(Paging<DatabaseSet> paging) 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 \n" + "FROM databaseset t1 \n" + "inner join project_dbset_relation t2 on t2.dbset_id = t1.id \n" + "inner join dal_group t3 on t1.group_id = t3.id\n" + "inner join project t4 on t2.project_id = t4.id\n" + "where t4.app_id = " + paging.getData().getApp_id(); return this.queryBySql(sql, DatabaseSetView.class); }  }
DatabaseSetDao extends BaseDao { public List<DatabaseSetView> findDbSetPageListByAppid(Paging<DatabaseSet> paging) 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 \n" + "FROM databaseset t1 \n" + "inner join project_dbset_relation t2 on t2.dbset_id = t1.id \n" + "inner join dal_group t3 on t1.group_id = t3.id\n" + "inner join project t4 on t2.project_id = t4.id\n" + "where t4.app_id = " + paging.getData().getApp_id(); 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); }
DatabaseSetDao extends BaseDao { public List<DatabaseSetView> findDbSetPageListByAppid(Paging<DatabaseSet> paging) 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 \n" + "FROM databaseset t1 \n" + "inner join project_dbset_relation t2 on t2.dbset_id = t1.id \n" + "inner join dal_group t3 on t1.group_id = t3.id\n" + "inner join project t4 on t2.project_id = t4.id\n" + "where t4.app_id = " + paging.getData().getApp_id(); 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);  }