[JSP] 51.  (10)  package com.tenco.controller;import jakarta.servlet.ServletException;import jakarta.servlet.annotation.WebServlet;import jakarta.servlet.http.HttpServlet;import jakarta.servlet.http.HttpServletRequest;import jakarta.servlet.http.HttpServletResponse;import jakarta.servlet.http.HttpSession;import java.io.IOException;import java.io.PrintWriter;import java.security.Principal;import ..

[JSP] 50.  (9) 1. getTodosById (ID로 Todolist 조회하기)(1) 내가 쓴 코드@Override public List getTodosByUserId(int userId) { String sql=" select * from todos where user_id= ? "; List todos=new ArrayList(); try (Connection conn=dataSource.getConnection()){ conn.setAutoCommit(false); try (PreparedStatement pstmt=conn.prepareStatement(sql)){ pstmt.setInt(1, userId); ResultSet rs=pstmt.executeQuer..

[JSP] 49.  (8) 1. TodoDAOImplpackage com.tenco.model;import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.util.ArrayList;import java.util.List;import javax.naming.InitialContext;import javax.naming.NamingException;import javax.sql.DataSource;import com.mysql.cj.protocol.Resultset;public class TodoDAOImpl implements TodoDAO { private DataSource dataSo..

[JSP] 48.  (7) 1. todoList.jsp todos = new ArrayList(); TodoDTO todo1=TodoDTO.builder() .id(1) .title("할 일 1") .description("놀기") .dueDate(new Date()) .completed(false) .userId(1) .build(); TodoDTO todo2=TodoDTO.builder() .id(1) .title("할 일 2") .description("놀기") .dueDate(new Date()) .completed(false) .userId(1) .build(); TodoDTO todo3=TodoDTO.bu..

[JSP] 47.  (6)   1. UserControllerpackage com.tenco.controller;import jakarta.servlet.ServletException;import jakarta.servlet.annotation.WebServlet;import jakarta.servlet.http.HttpServlet;import jakarta.servlet.http.HttpServletRequest;import jakarta.servlet.http.HttpServletResponse;import jakarta.servlet.http.HttpSession;import java.io.IOException;import com.mysql.cj.Session;import com.tenco.mod..

[JSP] 46.  (5)   1. UserDAOImplpackage com.tenco.model;import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import java.util.ArrayList;import java.util.List;import javax.naming.InitialContext;import javax.naming.NamingException;import javax.sql.DataSource;import com.tenco.utils.DBUtil;public class UserDAOImpl implements UserDAO{ priv..

[JSP] 45.  (4) 폴더명클래스 파일controllerTodoControllerUserControllermodelUserDAOUserDAOImplUserDTOutilsBasicDBUtilDBUtilviewssignInsignUptodoDetailtodoFormtodoListMETA-INFcontext.xml  1. [Controller](1) TodoControllerpackage com.tenco.controller;import jakarta.servlet.ServletException;import jakarta.servlet.annotation.WebServlet;import jakarta.servlet.http.HttpServlet;import jakarta.servlet.http.HttpS..

[JSP] 44.  (3)  1.UserController.java*보안상의 이유로 [views]를 [WEB-INF]에 넣는다.*GET/POST는 방식 상의 차이가 있는 것이지, URL은 동일하다.package com.tenco.controller;import jakarta.servlet.ServletException;import jakarta.servlet.annotation.WebServlet;import jakarta.servlet.http.HttpServlet;import jakarta.servlet.http.HttpServletRequest;import jakarta.servlet.http.HttpServletResponse;import java.io.IOException;import com.t..

[JSP] 43.  (2) 1. UserDAOpackage com.tenco.model;import java.util.List;public interface UserDAO { int addUser(UserDTO userDTO); UserDTO getUserById(int id); UserDTO getUserByUsername(String username); List getAllUsers(); int updateUser(UserDTO userDTO, int principalId); // 권한 (마이 정보 -> 나만 바꿔야 함!) // 인증 시에는 세션도 체크해야 한다. (세션 ID) // principalId == 세션 ID int deleteUser(int id); // 세션 인증 필요}   2.User..

[JSP] 42. (1) 1. MVC 패턴을 활용한 코드 설계(1) 회원가입 + 로그인 (2) todo작성, 조회, 수정, 삭제 (CRUD) 2. 필요 라이브러리 확인 : HikariCP의 의존성  3. 코드 작성(1) BasicDBUtil.javapackage com.tenco.utils;import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;public class BasicDBUtil { private static final String URL="jdbc:mysql://localhost:3306/m_todo?serverTimezone=Asia/Seoul"; private static final Str..