This project is a CRUD Java Spring Boot application for a vet clinic that stores the information of pets, owners, and appointments in an SQL Server database. The application also has a Kafka pipeline integrated to send confirmation emails to the pet owners when an appointment is made.
- Java 11
- Spring Boot 2.5.1
- JPA
- SQL Server
- Kafka
- Create, read, update, and delete pet information
- Create, read, update, and delete owner information
- Create, read, update, and delete appointment information
- Integration with Kafka to send confirmation emails to owners when an appointment is made
Clone the repo and then do the following:
You need to create and populate the entire application.properties file that is located in src/main/resources with the following template
server.address=127.0.0.1
server.port=4000
spring.datasource.url=
spring.datasource.username=
spring.datasource.password=
spring.jpa.show-sql=true
spring.jpa.properties.hibernate.format_sql=true
spring.jpa.hibernate.ddl-auto=create-drop
spring.kafka.bootstrap-servers=localhost:9092
spring.mail.host=your.smtp.host
spring.mail.port=your.smtp.port
spring.mail.username=your.email.username
spring.mail.password=your.email.password
spring.mail.properties.mail.smtp.auth=true
spring.mail.properties.mail.smtp.starttls.enable=true
- Got to the Apache Quickstart and follow the instructions. By default it should start in 9092
- Create the database using your favorite SQL Server Management Service. Then change the connection string in the spring.datasource.url field
- Populate your username and password to access the DB
- Change the properties for your email sending configuration
- After that you should be ready to run the app using Maven