인서트문 질문 드립니다!

Question

인서트 할 테이블 이구요밑에 쿼리문인데 이렇게 작성하는 게 맞나요?public int inputReser (Reservation reservation) { String sql &#61; &#34;INSERT INTO RESERVATION( RvBname, RvOname, RvPeriod, RvIndate, RvEmail ) &#34; &#43; &#34;VALUES(COUNSEL_SEQ.nextval, ?, ?, ?, ?, ? SYSDATE )&#34;; try { pstmt &#61; conn.prepareStatement(sql); pstmt.setString(1, reservation.getRvBname()); pstmt.setString(2, reservation.getRvOname()); pstmt.setInt(3, reservation.getRvPeriod()); pstmt.setDate(4, reservation.getRvIndate()); pstmt.setString(5, reservation.getRvEmail()); return pstmt.executeUpdate(); } catch (Exception e) { System.out.println(&#34;예약신청 오류&#34;); } finally { close(); } //DB오류 return -1; }

onimusha · Answer

아니요. INSERT INTO 테이블명 (컬럼명, ...) 을 쓰셔야죠;;

pooha21 · Answer

이렇게 했는데 맞나요??

인서트문 질문 드립니다!

2개의 답변

#column 목록