@Test public void findPublicStrategyPageList() throws Exception { List<PublicStrategyView> list = publicStrategyDao.findPublicStrategyPageList(paging); System.out.println("findPublicStrategyPageList :-------> " + list); Assert.assertTrue(list.size() > 0); }
public List<PublicStrategyView> findPublicStrategyPageList(Paging<PublicStrategy> paging) throws SQLException { String sql = "select t1.id, t1.name, t1.strategy_loading_type, t1.class_name, t1.strategy_source, " + "t1.strategy_params, t1.comment, t1.insert_time, t1.update_time,t2.user_real_name " + "from public_strategy t1 " + "left join login_users t2 on t1.update_user_no = t2.user_no " + appenCondition(paging); return this.queryBySql(sql, PublicStrategyView.class); }
PublicStrategyDao extends BaseDao { public List<PublicStrategyView> findPublicStrategyPageList(Paging<PublicStrategy> paging) throws SQLException { String sql = "select t1.id, t1.name, t1.strategy_loading_type, t1.class_name, t1.strategy_source, " + "t1.strategy_params, t1.comment, t1.insert_time, t1.update_time,t2.user_real_name " + "from public_strategy t1 " + "left join login_users t2 on t1.update_user_no = t2.user_no " + appenCondition(paging); return this.queryBySql(sql, PublicStrategyView.class); } }
PublicStrategyDao extends BaseDao { public List<PublicStrategyView> findPublicStrategyPageList(Paging<PublicStrategy> paging) throws SQLException { String sql = "select t1.id, t1.name, t1.strategy_loading_type, t1.class_name, t1.strategy_source, " + "t1.strategy_params, t1.comment, t1.insert_time, t1.update_time,t2.user_real_name " + "from public_strategy t1 " + "left join login_users t2 on t1.update_user_no = t2.user_no " + appenCondition(paging); return this.queryBySql(sql, PublicStrategyView.class); }  }
PublicStrategyDao extends BaseDao { public List<PublicStrategyView> findPublicStrategyPageList(Paging<PublicStrategy> paging) throws SQLException { String sql = "select t1.id, t1.name, t1.strategy_loading_type, t1.class_name, t1.strategy_source, " + "t1.strategy_params, t1.comment, t1.insert_time, t1.update_time,t2.user_real_name " + "from public_strategy t1 " + "left join login_users t2 on t1.update_user_no = t2.user_no " + appenCondition(paging); return this.queryBySql(sql, PublicStrategyView.class); }  Long insertPublicStrategy(PublicStrategy publicStrategy); int updatePublicStrategy(PublicStrategy publicStrategy); PublicStrategy getPublicStrategyById(Long id); Long getCountByName(String name); Long getCountByIdAndName(Long id, String name); int deletePublicStrategy(PublicStrategy publicStrategy); List<PublicStrategy> getAllPublicStrateges(); Long getPublicStrategyTotalCount(Paging<PublicStrategy> paging); List<PublicStrategyView> findPublicStrategyPageList(Paging<PublicStrategy> paging); }
PublicStrategyDao extends BaseDao { public List<PublicStrategyView> findPublicStrategyPageList(Paging<PublicStrategy> paging) throws SQLException { String sql = "select t1.id, t1.name, t1.strategy_loading_type, t1.class_name, t1.strategy_source, " + "t1.strategy_params, t1.comment, t1.insert_time, t1.update_time,t2.user_real_name " + "from public_strategy t1 " + "left join login_users t2 on t1.update_user_no = t2.user_no " + appenCondition(paging); return this.queryBySql(sql, PublicStrategyView.class); }  Long insertPublicStrategy(PublicStrategy publicStrategy); int updatePublicStrategy(PublicStrategy publicStrategy); PublicStrategy getPublicStrategyById(Long id); Long getCountByName(String name); Long getCountByIdAndName(Long id, String name); int deletePublicStrategy(PublicStrategy publicStrategy); List<PublicStrategy> getAllPublicStrateges(); Long getPublicStrategyTotalCount(Paging<PublicStrategy> paging); List<PublicStrategyView> findPublicStrategyPageList(Paging<PublicStrategy> paging);  }