로그인, 회원가입, 게시판 만들기 2

cozy coding 2020. 7. 30. 16:32

2020. 7. 30. 16:32

header.jsp

header.jsp에 jstl/core 경로를 taglib으로 잡아준다. (prefix이름을 c로 지정. jstl쓰기 위함)
userid 세션에 따라 헤더에 나타나는 메뉴를 다르게 잡아준다.
userid 세션이 비어있다면 로그인, 회원가입, 게시판 메뉴가 뜨도록한다.
그게 아니라면(로그인 되어있다면) 로그아웃, 정보변경, 게시판 메뉴가 뜨도록한다.
회원탈퇴 기능도 추가한다. 액션은 MemberDelete.java에서 처리한다.

<%@ page language="java" contentType="text/html; charset=UTF-8"

    pageEncoding="UTF-8"%>

<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>   

<!DOCTYPE html>

<html lang="en">

<head>

  <title>Bootstrap Example</title>

  <meta charset="utf-8">                       

  <meta name="viewport" content="width=device-width, initial-scale=1">

  <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.0/css/bootstrap.min.css">

  <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>

  <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.16.0/umd/popper.min.js"></script>

  <script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.0/js/bootstrap.min.js"></script>

  <script src="/project01/js/member.js"></script>

</head>

<body>

<nav class="navbar navbar-expand-sm bg-dark navbar-dark">

  <!-- Brand/logo -->

  <a class="navbar-brand" href="#">

    <h3>LOGO</h3>

  </a>

 

  <!-- Links -->

  <ul class="navbar-nav">

  <c:choose>

    <c:when test="${empty sessionScope.userid}">

        <li class="nav-item">

          <a class="nav-link" href="/project01/member/login.me">로그인</a>

        </li>

        <li class="nav-item">

          <a class="nav-link" href="/project01/member/insert.me">회원가입</a>

        </li>

    </c:when>

    <c:otherwise>

        <li class="nav-item">

          <a class="nav-link" href="/project01/member/logout.me">로그아웃</a>

        </li>

        <li class="nav-item">

          <a class="nav-link" href="/project01/member/view.me">정보변경</a>

        </li>

        <li class="nav-item">

          <a class="nav-link" href="/project01/member/delete.me">회원탈퇴</a>

        </li>

    </c:otherwise>

  </c:choose>

        <li class="nav-item">

          <a class="nav-link" href="/project01/board/board.me">게시판</a>

        </li>

  </ul>

 

  <c:if test="${not empty sessionScope.userid}">

    <span class="navbar-text">

     ${sessionScope.userid} 님 반갑습니다.

    </span>

  </c:if>

</nav>

MemberDelete.java: 탈퇴하기 서블릿

package com.member.action;

import java.io.IOException;

import java.util.ArrayList;

import javax.servlet.RequestDispatcher;

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 javax.servlet.http.HttpSession;

import com.member.model.MemberDTO;

import com.member.model.SMemberDAOImpl;

/**

 * Servlet implementation class MemberDelete

 */

@WebServlet("/member/delete.me")

public class MemberDelete extends HttpServlet {

    private static final long serialVersionUID = 1L;

      

    /**

     * @see HttpServlet#HttpServlet()

     */

    public MemberDelete() {

        super();

        // TODO Auto-generated constructor stub

    }

    /**

     * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)

     */

    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

        HttpSession session=request.getSession();

        String userid=(String)session.getAttribute("userid");

        SMemberDAOImpl dao=SMemberDAOImpl.getInstance();

        dao.memberDel(userid);

        session.invalidate();

        response.sendRedirect("login.me");

    }

    /**

     * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)

     */

    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

    

    }

}

list.jsp: 관리자로 로그인 했을때 뜨는 회원리스트. list.jsp가 header.jsp를 포함하고 있으므로 jstl을 사용할 수 있다. 따라서 <c: forEach> 구문으로 회원 리스트를 불러올 수 있다.
회원 리스트는 list액션을 처리하는 MemberList에서 memberList()메소드를 이용하여 ArrayList형식으로 저장되어 있다. 그 ArrayList를 members이름으로 불러온다.
<c: forEach items="${members}" var="mem">, ${mem.name}
회원리스트에 삭제할 수 있는 기능을 넣는다. member.js에서 del() 함수로 삭제한다.

