Spring Boot无法连接到MySql

Question

这是我使用Spring Boot的第一次练习，这是我的应用程序。属性：

spring.jpa.database-platform=org.hibernate.dialect.MySQL5InnoDBDialect
spring.jpa.hibernate.ddl-auto=update
spring.datasource.driverClassName=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc.mysql://localhost:3306/notedb
spring.datasource.username=root
spring.datasource.password=*******

这些是我的课程：

>

DemomysqlApplication.java

@ComponentScan(BasePackages={“Com.JoyDeep.SpringBoot”}）公共类DemoMysqlApplication{

 public static void main(String[] args) {
     SpringApplication.run(DemoMysqlApplication.class, args);


 }

noteRepository.java（接口）：

package com.example.demomysql;
    
    import org.springframework.data.repository.CrudRepository;
     
    public interface NoteRepository extends CrudRepository <Note, Integer>{
    
    }

    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Controller;
    import org.springframework.ui.Model;
    import org.springframework.web.bind.annotation.GetMapping;
    import org.springframework.web.bind.annotation.RequestMapping;
    import org.springframework.web.bind.annotation.ResponseBody;
    
    
       @RestController
        @RequestMapping(value="/note")
        public class NoteController {
            
            
            @Autowired
            private NoteRepository noteRepository;
            
            @GetMapping(value="/all")
            public String getAllNotes(Model model) {
                model.addAttribute("notes", noteRepository.findAll());
                return "list";
            }
            
            @GetMapping(value="/debug")
            public @ResponseBody Iterable<Note> getNotes(){
                return noteRepository.findAll();
            }
            
        }

package com.example.demomysql;

import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;

import org.springframework.data.repository.CrudRepository;

@Entity
public class Note {
    
    @Id
    @GeneratedValue(strategy=GenerationType.AUTO)
    private Integer id;
    
    private String title;
    private String description;
    private Boolean done;
    
    public Integer getId() {
        return id;
    }
    
    public String getTitle() {
        return title;
    }
    public void setTitle(String title) {
        this.title = title;
    }
    public String getDescription() {
        return description;
    }
    public void setDescription(String description) {
        this.description = description;
    }
    public Boolean getDone() {
        return done;
    }
    public void setDone(Boolean done) {
        this.done = done;
    }
    

}

从控制台，我没有看到错误。Tomcat正常启动。这是最后两个信息：

Tomcat started on port(s): 8080 (http) with context path ''

Started DemoMysqlApplication in 0.731 seconds (JVM running for 480.726)

我想我对控制器类有问题。拜托，你能帮帮我吗？

谢谢

Answer 1

pring.jpa.hibernate.ddl-auto=update
spring.datasource.platform=mysql
spring.datasource.url=jdbc:mysql://localhost:3306/notedb?createDatabaseIfNotExist=true
spring.datasource.username=root
spring.datasource.password=****
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.jpa.properties.hibernate.dialect = org.hibernate.dialect.MySQL5InnoDBDialect

>

删除

>

exclude={DatasourceAutoConfiguration.class}

@componentscan(BasePackages={“com.joydeep.springboot”}）

应用程序

@SpringBootApplication
public class DemoMysqlApplication {
    public static void main(String[] args) {
        SpringApplication.run(DemoMysqlApplication.class, args);
    }

休息控制器

    @RestController
    @RequestMapping(value="/note")
    public class NoteController {

        @Autowired
        private NoteRepository noteRepository;

        @GetMapping(value="/debug")
        public List<Note> getNotes(){
            return noteRepository.findAll();
        }

    }

控制器

@Controller
    @RequestMapping(value="/note")
    public class NoteController {

        @Autowired
        private NoteRepository noteRepository;

        @GetMapping(value="/debug")
        public ResponseEntity<List<Note>> getNotes(){
             return new ResponseEntity<List<Note>>(noteRepository.findAll(),HttpStatus.OK);
        }

    }