页面展示信息功能
- 新闻展示
在这里我们需要提取到数据库中的所有新闻信息,然后进行分页展示,首先先在NewService接口中声明一个分页查询的方法
//主页分页展示
Page<News> listNew(Pageable pageable);
再在Impl中实现该方法,直接使用jpa中根据分页查询的方法
@Override
public Page<News> listNew(Pageable pageable) {
return newRepository.findAll(pageable);
}
最后再在indexController中调用该方法显示
@Controller
public class indexController {
@Autowired
private NewService newService;
@GetMapping("/")
public String index(@PageableDefault(size = 3,sort = {"updateTime"},direction = Sort.Direction.DESC)
Pageable pageable, Model model){
model.addAttribute("page",newService.listNew(pageable));
return "index";
}
}
- 分类展示
//不分页的List 在查找新闻界面显示出
List<Type> listTypeTop(Integer size);
@Query("select t from Type t")
List<Type> findTop(Pageable pageable);
在Impl中实现该方法,根据分类下的新闻数量进行排序
//显示在主页
@Override
public List<Type> listTypeTop(Integer size) {
Sort sort = Sort.by(Sort.Direction.DESC,"news.size");
Pageable pageable = PageRequest.of(0,size,sort);
return typeRepository.findTop(pageable);
}
最后在indexController中添加该方法显示
@Controller
public class indexController {
@Autowired
private NewService newService;
@Autowired
private TypeService typeService;
@GetMapping("/")
public String index(@PageableDefault(size = 3,sort = {"updateTime"},direction = Sort.Direction.DESC)
Pageable pageable, Model model){
model.addAttribute("page",newService.listNew(pageable));
model.addAttribute("types",typeService.listTypeTop(3));
return "index";
}
}
- 标签展示
各个类的展示:
TagRepository
@Query("select t from Tag t")
List<Tag> findTop(Pageable pageable);
TagService
//显示在主页
List<Tag> listTagTop(Integer size);
indexController
@Controller
public class indexController {
@Autowired
private TypeService typeService;
@Autowired
private TagService tagService;
@Autowired
private NewService newService;
@GetMapping("/")
public String index(@PageableDefault(size = 3,sort = {"updateTime"},direction = Sort.Direction.DESC)
Pageable pageable, Model model){
model.addAttribute("page",newService.listNew(pageable));
model.addAttribute("types",typeService.listTypeTop(3));
model.addAttribute("tags",tagService.listTagTop(3));
return "index";
}
}
效果:
搜索新闻功能
在主页显示新闻之后,右上角有一个搜索新闻功能,可以根据文章标题和文章内容进行模糊搜索
首先在NewRepository中声明接口方法自定义sql语句进行查询
// //输入标题或文本内容查询
@Query("select n from News n where n.title like ?1 or n.content like ?1")
Page<News> findByQuery(String query, Pageable pageable);
NewService
//全局搜索
Page<News> listNew(String query,Pageable pageable);
实现方法
@Override
public Page<News> listNew(String query, Pageable pageable) {
return newRepository.findByQuery(query,pageable);
}
indexController:
//搜索
@PostMapping("/search")
public String search(@PageableDefault(size = 3,sort = {"updateTime"},direction = Sort.Direction.DESC)Pageable pageable,
@RequestParam String query,Model model){
model.addAttribute("page",newService.listNew("%"+query+"%",pageable));
model.addAttribute("query",query);
return "search";
}
效果
新闻详情跳转功能
Impl需要用到一个工具类MarkDownUtils
package com.tengshan.springpro.util;
import org.commonmark.Extension;
import org.commonmark.ext.gfm.tables.TableBlock;
import org.commonmark.ext.gfm.tables.TablesExtension;
import org.commonmark.ext.heading.anchor.HeadingAnchorExtension;
import org.commonmark.node.Link;
import org.commonmark.node.Node;
import org.commonmark.parser.Parser;
import org.commonmark.renderer.html.AttributeProvider;
import org.commonmark.renderer.html.AttributeProviderContext;
import org.commonmark.renderer.html.AttributeProviderFactory;
import org.commonmark.renderer.html.HtmlRenderer;
import java.util.*;
public class MarkdownUtils {
/**
* markdown格式转换成HTML格式
* @param markdown
* @return
*/
public static String markdownToHtml(String markdown) {
Parser parser = Parser.builder().build();
Node document = parser.parse(markdown);
HtmlRenderer renderer = HtmlRenderer.builder().build();
return renderer.render(document);
}
/**
* 增加扩展[标题锚点,表格生成]
* Markdown转换成HTML
* @param markdown
* @return
*/
public static String markdownToHtmlExtensions(String markdown) {
//h标题生成id
Set<Extension> headingAnchorExtensions = Collections.singleton(HeadingAnchorExtension.create());
//转换table的HTML
List<Extension> tableExtension = Arrays.asList(TablesExtension.create());
Parser parser = Parser.builder()
.extensions(tableExtension)
.build();
Node document = parser.parse(markdown);
HtmlRenderer renderer = HtmlRenderer.builder()
.extensions(headingAnchorExtensions)
.extensions(tableExtension)
.attributeProviderFactory(new AttributeProviderFactory() {
public AttributeProvider create(AttributeProviderContext context) {
return new CustomAttributeProvider();
}
})
.build();
return renderer.render(document);
}
/**
* 处理标签的属性
*/
static class CustomAttributeProvider implements AttributeProvider {
@Override
public void setAttributes(Node node, String tagName, Map<String, String> attributes) {
//改变a标签的target属性为_blank
if (node instanceof Link) {
attributes.put("target", "_blank");
}
if (node instanceof TableBlock) {
attributes.put("class", "ui celled table");
}
}
}
public static void main(String[] args) {
String table = "| hello | hi | 哈哈哈 |\n" +
"| ----- | ---- | ----- |\n" +
"| 斯维尔多 | 士大夫 | f啊 |\n" +
"| 阿什顿发 | 非固定杆 | 撒阿什顿发 |\n" +
"\n";
String a = "[imCoding 爱编程](http://www.lirenmi.cn)";
System.out.println(markdownToHtmlExtensions(a));
}
}
NewService中声明一个方法
//获取新闻跳转
News getAndConvert(Long id);
NewServiceImpl
@Override
public News getAndConvert(Long id) {
News news = newRepository.findById(id).orElse(null);
if(news==null){
System.out.println("该新闻不存在");
}
News news1 = new News();
BeanUtils.copyProperties(news,news1);
String content = news1.getContent();
news1.setContent(MarkdownUtils.markdownToHtmlExtensions(content));
return news1;
}
indexController中实现
//展示点击的新闻
@RequestMapping("/news/{id}")
public String news(@PathVariable Long id,Model model){
News news = newService.getAndConvert(id);
model.addAttribute("news",news);
return "new";
}
效果: