Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ★ 1. MemberController.java
- package com.shoppingmall.member.controller;
- import java.util.List;
- import javax.servlet.http.HttpServletResponse;
- import javax.servlet.http.HttpSession;
- import org.springframework.beans.factory.annotation.Autowired;
- import org.springframework.beans.factory.annotation.Qualifier;
- import org.springframework.stereotype.Controller;
- import org.springframework.web.bind.annotation.ExceptionHandler;
- import org.springframework.web.bind.annotation.RequestMapping;
- import org.springframework.web.servlet.ModelAndView;
- import com.shoppingmall.member.model.Member;
- import com.shoppingmall.member.service.MemberService;
- import common.exception.DidNotCheckLoginException;
- @Controller
- @RequestMapping("/shopJSP")
- public class MemberController {
- String tag = this.getClass().getName();
- @Autowired
- @Qualifier("memberServiceImpl")
- private MemberService memberService;
- @RequestMapping("/registForm.do")
- public String regist(Member member) {
- System.out.println(tag + "해해해" + member.getName());
- memberService.insert(member);
- return "shopJSP/loginForm";
- }
- @RequestMapping("/checkId.do")
- public ModelAndView checkId(Member member, HttpServletResponse httpServletResponse) {
- System.out.println("어이디는" + member.getId());
- List list = memberService.selectId(member);
- ModelAndView mav = new ModelAndView("shopJSP/checkLoginResult");
- mav.addObject("msg", "사용가능한 아이디입니다");
- mav.addObject("result", "true");
- return mav;
- }
- // 로그인 아이디 비밀번호 체크
- @RequestMapping("/loginCheck.do")
- public ModelAndView checkLogin(HttpSession session, Member member) {
- System.out.println(member.getId());
- memberService.checkLogin(member);
- ModelAndView mav = new ModelAndView("shopJSP/checkLoginResult");
- session.setAttribute("id", member.getId());
- mav.addObject("msg", "로그인 성공");
- mav.addObject("result", "true");
- return mav;
- }
- // 로그인 아이디 비밀번호가 틀렸을때
- @ExceptionHandler(DidNotCheckLoginException.class)
- public ModelAndView handle(DidNotCheckLoginException e) {
- ModelAndView mav = new ModelAndView("shopJSP/checkLoginResult");
- mav.addObject("msg", e.getMessage());
- mav.addObject("result", "false");
- return mav;
- }
- // 로그아웃됬을떄
- @RequestMapping("/loginOut.do")
- public String loginOut(HttpSession session) {
- session.setAttribute("id", null);
- return "shopJSP/index";
- }
- // 마이페이지 정보 가져오기
- @RequestMapping("/myPage.do")
- public ModelAndView selectOne(HttpSession session) {
- String id = (String) session.getAttribute("id");
- ModelAndView mav = new ModelAndView("shopJSP/myPage");
- Member member = memberService.selectOne(id);
- mav.addObject("member", member);
- return mav;
- }
- }
- ★ 2. MemberService.java
- package com.shoppingmall.member.service;
- import java.util.List;
- import com.shoppingmall.member.model.Member;
- public interface MemberService {
- public void insert(Member member);
- public List selectId(Member member);
- public int checkLogin(Member member);
- public Member selectOne(String id);
- }
- ★ 3. MemberServiceImpl.java
- package com.shoppingmall.member.service;
- import java.util.List;
- import org.springframework.beans.factory.annotation.Autowired;
- import org.springframework.beans.factory.annotation.Qualifier;
- import org.springframework.stereotype.Service;
- import com.shoppingmall.member.model.Member;
- import com.shoppingmall.member.model.MemberDAO;
- import common.exception.DidNotCheckLoginException;
- @Service
- public class MemberServiceImpl implements MemberService {
- String tag = this.getClass().getName();
- @Autowired
- @Qualifier("mybatisMemberDAO")
- private MemberDAO memberDAO;
- @Override
- public void insert(Member member) {
- // TODO Auto-generated method stub
- System.out.println(tag + "dd");
- memberDAO.insert(member);
- }
- @Override
- public List selectId(Member member) throws DidNotCheckLoginException{
- // TODO Auto-generated method stub
- List list = memberDAO.selectId(member);
- return list;
- }
- @Override
- public int checkLogin(Member member) throws DidNotCheckLoginException {
- int result = memberDAO.checkLogin(member);
- return result;
- }
- //내정보가져오기
- @Override
- public Member selectOne(String id) {
- Member member=memberDAO.selectOne(id);
- return member;
- }
- }
- ★ 4. MemberDAO.java
- package com.shoppingmall.member.model;
- import java.util.List;
- public interface MemberDAO {
- public void insert(Member member);
- public List selectId(Member member);
- public int checkLogin(Member member);
- public Member selectOne(String id);
- public List selectAll();
- }
- ★ 5. MybatisMemberDAO.java
- package com.shoppingmall.member.model;
- import java.util.List;
- import org.mybatis.spring.SqlSessionTemplate;
- import org.springframework.beans.factory.annotation.Autowired;
- import org.springframework.stereotype.Repository;
- import common.exception.DidNotCheckLoginException;
- @Repository
- public class MybatisMemberDAO implements MemberDAO {
- String tag = this.getClass().getName();
- @Autowired
- SqlSessionTemplate sqlSessionTemplate;
- @Override
- public void insert(Member member) {
- // TODO Auto-generated method stub
- int result = sqlSessionTemplate.insert("Member.insert", member);
- System.out.println(tag + "마이바티스" + result);
- }
- @Override
- public List selectId(Member member) {
- List list = sqlSessionTemplate.selectList("Member.selectId", member);
- if (list.size() != 0) {
- throw new DidNotCheckLoginException("이미 아이디가 있습니다!");
- }
- return list;
- }
- @Override
- public int checkLogin(Member member) throws DidNotCheckLoginException {
- List list = sqlSessionTemplate.selectList("Member.checkLogin", member);
- System.out.println(tag + list.size());
- if (list.size() == 0) {
- throw new DidNotCheckLoginException("로그인 아이디 비밀번호를 확인하세요");
- }else{
- Member getMember=(Member)list.get(0);
- member.setId(getMember.getId());
- }
- return 0;
- }
- //내정보가져오기
- @Override
- public Member selectOne(String id) {
- System.out.println("id="+id);
- /*Member member=(Member)sqlSessionTemplate.selectMap("Member.selectOne", member1);*/
- Member member=sqlSessionTemplate.selectOne("Member.selectOne", id);
- return member;
- }
- @Override
- public List selectAll() {
- List list = sqlSessionTemplate.selectList("Member.selectAll");
- return list;
- }
- }
- ★ 6. Member.java
- package com.shoppingmall.member.model;
- public class Member {
- private int member_id;
- private String id;
- private String pwd;
- private String email;
- private String zipcode;
- private String addr;
- private String name;
- private String birthday;
- private String phone;
- private int point;
- private int level_id;
- private String regdate;
- private String recently;
- private String telephone;
- private int memberletter_id;
- private String gender;
- public String getGender() {
- return gender;
- }
- public void setGender(String gender) {
- this.gender = gender;
- }
- public int getMember_id() {
- return member_id;
- }
- public void setMember_id(int member_id) {
- this.member_id = member_id;
- }
- public String getId() {
- return id;
- }
- public void setId(String id) {
- this.id = id;
- }
- public String getPwd() {
- return pwd;
- }
- public void setPwd(String pwd) {
- this.pwd = pwd;
- }
- public String getEmail() {
- return email;
- }
- public void setEmail(String email) {
- this.email = email;
- }
- public String getZipcode() {
- return zipcode;
- }
- public void setZipcode(String zipcode) {
- this.zipcode = zipcode;
- }
- public String getAddr() {
- return addr;
- }
- public void setAddr(String addr) {
- this.addr = addr;
- }
- public String getName() {
- return name;
- }
- public void setName(String name) {
- this.name = name;
- }
- public String getBirthday() {
- return birthday;
- }
- public void setBirthday(String birthday) {
- this.birthday = birthday;
- }
- public String getPhone() {
- return phone;
- }
- public void setPhone(String phone) {
- this.phone = phone;
- }
- public int getPoint() {
- return point;
- }
- public void setPoint(int point) {
- this.point = point;
- }
- public int getLevel_id() {
- return level_id;
- }
- public void setLevel_id(int level_id) {
- this.level_id = level_id;
- }
- public String getRegdate() {
- return regdate;
- }
- public void setRegdate(String regdate) {
- this.regdate = regdate;
- }
- public String getRecently() {
- return recently;
- }
- public void setRecently(String recently) {
- this.recently = recently;
- }
- public String getTelephone() {
- return telephone;
- }
- public void setTelephone(String telephone) {
- this.telephone = telephone;
- }
- public int getMemberletter_id() {
- return memberletter_id;
- }
- public void setMemberletter_id(int memberletter_id) {
- this.memberletter_id = memberletter_id;
- }
- }
- ★ 7. DidNotCheckLoginException.java
- package common.exception;
- public class DidNotCheckLoginException extends RuntimeException {
- public DidNotCheckLoginException(String msg) {
- super(msg);
- }
- }
- ★ 8. AdminFailException.java
- package common.exception;
- public class AdminFailException extends RuntimeException{
- public AdminFailException(String msg) {
- super(msg);
- }
- }
- ★ 9. DoNotLoginException.java
- package common.exception;
- public class DoNotLoginException extends RuntimeException{
- public DoNotLoginException(String msg) {
- super(msg);
- }
- }
- ★ 10. LoginException.java
- package common.exception;
- public class LoginException extends RuntimeException{
- public LoginException(String msg) {
- super(msg);
- }
- }
- ★ 11. LoginCheckInterceptor.java
- package common.intercepter;
- import javax.servlet.http.HttpServletRequest;
- import javax.servlet.http.HttpServletResponse;
- import javax.servlet.http.HttpSession;
- import org.springframework.web.servlet.handler.HandlerInterceptorAdapter;
- /* 로그인 안한거 체크하기 */
- public class LoginCheckInterceptor extends HandlerInterceptorAdapter{
- // 메서드 실행전에 검사하기
- @Override
- public boolean preHandle(HttpServletRequest request, HttpServletResponse response, Object handler) throws Exception {
- HttpSession session = request.getSession();
- if(session != null){
- Object admin = session.getAttribute("admin");
- if(admin != null){ // 세션에 넣은 값이 존재하면,
- return true; // 리턴값이 true이면 메서드 실행.
- }
- }
- response.sendRedirect(request.getContextPath()+"/admin/index.jsp"); // 서버에 등록된 Context 경로/admin/index.jsp로 이동.
- return false; // 리턴값이 false이면 메서드 실행 안함.
- }
- }
- ★ 12. MemberMapper.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="Member">
- <insert id="insert" parameterType="Member">
- insert into
- member(member_id, id, pwd, email, zipcode, addr, name,birthday,phone,point,level_id,telephone,memberletter_id,gender)
- values(
- seq_member.nextval,
- #{id,jdbcType=INTEGER},
- #{pwd,jdbcType=VARCHAR},
- #{email,jdbcType=VARCHAR},
- #{zipcode,jdbcType=VARCHAR},
- #{addr,jdbcType=VARCHAR},
- #{name,jdbcType=VARCHAR},
- #{birthday,jdbcType=VARCHAR},
- #{phone,jdbcType=VARCHAR},
- #{point,jdbcType=INTEGER },
- #{level_id,jdbcType=INTEGER },
- #{telephone,jdbcType=VARCHAR},
- #{memberletter_id,jdbcType=INTEGER},
- #{gender,jdbcType=VARCHAR})
- </insert>
- <select id="selectId" resultType="Member">
- select id from member where
- id=#{id}
- </select>
- <select id="checkLogin" resultType="Member" parameterType="Member">
- select id from member where id=#{id} and pwd=#{pwd}
- </select>
- <select id="selectOne" resultType="Member" parameterType="string">
- select * from member where id=#{id}
- </select>
- <select id="selectAll" resultType="Member">
- select * from member order by member_id desc
- </select>
- </mapper>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement