CKEditor使用

2020-05-21

字数统计: 1.2k字 | 阅读时长: 7分

阅读量

× 文章目录

1. CKEditor保存数据库、通过Thymeleaf解析到前台完整实现代码
1. 1.0.1. 目录结构

Writing by Tor小黑 —-心中藏之，无日忘之

CKEditor保存数据库、通过Thymeleaf解析到前台完整实现代码

目录结构

1.数据库表对应的实体类

PubNews.java

package com.web.entity;

public class PubNews {
    private Integer id;
    private String title;    //标题
    private String author;    //作者
    private String updateTime;    //更新时间
    private String viewCount;    //浏览数
    private String content;        //内容
    private String remark;        //备注
    private String status;        //状态
    public Integer getId() {
        return id;
    }
    public void setId(Integer id) {
        this.id = id;
    }
    public String getTitle() {
        return title;
    }
    public void setTitle(String title) {
        this.title = title;
    }
    public String getAuthor() {
        return author;
    }
    public void setAuthor(String author) {
        this.author = author;
    }
    public String getUpdateTime() {
        return updateTime;
    }
    public void setUpdateTime(String updateTime) {
        this.updateTime = updateTime;
    }
    public String getViewCount() {
        return viewCount;
    }
    public void setViewCount(String viewCount) {
        this.viewCount = viewCount;
    }
    public String getContent() {
        return content;
    }
    public void setContent(String content) {
        this.content = content;
    }
    public String getRemark() {
        return remark;
    }
    public void setRemark(String remark) {
        this.remark = remark;
    }
    public String getStatus() {
        return status;
    }
    public void setStatus(String status) {
        this.status = status;
    }
}

2.数据库的接口Dao层

PubNewsDao.java

package com.web.dao;

import org.apache.ibatis.annotations.Param;

import com.web.entity.PubNews;

public interface PubNewsDao {
	
    //增加新闻接口
    public abstract void addPubNews(PubNews pubnew);
    //根据ID查询新闻
    public abstract PubNews getNewsById(@Param("id") Integer id);
}

3.Dao接口实现

