@Test public void findServerGroupPageList() throws Exception { List<ServerGroupView> list = serverGroupDao.findServerGroupPageList(paging); System.out.println("findServerGroupPageList :-------> " + list); Assert.assertTrue(list.size() > 0); }
public List<ServerGroupView> findServerGroupPageList(Paging<ServerGroup> paging) throws SQLException { String sql = "SELECT t1.id, t1.name, t1.comment, t1.insert_time, t1.update_time, t2.user_real_name FROM server_group t1 " + "left join login_users t2 on t1.update_user_no = t2.user_no " + appenCondition(paging); return this.queryBySql(sql, ServerGroupView.class); }
ServerGroupDao extends BaseDao { public List<ServerGroupView> findServerGroupPageList(Paging<ServerGroup> paging) throws SQLException { String sql = "SELECT t1.id, t1.name, t1.comment, t1.insert_time, t1.update_time, t2.user_real_name FROM server_group t1 " + "left join login_users t2 on t1.update_user_no = t2.user_no " + appenCondition(paging); return this.queryBySql(sql, ServerGroupView.class); } }
ServerGroupDao extends BaseDao { public List<ServerGroupView> findServerGroupPageList(Paging<ServerGroup> paging) throws SQLException { String sql = "SELECT t1.id, t1.name, t1.comment, t1.insert_time, t1.update_time, t2.user_real_name FROM server_group t1 " + "left join login_users t2 on t1.update_user_no = t2.user_no " + appenCondition(paging); return this.queryBySql(sql, ServerGroupView.class); }  }
ServerGroupDao extends BaseDao { public List<ServerGroupView> findServerGroupPageList(Paging<ServerGroup> paging) throws SQLException { String sql = "SELECT t1.id, t1.name, t1.comment, t1.insert_time, t1.update_time, t2.user_real_name FROM server_group t1 " + "left join login_users t2 on t1.update_user_no = t2.user_no " + appenCondition(paging); return this.queryBySql(sql, ServerGroupView.class); }  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 List<ServerGroupView> findServerGroupPageList(Paging<ServerGroup> paging) throws SQLException { String sql = "SELECT t1.id, t1.name, t1.comment, t1.insert_time, t1.update_time, t2.user_real_name FROM server_group t1 " + "left join login_users t2 on t1.update_user_no = t2.user_no " + appenCondition(paging); return this.queryBySql(sql, ServerGroupView.class); }  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);  }