Java
jstl foreach 반복문 돌린값중 특정값을 가져와서 게시글을 삭제하고 싶습니다 
             <c:forEach var="pjtList" items="${pjtList}" varStatus="vs">
                                    <tr>
                                        <td><label>
                                            <input name="delList" type="checkbox" value="${pjtList.no}"/>
                                        </label></td>
                                        <td><c:out value="${pjtList.pjtC}"/></td>
                                        <td><c:out value="${pjtList.pjtOrgC}"/></td>
                                        <td><c:out value="${pjtList.pjtDivC}"/></td>
                                        <td><c:out value="${pjtList.pjtStC}"/></td>
                                        <td><c:out value="${pjtList.pjtClient}"/></td>
                                        <td><c:out value="${pjtList.pjtNm }"/></td>
                                        <td><c:out value="${pjtList.pjtEmpList}"/></td>
                                        <td><c:out value="${pjtList.pjtPm}"/></td>
                                        <td><c:out value="${pjtList.pjtStartDate}"/></td>
                                        <td><c:out value="${pjtList.pjtEndDate}"/></td>
                                        <td><c:out value="${pjtList.pjtEndYn}"/></td>
                                    </tr>
                                </c:forEach>

jsp는 이렇구

저기서 pjtList.no 값을 받아와서

    @RequestMapping(value="/delete", method=RequestMethod.POST)
    public String delete(@RequestParam("delList") int no) {

        pjtService.deletePjt(no);
        pjtService.deletePjtCode(no);

        return "redirect:/project/pjtShow";
    }

이렇게 처리 하면 

DEBUG: org.mybatis.spring.SqlSessionUtils - Creating a new SqlSession
DEBUG: org.mybatis.spring.SqlSessionUtils - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@71e46937] was not registered for synchronization because synchronization is not active
DEBUG: org.springframework.jdbc.datasource.DataSourceUtils - Fetching JDBC Connection from DataSource
DEBUG: org.mybatis.spring.transaction.SpringManagedTransaction - JDBC Connection [HikariProxyConnection@1042191168 wrapping net.sf.log4jdbc.sql.jdbcapi.ConnectionSpy@f21126b] will not be managed by Spring
DEBUG: org.leedh.mapper.PjtMapper.deletePjt - ==>  Preparing: DELETE FL_PROJECT WHERE NO = ? 
DEBUG: org.leedh.mapper.PjtMapper.deletePjt - ==> Parameters: null
DEBUG: jdbc.sqlonly -  com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
1. DELETE FL_PROJECT WHERE NO = NULL 

DEBUG: jdbc.sqltiming -  com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
1. DELETE FL_PROJECT WHERE NO = NULL 
 {executed in 2 msec}

이렇게 null 값이 넘어옵니다...

 

이건 매퍼입니다


    <delete id="deletePjtCode" >
        DELETE
            FL_PJT_CODE
        WHERE
            NO = #{no}
    </delete>

    <delete id="deletePjt">
        DELETE
            FL_PROJECT
        WHERE
            NO = #{no}
    </delete>

 

어떻게 해야할까요...

0
2
2,795
댓글 2