https://dev-coco.tistory.com/56

양방향 암호화

단방향 암호화

SELECT * FROM board
WHERE title IN['프론트엔드 팀', '백엔드 팀']

SELECT * FROM board
WHERE title LIKE '%팀%'

https://gent.tistory.com/401

https://boring9.tistory.com/48

SELECT * FROM board
WHERE title LIKE '%팀%'

SELECT * FROM board AS b -- 첫번째 테이블 <board(b)>
INNER JOIN member AS m -- 두번째 테이블 <member(m)>
ON b.mem_idx=m.mem_idx -- board의 mem_idx와 member의 mem_idx는 같음
WHERE b.title IN ('백엔드 팀') -- board에서 '백엔드 팀'인 거만 소환

package com.ds.ds_front.controller;

import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;

@Controller
public class ViewController {
	
	@GetMapping("/detailUser")
	public String detailUser(@RequestParam(value="user_idx") int user_idx, Model model) {
		
		String idFromDB = "hello";
		String nickFromDB = "나현";
		String telFromDB = "010-1234-5678";
		
		model.addAttribute("id",idFromDB);
		model.addAttribute("nick",nickFromDB);
		model.addAttribute("tel",telFromDB);
		
		return "detail-user";
	}
	
	@GetMapping("/getUser/{userIdx}")
	@ResponseBody 
	public String addUser(@PathVariable("userIdx") int userIdx) {
			
			return "ok";
	}
	
	@GetMapping("/saveUser")
	@ResponseBody
	public String saveUser(@RequestParam(value="uid") String id, @RequestParam(value="upw") String pw) {
		System.out.println(id);
		System.out.println(pw);
		return "아이디 : "+id+" / 비밀번호 : "+pw;
	}
	
	@GetMapping("/")
	public String home() {
		return "home";
	}
}

-- 데이터 삭제
DELETE FROM item
WHERE user_idx=1

-- 정보변경
UPDATE item
SET 
	stock_cnt=stock_cnt-25
WHERE item_idx=1

-- 데이터 불러오기
SELECT * FROM board
WHERE title LIKE '%팀%'member

SELECT * FROM board AS b -- 첫번째 테이블 <board(b)>
INNER JOIN memmemberber AS m -- 두번째 테이블 <member(m)>
ON b.mem_idx=m.mem_idx -- board의 mem_idx와 member의 mem_idx는 같음
WHERE b.title IN ('백엔드 팀') -- board에서 '백엔드 팀'인 거만 소환

-- 데이터 추가
INSERT INTO member
(
	id,
	pw,
	name,
	lec_class,
	created_date
)
VALUES
(
	'zeuswoo219',
	MD5('jw0219!'),
	'김정우',
	'601',
	SYSDATE()
)

INSERT INTO board
(
	mem_idx,
	title,
	content,
	modified_date,
	created_date
)
VALUES
(
	1,
	'복학날짜, 안 본 눈 삽니다.',
	'복학하기 너무 싫어요. 그냥 공짜로 졸업시켜줘요.',
	SYSDATE(),
	SYSDATE()
)boardordersproducts