原始方法join中有帖子表里的id ,假设值为join ="1,2,3":
1.使用占位符,只能展示出帖子表里面的一条数据
public List<PostModel> findNewCommentDiary(String join) {
String sql= "select a.id, a.content, a.title ...from post as a where a.id in (?)";
return this.find(sql,join);
}
2.拼接方式(不建议用,以免造成sql语句的二次编译)
public List<PostModel> findNewCommentDiary(String join) {
String sql= "select a.id, a.content, a.title ...from post as a where a.id in ("+join+")";
return this.find(sql);
}
3.使用String.format替换(建议使用)
public List<PostModel> findNewCommentDiary(String join) {
String sql= "select a.id, a.content, a.title ...from post as a where a.id in (%s)";
return this.find(String.format(sql,join));
}
4.使用find_in_set函数(建议使用 )
public List<PostModel> findNewCommentDiary(String join) {
String sql= "select a.id, a.content, a.title ...from post as a where find_in_set(a.id, ?)";
return this.find(sql,join);
}
find_in_set具体资料地址http://1055592535.iteye.com/blog/1674734