@Test public void getDbSetEntryTotalCount() throws Exception { Long count = dataBaseSetEntryDao.getDbSetEntryTotalCount(paging); System.out.println("getDbSetEntryTotalCount :-------> " + count); Assert.assertTrue(count > 0); }
public Long getDbSetEntryTotalCount(Paging<DatabaseSetEntry> paging) throws SQLException { String sql = "SELECT count(1) FROM databasesetentry t1 " + "left join alldbs t2 on t1.db_Id = t2.id " + appenWhere(paging); log.info("getDbSetEntryTotalCount-----> " + sql); return this.getCount(sql); }
DataBaseSetEntryDao extends BaseDao { public Long getDbSetEntryTotalCount(Paging<DatabaseSetEntry> paging) throws SQLException { String sql = "SELECT count(1) FROM databasesetentry t1 " + "left join alldbs t2 on t1.db_Id = t2.id " + appenWhere(paging); log.info("getDbSetEntryTotalCount-----> " + sql); return this.getCount(sql); } }
DataBaseSetEntryDao extends BaseDao { public Long getDbSetEntryTotalCount(Paging<DatabaseSetEntry> paging) throws SQLException { String sql = "SELECT count(1) FROM databasesetentry t1 " + "left join alldbs t2 on t1.db_Id = t2.id " + appenWhere(paging); log.info("getDbSetEntryTotalCount-----> " + sql); return this.getCount(sql); }  }
DataBaseSetEntryDao extends BaseDao { public Long getDbSetEntryTotalCount(Paging<DatabaseSetEntry> paging) throws SQLException { String sql = "SELECT count(1) FROM databasesetentry t1 " + "left join alldbs t2 on t1.db_Id = t2.id " + appenWhere(paging); log.info("getDbSetEntryTotalCount-----> " + sql); return this.getCount(sql); }  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 Long getDbSetEntryTotalCount(Paging<DatabaseSetEntry> paging) throws SQLException { String sql = "SELECT count(1) FROM databasesetentry t1 " + "left join alldbs t2 on t1.db_Id = t2.id " + appenWhere(paging); log.info("getDbSetEntryTotalCount-----> " + sql); return this.getCount(sql); }  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);  }