public int insert(BookVo vo) {
int count = 0;
Connection conn = null;
PreparedStatement pstmt = null;
try {
// 1. 드라이버 로딩
Class.forName("oracle.jdbc.driver.OracleDriver");
// 2. 연결 얻어오기
String url = "jdbc:oracle:thin:@localhost:1521:xe";
conn = DriverManager.getConnection(url, "skudb", "skudb");
// 3. statement 준비
String sql = "insert into book values(seq_book.nextval, ?, ?, ?, ?)";
pstmt = conn.prepareStatement(sql);
// 4. 바인딩
pstmt.setString(1, vo.getTitle());
pstmt.setInt(2, vo.getRate());
pstmt.setInt(3, vo.getStatus());
pstmt.setLong(4, vo.getAuthorNo());
// 5. query 실행
count = pstmt.executeUpdate();
} catch (ClassNotFoundException e) {
System.out.println("드라이버 로딩 실패 :" + e);
} catch (SQLException e) {
System.out.println("error:" + e);
} finally {
try {
// 6. 자원정리
if (pstmt != null) {
pstmt.close();
}
if (conn != null) {
conn.close();
}
} catch (SQLException e) {
System.out.println("error:" + e);
}
}
return count;
}
