database config complete

John Woolbright · John Woolbright · commit fd03bdea6a5b · 2023-08-21T10:50:38.000-05:00
diff --git a/build.gradle b/build.gradle
@@ -19,6 +19,8 @@ dependencies {
 	implementation 'org.springframework.boot:spring-boot-starter-thymeleaf'
 	implementation 'org.springframework.boot:spring-boot-starter-validation'
 	implementation 'org.springframework.boot:spring-boot-starter-web'
+	implementation 'org.springframework.boot:spring-boot-starter-data-jpa'
+	implementation 'mysql:mysql-connector-java:8.0.32'
 	developmentOnly 'org.springframework.boot:spring-boot-devtools'
 	testImplementation 'org.springframework.boot:spring-boot-starter-test'
 }
diff --git a/src/main/resources/application.properties b/src/main/resources/application.properties
@@ -1 +1,17 @@
+# Database connection settings
+spring.datasource.url=jdbc:mysql://localhost:3306/coding_events
+spring.datasource.username=john
+spring.datasource.password=admin
 
+# Specify the DBMS
+spring.jpa.database = MYSQL
+
+# Show or not log for each sql query
+spring.jpa.show-sql = false
+
+# Hibernate ddl auto (create, create-drop, update)
+spring.jpa.hibernate.ddl-auto = update
+
+# Use spring.jpa.properties.* for Hibernate native properties (the prefix is
+# stripped before adding them to the entity manager)
+spring.jpa.properties.hibernate.dialect = org.hibernate.dialect.MySQL8Dialect

Original file line number	Diff line number	Diff line change
`@@ -19,6 +19,8 @@ dependencies {`
`19`	`19`	`implementation 'org.springframework.boot:spring-boot-starter-thymeleaf'`
`20`	`20`	`implementation 'org.springframework.boot:spring-boot-starter-validation'`
`21`	`21`	`implementation 'org.springframework.boot:spring-boot-starter-web'`
	`22`	`+ implementation 'org.springframework.boot:spring-boot-starter-data-jpa'`
	`23`	`+ implementation 'mysql:mysql-connector-java:8.0.32'`
`22`	`24`	`developmentOnly 'org.springframework.boot:spring-boot-devtools'`
`23`	`25`	`testImplementation 'org.springframework.boot:spring-boot-starter-test'`
`24`	`26`	`}`