240125 WEB - Spring4(JDBC, 마이바티스)

KDT/WEB

240125 WEB - Spring4(JDBC, 마이바티스)

001cloudid 2024. 1. 25. 12:59

728x90

JDBC

MemberDAO

package com.itwillbs.dao;

import javax.inject.Inject;
import javax.sql.DataSource;

import com.itwillbs.domain.MemberDTO;

public class MemberDAO {
	
	//멤버변수 정의 javax.sql.DataSource
	private DataSource dataSource;
	
	//set 메소드
	@Inject
	public void setDataSource(DataSource dataSource) {
		this.dataSource = dataSource;
	}
	
	//리턴형 없는 insertMember(memberDTO 주소) 메소드 정의
	public void insertMember(MemberDTO memberDTO) {
		System.out.println("MemberDAO insertMember()");
	}
    
}// 닫는 괄호

root-context.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://www.springframework.org/schema/beans https://www.springframework.org/schema/beans/spring-beans.xsd">
	
	<!-- Root Context: defines shared resources visible to all other web components -->

<!-- MemberController 객체 생성 -->
	<bean id="memberController" class="com.itwillbs.controller.MemberController">
<!-- 		<constructor-arg name="memberService" ref="memberService"></constructor-arg> -->
			<property name="memberService" ref="memberService"></property>
	</bean>


<!-- //부모(인터페이스) = 자식(인터페이스를 상속받은 클래스) 객체 생성
     MemberService 객체 생성 
     자바 MemberService memberService = new MemberService();
     스프링 <bean id="변수명" class="경로">-->
	<bean id="memberService" class="com.itwillbs.service.MemberService">
	<property name="memberDAO" ref="memberDAO"></property>
	</bean>

	
<!-- MemberDAO 객체 생성 -->
	<bean id="memberDAO" class="com.itwillbs.dao.MemberDAO">
<!--<property name="set메소드 이름" ref="객체생성 참조변수"></property> -->
	<property name="dataSource" ref="dataSource"></property>
	</bean>

<!-- 데이터베이스 연결 객체 생성 
	 프로그램 설치
	 → 자동으로 프로그램 설치 Maven 의존
	 → Maven 서버에 프로그램이 저장되어 있고 다운받고자 하는 프로그램 이름을 적으면 다운받아서 사용 
	 → 프로그램 맨 아래 pom.xml(다운받고 싶은 프로그램 목록을 적음)
	 → 웹 maven repository 검색
	 → https://mvnrepository.com/에서 mysql 검색 
	 → 중간에 Maven 코드 복사
	 → pom.xml에 코드 붙여넣기 
	 → https://mvnrepository.com/에서 Spring JDBC 검색
	 → 버전 수정 <version>${org.springframework-version}</version> -->
	
	<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
		<property name="driverClassName" value="com.mysql.cj.jdbc.Driver"></property>
		<property name="url" value="jdbc:mysql://localhost:3306/jspdb?serverTimezone=Asia/Seoul"></property>
		<property name="username" value="root"></property>
		<property name="password" value="1234"></property>
	</bean>

	
</beans>

MemberDAO

package com.itwillbs.dao;

import javax.inject.Inject;
import javax.sql.DataSource;

import org.springframework.jdbc.core.simple.SimpleJdbcTemplate;

import com.itwillbs.domain.MemberDTO;

public class MemberDAO {
	
	//멤버변수 정의 javax.sql.DataSource
//	private DataSource dataSource;
	//스프링에서 디비연결 정보를 받아서 sql구문을 실행하는 프로그램 제공(테스트용으로해보기)
	private SimpleJdbcTemplate jdbcTemplate;
	
	//set 메소드
	@Inject
	public void setDataSource(DataSource dataSource) {
//		this.dataSource = dataSource;
		jdbcTemplate = new SimpleJdbcTemplate(dataSource);
	}
	
	//리턴형 없는 insertMember(memberDTO 주소) 메소드 정의
	String sql = "insert into members(id,pw,name,date) values(?,?,?,?)";
	public void insertMember(MemberDTO memberDTO) {
		System.out.println("MemberDAO insertMember()");
		jdbcTemplate.update(sql, memberDTO.getId(),memberDTO.getPw(),memberDTO.getName(),memberDTO.getDate());
	}

}// 닫는 괄호

