@Data
@NoArgsConstructor
@AllArgsConstructor
public class Article implements Serializable {
private Long articleId;
private Long userId=1l ;
private String title;
private String name;
private Integer viewNum=0 ;
private Integer commentNum=0 ;
private long categoryId ;
private Timestamp createTime;
}
4.2 dao層建立
@Mapper
@Repository
public interface ArticleDao {
//查詢所有文章
public List<Article> queryAll();
//根據id查詢文章
public Article queryById(long id);
//添加文章
public Boolean addArticle(Article article);
}
4.3 servcie層建立
ArticleService
public interface ArticleService {
//查詢所有文章
public List<Article> queryAll();
//根據id查詢文章
public Article queryById(long id);
//添加文章
public Boolean addArticle(Article article);
}
ArticleServiceImpl
@Service
@Transactional
public class ArticleServiceImpl implements ArticleService {
@Autowired
private ArticleDao articleDao;
@Override
public List<Article> queryAll() {
return articleDao.queryAll();
}
@Override
public Article queryById(long id) {
return articleDao.queryById(id);
}
@Override
public Boolean addArticle(Article article) {
return articleDao.addArticle(article);
}
}
注意加上@Transactional注解
4.4 ArticleMapper.xml
這裡主要寫sql語句，建議先在SQLyog中自己測一遍，做大項目，一般都要自己寫sql語句。
<?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">
<!--查官網https://mybatis.org/mybatis-3/zh/getting-started.html-->
<mapper namespace="com.xinxin.dao.ArticleDao">
<select id="queryAll" resultType="Article">
select * from articles
</select>
<select id="queryById" parameterType="Long" resultType="Article">
select * from articles where article_id = #{articleId}
</select>
<insert id="addArticle" parameterType="Article">
insert into articles
(user_id,title,name,view_num,comment_num,category_id,create_time)
-- 注意這裡與pojo中的參數名相對應，不要搞錯了
VALUES(#{userId},#{title},#{name},#{viewNum},#{commentNum},#{categoryId},#{createTime})
</insert>
</mapper>
4.5 controller層
@RestController
public class ArticleController {
@Autowired
private ArticleService articleService;
//查詢所有
@GetMapping("/api/queryAll")
public Object queryAll(){
return articleService.queryAll();
}
//根據id查詢
@GetMapping("api/queryById/{id}")
public Object queryById(@PathVariable("id") long id){
return articleService.queryById(id);
}
//增加article
@PostMapping("api/addArticle")
public Boolean addAritcle(Article article){
return articleService.addArticle(article);
}
}
