com.intelligentz.appointmentz.controllers.deleteRPI.java Source code

Introduction

Here is the source code for com.intelligentz.appointmentz.controllers.deleteRPI.java

Source

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package com.intelligentz.appointmentz.controllers;

import com.intelligentz.appointmentz.database.DBConnection;
import java.beans.PropertyVetoException;
import java.io.IOException;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.commons.dbutils.DbUtils;

/**
 *
 * @author ndine
 */

public class deleteRPI extends HttpServlet {
    private static PreparedStatement preparedStmt;
    private static ResultSet resultSet;
    private static java.sql.Connection connection;
    private static final Logger LOGGER = Logger.getLogger(deleteRPI.class.getName());

    @Override
    public void doPost(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException {
        try {
            String serial = req.getParameter("serial");
            connection = DBConnection.getDBConnection().getConnection();
            String SQL1 = "delete from rpi where serial=?";
            preparedStmt = connection.prepareStatement(SQL1);
            preparedStmt.setString(1, serial);
            // execute the preparedstatement
            preparedStmt.execute();
            res.sendRedirect("./equipments?status=Successfully Deleted Device Serial:" + serial);
        } catch (SQLException | PropertyVetoException ex) {
            LOGGER.log(Level.SEVERE, null, ex);
            res.sendRedirect("./error.jsp?error=Error in delettiing device!\n+" + ex.toString() + "");
        } finally {
            try {
                DbUtils.closeQuietly(resultSet);
                DbUtils.closeQuietly(preparedStmt);
                DbUtils.close(connection);
            } catch (SQLException ex) {
                Logger.getLogger(register.class.getName()).log(Level.SEVERE, ex.toString(), ex);
            }
        }
    }
}