com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1


<script src="/scripts/vendor/jquery.rwdImageMaps.min.js"></script>
<script>
    $(document).ready(function(e) {
        $('img[usemap]').rwdImageMaps();
    });

    function Send_edit() {
        
        document.frm.action="comment/board_edit.jsp";
        document.frm.submit();
        
    }

    function Send_del() {
        
        if (confirm("정말 삭제하겠습니까?")) {
            document.frm.action="/servlet/Aik_Board_Delete";
            document.frm.submit();
        }
        
    }

    function CheckForm() {
        if(frm._0000_aik_passwd.value=="") {
            alert("수정, 삭제시 비밀번호를 입력해 주십시오.");
            frm._0000_aik_passwd.focus();
            return false;
        }
        return true;
    }

    function Send_re() {
        document.frm2.submit();
    }
    //공개 여부 수정시 비밀번호 모달 보여주기
    function nonMemberShowModal(commentId, index) {
        $('#comment_modify_modal').modal("show");
        $(".modal_btn").attr("onclick", "nonmember_change_open_state('" + commentId + "','" + index + "')")
    }

    //공개 여부 수정 ajax
    function nonmember_change_open_state(commentId, index) {
        var comment = ".comment-row-" + index
        var is_opened = 0;
        var password = document.getElementById("input_password").value

        var check_state = $(comment + " .open_check")[0].checked;

        if (check_state) {
            is_opened = 1;
        } else {
            is_opened = 0;
        }

        $.ajax({
            url: "comment/open_comment.jsp",
            data: {
                "comment_id": commentId,
                "is_opened": is_opened,
                "password": password
            },
            type: 'post',
            dataType: 'JSON',
            success: function (response) {
                if (response && response.msg == 'success') {
                    if (response.is_open == 0) {
                        alert("댓글이 비공개로 설정되었습니다.")
                    } else {
                        alert("댓글이 공개로 설정되었습니다.")
                    }
                    listComment();
                } else if (response.msg == 'fail') {
                    alert("비밀번호가 틀렸습니다.");
                    return false;
                } else {
                    alert("공개여부 수정에 실패했습니다. 관리자에게 문의하시기 바랍니다.");
                    return false;
                }
            }
        });
        $('#comment_modify_modal').modal('hide');
        $("#input_password").value = ""
        $(comment + " .open_check")[0].checked = !check_state
    }
    //회원 공개 수정
    function member_change_open_state(commentId, index) {
        var comment = ".comment-row-" + index
        var is_opened = 0;

        if ($(comment + " .open_check")[0].checked) {
            is_opened = 1;
        } else {
            is_opened = 0;
        }

        $.ajax({
            url: "comment/open_comment.jsp",
            data: {
                "comment_id": commentId,
                "is_opened": is_opened
            },
            type: 'post',
            dataType: 'JSON',
            success: function (response) {
                if (response && response.msg == 'success') {
                    if (response.is_open == 0) {
                        alert("댓글이 비공개로 설정되었습니다.")
                    } else {
                        alert("댓글이 공개로 설정되었습니다.")
                    }
                    listComment();
                } else if (response.msg == 'fail') {
                    alert("비밀번호가 틀렸습니다.");
                    return false;
                } else {
                    alert("공개여부 수정에 실패했습니다. 관리자에게 문의하시기 바랍니다.");
                    return false;
                }
            }
        });
    }

    function comment_modify(index) {
        //모달에 있는 버튼 함수 해당 row에 있는 form submit 실행 할 수 있도록 수정
        $(".modal_btn").attr('onclick', 'comment_modal_submit("' + index + '")');
    }

    function comment_modify(index) {
        //모달에 있는 버튼 함수 해당 row에 있는 form submit 실행 할 수 있도록 수정
        $(".modal_btn").attr('onclick', 'comment_modal_submit("' + index + '")');
    }

    function comment_modal_submit(index) {
        var comment = ".comment-row-" + index
        let password = document.getElementById("input_password").value

        //해당 row에 있는 hidden password에 값을 넘겨줌
        $(comment + ' .password').val(password);
        //submit
        submitEditReply(index);
        //modal에 입력되어 있는값 초기화 및 모달 닫기
        document.getElementById("input_password").value = "";
        $('#comment_modify_modal').modal('hide');
    }

    function nonmember_comment_modify(comment_id, board_id, index, is_opened) {
        //모달에 있는 버튼 함수 해당 row에 있는 form submit 실행 할 수 있도록 수정
        $(".modal_btn").html("수정")
        $(".modal_btn").attr("style", "background-color:#012385 ; border-color : #012385")
        $(".modal_btn").attr('onclick', 'commentModifyPasswordCheck("' + comment_id + '","' + board_id + '","' + index + '","' + is_opened + '")');
    }

    function commentModifyPasswordCheck(comment_id, board_id, index, is_open) {
        var password = document.getElementById("input_password").value
        $.ajax({
            url: 'comment/check_password.jsp',
            data: {
                'password': password,
                'comment_id': comment_id
            },
            type: 'post',
            dataType: 'JSON',
            success: function (res) {
                if (res.msg == "success") {
                    editReplyUsingAdmin(0, comment_id, index, is_open)
                    $('#comment_modify_modal').modal('hide');
                } else if (res.msg == "fail") {
                    alert("비밀번호가 틀렸습니다.");
                    return false;
                } else {
                    alert("비밀번호 확인에 실패했습니다. 관리자에게 문의하시기 바랍니다.");
                    return false;
                }
            }
        })
    }

    function comment_delete(comment_id, user_code) {
        //모달에 있는 버튼 함수 해당 row에 있는 form submit 실행 할 수 있도록 수정
        $(".modal_btn").attr('onclick', 'comment_delete_submit("' + comment_id + '" , "' + user_code + '")');
        $(".modal_btn").html("삭제")
        $(".modal_btn").attr("style", "background-color:red ; border-color : red")
    }

    function comment_delete_submit(comment_id, user_code) {
        var comment = ".comment-row-" + comment_id
        let password = document.getElementById("input_password").value

        deleteReply(comment_id, password, user_code);
        //modal에 입력되어 있는값 초기화 및 모달 닫기
        document.getElementById("input_password").value = "";
        $('#comment_modify_modal').modal('hide');
    }

    // 답글 등록
    function postReply(commentId, index) {
        $(".comment-area .text-box").removeClass("hide")
        $(".comment-area .reply-form-container").remove()

        var class_name = '.comment-row-' + index + '+ .comment-area';

        if ($(class_name + ' > .reply-form-container').size() < 1) {

            var clone_target = $('#reply-form-container').clone();
            $(class_name).append(clone_target);

            $(class_name + ' > .reply-form-container').removeClass('hide');
            $(class_name + ' > .reply-form-container').removeAttr('id');

            $(class_name + ' .submitReply').attr('href', 'javascript:submitAddReply("' + index + '")');
            $(class_name + ' .cancelReply').attr('href', 'javascript:cancelAddReply(' + index + ')');
            $(class_name + ' .parent_id').val(commentId);
        }
    }

    // 댓글, 답글 수정
    function editReply(parentId, commentId, index , is_opened) {
        $(".comment-area .text-box").removeClass("hide")
        $(".comment-area .reply-form-container").remove()

        var class_name = '.comment-row-' + index;
        var comment_text = $('.comment-row-' + index + " + .comment-area .comment-text").text();

        if ($(class_name + ' .reply-form-container').size() < 1) {

            $(class_name + ' + .comment-area .text-box').addClass("hide");
            $(class_name + ' .utility-btn-area').addClass("hide");

            var clone_target = $('#reply-form-container').clone();
            $(class_name + ' + .comment-area .content-area').append(clone_target);

            $(class_name + ' + .comment-area .reply-form-container').removeClass('hide');
            $(class_name + ' + .comment-area .reply-form-container').removeAttr('id');

            /*            if (parentId != 0) {
                            $(class_name + ' .board_id').val(parentId);
                        }*/
            if(is_opened == "0"){
                $("#is_open").attr("checked" , true);
            }else{
                $("#is_open").attr("checked" , false);
            }
            $(class_name + ' + .comment-area .comment_id').val(commentId);
            $("#comment_id").val(commentId)
            $(class_name + ' + .comment-area .input-field ').text(comment_text);
            $(class_name + ' + .comment-area .reply-form-container .commenter').remove();
            $(class_name + ' + .comment-area .reply-form-container .btn-box > .submitReply').text('수정');
            // $(class_name + ' .reply-form-container .btn-box > .submitReply').remove();

            $(class_name + ' + .comment-area .submitReply').attr('href', 'javascript:submitEditReply("' + index + '")');
            $(class_name + ' + .comment-area .modalbutton').attr('onclick', 'comment_modify("' + index + '")');
            $(class_name + ' + .comment-area .cancelReply').attr('href', 'javascript:cancelEditReply(' + index + ')');
        }
    }

    // 댓글, 답글 수정
    function editReplyUsingAdmin(parentId, commentId, index, is_open) {
        $(".comment-area .text-box").removeClass("hide")
        $(".comment-area .reply-form-container").remove()

        var class_name = '.comment-row-' + index + ' + .comment-area';
        var comment_text = $('.comment-row-' + index + " + .comment-area .comment-text").text();


        if ($(class_name + ' .reply-form-container').size() < 1) {

            $(class_name + ' .text-box').addClass("hide");
            $(class_name + ' .text-box').addClass("hide");

            var clone_target = $('#reply-form-container').clone();
            $(class_name + ' .content-area').append(clone_target);

            $(class_name + ' .reply-form-container').removeClass('hide');
            $(class_name + ' .reply-form-container').removeAttr('id');


            if (parentId != 0) {
                $(class_name + ' .board_id').val(parentId);
            }
            $(class_name + ' .comment_id').val(commentId);
            $("#comment_id").val(commentId)

            $.ajax({
                url: "comment/get_comment.jsp",
                data: {"id": commentId},
                dataType: "JSON",
                type: "post",
                success: function (res) {
                    $(class_name + ' .input-field ').text(res.commentContents);
                }
            })
            if (is_open == 1) {
                document.getElementById("is_open").checked = false;
            } else {
                document.getElementById("is_open").checked = true;
            }
            $(class_name + ' .reply-form-container .commenter').remove();
            $(class_name + ' .reply-form-container .btn-box > .submitReply').text('수정');

            $(class_name + ' .submitReply').attr('href', 'javascript:submitEditReply("' + index + '")');
            $(class_name + ' .cancelReply').attr('href', 'javascript:cancelEditReply(' + index + ')');
        }
    }

    // 댓글, 답글 수정 submit
    function submitEditReply(index) {
        var str = $(".comment-row-" + index + " + .comment-area #frm-reply").serialize();

        if ($(".comment-row-" + index + " + .comment-area .reply-form-container textarea").val() == '') {
            alert('글을 작성해 주시기 바랍니다.');
        } else {
            $.ajax({
                url: "comment/edit_comment.jsp",
                data: str,
                type: 'post',
                dataType: 'JSON',
                success: function (response) {
                    if (response && response.msg == 'success') {
                        listComment();
                    } else if (response.msg == 'fail') {
                        alert("비밀번호가 틀렸습니다.");
                        return false;
                    } else {
                        alert("글 수정에 실패했습니다. 관리자에게 문의하시기 바랍니다.");
                        return false;
                    }
                }
            });
        }
    }

    // 답글 등록 submit
    function submitAddReply(index) {
        var str = $(".comment-row-" + index + " + .comment-area #frm-reply").serialize();

        if ($(".comment-row-" + index + " + .comment-area .reply-form-container textarea").val() == '') {
            alert('글을 작성해주시기 바랍니다.');
        } else {
            $.ajax({
                url : "comment/add_comment.jsp",
                data : str,
                type : 'post',
                dataType: 'JSON',
                success : function(response) {
                    if (response && response.msg == 'success') {
                        listComment();
                    } else {
                        alert("글 등록에 실패했습니다. 관리자에게 문의하시기 바랍니다.");
                        return false;
                    }
                }
            });
        }
    }

    // 비회원 댓글, 답글 삭제
    function deleteReply(commentId, password, user_code) {
        var chk = confirm('삭제하시겠습니까?');

        if (chk && commentId != '') {
            $.ajax({
                url: "comment/delete_comment.jsp",
                data: {
                    "comment_id": commentId,
                    "password": password,
                    "user_code": user_code
                },
                type: 'post',
                dataType: 'JSON',
                success: function (response) {
                    if (response && response.msg == 'success') {
                        listComment();
                        alert('삭제되었습니다.');
                    } else if (response.msg == 'fail') {
                        alert("비밀번호가 틀렸습니다.");
                    } else {
                        alert("글을 삭제하는데 실패했습니다. 관리자에게 문의하시기 바랍니다.");
                        return false;
                    }
                }
            });
        }

    }

    //관리자, 댓글 작성자 답글 삭제 버튼
    function deleteReplyUsingAdmin(commentId) {
        var chk = confirm('삭제하시겠습니까?');

        if (chk && commentId != '') {
            $.ajax({
                url: "comment/delete_comment.jsp",
                data: 'comment_id=' + commentId,
                type: 'post',
                dataType: 'JSON',
                success: function (response) {
                    if (response && response.msg == 'success') {
                        listComment();
                        alert('삭제되었습니다.');
                    } else {
                        alert("글을 삭제하는데 실패했습니다. 관리자에게 문의하시기 바랍니다.");
                        return false;
                    }
                }
            });
        }

    }


    $(function () {
        //모달 그냥 닫으면 기존 상태로 돌아오기
        $('.modal').on('hidden.bs.modal', function () {
            document.getElementById("input_password").value = "";
            // listComment();
        });

        // 댓글 리스트 불러오기
        listComment();

        // 댓글 등록
        $("#submitButton").click(function () {

            var str = $("#frm-comment").serialize();
            
            var name = document.getElementById("name").value;
            var password = document.getElementById("password").value;
            var _capcha = document.getElementById("_capcha").value;


            if (!name.length > 0) {
                alert("이름을 입력해 주시기 바랍니다.");
                return false;
            }
            if (!password.length > 0) {
                alert("비밀번호를 입력해 주시기 바랍니다.");
                return false;
            }
            if (!_capcha.length > 0) {
                alert("보안 문자를 입력해 주시기 바랍니다.");
                return false;
            }
            

            if ($('.comment-form-container textarea').val() == '') {
                alert('글을 작성해 주시기 바랍니다.');
                return false;
            }

            $.ajax({
                url: "comment/add_comment.jsp",
                data: str,
                type: 'post',
                dataType: 'JSON',
                success: function (response) {
                    if (response && response.msg == 'success') {
                        $("#comment").val("");
                        // $("#board_id").val("");
                        // listComment();
                        location.reload()
                    } else {
                        alert(response.msg);
                        return false;
                    }
                }
            });
        });
    });

    var index = 0;

    // 댓글 리스트 불러오기
    function listComment() {
        $.post(
            "comment/get_comment_list.jsp?board_id=",
            function (data) {
                var data = JSON.parse(data);
                var comments = "";
                var replies = "";
                var item = "";
                var parent = -1;
                var results = new Array();

                var list = $("<ul class='outer-comment'>");
                var item = $("<li>").html(comments);

                for (var i = 0; (i < data.length); i++) {
                    var commentId = data[i]['id'];
                    var parent = data[i]['parent_id']
                    var usercode = data[i]['user_code'];
                    var is_opened = data[i]['is_opened'];

                    var edit_button = "";
                    var delete_button = "";
                    var open_button = "";
                    var lock = "";
                    var reply = "";

                    //회원일때 비공개 된 comment 막기
                    /*                    if('

                    0' != usercode && is_opened == 0){
                        continue;
                    }*/

                    if ((usercode == 0 && '0' == usercode)) { // 비회원인 경우
                        // edit_button = "<span><a class='btn-reply pull-right' onClick='editReply(" + 0 + ", " + commentId + ", " + index + ")'>수정<span class='mg-r5'></span>·<span class='mg-r5'></span></a></span></a></span>";
                        edit_button = "<a class='btn btn-warning btn-xs nonMemberDeletebutton' type='button' data-toggle='modal' data-target='#comment_modify_modal' onclick='nonmember_comment_modify(" + commentId + ", 0 ," + index + "," + is_opened + ")'>수정</a>";
                        delete_button = "<a class='btn btn-danger btn-xs nonMemberDeletebutton' type='button' data-toggle='modal' data-target='#comment_modify_modal' onclick='comment_delete(" + commentId + "," + usercode + ")'>삭제</a>";
                        if (is_opened == 1) {
                            open_button = "<span class='input-comment-private'><input class='form-check-input open_check' type='checkbox'  name='is_opends' onchange='nonMemberShowModal(" + commentId + " , " + index + ")'>비밀글</span>";
                        } else {
                            lock = "<span class='icon-lock'><i class='ion-locked'></i></span>"
                            open_button = "<span class='input-comment-private'><input class='form-check-input open_check' type='checkbox' name='is_opends' checked onchange='nonMemberShowModal(" + commentId + " , " + index + ")'>비밀글</span>";
                        }
                    } else if ((usercode != 0 && '0' == usercode)) { // 회원인 경우
                        edit_button = "<a class='btn-reply modify' onClick='editReplyUsingAdmin(" + 0 + ", " + commentId + ", " + index + ", " + is_opened + ")'>수정</a><span class='divline'>·</span>";
                        delete_button = "<a class='btn-reply delete' onClick='deleteReplyUsingAdmin(" + commentId + ")'>삭제</a>";
                        if (is_opened == 1) {
                            open_button = "<span class='input-comment-private'><input class='form-check-input open_check' type='checkbox'  name='is_opends' onchange='member_change_open_state(" + commentId + " , " + index + ")'>비밀글</span>";
                        } else {
                            lock = "<span class='icon-lock'><i class='ion-locked'></i></span>"
                            open_button = "<span class='input-comment-private'><input class='form-check-input open_check' type='checkbox'  name='is_opends' checked onchange='member_change_open_state(" + commentId + " , " + index + ")'>비밀글</span>";
                        }
                    } else if ('' == '00') {//관리자 인 경우
                        edit_button = "<a class='btn btn-warning btn-xs' onClick='editReplyUsingAdmin(" + 0 + ", " + commentId + ", " + index + ", " + is_opened + ")'>수정</a>";
                        delete_button = "<a class='btn btn-danger btn-xs' onClick='deleteReplyUsingAdmin(" + commentId + ")'>삭제</a>";
                        if (is_opened == 1) {
                            open_button = "<span class='input-comment-private'><input class='form-check-input open_check' type='checkbox' name='is_opends' onchange='member_change_open_state(" + commentId + " , " + index + ")'>비밀글</span>";
                        } else {
                            lock = "<span class='icon-lock'><i class='ion-locked'></i></span>"
                            open_button = "<span class='input-comment-private'><input class='form-check-input open_check' type='checkbox' name='is_opends' checked onchange='member_change_open_state(" + commentId + " , " + index + ")'>비밀글</span>";
                        }
                    }

                    //댓글 숨김 여부에 따른 노출
                    var commen_contents = data[i]['comment'];

                    var UserAuth =-1

                    if (is_opened == 1 || UserAuth == "00" || (usercode != 0 && 0 == usercode) || true) {
                        comment = "<div class='comment-text'>" + commen_contents + "</div>"
                    } else {
                        lock = "<span class='icon-lock'><i class='ion-locked'></i></span>"

                        comment = "<p class='comment-text-private'>비공개 댓글입니다.</p>"
                    }

                    if(UserAuth == "00" || (usercode != 0 && 0 == usercode) || true){
                        reply = "<span><a class='btn-reply reply-depth2' onClick='postReply(" + commentId + ", " + index + ")'>대댓글 작성</a></span>";
                    }

                    if(data[i].deleted == "1"){
                        comment = "<p class='comment-text-private'>삭제된 댓글입니다.</p>"
                        edit_button = "";
                        delete_button = "";
                        reply=""
                    }

                    if (parent == "0") {

                        comments = "<span class='comment-row-" + index + " comment-box clearfix'>"
                            + "<span class='comment-profile'><span class='icon-profile'><i class='ion-person'></i></span>"
                            + "<span class='posted-info'><span class='posted-by'>" + data[i]['name'] + lock + "</span> "
                            + "<span class='posted-at'>" + data[i]['created_at'] + "</span></span>"
                            + "<span class='utility-btn-area'>"
                            + edit_button
                            + delete_button
                            + "</span>"
                            + "</span>"
                            + "</span>"
                            // + open_button
                            + "<div class='comment-area'>"
                            + "<div class='content-area'>"
                            + "<div class='text-box'> "
                            + comment
                            + "<div class='btn-box'>"
                            + reply
                            + "</div>"
                            + "</div>"
                            + "</div>"
                            + "</div>";

                        var item = $("<li>").html(comments);
                        list.append(item);
                        var reply_list = $("<ul class='reply-depth2'>");
                        item.append(reply_list);
                        listReplies(commentId, data, reply_list,usercode);
                    }
                    ++index;
                }
                $("#output").html(list);
            });
    }

    function cancelAddReply(index) {
        $('.comment-row-' + index + ' + .comment-area .reply-form-container').remove();
    }

    // 답글 수정 취소
    function cancelEditReply(index) {
        $("#" + index + "_password").remove();
        $('.comment-row-' + index + ' + .comment-area .reply-form-container').remove();
        $('.comment-row-' + index + ' + .comment-area .text-box').removeClass("hide");
    }

    // 답글 불러오기
    function listReplies(commentId, data, list , parentUserCode) {
        for (var i = 0; (i < data.length); i++) {

            if (commentId == data[i].parent_id) {
                var lock = "";
                var comments = "";

                var edit_button = "";
                var delete_button = "";

                var usercode = data[i]['user_code'];
                var is_opened = data[i]['is_opened'];
                var UserAuth =-1

                if (is_opened == 1 || UserAuth == "00" || (usercode != 0 && 0 == usercode) || true || parentUserCode == 0) {
                    comment = "<div class='comment-text'>" + data[i]['comment'] + "</div>"
                } else {
                    lock = "<span class='icon-lock'><i class='ion-locked'></i></span>"

                    comment = "<p class='comment-text-private'>비공개 댓글입니다.</p>"
                }



                
                
                //         edit_button = "<span><a class='btn-reply pull-right' onClick='editReply(" + commentId + ", " + data[i]['id'] + ", " + index + ")'>수정<span class='mg-r5'></span>·<span class='mg-r5'></span></a></span>";
                //         delete_button = "<span><a class='btn-reply pull-right' onClick='deleteReply(" + data[i]['id'] + ")'>삭제</a></span>";
                //     }
                // } else {
                if (data[i]['user_code'] == '0') {
                    edit_button = "<a class='btn-reply modify' onClick='editReply(" + commentId + ", " + data[i]['id'] + ", " + index + ","+is_opened+")'>수정</a><span class='divline'>·</span>";
                    delete_button = "<a class='btn-reply delete' onClick='deleteReply(" + data[i]['id'] + ")'>삭제</a>";
                }
                // }
                if(data[i].deleted == 1){
                    comment = "<p class='comment-text-private'>삭제된 댓글입니다.</p>"
                    edit_button="";
                    delete_button="";
                }

                var comments = "<span class='bg-reply-line'></span><span class='comment-row-"+index+" comment-box clearfix'>"
                    + "<span class='comment-profile'><span class='icon-reply'><i class='ion-chatbox-working'></i></span>"
                    + "<span class='posted-info'><span class='posted-by'>" + data[i]['name'] + lock+"</span> "
                    + "<span class='posted-at'>" + data[i]['created_at'] + "</span></span></span></span>"
                    + "<div class='comment-area'>"
                    + "<div class='content-area'>"
                    + "<div class='text-box'> "
                    + comment
                    + "<div class='btn-box'>"
                    + edit_button
                    + delete_button
                    + "</div>"
                    + "</div>"
                    + "</div>"
                    + "</div>";

                var item = $("<li>").html(comments);
                var reply_list = $('<ul>');
                list.append(item);
                item.append(reply_list);
                listReplies(data[i].id, data, reply_list);
            }

            ++index;
        }
    }
</script>