<%@ page language="java" contentType="text/html; charset=UTF-8"

    pageEncoding="UTF-8"%>

<%@ include file="../include/header.jsp" %>

  <div class="container">

    <br/>

    <h3>회원리스트</h3><br/><br/>

    <table class="table table-hover">

    <thead>

      <tr>

        <th>이름</th>

        <th>아이디</th>

        <th>전화번호</th>

        <th>이메일</th>

        <th>구분</th>

        <th>삭제</th>

      </tr>

    </thead>

    <tbody>

      <c:forEach items="${members}" var="mem">

      <c:if test="${mem.admin==0 }">

        <c:set var="mode" value="일반회원"/>

      </c:if>

      <c:if test="${mem.admin==1 }">

        <c:set var="mode" value="관리자"/>

      </c:if>

        <tr>

            <td>${mem.name}</td>

            <td>${mem.userid}</td>

            <td>${mem.phone}</td>

            <td>${mem.email}</td>

            <c:if test="${mem.admin==0}">

                <td>일반회원</td>

                <td onclick="del('${mem.userid}')">삭제</td>

            </c:if>

            <c:if test="${mem.admin==1}">

                <td>관리자</td>

                <td>Admin</td>

            </c:if>

        </tr>

      </c:forEach>

    </tbody>

  </table>

  </div>

  <script>

  </script>

<%@ include file="../include/footer.jsp" %>

UserDelete.java: 회원 삭제 서블릿. 회원 삭제를 하면 자동적으로 회원수도 줄어들도록.

package com.member.action;

import java.io.IOException;

import java.io.PrintWriter;

import java.util.ArrayList;

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 org.json.simple.JSONArray;

import org.json.simple.JSONObject;

import com.member.model.MemberDTO;

import com.member.model.SMemberDAOImpl;

/**

 * Servlet implementation class UserDelete

 */

@WebServlet("/member/userDelete.me")

public class UserDelete extends HttpServlet {

    private static final long serialVersionUID = 1L;

      

    /**

     * @see HttpServlet#HttpServlet()

     */

    public UserDelete() {

        super();

        // TODO Auto-generated constructor stub

    }

    /**

     * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)

     */

    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

        request.setCharacterEncoding("utf-8");

        String userid=request.getParameter("userid");

        SMemberDAOImpl dao=SMemberDAOImpl.getInstance();

        dao.memberDel(userid); //삭제

        ArrayList<MemberDTO> arr=dao.memberList();

        int count=dao.getCount();

        //JSON 형태로 값을 가져가야함.

        JSONObject mainObj=new JSONObject();

        JSONArray jarr=new JSONArray();

        for(MemberDTO dto:arr) {

            String mode=dto.getAdmin()==1?"관리자":"일반회원";

            JSONObject obj=new JSONObject();

            obj.put("name", dto.getName());

            obj.put("userid", dto.getUserid());

            obj.put("email", dto.getEmail());

            obj.put("phone", dto.getPhone());

            obj.put("mode", mode);

            jarr.add(obj);

        }

        

        JSONObject countObj=new JSONObject();

        countObj.put("count", count);

        

        mainObj.put("root",jarr);

        mainObj.put("rootCount", countObj);

        

        response.setContentType("text/html;charset=utf-8");

        PrintWriter out=response.getWriter();

        out.println(mainObj.toString());

    }

    /**

     * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)

     */

    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

        // TODO Auto-generated method stub

        doGet(request, response);

    }

}

MemberList.java: 회원리스트 서블릿

package com.member.action;

import java.io.IOException;

import java.util.ArrayList;

import javax.servlet.RequestDispatcher;

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 com.member.model.MemberDTO;

import com.member.model.SMemberDAOImpl;

