Blog

You are currently viewing Spring Boot Masterclass – Setup the MySQL database 02

Spring Boot Masterclass – Setup the MySQL database 02

Hello in this post, we will set up the MySQL database and we configure the data source in the spring boot project. let’s begin.

Create a MySQL database,

CREATE DATABASE ecom;

Execute the query to create the expense table,

CREATE TABLE tbl_expenses
(
    id BIGINT(20) PRIMARY KEY NOT NULL AUTO_INCREMENT,
    amount DECIMAL(19, 2) NOT NULL,
    created_at BIGINT(20) NOT NULL,
    description VARCHAR(255) NOT NULL,
    note VARCHAR(255)
);



Next, configure the data source in the spring boot project. Add the following code inside the application.properties file

spring.datasource.url=jdbc:mysql://localhost:3306/ecom?useSSL=false
spring.datasource.username=expensetracker
spring.datasource.password=expensetracker

# spring.jpa.generate-ddl=true

 

Our Best Partners: https://vironlisenssikasinot.com/ jogar mines nopea kasino crazy time big win 2022 king billy casino uudet casino bonukset play fishin frenzy online talleta ja pelaa ilman rekisteröitymistä kasino demo do touro
Post Views: 3,194

Related posts:

  1. Spring Boot Masterclass – Create Spring Boot Project using Spring Initializer 01
  2. Angular 9 and Spring Boot CRUD Tutorial – Introduction and Setup
  3. Spring Boot Masterclass – Configure the JSP view template 03
  4. Complete CRUD Application with Spring Boot, Hibernate and MySQL
  5. Creating REST API using Spring Boot + Hibernate + MySQL
  6. Spring Boot Masterclass – Create an entity class for Expense 05
  7. Spring Boot Masterclass – Create service and repository for Expense 06
  8. Spring Boot Masterclass – Display the list of expense in JSP 08
  9. Spring Boot Masterclass – Call service method and print data in console 07
  10. Angular 9 and Spring Boot CRUD Tutorial – Feature 1 Display list of records in browser

Bushan Sirgur

Hey guys, I am Bushan Sirgur from Banglore, India. Currently, I am working as an Associate project in an IT company.

This Post Has 2 Comments

  1. Alem Aweke June 30, 2020 Reply

    Hi Bushan,
    I started to work on an Angular 8/Spring boot project you shared on YouTube and found out later that those videos are no more there. Shall we expect that you share them again?

    Thank you.

    1. Bushan Sirgur July 3, 2020 Reply

      Hello,

      I am really sorry! I removed those videos as i was working for same project in my organization, they saw those videos and told me to remove as they violates the company policy. So i removed them! I will re-create those videos may be the future. But for now you can watch my other course Spring Boot Masterclass 🙂 Let me know if you need anything else.

Leave a Reply