Notice
Recent Posts
Recent Comments
ยซ   2024/12   ยป
์ผ ์›” ํ™” ์ˆ˜ ๋ชฉ ๊ธˆ ํ† 
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
Archives
Today
In Total
๊ด€๋ฆฌ ๋ฉ”๋‰ด

A Joyful AI Research Journey๐ŸŒณ๐Ÿ˜Š

[13] 230412 ํฌํŠธํด๋ฆฌ์˜ค 13์ผ ์ฐจ Wed) ๋ฐฑ์—”๋“œ, ํ”„๋ก ํŠธ์—”๋“œ, ๋‚ด์šฉ ์ฒดํฌ๋ฆฌ์ŠคํŠธ [K-๋””์ง€ํ„ธ ํŠธ๋ ˆ์ด๋‹ 73์ผ] ๋ณธ๋ฌธ

๐Ÿ’–My Bootcamp Projects Logsโœจ/My Portfolio Website

[13] 230412 ํฌํŠธํด๋ฆฌ์˜ค 13์ผ ์ฐจ Wed) ๋ฐฑ์—”๋“œ, ํ”„๋ก ํŠธ์—”๋“œ, ๋‚ด์šฉ ์ฒดํฌ๋ฆฌ์ŠคํŠธ [K-๋””์ง€ํ„ธ ํŠธ๋ ˆ์ด๋‹ 73์ผ]

yjyuwisely 2023. 4. 12. 07:00

2304012 Wed 73rd class

๋ฐฑ์—”๋“œ (์Šคํ”„๋ง๋ถ€ํŠธ - ์Šคํ”„๋ง ์‹œํ๋ฆฌํ‹ฐ) ํ•  ๊ฒƒ ๋ฆฌ์ŠคํŠธ

  1. MySQL ์—ฐ๊ฒฐํ•˜๊ธฐ (์•„๋‹ˆ๋ฉด h2)
  2. ๋กœ๊ทธ์ธ, ๋กœ๊ทธ์•„์›ƒ ๋ฉ”์‹œ์ง€ ์ƒ๋‹จ์— ๋œจ๊ฒŒ ํ•˜๊ธฐ 
  3. ๊ด€๋ฆฌ์ž์˜ ํšŒ์› ๊ด€๋ฆฌ ํŽ˜์ด์ง€ ๋งŒ๋“ค๊ธฐ
  4. ํšŒ์›์˜ My Page ๋งŒ๋“ค๊ณ  ํšŒ์›์˜ ํšŒ์›์ •๋ณด์ˆ˜์ • ๊ตฌํ˜„ํ•˜๊ธฐ

https://memostack.tistory.com/155

 

Spring Boot ์—์„œ JPA ์‚ฌ์šฉํ•˜๊ธฐ (MySQL ์‚ฌ์šฉ)

MySQL ์„ค์ • MySQL ์„ค์น˜ MySQL ์„ค์น˜๋Š” ์•„๋ž˜ ๊ธ€ ์ฐธ๊ณ  2020/10/30 - [Database/RDB] - MySQL ์„ค์น˜ํ•˜๊ธฐ (Mac OSX) MySQL ์„ค์น˜ํ•˜๊ธฐ (Mac OSX) MySQL ์„ค์น˜ ๋ณธ ๊ธ€์—์„œ๋Š” Homebrew ๋ฅผ ์ด์šฉํ•˜์—ฌ MySQL ์„ ์„ค์น˜ํ•œ๋‹ค. $ brew update $ brew install

memostack.tistory.com

CSS์— ์ถ”๊ฐ€ํ•œ ๊ฒƒ

input{
	font-size:12px !important;
}

MySQL ์—ฐ๊ฒฐํ•˜๊ธฐ ์œ„ํ•œ ์ฝ”๋“œ

CREATE DATABASE users;
-- show databases;

-- ์‚ฌ์šฉ์ž ์ƒ์„ฑ
CREATE USER root@localhost
	IDENTIFIED BY 'admin';
    
-- DB ๊ถŒํ•œ ๋ถ€์—ฌ
GRANT ALL PRIVILEGES
	ON users.*
    TO root@localhost;
    

CREATE TABLE users (
    id INT NOT NULL AUTO_INCREMENT,
    firstName VARCHAR(255),
    lastName VARCHAR(255),
    email VARCHAR(255),
    password VARCHAR(255),
    PRIMARY KEY (id)
);

