String boot <3> mysql

来源：互联网发布：看演唱会软件编辑：程序博客网时间：2024/05/16 06:52

pom.xml 要添加MySQL jap 、mysql、web

package com.java1234;import javax.persistence.Column;import javax.persistence.Entity;import javax.persistence.GeneratedValue;import javax.persistence.Id;import javax.persistence.Table;@Entity@Table(name="book")public class Books {@Id@GeneratedValueprivate int id;@Column(length=100)private String name;@Column(length=50)private String author;public int getId() {return id;}public void setId(int id) {this.id = id;}public String getName() {return name;}public void setName(String name) {this.name = name;}public String getAuthor() {return author;}public void setAuthor(String author) {this.author = author;}}

一、声明实体

@Entity

对实体注释。任何Hibernate映射对象都要有这个注释

@Table

声明此对象映射到数据库的数据表，通过它可以为实体指定表(talbe),目录(Catalog)和schema的名字。该注释不是必须的，如果没有则系统使用默认值(实体的短类名)。

package com.java1234.controller;import javax.annotation.Resource;import org.springframework.stereotype.Controller;import org.springframework.web.bind.annotation.GetMapping;import org.springframework.web.bind.annotation.PathVariable;import org.springframework.web.bind.annotation.RequestMapping;import org.springframework.web.bind.annotation.RequestMethod;import org.springframework.web.servlet.ModelAndView;import com.java1234.Books;import com.java1234.dao.Bookdao;@Controller@RequestMapping("books")public class bookcontrpoller {@Resourceprivate Bookdao bookdao;@RequestMapping("/list")public ModelAndView list() {ModelAndView mav = new ModelAndView();mav.addObject("bookslist", bookdao.findAll());mav.setViewName("booklist");return mav;}@RequestMapping(value="/addbook",method=RequestMethod.POST)public String addbook(Books book) {bookdao.save(book);return "forward:/books/list";}@RequestMapping("/perupdata/{id}")public ModelAndView perupdata(@PathVariable("id") Integer id) {System.out.println("id:"+id);ModelAndView mav = new ModelAndView();mav.addObject("bookslist", bookdao.getOne(id));mav.setViewName("updatal");return mav;}@GetMapping(value="delete")/**@postMapping
**/public String delete(Integer id) {System.out.println("id:"+id);ModelAndView mav = new ModelAndView();bookdao.delete(id);return "forward:/books/list";}}

application.properties文件改为application.yml 更有层次感
server:     port: 80    context-path: /spring:   datasource:     driver-class-name: com.mysql.jdbc.Driver    url: jdbc:mysql://localhost:3306/book    username: root    password: 123456  jpa:     hibernate:       ddl-auto: update    show-sql: true

阅读全文

0 0