PubNewsMapper.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<!--命名空间应该是对应接口的包名+接口名 -->
<mapper namespace="com.web.dao.PubNewsDao">

	<insert id="addPubNews" parameterType="PubNews">
		insert into pub_news(author,content,title)
		values(#{author},#{content},#{title})
	</insert>
	
	<select id="getNewsById" resultType="PubNews">
    	select * from pub_news where id=#{id} 
    </select>

</mapper>

4.定义service接口

PubNewsService.java

package com.web.service;

import com.web.entity.PubNews;

public interface PubNewsService {
	
	public abstract void save(PubNews pubnew);

	public abstract PubNews getNewsById(Integer id);

	//public abstract PubNews getNewsById(Integer id);



}

5.service接口实现

PubNewsServiceImpl.java

package com.web.service.impl;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.web.dao.PubNewsDao;
import com.web.entity.PubNews;
import com.web.service.PubNewsService;

@Service
public class PubNewsServiceImpl implements PubNewsService {
	
	@Autowired
	private PubNewsDao pns;
	
	//service服务实现  存入数据库
	@Override
	public void save(PubNews pubnew) {
		pns.addPubNews(pubnew);
	}

	@Override
	public PubNews getNewsById(Integer id) {
		// TODO Auto-generated method stub
		return pns.getNewsById(id);
	}
}

6.控制器调用服务接口

PubNewsController.java

package com.web.controller;

import java.util.HashMap;
import java.util.Map;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import com.alibaba.fastjson.JSONObject;
import com.web.entity.PubNews;
import com.web.service.PubNewsService;

@Controller
@RequestMapping("pubnews")
public class PubNewsController {

	@Autowired
	private PubNewsService pns;

	@RequestMapping("ckeditor")
	public String ckeditor() {
		return "pubEditor/ckeditor";
	}

	@ResponseBody

	@RequestMapping("save")
	public Map<String, Object> save(PubNews pn) {
		System.out.println(JSONObject.toJSON(pn));
		Map<String, Object> resultMap = new HashMap<String, Object>();
		pns.save(pn);
		resultMap.put("result", "success");
		return resultMap;
	}
	
	//使用Thymeleaf解析ckeditor新闻
	@RequestMapping("get")
	public String getNews(Integer id,Model model) {
		System.out.println("Id:"+id);
		PubNews pn = pns.getNewsById(id);
		model.addAttribute("PubNews", pn);
		System.out.println(JSONObject.toJSON(pn));
		return "pubEditor/showNews";
	}

}

7.文件上传下载工具类

FileUtil.java

package com.web.util;

import java.awt.Graphics2D;
import java.awt.image.BufferedImage;
import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;
import javax.imageio.ImageIO;
import javax.servlet.http.HttpServletRequest;
import org.springframework.http.HttpHeaders;
import org.springframework.http.HttpStatus;
import org.springframework.http.ResponseEntity;
import org.springframework.web.multipart.MultipartFile;

public class FileUtil {
    /**
     * 
     * @param path
     *            文件最终保存路劲
     * @param file
     *            原始文件
     * @param desFileName
     *            最终保存文件名称
     * @return
     */
    public static boolean Save(String path, MultipartFile file, String desFileName) {
        File filePath=new File(path);
        if(!filePath.exists()) {
            filePath.mkdirs();
        }
        File dest = new File(desFileName);
        try {
            // 保存文件;
            file.transferTo(new File(path + dest));
            return true;
        } catch (IOException e) {
            // LOGGER.error(e.toString(), e);
            return false;
        }
    }
    public static ResponseEntity<byte[]> download(HttpServletRequest request, String  absPath) throws IOException {
        String tPath=System.getProperties().getProperty("user.home")+absPath;
        System.out.println("文件路径应该为:"+tPath);
        File file = new File(tPath);
        if(file.exists()) {
            byte[] body = null;
            InputStream is = new FileInputStream(file);
            body = new byte[is.available()];
            is.read(body);
            HttpHeaders headers = new HttpHeaders();
            headers.add("Content-Disposition", "attchement;filename=" + file.getName());
            HttpStatus statusCode = HttpStatus.OK;
            ResponseEntity<byte[]> entity = new ResponseEntity<>(body, headers, statusCode);
            return entity;
        }else {
            HttpHeaders headers = new HttpHeaders();
            headers.add("Content-Disposition", "attchement;filename='不存在'");
            HttpStatus statusCode = HttpStatus.OK;
            ResponseEntity<byte[]> entity = new ResponseEntity<>(null, headers, statusCode);
            return entity;
        }
    }
    public static boolean SaveImgIcon(String path, MultipartFile file, String desFileName) {
        File filePath=new File(path);
        if(!filePath.exists()) {
            filePath.mkdirs();
        }
        File dest = new File(desFileName);
        try {
            /*
             * File fileOld = new File(path + dest); fileOld.delete();
             */
            // 保存文件;        
            file.transferTo(new File(path + dest));
            BufferedImage input = ImageIO.read(new File(path+dest));
            BufferedImage inputbig = new BufferedImage(50, 50, BufferedImage.TYPE_INT_BGR);
            Graphics2D g = (Graphics2D) inputbig.getGraphics();
            g.drawImage(input, 0, 0,50,50,null); //画图
            g.dispose();
            input.flush();
            inputbig.flush();
            ImageIO.write(inputbig, "jpg", new File(path+dest)); //将其保存在C:/imageSort/targetPIC/下
            return true;
        } catch (IOException e) {
            // LOGGER.error(e.toString(), e);
            return false;
        }
    }
}

8.前台thymeleaf解析

ShowNews.java

<!DOCTYPE html SYSTEM "http://www.thymeleaf.org/dtd/xhtml1-strict-thymeleaf-4.dtd">
<html xmlns="http://www.w3.org/1999/xhtml"
	xmlns:th="http://www.thymeleaf.org">
<head>
<meta charset="UTF-8">
<title>显示新闻</title>
<script th:src="@{/js/jQuery34.js}"></script>
<script th:inline="javascript">
$(function(){
    console.log([[${PubNews.content}]])
    $("body").html([[${PubNews.content}]])
})
</script>
</head>
<body>
</body>
</html>