@Test public void getCountByIdAndName() throws Exception { Long count = publicStrategyDao.getCountByIdAndName(2L, "publicStrategy"); System.out.println("getCountByIdAndName :-------> " + count); Assert.assertTrue(count > 0); }
public Long getCountByIdAndName(Long id, String name) throws SQLException { return this.getCount("SELECT count(1) FROM public_strategy WHERE name='" + name + "' and id = " + id); }
PublicStrategyDao extends BaseDao { public Long getCountByIdAndName(Long id, String name) throws SQLException { return this.getCount("SELECT count(1) FROM public_strategy WHERE name='" + name + "' and id = " + id); } }
PublicStrategyDao extends BaseDao { public Long getCountByIdAndName(Long id, String name) throws SQLException { return this.getCount("SELECT count(1) FROM public_strategy WHERE name='" + name + "' and id = " + id); }  }
PublicStrategyDao extends BaseDao { public Long getCountByIdAndName(Long id, String name) throws SQLException { return this.getCount("SELECT count(1) FROM public_strategy WHERE name='" + name + "' and id = " + id); }  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 Long getCountByIdAndName(Long id, String name) throws SQLException { return this.getCount("SELECT count(1) FROM public_strategy WHERE name='" + name + "' and id = " + id); }  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);  }