JSP REF 예제

특별한 처리 없이 class ref를 받을 수 있습니다.

public void insertBbs(Bbs bbs) {

String sql = "insert into bbs(BBSNO, TITLE, UPLOADER, CONTENT) " + 

"values (bbs_seq.nextval,?,?,?)";

try(Connection connection = DBUtil.getDataSource().getConnection();

//Statement st = connection.createStatement();

PreparedStatement pstmt = connection.prepareStatement(sql, new String[] {

"bbsno"

});){

//pstmt.setInt(1, bbs.getBbsno());

pstmt.setString(1, bbs.getTitle());

pstmt.setString(2, bbs.getUploader());

pstmt.setString(3, bbs.getContent());

pstmt.executeUpdate();

ResultSet rs = pstmt.getGeneratedKeys();

if(null != rs && rs.next()) {

Long pk = rs.getLong(1);

bbs.setBbsno(pk.intValue());

}

}

catch(Exception e){

e.printStackTrace();

}

}