https://galid1.tistory.com/699

 

Spring Security - SpringSecurity ์ด์šฉํ•˜๊ธฐ 3 (logout ๊ธฐ๋Šฅ ์ถ”๊ฐ€ํ•˜๊ธฐ)

Spring Security Logout ๊ตฌํ˜„ SpringSecurity ์ด์šฉํ•˜๊ธฐ - 1 : https://galid1.tistory.com/688 (custom login form ๊ตฌํ˜„)SpringSecurity ์ด์šฉํ•˜๊ธฐ - 2 : https://galid1.tistory.com/698 (login Success Handle)SpringSecurity ์ด์šฉํ•˜๊ธฐ - 3 : ํ˜„์žฌ ํฌ์Šค

galid1.tistory.com

https://galid1.tistory.com/700

 

Spring Security - SpringSecurity ์ด์šฉํ•˜๊ธฐ 4 (Database๋ฅผ ์ด์šฉํ•œ Login ๊ตฌํ˜„)

Spring Security Database User Login ๊ตฌํ˜„ SpringSecurity ์ด์šฉํ•˜๊ธฐ - 1 : https://galid1.tistory.com/688 (custom login form ๊ตฌํ˜„)SpringSecurity ์ด์šฉํ•˜๊ธฐ - 2 : https://galid1.tistory.com/698 (login Success Handle)SpringSecurity ์ด์šฉํ•˜๊ธฐ - 3 : h

galid1.tistory.com

https://programmer93.tistory.com/m/37

 

์Šคํ”„๋ง ์‹œํ๋ฆฌํ‹ฐ DB๋ฅผ ์ด์šฉํ•œ ๋กœ๊ทธ์ธ ๊ตฌํ˜„ 1 ( ํšŒ์› ์„ค์ • ๋ฐ ์ผ๋ฐ˜ ๋กœ๊ทธ์ธ ) - ์‚ฝ์งˆ์ค‘์ธ ๊ฐœ๋ฐœ์ž

- spring security ๋กœ๊ทธ์ธ (mariaDB) - ์Šคํ”„๋ง ์‹œํ๋ฆฌํ‹ฐ ์Šคํ”„๋ง ๊ธฐ๋ฐ˜์˜ ๋ณด์•ˆ ๊ด€๋ จ ํ”„๋ ˆ์ž„์›Œํฌ์ด๋‹ค. ์Šคํ”„๋ง ์‹œํ๋ฆฌํ‹ฐ๋ฅผ ์‚ฌ์šฉํ•˜๋ฉด ๋ณด์•ˆ์— ๊ด€๋ จ๋œ ์˜ต์…˜์„ ์ž๋™์ ์œผ๋กœ ๊ตฌํ˜„ํ•ด์ฃผ๊ธฐ์— ์šฐ๋ฆฌ๊ฐ€ ์–ด๋Š์ •๋„ ์‹ ๊ฒฝ์„

programmer93.tistory.com

https://kimchanjung.github.io/programming/2020/07/02/spring-security-02/

 

[Spring Security] ์Šคํ”„๋ง์‹œํ๋ฆฌํ‹ฐ ์„ค์ •๊ฐ’๋“ค์˜ ์—ญํ• ๊ณผ ์„ค์ •๋ฐฉ๋ฒ•(2)

์Šคํ”„๋ง์‹œํ๋ฆฌํ‹ฐ์˜ ์—ฌ๋Ÿฌ๊ฐ€์ง€ ์„ค์ •๊ฐ’๋“ค์˜ ์—ญํ• ๊ณผ ์„ค์ •๋ฐฉ๋ฒ•์„ ์ƒ์„ธํžˆ ์•Œ์•„๋ด…๋‹ˆ๋‹ค. Spring Security ์ปค์Šคํ…€ ํ•„ํ„ฐ๋ฅผ ์ด์šฉํ•œ ์ธ์ฆ ๊ตฌํ˜„ - ์Šคํ”„๋ง์‹œํ๋ฆฌํ‹ฐ ์„ค์ •(2) ๋ณธ ํฌ์ŠคํŒ…์€ ์Šคํ”„๋ง์‹œํ๋ฆฌํ‹ฐ์˜ ์ „๋ฐ˜์ ์ธ

kimchanjung.github.io


