5/26 deleteBoard 부모글삭제시 댓글삭제. 트랜잭션처리

public void deleteBoard(String num) {
		String sql="delete board where num=?";
		String sql2="delete reply where pNum=?";
		Connection conn = null;
		PreparedStatement pstmt = null;
		try {
			conn = DBManager.getConnection();
			conn.setAutoCommit(false);
			//댓글삭제
			pstmt = conn.prepareStatement(sql2);
			pstmt.setString(1, num);
			pstmt.executeUpdate();
			//부모글삭제
			pstmt = conn.prepareStatement(sql);
			pstmt.setString(1, num);
			pstmt.executeUpdate();
			
			conn.commit();
		} catch (SQLException e) {
			e.printStackTrace();
			if(conn!=null) {
				try {
					conn.rollback();
				} catch (SQLException e1) {					
					e1.printStackTrace();
				}
			}
		}
	}