菜鸟 SSh 求帮助
/* //搜索 */
public List<Object[]> findTibleSearch(String title) {
String sql = ("SELECT e.Title, e.Record_Create_Time,e.id,c.name from WZ_news_class c,WZ_news_entity e"
+ " where c.id=e.Class_id and e.title like '%" + title + "%' order by e.Record_Create_Time desc ");
List<Object[]> news = (List<Object[]>) executeSQL(sql);
return news;
}
public List<Object[]> findTibleSearch(String title,int pageNow, int pageSize){
StringBuffer buffer = new StringBuffer("FROM ArticleInfo a WHERE 1=1 ");
buffer.append(" and a.title like '%"+title+"%' ");
buffer.append(" ORDER BY a.recordCreateTime DESC");
List<Object[]> news = (List<Object[]>) executeQueryByPage(buffer.toString(), null, pageNow, pageSize);
return news;
}