批量删除,可作为JDBC DAO层模板代码

/** * 删除 流向单主表,支持批量删除 * @param flowCardNOs 流向单号 * @throws DaoException Dao层异常 */@Overridepublic void delFlowCardMaster(String[] flowCardNOs) throws DaoException {// 表示 流向单号 的占位符StringBuilder flowCardNOsMarks = new StringBuilder();// 最终的效果 ?,?,?for (int i = 0; i < flowCardNOs.length; i++) {flowCardNOsMarks.append("?");if (i < flowCardNOs.length - 1) {flowCardNOsMarks.append(",");}}// 删除 流向单 的 sql/*delete from t_flow_card_masterwhere Flow_card_no in ('');*/StringBuffer sql = new StringBuffer();sql.append("delete from t_flow_card_master ").append("where Flow_card_no in (").append(flowCardNOsMarks).append(")");// JDBCPreparedStatement preparedStatement = null;Connection connection = ConnectionManager.getConnection();try {preparedStatement = connection.prepareStatement(sql.toString());// 给 占位符 赋值for (int i = 0; i < flowCardNOs.length; i++) {preparedStatement.setString(i + 1, flowCardNOs[i]);}preparedStatement.executeUpdate();} catch (SQLException e) {e.printStackTrace();throw new DaoException("删除流向单主表失败!");} finally {ConnectionManager.closeStatement(preparedStatement);}}