Spring Boot से लोकलहोस्ट MySQL कैसे कनेक्ट करें

application.properties कॉन्फ़िगरेशन

spring.datasource.username=yourMySQLUserName
spring.datasource.password=yourMySQLPassword
spring.datasource.url=jdbc:mysql://localhost:3306/yourDatabaseName
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver

टेस्ट टेबल

mysql> create table demo71 (id int, name varchar(20));
mysql> insert into demo71 values(100,'John'), (101,'David'), (102,'Bob');

Spring Boot कंट्रोलर कोड

@RestController
@RequestMapping("/table")
public class TableController {
    @Autowired EntityManager entityManager;
    @GetMapping("/demo71")
    public String getData() {
        Query sqlQuery = entityManager.createNativeQuery("select name from demo71");
        List result = sqlQuery.getResultList();
        StringBuilder sb = new StringBuilder();
        for (String s : result) sb.append(s).append(" ");
        return sb.toString();
    }
}

मुख्य क्लास और चलाना

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

चलाने के बाद URL हिट करें: https://localhost:8093/table/demo71

आउटपुट: John David Bob