@Test public void getDbSetTotalCount() throws Exception { Long count = databaseSetDao.getDbSetTotalCount(paging); System.out.println("getDbSetTotalCount :-------> " + count); Assert.assertTrue(count > 0); }
public Long getDbSetTotalCount(Paging<DatabaseSet> paging) throws SQLException { String sql = "SELECT count(1) FROM databaseset t1 " + " inner join login_users t2 on t1.update_user_no = t2.user_no " + " inner join dal_group t3 on t1.group_id = t3.id " + appenWhere(paging); log.info("getDbSetTotalCount-----> " + sql); return this.getCount(sql); }
DatabaseSetDao extends BaseDao { public Long getDbSetTotalCount(Paging<DatabaseSet> paging) throws SQLException { String sql = "SELECT count(1) FROM databaseset t1 " + " inner join login_users t2 on t1.update_user_no = t2.user_no " + " inner join dal_group t3 on t1.group_id = t3.id " + appenWhere(paging); log.info("getDbSetTotalCount-----> " + sql); return this.getCount(sql); } }
DatabaseSetDao extends BaseDao { public Long getDbSetTotalCount(Paging<DatabaseSet> paging) throws SQLException { String sql = "SELECT count(1) FROM databaseset t1 " + " inner join login_users t2 on t1.update_user_no = t2.user_no " + " inner join dal_group t3 on t1.group_id = t3.id " + appenWhere(paging); log.info("getDbSetTotalCount-----> " + sql); return this.getCount(sql); }  }
DatabaseSetDao extends BaseDao { public Long getDbSetTotalCount(Paging<DatabaseSet> paging) throws SQLException { String sql = "SELECT count(1) FROM databaseset t1 " + " inner join login_users t2 on t1.update_user_no = t2.user_no " + " inner join dal_group t3 on t1.group_id = t3.id " + appenWhere(paging); log.info("getDbSetTotalCount-----> " + sql); return this.getCount(sql); }  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 Long getDbSetTotalCount(Paging<DatabaseSet> paging) throws SQLException { String sql = "SELECT count(1) FROM databaseset t1 " + " inner join login_users t2 on t1.update_user_no = t2.user_no " + " inner join dal_group t3 on t1.group_id = t3.id " + appenWhere(paging); log.info("getDbSetTotalCount-----> " + sql); return this.getCount(sql); }  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);  }