국비 지원 개발자 과정_Day105

<시험문제풀이 - MemberController.java>

package com.ncs.test.controller;

import java.util.Map;
import javax.servlet.http.HttpSession;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;

import com.ncs.test.logic.MemberServiceImpl;

@Controller
@RequestMapping("/member/*")
public class MemberController {
	Logger logger = LoggerFactory.getLogger(MemberController.class);
	
	@Autowired
	private MemberServiceImpl memberServiceImpl;
	
	@PostMapping("memberLogin")
	public String memberLogin(@RequestParam Map<String, Object> pMap, HttpSession session) {
		logger.info("memberLogin");
		String name = memberServiceImpl.memberLogin(pMap);
		session.setAttribute("s_name", name);
		return "redirect:/";
	}
}

 

<시험문제풀이 - MemberServiceImpl.java>

package com.ncs.test.logic;

import java.util.Map;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.ncs.test.dao.MemberDao;

@Service
public class MemberServiceImpl implements MemberService {
	Logger logger = LoggerFactory.getLogger(MemberServiceImpl.class);

	@Autowired
	private MemberDao memberDao;
	
	@Override
	public String memberLogin(Map<String, Object> pMap) {
		logger.info("memberLogin");
		String name = memberDao.memberLogin(pMap);
		return null;
	}
}

 

<시험문제풀이 - MemberDao.java>

package com.ncs.test.dao;

import java.util.Map;
import org.mybatis.spring.SqlSessionTemplate;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Repository;
import com.ncs.test.logic.MemberServiceImpl;

@Repository
public class MemberDao {
	Logger logger = LoggerFactory.getLogger(MemberDao.class);
	
	@Autowired
	private SqlSessionTemplate sqlSessionTemplate = null;

	public String memberLogin(Map<String, Object> pMap) {
		String name = null;
		name = sqlSessionTemplate.selectOne("memberLogin", pMap);
		return name;
	}
}

 

<시험문제풀이 - member-mapper.xml>

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="memberMapper">
	<select id="memberLogin" parameterType="map" resultType="String">
		SELECT member_nm
		 FROM MEMBER
		 WHERE member_id= #{member_id}
		 AND member_pwd=#{member_pwd}
	</select>
</mapper>