/**

 * Servlet implementation class MemberList

 */

@WebServlet("/member/list.me")

public class MemberList extends HttpServlet {

    private static final long serialVersionUID = 1L;

      

    /**

     * @see HttpServlet#HttpServlet()

     */

    public MemberList() {

        super();

        // TODO Auto-generated constructor stub

    }

    /**

     * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)

     */

    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

        request.setCharacterEncoding("utf-8");

        SMemberDAOImpl dao=SMemberDAOImpl.getInstance();

        ArrayList<MemberDTO> arr= dao.memberList();

        request.setAttribute("members", arr);

        

        RequestDispatcher rd=request.getRequestDispatcher("list.jsp");

        rd.forward(request, response);

    }

    /**

     * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)

     */

    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

        doGet(request, response);

    }

}

view.jsp: 일반회원이 로그인했을때 상세정보를 수정할 수 있는 폼

<%@ page language="java" contentType="text/html; charset=UTF-8"

    pageEncoding="UTF-8"%>

<%@ include file="../include/header.jsp" %>

<div class="container">

  <form action="update.me" method="post" id="frm">

    <br/>

    <div class="form-group">

      <label for="id">id:</label>

      <input type="text" name="userid" id="userid" value="${member.userid}" readonly="readonly">

    </div>

    <div class="form-group">

      <label for="name">Name:</label>

      <input type="text" class="form-control" id="name" value="${member.name}" name="name">

    </div>

    <div class="form-group">

      <label for="pwd">Password:</label>

      <input type="password" class="form-control" id="pwd" value="${member.pwd}" name="pwd">

    </div>

    <div class="form-group">

      <label for="email">Email:</label>

      <input type="text" class="form-control" id="email" value="${member.email}" name="email">

    </div>

   

    <div class="form-group">

      <label for="phone">Phone:</label>

      <input type="text" class="form-control" id="phone" value="${member.phone}" name="phone">

    </div>

    <div class="form-check-inline">

        <label class="form-check-label">

        <input type="radio" class="form-check-input" name="admin" value="1">관리자

        </label>

    </div>

    <div class="form-check-inline">

      <label class="form-check-label">

        <input type="radio" class="form-check-input" name="admin"  value="0" checked>일반회원

      </label>

    </div>

    <script>

            if(${member.getAdmin()==0}){

                $("input:radio[value='0']").prop("checked", true);

            }else{

                $("input:radio[value='1']").prop("checked", true);              

            }

    </script>

    <br/>

     <button type="submit"  class="btn btn-primary">수정</button>

</div>

</form>

<%@ include file="../include/footer.jsp" %>

MemberView.java: 상세보기 서블릿

package com.member.action;

import java.io.IOException;

import javax.servlet.RequestDispatcher;

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 javax.servlet.http.HttpSession;

import com.member.model.MemberDTO;

import com.member.model.SMemberDAOImpl;

/**

 * Servlet implementation class MemberView

 */

@WebServlet("/member/view.me")

public class MemberView extends HttpServlet {

    private static final long serialVersionUID = 1L;

      

    /**

     * @see HttpServlet#HttpServlet()

     */

    public MemberView() {

        super();

        // TODO Auto-generated constructor stub

    }

    /**

     * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)

     */

    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

        HttpSession session=request.getSession();

        String userid=(String)session.getAttribute("userid");

        SMemberDAOImpl dao=SMemberDAOImpl.getInstance();

        MemberDTO dto=dao.memberView(userid);

        request.setAttribute("member", dto);

        

        RequestDispatcher rd=request.getRequestDispatcher("view.jsp");

        rd.forward(request, response);

    }

    /**

     * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)

     */

    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

    

    }

}

MemberUpdate.java: 회원 상세보기-수정하기 서블릿

package com.member.action;

import java.io.IOException;

import javax.servlet.RequestDispatcher;

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 javax.servlet.http.HttpSession;

import com.member.model.MemberDTO;

import com.member.model.SMemberDAOImpl;

/**

 * Servlet implementation class MemberUpdate

 */

@WebServlet("/member/update.me")

public class MemberUpdate extends HttpServlet {

    private static final long serialVersionUID = 1L;

      

    /**

     * @see HttpServlet#HttpServlet()

     */

    public MemberUpdate() {

        super();

        // TODO Auto-generated constructor stub

    }

    /**

     * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)

     */

    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

        

        

    }

    /**

     * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)

     */

    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

        request.setCharacterEncoding("utf-8");

        MemberDTO dto=new MemberDTO();

        dto.setAdmin(Integer.parseInt(request.getParameter("admin")));

        dto.setEmail(request.getParameter("email"));

        dto.setName(request.getParameter("name"));

        dto.setPhone(request.getParameter("phone"));

        dto.setPwd(request.getParameter("pwd"));

        dto.setUserid(request.getParameter("userid"));

        SMemberDAOImpl dao=SMemberDAOImpl.getInstance();

        int flag=dao.memberUpdate(dto);

        HttpSession session=request.getSession();

        if(flag==1) {

            session.invalidate();

            response.sendRedirect("login.me");

        }

    }

}

MemberLogout.java: 로그아웃 서블릿

package com.member.action;

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 javax.servlet.http.HttpSession;

/**

 * Servlet implementation class MemberLogout

 */

@WebServlet("/member/logout.me")

public class MemberLogout extends HttpServlet {

    private static final long serialVersionUID = 1L;

      

    /**

     * @see HttpServlet#HttpServlet()

     */

    public MemberLogout() {

        super();

        // TODO Auto-generated constructor stub

    }

    /**

     * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)

     */

    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

        HttpSession session=request.getSession();

        session.invalidate();

        response.sendRedirect("login.me");

    }

    /**

     * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)

     */

    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

    }

}

member.js: 자바스크립트

var exp= /^[0-9]{3}-[0-9]{4}-[0-9]{4}$/;

$(document).ready(function(){

    $("#send").click(function(){

        //아이디가 공백일때

        if($("#userid").val()==""){

            alert("아이디를 입력하세요");

            $("#userid").focus();

            return false;

        }

        //암호가 공백일때

        if($("#pwd").val()==""){

            alert("암호를 입력하세요");

            $("#pwd").focus();

            return false;

        }

        //암호확인이 공백일때

        if($("#pwd_check").val()==""){

            alert("암호확인 필수");

            $("#pwd_check").focus();

            return false;

        }

        //암호 일치확인

        if($("#pwd").val()!=$("#pwd_check").val()){

            alert("암호 불일치");

            $("#pwd_check").focus();

            return false;

        }

        if($("#name").val()==""){

            alert("이름을 입력하세요");

            return false;

        }

        if($("#email").val()==""){

            alert("이메일을 입력하세요");

            return false;

        }

        if($("#phone").val()==""){

            alert("전화번호를 입력하세요");

            return false;

        }

        //전화번호 확인

        if(!$("#phone").val().match(exp)){

            alert("전화번호 입력 양식이 아닙니다.");

            $("#phone").focus();

            return false;

        }

        $("#frm").submit();

    })//send

    

    //아이디 중복체크 버튼

    $("#idcheck").click(function(){

        window.open("idCheck.jsp", "", "width=600 height=500")

    }); //idcheck

});//document

function del(userid){

    if(confirm("정말 삭제할까요?")){

        $.getJSON("userDelete.me?userid="+userid, function(data){

            //alert(data.root.length);

            var htmlStr="";

            $.each(data.root, function(key, val){

                htmlStr+="<tr>";

                htmlStr+="<td>"+val.name+"</td>";

                htmlStr+="<td>"+val.userid+"</td>";

                htmlStr+="<td>"+val.phone+"</td>";

                htmlStr+="<td>"+val.email+"</td>";

                htmlStr+="<td>"+val.mode+"</td>";

                if(val.mode=='일반회원'){

                    htmlStr+="<td onclick=del('"+val.userid+"')>삭제</td>";

                }else{

                    htmlStr+="<td>Admin</td>";

                }

                htmlStr+="</tr>";

            })

            $("table tbody").html(htmlStr);

        })

    }

}

