//查询附件信息
public List queryAttaches(String id){
StringBuffer sql = new StringBuffer("select * from ATTACH where id = '"+id+"' ");
return jdbcTemplate.queryEntitys(sql.toString(),AttachEntity.class);
}
//根据pid查询附件信息
public List queryAttachesByPid(String pid){
StringBuffer sql = new StringBuffer("select * from ATTACH where pid = '"+pid+"' ");
return jdbcTemplate.queryEntitys(sql.toString(),AttachEntity.class);
}