- ๋‚ด์šฉ ์ˆ˜์ • ํ•  ๊ฒƒ

  1. ์„น์…˜๋“ค "์ด๋ฏธ์ง€" ์ฑ„์›Œ ๋„ฃ์Œ
  2. ํฌํŠธํด๋ฆฌ์˜ค๋„ ํ”„๋กœ์ ํŠธ ์„น์…˜์— ๋„ฃ๊ธฐ
  3. ๋‚ด์šฉ ์ ์ ˆํ•œ์ง€ ์ฒดํฌํ•˜๊ธฐ

- ํ”„๋ก ํŠธ์—”๋“œ ํ•  ๊ฒƒ

  1. ๋กœ๊ทธ์ธ, ํšŒ์›๊ฐ€์ž… ํŽ˜์ด์ง€ INPUT ์•ˆ์˜ ํ…์ŠคํŠธ ํฌ๊ฒŒ ๋งŒ๋“ค๊ธฐ [์™„๋ฃŒ]
  2. ๋ฐฑ์—”๋“œ ๊ณต๊ฐ„ ์„น์…˜: ๋กœ๊ทธ์ธ, ํšŒ์›๊ฐ€์ž… ์œˆ๋„์šฐ ํฌ๊ธฐ ๋ฐ˜์‘ํ˜•์œผ๋กœ ๋ฐ”๊พธ๊ธฐ
  3. ๊ธฐ์ˆ  ์„น์…˜: ์ด๋ฏธ์ง€๋กœ ๋ฐ”๊พธ๊ธฐ (์ƒ๊ฐ)
  4. ํฌํŠธํด๋ฆฌ์˜ค: ๋ฉ”๋‰ด ํฐํŠธ ์ƒ‰์ƒ ์ด๋™ํ•˜๋ฉด ๋ณ€๊ฒฝ๋˜๊ฒŒ ๋งŒ๋“ค๊ธฐ(์ž๋ฐ”์Šคํฌ๋ฆฝํŠธ)
  5. ์ „์ฒด ์„น์…˜: ๋ฐ”ํƒ• ๋ˆ„๋ฅด๋ฉด ์งง๊ฒŒ ๋ฐ‘์œผ๋กœ ๋‚ด๋ ค๊ฐ”๋‹ค ์˜ฌ๋ผ๊ฐ€๋Š” ๋””์ž์ธ
  6. ๋ฐ˜์‘ํ˜•์ผ ๋•Œ ๋œจ๋Š” ๋ฉ”๋‰ด๋ฐ” ํฌ๊ธฐ, ์ƒ‰์ƒ, ์•„์ด์ฝ˜ ๋ณ€๊ฒฝํ•˜๊ธฐ
  7. ์ปจํ…Œ์ด๋„ˆ ์•„์šฐํ„ฐ ์ง™๊ฒŒ ์ฑ„์šฐ๊ธฐ
  8. three.js ํ™œ์šฉ

- ๊ฐœ์ธํ”„๋กœ์ ํŠธ 1

  1. ๋ฐฑ์—”๋“œ ์ ์šฉํ•˜๊ณ  ํฌํŠธํด๋ฆฌ์˜ค์˜ "์„น์…˜: ํ”„๋กœ์ ํŠธ1 ์„ค๋ช…" ์ฑ„์›Œ ๋„ฃ๊ธฐ
  2. ๋ฐฑ์—”๋“œ ์ ์šฉํ•˜๊ณ  ๊นƒํ—ˆ๋ธŒ ๋‚ด ํ”„๋กœ์ ํŠธ ์„ค๋ช… ์“ฐ๊ธฐ
  3. ์‚ฌ์ง„ ์˜ฌ๋ฆฌ๊ธฐ ๊ธฐ๋Šฅ ๊ตฌํ˜„ํ•˜๊ธฐ (์‚ฌ์ง„ ์˜ฌ๋ฆฌ๊ธฐ => ๋ฐ˜์‘ํ˜•์œผ๋กœ ๋งŒ๋“ฆ)
  4. ์„ธ๋ถ€ ๊ฒŒ์‹œํŒ๋“ค ๋‹ค ์ฑ„์›Œ๋„ฃ๊ธฐ
  5. ํ”„๋ก ํŠธ์—”๋“œ: ํšŒ์›๊ฐ€์ž…, ๋กœ๊ทธ์ธ ์œ ํšจ์„ฑ ๊ฒ€์‚ฌ ์™„๋ฃŒํ•˜๊ธฐ

728x90
๋ฐ˜์‘ํ˜•
Comments