MemberService

package com.itwillbs.service;

import java.sql.Timestamp;

import javax.inject.Inject;

import com.itwillbs.dao.MemberDAO;
import com.itwillbs.domain.MemberDTO;

public class MemberService {

	//MemberDAO 객체 생성 → 멤버 변수
//	MemberDAO memberDAO = new MemberDAO();
	private MemberDAO memberDAO;
	
	//set 메소드 정의
	@Inject
	public void setMemberDAO(MemberDAO memberDAO) {
		this.memberDAO = memberDAO;
	}

	//리턴형 없는 insertMember(memberDTO 주소) 메소드 정의
	public void insertMember(MemberDTO memberDTO) {
		System.out.println("MemberService insertMember()");
		//가입날짜 설정
		memberDTO.setDate(new Timestamp(System.currentTimeMillis()));
			//MemberDAO insertMember() 메소드 호출
			memberDAO.insertMember(memberDTO);
	}
	
}// 닫는 괄호

240125.zip

0.04MB

※

export : archive(개인이 다른 곳에서 작업할 때), war(배포)

import : existing projects into workspace(archive 파일 가져오기)

마이바티스 JDBC 설정

프로젝트에서 사용

1) new - spring legacy project - springProject2/spring mvc project - com.itwillbs.myweb2

2) 자바 버전 변경 : 기본값 1.6 → 11 버전으로 변경

project 오른쪽 버튼 - Properties

Java Compiler - JDK Compliance - Use compliance from execution~~ 체크 해제 - 1.6에서 11로 변경

Project Facets - Dynamic Web Module 3.1로 변경, Java 11으로 변경

3) 스프링 버전 변경

pom.xml 파일에서 스프링 버전을 변경

<-- 생략 -->
		<java-version>11</java-version>
		<org.springframework-version>4.3.8.RELEASE</org.springframework-version>
		<org.aspectj-version>1.6.10</org.aspectj-version>
		<org.slf4j-version>1.6.6</org.slf4j-version>
	</properties>
	<dependencies>
<-- 생략 -->

4) 프로그램 설치 (JDBC, spring JDBC, 마이바티스)

pom.xml 파일

mvnrepository 검색해서 코드 넣으면 자동으로 프로그램 다운되면서 설치

<!-- MySQL Connector/J 8.0.33 -->
		<!-- https://mvnrepository.com/artifact/com.mysql/mysql-connector-j -->
		<dependency>
			<groupId>com.mysql</groupId>
			<artifactId>mysql-connector-j</artifactId>
			<version>8.0.33</version>
		</dependency>
		
		<!-- Spring JDBC -->
		<!-- https://mvnrepository.com/artifact/org.springframework/spring-jdbc -->
		<dependency>
		    <groupId>org.springframework</groupId>
		    <artifactId>spring-jdbc</artifactId>
		    <version>${org.springframework-version}</version>
		</dependency>

추가

5) 가상 주소 시작 → web.xml(서블릿 지정(자동지정), 한글 설정)

6) /WEB-INF/spring/appServlet/servlet-context.xml 연결

@애노테이션 자동으로 스캔할 폴더 등록

src/main/java에 com.itwillbs.controller.MemberController 생성 후