SMemberDAOImpl.java: 추가 삭제 수정 등 각종 메소드 자바파일

package com.member.model;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import java.util.ArrayList;

import javax.naming.Context;

import javax.naming.InitialContext;

import javax.sql.DataSource;

public class SMemberDAOImpl implements MemberDAO{

    

    private static SMemberDAOImpl instance=new SMemberDAOImpl();

    public static SMemberDAOImpl getInstance() {

        return instance;

    }

    private Connection getConnection() throws Exception{

        Context initCtx=new InitialContext();

        Context envCtx=(Context) initCtx.lookup("java:comp/env");

        DataSource ds=(DataSource) envCtx.lookup("jdbc/member"); //context.xml의 name을 jdbc/member로 바꾸기

        return ds.getConnection();

    }

    

    //회원가입

    public void memberInsert(MemberDTO vo) {

        Connection con=null;

        PreparedStatement ps=null;

        

        try {

            con=getConnection();

            String sql="INSERT INTO jmember VALUES(?,?,?,?,?,?)";

            ps=con.prepareStatement(sql);

            ps.setString(1, vo.getUserid());

            ps.setString(2, vo.getName());

            ps.setString(3, vo.getPwd());

            ps.setString(4, vo.getEmail());

            ps.setString(5, vo.getPhone());

            ps.setInt(6, vo.getAdmin());

            ps.executeUpdate();

        } catch (Exception e) {

            e.printStackTrace();

        } finally {

            closeConnection(con, ps);

        }

    }

    //회원리스트 보기

    public ArrayList<MemberDTO> memberList() {

        Connection con=null;

        Statement st=null;

        ResultSet rs=null;

        ArrayList<MemberDTO>arr=new ArrayList<MemberDTO>();

        

        try {

            con=getConnection();

            String sql="select * from jmember";

            st=con.createStatement();

            rs=st.executeQuery(sql);

            while(rs.next()) {

                MemberDTO dto=new MemberDTO();

                dto.setAdmin(rs.getInt("admin"));

                dto.setEmail(rs.getString("email"));

                dto.setName(rs.getString("name"));

                dto.setPhone(rs.getString("phone"));

                dto.setPwd(rs.getString("pwd"));

                dto.setUserid(rs.getString("userid"));

                arr.add(dto);

            }

        } catch (Exception e) {

            e.printStackTrace();

        } finally {

            closeConnection(con, st, rs);

        }

        return arr;

    }

    //회원정보 수정

    public int memberUpdate(MemberDTO vo) {

        Connection con=null;

        PreparedStatement ps=null;

        int flag=0;

        try {

            con=getConnection();

            String sql="update jmember set name=?, pwd=?, email=?, phone=?, admin=? where userid=?";

            ps=con.prepareStatement(sql);

            ps.setString(1, vo.getName());

            ps.setString(2, vo.getPwd());

            ps.setString(3, vo.getEmail());

            ps.setString(4, vo.getPhone());

            ps.setInt(5, vo.getAdmin());

            ps.setString(6, vo.getUserid());

            flag=ps.executeUpdate();

        } catch (Exception e) {

            e.printStackTrace();

        } finally {

            closeConnection(con, ps);

        }

        return flag;

    }

    

    //회원 상세보기

    public MemberDTO memberView(String userid) {

        Connection con=null;

        Statement st=null;

        ResultSet rs=null;

        MemberDTO dto=null;

        try {

            con=getConnection();

            String sql="select * from jmember where userid='"+userid+"'";

            st=con.createStatement();

            rs=st.executeQuery(sql);

            if(rs.next()) {

                dto=new MemberDTO();

                dto.setAdmin(rs.getInt("admin"));

                dto.setEmail(rs.getString("email"));

                dto.setName(rs.getString("name"));

                dto.setPhone(rs.getString("phone"));

                dto.setPwd(rs.getString("pwd"));

                dto.setUserid(rs.getString("userid"));

            }

        } catch (Exception e) {

            e.printStackTrace();

        } finally {

            closeConnection(con, st, rs);

        }

        return dto;

    }

    

