Spring之路(32)–SpringMVC+SpringJDBC+jQuery+Bootstrap博客系统完整实例

CREATE TABLE `blog` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一标志',
  `title` varchar(255) DEFAULT '' COMMENT '标题',
  `author` varchar(255) DEFAULT '' COMMENT '作者姓名',
  `content` longtext COMMENT '内容',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8;

package org.maoge.sjblog.xdo;
/**
 * @theme 数据对象--博客
 * @author maoge
 * @date 2020-01-29
 */
public class BlogDo {
  private Long id;
  private String title;
  private String author;
  private String content;
  // 省略get get
}
5.2 封装数据访问层，并注册为bean
我们将博客数据访问层封装为BlogDao，并通过@Repositoy注册为bean，然后通过@Autowired注入jdbcTemplate对象。
package org.maoge.sjblog.dao;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import org.maoge.sjblog.xdo.BlogDo;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate;
import org.springframework.stereotype.Repository;
/**
 * @theme DAO--博客
 * @author maoge
 * @date 2020-01-29
 */
@Repository // 注册为组件
public class BlogDao {
  @Autowired // 自动注入
  private NamedParameterJdbcTemplate namedTemplate;
  /**
  * 新增
  */
  public void insert(BlogDo blog) {
  Map map = new HashMap<>();
  map.put("author", blog.getAuthor());
  map.put("content", blog.getContent());
  map.put("title", blog.getTitle());
  // 注意使用:xxx占位
  namedTemplate.update("insert into blog(author,content,title)values(:author,:content,:title)", map);
  }
  /**
  * 删除
  */
  public void delete(Long id) {
  Map map = new HashMap<>();
  map.put("id", id);
  namedTemplate.update("delete from blog where id =:id", map);
  }
  /**
  * 更新
  */
  public void update(BlogDo blog) {
  Map map = new HashMap<>();
  map.put("author", blog.getAuthor());
  map.put("content", blog.getContent());
  map.put("title", blog.getTitle());
  map.put("id", blog.getId());
  namedTemplate.update("update blog set author=:author,content=:content,title=:title where id=:id", map);
  }
  /**
  * 按id查询
  */
  public BlogDo getById(Long id) {
  Map map = new HashMap<>();
  map.put("id", id);
  return namedTemplate.queryForObject("select * from blog where id=:id", map, new RowMapper() {
    @Override
    public BlogDo mapRow(ResultSet rs, int rowNum) throws SQLException {
    BlogDo blog = new BlogDo();
    blog.setAuthor(rs.getString("author"));
    blog.setContent(rs.getString("content"));
    blog.setId(rs.getLong("id"));
    blog.setTitle(rs.getString("title"));
    return blog;
    }
  });
  }
  /**
  * 查询列表
  */
  public List getList() {
  return namedTemplate.query("select * from blog", new RowMapper() {
    @Override
    public BlogDo mapRow(ResultSet rs, int rowNum) throws SQLException {
    BlogDo blog = new BlogDo();
    blog.setAuthor(rs.getString("author"));
    blog.setContent(rs.getString("content"));
    blog.setId(rs.getLong("id"));
    blog.setTitle(rs.getString("title"));
    return blog;
    }
  });
  }
}

package org.maoge.sjblog.service;
import java.util.List;
import org.maoge.sjblog.dao.BlogDao;
import org.maoge.sjblog.xdo.BlogDo;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
/**
 * @theme 服务--博客
 * @author maoge
 * @date 2020-01-27
 */
@Service//替代@Component
public class BlogService {
  @Autowired // 自动注入BlogDao组件
  private BlogDao blogDao;
  /**
  * 获取博客列表
  */
  public List getBlogList() {
  return blogDao.getList();
  }
  /**
  * 按id获取博客信息
  */
  public BlogDo getBlogById(Long id) {
  return blogDao.getById(id);
  }
  /**
  * 新增博客
  */
  public void addBlog(BlogDo blog) {
  blogDao.insert(blog);
  }
  /**
  * 根据博客id更新博客信息
  */
  public void updateBlog(BlogDo blog) {
  blogDao.update(blog);
  }
  /**
  * 根据博客id删除对应博客
  */
  public void deleteBlog(Long id) {
  blogDao.delete(id);
  }
}
5.4 编写控制器，提供http接口
然后我们编写BlogController，按照Restful风格提供http接口，代码如下：
package org.maoge.sjblog.controller;
import java.util.List;
import org.maoge.sjblog.service.BlogService;
import org.maoge.sjblog.xdo.BlogDo;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.DeleteMapping;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.PutMapping;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RestController;
/**
 * @theme 控制器--博客
 * @author maoge
 * @date 2020-01-28
 */
@RestController // 通过该注解，第一将BlogController注册为控制器，第二将其中方法返回值转换为json
public class BlogController {
  @Autowired // 自动装配blogService
  private BlogService blogService;
  /**
  * 查询博客信息
  * 1、@GetMapping表示可以使用get方法请求该api
  * 2、"/blog/{id}"表示请求路径为/blog/{id}的形式，其中{id}为占位符
  * 3、@PathVariable("id")表示将占位符{id}的值传递给id
  * 4、也就是说/blog/123请求的话，会将123传递给参数id
  */
  @GetMapping(value="/blog/{id}")
  public BlogDo getOne(@PathVariable("id") long id) {
  return blogService.getBlogById(id);
  }
  /**
  * 查询博客列表，使用get方法
  */
  @GetMapping("/blog")
  public List getList(){
  return blogService.getBlogList();
  }
  /**
  * 新增博客
  * 1、@PostMapping表示使用post方法
  * 2、@RequestBody表示将请求中的json信息转换为BlogDo类型的对象信息，该转换也是由SpringMVC自动完成的
  */
  @PostMapping("/blog")
  public void add(@RequestBody BlogDo blog) {
  blogService.addBlog(blog);
  }
  /**
  * 修改博客
  * 实际上此处也可以不在路径中传递id，而是整个使用json传递对象信息，但是我查询了一些文档，貌似使用路径传递id更加规范一些，此处不用纠结
  */
  @PutMapping("/blog/{id}")
  public void update(@PathVariable("id") long id,@RequestBody BlogDo blog) {
  //修改指定id的博客信息
  blog.setId(id);
  blogService.updateBlog(blog);
  }
  /**
  * 删除博客
  */
  @DeleteMapping("/blog/{id}")
  public void delete(@PathVariable("id") long id) {
  blogService.deleteBlog(id);
  }
}

integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u" crossorigin="anonymous">

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xmlns:context="http://www.springframework.org/schema/context"
  xmlns:mvc="http://www.springframework.org/schema/mvc"
  xsi:schemaLocation="http://www.springframework.org/schema/beans 
        http://www.springframework.org/schema/beans/spring-beans-4.0.xsd
        http://www.springframework.org/schema/context
        http://www.springframework.org/schema/context/spring-context-4.0.xsd
        http://www.springframework.org/schema/mvc
        http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd">
  base-package="org.maoge.sjblog" />
  class="com.alibaba.druid.pool.DruidDataSource">
    value="com.mysql.jdbc.Driver">
    value="jdbc:mysql://127.0.0.1:3306/myblog?useUnicode=true&characterEncoding=utf-8">
  class="org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate">

xmlns="http://xmlns.jcp.org/xml/ns/javaee"
  xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd"
  id="WebApp_ID" version="3.1">
  springjdbcblog
 springmvc
 org.springframework.web.servlet.DispatcherServlet
  contextConfigLocation
  /WEB-INF/springmvc-config.xml
 1
 springmvc
 /*