/* //搜索 */
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;
}
------解决思路----------------------
建议楼主多看看api吧。
一种可以查询数据库的时候就分页,按每次取指定条数的数据;一种是全部取出数据,显示的时候按指定的条数显示
------解决思路----------------------
没明白你要问啥?一开始我以为是分页,好像不是?
------解决思路----------------------
懂了 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 ");
把这个转换为
StringBuilder sb = new StringBuilder();
sb.append("SELECT e.Title, e.Record_Create_Time,e.id,c.name from WZ_news_class c,WZ_news_entity e where ") .append(“c.id=e.Class_id and e.title like '%") .append(title).append("%'")
.append(" order by e.Record_Create_Time desc ");
不过现在拼串和StringBuilder拼接效果一样。