<?xml version="1.0" encoding="UTF-8"?>
<beans:beans xmlns="http://www.springframework.org/schema/mvc"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xmlns:beans="http://www.springframework.org/schema/beans"
	xmlns:context="http://www.springframework.org/schema/context"
	xsi:schemaLocation="http://www.springframework.org/schema/mvc https://www.springframework.org/schema/mvc/spring-mvc.xsd
		http://www.springframework.org/schema/beans https://www.springframework.org/schema/beans/spring-beans.xsd
		http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd">

	<!-- DispatcherServlet Context: defines this servlet's request-processing infrastructure -->
	
	<!-- Enables the Spring MVC @Controller programming model -->
	<annotation-driven />

	<!-- Handles HTTP GET requests for /resources/** by efficiently serving up static resources in the ${webappRoot}/resources directory -->
	<resources mapping="/resources/**" location="/resources/" />

	<!-- Resolves views selected for rendering by @Controllers to .jsp resources in the /WEB-INF/views directory -->
	<beans:bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
		<beans:property name="prefix" value="/WEB-INF/views/" />
		<beans:property name="suffix" value=".jsp" />
	</beans:bean>
	
	<context:component-scan base-package="com.itwillbs.myweb2" />
	<context:component-scan base-package="com.itwillbs.controller" />
	
	
	
</beans:beans>

MemberController

@Controller 애노테이션 추가

주소매핑 → 자동으로 메소드 호출

package com.itwillbs.controller;

import java.lang.ProcessBuilder.Redirect;

import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;

import com.itwillbs.domain.MemberDTO;

//주소매핑

@Controller
public class MemberController {
	
	@RequestMapping(value = "/member/insert", method = RequestMethod.GET)
	public String insert() {
		// WEB-INF/views/member/insert.jsp 이동
		//주소는 /member/insert 주소변경없이 이동
		return "/member/insert";
	}
	
	@RequestMapping(value = "/member/insertPro", method = RequestMethod.POST)
	public String insertPro(MemberDTO memberDTO) {
		System.out.println("MemberController insertPro()");
		System.out.println(memberDTO.getId());
		System.out.println(memberDTO.getPw());
		System.out.println(memberDTO.getName());
		//회원가입 처리
		
		// 로그인 가상 주소 /member/login 주소 변경 이동
		return "redirect:/member/login";
	}
	
}

toString재정의

MemberDTO

package com.itwillbs.domain;

import java.sql.Timestamp;

public class MemberDTO {
	// 데이터 은닉과 캡슐화
	//멤버변수 => 변수를 아무나 접근못하게 막아줌 => 데이터 은닉
	private String id;
	private String pw;
	private String name;
	private Timestamp date;
	
	@Override
	public String toString() {
		return "MemberDTO [id=" + id + ", pw=" + pw + ", name=" + name + ", date=" + date + ", toString()="
				+ super.toString() + "]";
	}
	
	// 데이터를 접근하기위한 setter, getter   public 메서드 정의
	// alt shift s => r
	public String getId() {
		return id;
	}
	public void setId(String id) {
		this.id = id;
	}
	public String getPw() {
		return pw;
	}
	public void setPw(String pw) {
		this.pw = pw;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public Timestamp getDate() {
		return date;
	}
	public void setDate(Timestamp date) {
		this.date = date;
	}
	
}

7) /WEB-INF/spring/root-context.xml 연결

package com.itwillbs.dao;

import com.itwillbs.domain.MemberDTO;

public class MemberDAO {
	
	public void insertMember(MemberDTO memberDTO) {
		System.out.println("MemberDAO insertMember()");
	}

}

package com.itwillbs.service;

import org.springframework.stereotype.Service;

import com.itwillbs.domain.MemberDTO;

@Service
public class MemberService {
	
	public void insertMember(MemberDTO memberDTO) {
		System.out.println("MemberService insertMember()");
	}
}

package com.itwillbs.controller;

import java.lang.ProcessBuilder.Redirect;

import javax.inject.Inject;

import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;

import com.itwillbs.domain.MemberDTO;
import com.itwillbs.service.MemberService;

//주소매핑
@Controller
public class MemberController {
	
	//MemberService 객체생성 → 멤버변수
	//@Inject → MemberService 클래스 찾기 → @Service 애노테이션 자동으로 찾기 → 자동으로 객체 생성
	//찾으면 객체 생성
	//servlet-context에 component-scan 추가
	@Inject
	private MemberService memberService; 
	
	@RequestMapping(value = "/member/insert", method = RequestMethod.GET)
	public String insert() {
		// WEB-INF/views/member/insert.jsp 이동
		//주소는 /member/insert 주소변경없이 이동
		return "/member/insert";
	}
	
	@RequestMapping(value = "/member/insertPro", method = RequestMethod.POST)
	public String insertPro(MemberDTO memberDTO) {
		System.out.println("MemberController insertPro()");
		System.out.println(memberDTO.toString());
		//회원가입 처리
		
		//패키지 com.itwillbs.service 파일 MemberService
		//패키지 com.itwillbs.dao 파일 MemberDAO
		
		//insertMember() 메소드 호출
		memberService.insertMember(memberDTO);
		
		// 로그인 가상 주소 /member/login 주소 변경 이동
		return "redirect:/member/login";
	}
	
}

package com.itwillbs.service;

import javax.inject.Inject;

import org.springframework.stereotype.Service;

import com.itwillbs.dao.MemberDAO;
import com.itwillbs.domain.MemberDTO;

@Service
public class MemberService {
	//MemberDAO 객체생성 → 멤버변수
	//@Inject → MemberDAO 클래스 찾기 → @Repsitory 애노테이션 자동으로 찾기 → 자동으로 객체 생성
	//찾으면 객체 생성
	//servlet-context에 component-scan 추가
	@Inject
	private MemberDAO memberDAO;
	
	public void insertMember(MemberDTO memberDTO) {
		System.out.println("MemberService insertMember()");
		
		//insertMember() 메소드 호출
		memberDAO.insertMember(memberDTO);
	}

}

<?xml version="1.0" encoding="UTF-8"?>
<beans:beans xmlns="http://www.springframework.org/schema/mvc"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xmlns:beans="http://www.springframework.org/schema/beans"
	xmlns:context="http://www.springframework.org/schema/context"
	xsi:schemaLocation="http://www.springframework.org/schema/mvc https://www.springframework.org/schema/mvc/spring-mvc.xsd
		http://www.springframework.org/schema/beans https://www.springframework.org/schema/beans/spring-beans.xsd
		http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd">

	<!-- DispatcherServlet Context: defines this servlet's request-processing infrastructure -->
	
	<!-- Enables the Spring MVC @Controller programming model -->
	<annotation-driven />

	<!-- Handles HTTP GET requests for /resources/** by efficiently serving up static resources in the ${webappRoot}/resources directory -->
	<resources mapping="/resources/**" location="/resources/" />

	<!-- Resolves views selected for rendering by @Controllers to .jsp resources in the /WEB-INF/views directory -->
	<beans:bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
		<beans:property name="prefix" value="/WEB-INF/views/" />
		<beans:property name="suffix" value=".jsp" />
	</beans:bean>
	
	<context:component-scan base-package="com.itwillbs.myweb2" />
	<context:component-scan base-package="com.itwillbs.controller" />
	<context:component-scan base-package="com.itwillbs.service" />
	<context:component-scan base-package="com.itwillbs.dao" />
	
	
	
</beans:beans>

8) 한글 설정

<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.5" xmlns="http://java.sun.com/xml/ns/javaee"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://java.sun.com/xml/ns/javaee https://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">

	<!-- The definition of the Root Spring Container shared by all Servlets and Filters -->
	<context-param>
		<param-name>contextConfigLocation</param-name>
		<param-value>/WEB-INF/spring/root-context.xml</param-value>
	</context-param>
	
	<!-- Creates the Spring Container shared by all Servlets and Filters -->
	<listener>
		<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
	</listener>

	<!-- Processes application requests -->
	<servlet>
		<servlet-name>appServlet</servlet-name>
		<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
		<init-param>
			<param-name>contextConfigLocation</param-name>
			<param-value>/WEB-INF/spring/appServlet/servlet-context.xml</param-value>
		</init-param>
		<load-on-startup>1</load-on-startup>
	</servlet>
		
	<servlet-mapping>
		<servlet-name>appServlet</servlet-name>
		<url-pattern>/</url-pattern>
	</servlet-mapping>

<!-- post전송 request 한글 처리 "utf-8" 설정 -->
	<filter>
		<filter-name>encoding</filter-name>
		<filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
		<init-param>
			<param-name>encoding</param-name>
			<param-value>UTF-8</param-value>
		</init-param>
	</filter>
		<filter-mapping>
			<filter-name>encoding</filter-name>
			<url-pattern>/*</url-pattern>
		</filter-mapping>
		
</web-app>

240125.zip

0.04MB

728x90

'KDT > WEB' 카테고리의 다른 글

240130 WEB(회원수정,삭제) (0)	2024.01.30
240129 WEB(마이바티스) (0)	2024.01.29
240123 WEB - SPRING3(가상주소매핑, 의존성주입) (0)	2024.01.23
240122 WEB - SPRING2(환경설정, 가상주소매핑) (0)	2024.01.22
240118 WEB - JSP25(MVC, JSTL, 페이지), SPRING 1(설치, 환경설정) (0)	2024.01.18

현재글240125 WEB - Spring4(JDBC, 마이바티스)

001cloudid