主要查询数据库表中的content内容里的图片地址
content内容为:
<p>
文章内容内容内容内容<img alt="" src="/jeesite/userfiles/images/QQ%E5%9B%BE%E7%89%8720160408141848(1).png" style="width: 464px; height: 324px;" /><img alt="" src="/jeesite/userfiles/images/QQ%E5%9B%BE%E7%89%8720160411105812.png" style="width: 232px; height: 294px;" /></p>
ArticleDataDao.xml
<!-- 分页查询文章内容列表 -->
<select id="queryArticleDataList" resultType="java.util.HashMap">
select * from cms_article_data where id>=(
select id from cms_article_data order by id limit #{page},1
)limit #{pageSize}
</select>
ArticleDataDao.java
public List<HashMap<String, String>> queryArticleDataList(@Param("page") Integer page,@Param("pageSize") Integer pageSize);
ArticleDataService
@Transactional(readOnly = false)
public List<HashMap<String, String>> queryArticleDataList(String page,String pageSize){
Integer pageSizes=Integer.valueOf(pageSize);
Integer pages=(Integer.valueOf(page)-1)*pageSizes;
return articleDataDao.queryArticleDataList(pages,pageSizes);
}
picRest
@Path("/pic")
@Component
public class PicRest {
private static Logger logger=Logger.getLogger(UserRest.class);
@Autowired
private ArticleDataService articleDataService;
/**
* 获取图片地址
* @param id
* @return
*/
@GET
@Path("picUrl")
@Produces(MediaType.APPLICATION_JSON)
public JSONObject findContent(@QueryParam("page") String page
,@QueryParam("pageSize") String pageSize
){
try {
if (StringUtils.isEmpty(page))
return JsonMapper.failure2AndroidJson("查询页数不能为空");
if (StringUtils.isEmpty(pageSize))
return JsonMapper.failure2AndroidJson("查询条数不能为空");
List<HashMap<String, String>> contentList=articleDataService.queryArticleDataList(page,pageSize);
List<String> picURLs =new ArrayList<String>();
for (int i = 0; i < contentList.size(); i++) {
HashMap<String, String> contentMap=contentList.get(i);
//获取content内容
String content= contentMap.get("content");
//获取content中”/jeesite“第一次出现位置的索引
int start=content.indexOf("/jeesite");
//获取”/jeesite“后”““第一次出现位置的索引
int end=content.indexOf("\"",start+1);
while(start!=-1){
//获取start和end索引中间的字符串
String pic=content.substring(start, end);
//查找下一处"/jeesite"和”“”出现位置的索引
start=content.indexOf("/jeesite",start+1);
end=content.indexOf("\"",start+1);
String picURL= FileUtils.path(pic);
picURLs.add(picURL);
//将修改后的图片地址存入list
contentMap.put("content", picURLs.toString());
contentList.set(i, contentMap);
}
}
return JsonMapper.success2AndroidJson(contentList);
} catch (Exception e) {
logger.error("获取图片地址接口异常", e);
return JsonMapper.failure2AndroidJson("获取图片地址接口异常");
}
}
}