首先,定义个实体对象,用来接收参数。
@Entity
public class VideoApp {
@Id@Column(name="id")
private String id;
@Column
private String name;
@Column
private String score;
@Column
private String picturepath;
@Column
private String colunm;
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
dao层实现
Query query = sessionFactory.getCurrentSession().createSQLQuery(sql).addEntity(VideoApp.class);
return query.list();
controller实现 List<VideoApp> videolist=null;
String key="'"+category.getName()+"'";
String sql="SELECT a.name as name,a.id as id,a.picturepath as picturepath,a.colunm as colunm,a.score as score FROM Video a LEFT JOIN Video b ON a.colunm=b.colunm AND a.id<b.id WHERE a.category="+key+" GROUP BY a.id,a.colunm HAVING COUNT(b.colunm)<=5";
videolist=videoService.getlistbysql(sql);
JSONArray jsonObject = JSONArray.fromObject(videolist);
String s=jsonObject.toString();
PrintWriter out = response.getWriter();
response.setContentType("application/json;charset=utf-8");
out.write(s);
用时注意在hibernate和spring的xml配置好。