[JSP] 회원정보 : 등록하기 [DataSource를 이용하여 회원 정보 등록하기]

[JSP] 회원정보 : 목록조회[데이터베이스 연동하여 회원 정보 목록조회]

1. JSP에 연동할 데이터베이스 생성하기 [Oracle] 테이블스페이스(TABLESPACE) 생성하기[TABLESPACE 정의, 계정 생성 및 권한 부여] 1. 테이블스페이스란? 테이블스페이스(Tablespace)는 데이터베이스 오브젝

yermi.tistory.com

- 회원정보 : 등록하기

- Controller : Register

package member.controller;

import java.io.IOException;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import member.service.MemberService;
import member.service.MemberServiceImpl;
import member.vo.MemberVo;

@WebServlet("/member/register")
public class Register extends HttpServlet{
	private MemberService memberService = MemberServiceImpl.getInstance();
	
	@Override
	protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		req.getRequestDispatcher("/WEB-INF/lib/jsp/member/register.jsp").forward(req, resp);
	}

	@Override
	protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		req.setCharacterEncoding("utf-8");
		
		String id = req.getParameter("id");
		String pwd = req.getParameter("pwd");
		String name = req.getParameter("name");
		String email = req.getParameter("email");
		
		MemberVo memberVo = new MemberVo(id, pwd, name, email, null);
		memberService.register(memberVo);
		
		resp.sendRedirect("list");
	}
}

- Service : MemberService

package member.service;

import java.util.List;

import member.vo.MemberVo;

public interface MemberService {
	public List<MemberVo> list();
	
	public void register(MemberVo memberVo);
}

- Service : MemberServiceImpl

package member.service;

import java.util.List;

import member.dao.MemberDao;
import member.vo.MemberVo;

public class MemberServiceImpl implements MemberService{
	private static final MemberService memberService = new MemberServiceImpl();
	public static MemberService getInstance() {
		return memberService;
	}
	private MemberServiceImpl() {}
	
	private MemberDao memberDao = MemberDao.getInstance();
	
	@Override
	public List<MemberVo> list() {
		return memberDao.list();
	}
	
	@Override
	public void register(MemberVo memberVo) {
		memberDao.register(memberVo);
	}
}

- DAO : MemberDao

package member.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

import member.vo.MemberVo;
import utils.DBConn;

public class MemberDao {
	/**
	 * singleton
	 */
	private final static MemberDao dao = new MemberDao();
	public static MemberDao getInstance() {
		return dao;
	}
	public MemberDao() {}
	/**
	 * 
	 */
	private Statement stmt;
	private PreparedStatement pstmt;
	private Connection conn;
	
	// list 메서드 생략
	
	public void register(MemberVo memberVo) {
		try {
			conn = DBConn.getConnection();
			pstmt = conn.prepareStatement("INSERT INTO T_MEMBER"
					+ " VALUES(?, ?, ?, ?, SYSDATE)");
			
			int idx = 1;
			pstmt.setString(idx++, memberVo.getId());
			pstmt.setString(idx++, memberVo.getPwd());
			pstmt.setString(idx++, memberVo.getName());
			pstmt.setString(idx++, memberVo.getEmail());

			pstmt.executeUpdate();
			pstmt.close();
            
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
}

- JSP : register

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/bootstrap/5.0.1/css/bootstrap.min.css" integrity="sha512-Ez0cGzNzHR1tYAv56860NLspgUGuQw16GiOOp/I2LuTmpSK9xDXlgJz3XN4cnpXWDmkNBKXR/VDMTCnAaEooxA==" crossorigin="anonymous" referrerpolicy="no-referrer" />
<script src="https://cdnjs.cloudflare.com/ajax/libs/bootstrap/5.0.1/js/bootstrap.min.js" integrity="sha512-EKWWs1ZcA2ZY9lbLISPz8aGR2+L7JVYqBAYTq5AXgBkSjRSuQEGqWx8R1zAX16KdXPaCjOCaKE8MCpU0wcHlHA==" crossorigin="anonymous" referrerpolicy="no-referrer"></script>
<script>
    // 유효성 검증
    window.onload = function() {
        document.frm.onsubmit = function() {
            var id = document.frm.id;
            var pwd = document.frm.pwd;
            var name = document.frm.name;
            var email = document.frm.email;

            if(!id.value) {
                alert("아이디를 입력하세요")
                id.focus();
                return false;
            }
            if(!pwd.value) {
                alert("비밀번호를 입력하세요")
                pwd.focus();
                return false;
            }
            if(!name.value) {
                alert("이름을 입력하세요")
                name.focus();
                return false;
            }
            if(!email.value) {
                alert("이메일을 입력하세요")
                email.focus();
                return false;
            }
        }
    }
</script>
</head>
<body>
    <div class="container">
        <div class="col-6 mx-auto">
            <form class="form-control" name="frm" method="post" >
                <label for="userId" class="form-label">아이디</label>
                <input type="text" name="id" id="userId" class="form-control">
                <label for="password" class="form-label">비밀번호</label>
                <input type="text" name="pwd" id="password" class="form-control">
                <label for="name" class="form-label">이름</label>
                <input type="text" name="name" id="userId" class="form-control">
                <label for="email" class="form-label">이메일</label>
                <input type="text" name="email" id="password" class="form-control">
                <div class="d-grid">
                	<button class="btn btn-primary btn-block my-3">회원가입</button>
                </div>
                	<button type="reset" class="btn btn-danger">다시입력</button>
            </form>
        </div>
    </div>
</body>
</html>