@Test public void findDbSetEntryPageList() throws Exception { List<DatabaseSetEntryView> list = dataBaseSetEntryDao.findDbSetEntryPageList(paging); System.out.println("findDbSetEntryPageList :-------> " + list); Assert.assertTrue(list.size() > 0); }
public List<DatabaseSetEntryView> findDbSetEntryPageList(Paging<DatabaseSetEntry> paging) throws SQLException { String sql = "SELECT t1.id, t1.name, t1.database_type, t1.sharding, t1.db_Id, t1.dbset_id, t1.update_user_no, t1.update_time, t2.db_name, t2.db_catalog, t2.dal_group_id as groupId, t3.user_real_name, t4.name dbset_name " + "FROM databasesetentry t1 " + "inner join alldbs t2 on t1.db_Id = t2.id " + "left join login_users t3 on t1.update_user_no = t3.user_no " + "inner join databaseset t4 on t4.id = t1.dbset_id " + appenCondition(paging); log.info("findDbSetEntryPageList-----> " + sql); return this.queryBySql(sql, DatabaseSetEntryView.class); }
DataBaseSetEntryDao extends BaseDao { public List<DatabaseSetEntryView> findDbSetEntryPageList(Paging<DatabaseSetEntry> paging) throws SQLException { String sql = "SELECT t1.id, t1.name, t1.database_type, t1.sharding, t1.db_Id, t1.dbset_id, t1.update_user_no, t1.update_time, t2.db_name, t2.db_catalog, t2.dal_group_id as groupId, t3.user_real_name, t4.name dbset_name " + "FROM databasesetentry t1 " + "inner join alldbs t2 on t1.db_Id = t2.id " + "left join login_users t3 on t1.update_user_no = t3.user_no " + "inner join databaseset t4 on t4.id = t1.dbset_id " + appenCondition(paging); log.info("findDbSetEntryPageList-----> " + sql); return this.queryBySql(sql, DatabaseSetEntryView.class); } }
DataBaseSetEntryDao extends BaseDao { public List<DatabaseSetEntryView> findDbSetEntryPageList(Paging<DatabaseSetEntry> paging) throws SQLException { String sql = "SELECT t1.id, t1.name, t1.database_type, t1.sharding, t1.db_Id, t1.dbset_id, t1.update_user_no, t1.update_time, t2.db_name, t2.db_catalog, t2.dal_group_id as groupId, t3.user_real_name, t4.name dbset_name " + "FROM databasesetentry t1 " + "inner join alldbs t2 on t1.db_Id = t2.id " + "left join login_users t3 on t1.update_user_no = t3.user_no " + "inner join databaseset t4 on t4.id = t1.dbset_id " + appenCondition(paging); log.info("findDbSetEntryPageList-----> " + sql); return this.queryBySql(sql, DatabaseSetEntryView.class); }  }
DataBaseSetEntryDao extends BaseDao { public List<DatabaseSetEntryView> findDbSetEntryPageList(Paging<DatabaseSetEntry> paging) throws SQLException { String sql = "SELECT t1.id, t1.name, t1.database_type, t1.sharding, t1.db_Id, t1.dbset_id, t1.update_user_no, t1.update_time, t2.db_name, t2.db_catalog, t2.dal_group_id as groupId, t3.user_real_name, t4.name dbset_name " + "FROM databasesetentry t1 " + "inner join alldbs t2 on t1.db_Id = t2.id " + "left join login_users t3 on t1.update_user_no = t3.user_no " + "inner join databaseset t4 on t4.id = t1.dbset_id " + appenCondition(paging); log.info("findDbSetEntryPageList-----> " + sql); return this.queryBySql(sql, DatabaseSetEntryView.class); }  Long insertDatabaseSetEntry(DatabaseSetEntry dbsetEntry); int[] insertDatabaseSetEntrylist(List<DatabaseSetEntry> dbsetEntryList); int updateDatabaseSetEntry(DatabaseSetEntry dbsetEntry); int deleteDatabaseSetEntryById(Long id); Long getCountByName(String name); Long getCountByIdAndName(Long id, String name); List<DatabaseSetEntry> getAllDbSetEntryByDbSetId(Long dbset_id); DatabaseSetEntry getDataBaseSetEntryById(Long id); DatabaseSetEntryView getDataBaseSetEntryByDbId(Long dataBaseId); List<DatabaseSetEntryView> getDataBaseSetEntryListByDbSetId(Long dbsetId); List<DatabaseSetEntry> getAllDbSetEntryByDbSetIds(List<Integer> dbset_ids); List<DatabaseSetEntry> getDatabaseSetEntrysByDbNames(List<String> names); Long getDbSetEntryTotalCount(Paging<DatabaseSetEntry> paging); List<DatabaseSetEntryView> findDbSetEntryPageList(Paging<DatabaseSetEntry> paging); }
DataBaseSetEntryDao extends BaseDao { public List<DatabaseSetEntryView> findDbSetEntryPageList(Paging<DatabaseSetEntry> paging) throws SQLException { String sql = "SELECT t1.id, t1.name, t1.database_type, t1.sharding, t1.db_Id, t1.dbset_id, t1.update_user_no, t1.update_time, t2.db_name, t2.db_catalog, t2.dal_group_id as groupId, t3.user_real_name, t4.name dbset_name " + "FROM databasesetentry t1 " + "inner join alldbs t2 on t1.db_Id = t2.id " + "left join login_users t3 on t1.update_user_no = t3.user_no " + "inner join databaseset t4 on t4.id = t1.dbset_id " + appenCondition(paging); log.info("findDbSetEntryPageList-----> " + sql); return this.queryBySql(sql, DatabaseSetEntryView.class); }  Long insertDatabaseSetEntry(DatabaseSetEntry dbsetEntry); int[] insertDatabaseSetEntrylist(List<DatabaseSetEntry> dbsetEntryList); int updateDatabaseSetEntry(DatabaseSetEntry dbsetEntry); int deleteDatabaseSetEntryById(Long id); Long getCountByName(String name); Long getCountByIdAndName(Long id, String name); List<DatabaseSetEntry> getAllDbSetEntryByDbSetId(Long dbset_id); DatabaseSetEntry getDataBaseSetEntryById(Long id); DatabaseSetEntryView getDataBaseSetEntryByDbId(Long dataBaseId); List<DatabaseSetEntryView> getDataBaseSetEntryListByDbSetId(Long dbsetId); List<DatabaseSetEntry> getAllDbSetEntryByDbSetIds(List<Integer> dbset_ids); List<DatabaseSetEntry> getDatabaseSetEntrysByDbNames(List<String> names); Long getDbSetEntryTotalCount(Paging<DatabaseSetEntry> paging); List<DatabaseSetEntryView> findDbSetEntryPageList(Paging<DatabaseSetEntry> paging);  }