知乎专栏 |
ArticleRepository
package api.repository; import org.springframework.data.domain.Page; import org.springframework.data.domain.Pageable; import org.springframework.data.repository.CrudRepository; import org.springframework.stereotype.Repository; import api.domain.Article; @Repository public interface ArticleRepository extends CrudRepository<Article, Long> { Page<Article> findAll(Pageable pageable); }
Article.java
package api.domain; import java.io.Serializable; import javax.persistence.Column; import javax.persistence.Entity; import javax.persistence.Id; import javax.persistence.GeneratedValue; import javax.persistence.GenerationType; import javax.persistence.Table; @Entity @Table(name = "article") public class Article implements Serializable { private static final long serialVersionUID = 7998903421265538801L; @Id @GeneratedValue(strategy=GenerationType.IDENTITY) @Column(name = "id", unique=true, nullable=false, insertable=true, updatable = false) private Long id; private String title; private String content; public Article(){ } public Article(String title, String content) { this.title = title; this.content = content; } public Long getId() { return id; } public void setId(long id) { this.id = id; } public String getTitle() { return title; } public void setTitle(String title) { this.title = title; } public String getContent() { return content; } public void setContent(String content) { this.content = content; } @Override public String toString() { return "Article [id=" + id + ", title=" + title + ", content=" + content + "]"; } }
package api.web; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.jdbc.core.JdbcTemplate; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestParam; import org.springframework.web.bind.annotation.ResponseBody; import api.domain.City; import api.domain.Article; import api.ApplicationConfiguration; import api.repository.CityRepository; import api.repository.ArticleRepository; import api.service.TestService; @Controller public class IndexController { @Autowired private CityRepository repository; @Autowired private TestService testService; @Autowired private ApplicationConfiguration propertie; @Autowired private ArticleRepository articleRepository; @RequestMapping("/save") @ResponseBody public String save() { articleRepository.save(new Article("Neo", "Chen")); return "OK"; } @RequestMapping("/mysql") @ResponseBody public String mysql() { for (Article article : articleRepository.findAll()) { System.out.println(article); } return "OK"; } }