    //삭제

    public void memberDel(String userid) {

        Connection con=null;

        Statement st=null;

        try {

            con=getConnection();

            String sql="delete from JMEMBER where userid='"+userid+"'";

            st=con.createStatement();

            st.executeUpdate(sql);

        } catch (Exception e) {

            e.printStackTrace();

        } finally {

            closeConnection(con, st, null);

        }

    }

    

    //아이디 중복확인 사용하기 버튼

    public String idCheck(String userid) {

        Connection con=null;

        Statement st=null;

        ResultSet rs=null;

        String flag="yes"; //사용가능

        try {

            con=getConnection();

            String sql="select * from jmember where userid='"+userid+"'";

            st=con.createStatement();

            rs=st.executeQuery(sql);

            if(rs.next()) {

                flag="no"; //사용불가능

            }

        } catch (Exception e) {

            e.printStackTrace();

        } finally {

            closeConnection(con, st, rs);

        }

        return flag;

    }

    //로그인체크 (비밀번호 오류: 2, 회원아님: -1, 관리자: 1, 일반회원: 0)

    public int loginCheck(String userid, String pwd) {

        Connection con=null;

        Statement st=null;

        ResultSet rs=null;

        int flag=-1;

        try {

            con=getConnection();

            String sql="select pwd, admin from jmember where userid='"+userid+"'";

            st=con.createStatement();

            rs=st.executeQuery(sql);

            if(rs.next()) { //id 맞음

                if(rs.getString("pwd").equals(pwd)) { //비번 일치

                    flag=rs.getInt("admin");

                }else { //비번 오류

                    flag=2;

                }

            }

        } catch (Exception e) {

            e.printStackTrace();

        } finally {

            closeConnection(con, st, rs);

        }

        return flag;

    }

    

    //회원수

    public int getCount() {

        Connection con=null;

        Statement st=null;

        ResultSet rs=null;

        int count=0;

        

        try {

            con=getConnection();

            String sql="select count(*) from jmember";

            st=con.createStatement();

            rs=st.executeQuery(sql);

            if(rs.next()) {

                count=rs.getInt(1);

            }

        } catch (Exception e) {

            e.printStackTrace();

        } finally {

            closeConnection(con, st, rs);

        }

        return count;

    }

    

    //닫기 closeConnection

    private void closeConnection(Connection con, PreparedStatement ps) {

        try {

            if(ps!=null) ps.close();

            if(con!=null) con.close();

        } catch (SQLException e) {

            e.printStackTrace();

        }

    }

    private void closeConnection(Connection con, Statement st, ResultSet rs) {

        try {

            if(st!=null) st.close();

            if(con!=null) con.close();

            if(rs!=null) rs.close();

        } catch (SQLException e) {

            e.printStackTrace();

        }

    }

    

}

저작자표시 비영리 변경금지

'Learning > JSP' 카테고리의 다른 글

파일 전송 (0)	2020.08.06
게스트북 (평가리스트) 만들기 (0)	2020.08.06
로그인, 회원가입, 게시판 만들기 1 (0)	2020.07.29
서블릿: 출력경로 통일하기 (0)	2020.07.29
서블릿으로 주소록 만들기 (0)	2020.07.28

내 블로그 - 관리자 홈 전환	`Q` `Q`
새 글 쓰기	`W` `W`

글 수정 (권한 있는 경우)	`E` `E`
댓글 영역으로 이동	`C` `C`

이 페이지의 URL 복사	`S` `S`
맨 위로 이동	`T` `T`
티스토리 홈 이동	`H` `H`
단축키 안내	`Shift` + `/` `⇧` + `/`

cozy coding

로그인, 회원가입, 게시판 만들기 2

'Learning > JSP' 카테고리의 다른 글

+ Recent posts

티스토리툴바

단축키

내 블로그

블로그 게시글

모든 영역