@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);
}
}
