public void adicionar(Fornecedor fornecedor) throws SQLException {
        String sql = "insert into fornecedores (for_nome,for_cnpj,for_email,for_rua,for_num,for_bairro,"
                + "for_cidade,for_estado,for_cep) values (?,?,?,?,?,?,?,?,?)";
        try {
            PreparedStatement stmt = this.conexao.prepareStatement(sql);
            stmt.setString(1, fornecedor.getNome());
            stmt.setString(2, fornecedor.getCnpj());
            stmt.setString(3, fornecedor.getEmail());
            stmt.setString(4, fornecedor.getRua());
            stmt.setString(5, fornecedor.getNum());
            stmt.setString(6, fornecedor.getBairro());
            stmt.setString(7, fornecedor.getCidade());
            stmt.setString(8, fornecedor.getEstado());
            stmt.setString(9, fornecedor.getCep());

            stmt.execute();
            stmt.close();
        } catch (SQLException ex) {
            JOptionPane.showMessageDialog(null, "Erro: " + ex);
        }
    }