@Test public void getServerGroupTotalCount() throws Exception { Long count = serverGroupDao.getServerGroupTotalCount(paging); System.out.println("getServerGroupTotalCount :-------> " + count); Assert.assertTrue(count> 0); }
public Long getServerGroupTotalCount(Paging<ServerGroup> paging) throws SQLException { String sql = "SELECT count(1) FROM server_group t1 " + "left join login_users t2 on t1.update_user_no = t2.user_no " + appenWhere(paging); return this.getCount(sql); }
ServerGroupDao extends BaseDao { public Long getServerGroupTotalCount(Paging<ServerGroup> paging) throws SQLException { String sql = "SELECT count(1) FROM server_group t1 " + "left join login_users t2 on t1.update_user_no = t2.user_no " + appenWhere(paging); return this.getCount(sql); } }
ServerGroupDao extends BaseDao { public Long getServerGroupTotalCount(Paging<ServerGroup> paging) throws SQLException { String sql = "SELECT count(1) FROM server_group t1 " + "left join login_users t2 on t1.update_user_no = t2.user_no " + appenWhere(paging); return this.getCount(sql); }  }
ServerGroupDao extends BaseDao { public Long getServerGroupTotalCount(Paging<ServerGroup> paging) throws SQLException { String sql = "SELECT count(1) FROM server_group t1 " + "left join login_users t2 on t1.update_user_no = t2.user_no " + appenWhere(paging); return this.getCount(sql); }  Long insertServerGroup(ServerGroup serverGroup); ServerGroup getServerGroupById(Long id); List<ServerGroup> getAllServerGroups(); Long getCountByName(String name); Long getCountByIdAndName(Long id, String name); int updateServerGroup(ServerGroup serverGroup); int deleteServerGroup(ServerGroup serverGroup); int deleteServerGroupAndServerAndServerConfigByServerGroupId(Long serverGroupId); List<Server> serversNoGroup(Integer appGroupId); Long getServerGroupTotalCount(Paging<ServerGroup> paging); List<ServerGroupView> findServerGroupPageList(Paging<ServerGroup> paging); }
ServerGroupDao extends BaseDao { public Long getServerGroupTotalCount(Paging<ServerGroup> paging) throws SQLException { String sql = "SELECT count(1) FROM server_group t1 " + "left join login_users t2 on t1.update_user_no = t2.user_no " + appenWhere(paging); return this.getCount(sql); }  Long insertServerGroup(ServerGroup serverGroup); ServerGroup getServerGroupById(Long id); List<ServerGroup> getAllServerGroups(); Long getCountByName(String name); Long getCountByIdAndName(Long id, String name); int updateServerGroup(ServerGroup serverGroup); int deleteServerGroup(ServerGroup serverGroup); int deleteServerGroupAndServerAndServerConfigByServerGroupId(Long serverGroupId); List<Server> serversNoGroup(Integer appGroupId); Long getServerGroupTotalCount(Paging<ServerGroup> paging); List<ServerGroupView> findServerGroupPageList(Paging<ServerGroup> paging);  }