SpringBoot第04天_Spring Data JPA_IoC
安裝啟用XAMPP 將MySQL環境架設起來後 這裡若要更改預設springboot預設專案的port可以於 src/main/resources/application.properties 增加這行 server.port = 9090 這邊我mysql phpmyadmin用的port剛好也是8080會有衝突 所以更改我們的springboot專案預設port 於mysql (phpmyadmin)創建我們的資料庫命名為crmdb 於資料庫中產生一張customer 資料表 1 2 3 4 5 6 7 8 9 10 CREATE TABLE CUSTOMER( id BIGINT AUTO_INCREMENT PRIMARY KEY , first_name VARCHAR ( 64 ), last_name VARCHAR ( 64 ), email_address VARCHAR ( 64 ), address VARCHAR ( 64 ), city VARCHAR ( 64 ), country VARCHAR ( 64 ), phone_number VARCHAR ( 24 ) ); 以及相應測試用假資料 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 insert into customer (id, first_name, last_name, email_address, address, city, country, phone_number) values ( 1 , 'Barrett' , 'Velez' , 'bvelez0@google.pl' , '4747 Butternut Crossing' , 'Pestovo' , 'Russia' , '+7 (584) 984-8612' ); insert into customer (id, first_name, last_name, email...