An alert does not appear when a SQLException pops up on a JSP page, although it can be seen from the debugger that it passes this piece.

<% try { if (genre != null && artist != null) { genre_id = genre.getId(); artist_id = artist.getId(); trackDao.create(name, genre_id, artist_id); } } catch (SQLException e) { %> <script> alert('Нет такого жанра или исполнителя'); </script> <% } finally { daoFactory.closeConnection(); } %>

Full page code:

 <%@ page import="java.sql.Connection" %> <%@ page import="java.sql.SQLException" %> <%@ page import="controller.interfaceDaoItem.ArtistDao" %> <%@ page import="controller.interfaceDaoFactory.DaoFactory" %> <%@ page import="controller.interfaceDaoItem.GenreDao" %> <%@ page import="controller.interfaceDaoItem.TrackDao" %> <%@ page import="controller.impelementationDaoFactory.MySqlDaoFactory" %> <%@ page import="model.GenreItem" %> <%@ page import="model.ArtistItem" %> <%@ page contentType="text/html;charset=UTF-8" language="java" %> <html> <head> <title>Музыкальная библиотека</title> <link href="../../css/css.css" rel="stylesheet"> <script src="../js/common.js" defer></script> </head> <body> <% request.setCharacterEncoding("UTF-8");%> <form id="form" name="inputForm" action="trackIn.jsp" onsubmit="validateTrackInForm()"> <table class="cl2" align="center" border="1" bgcolor="white"> <% if (request.getParameter("track_name") == null && request.getParameter("genre_id") == null && request.getParameter("artist_id") == null) {%> <h1 align="center">Форма добавления нового трека</h1> <tr> <td>Введите название:</td> <td><input id="track_name" type="text" name="track_name" value=""/></td> </tr> <tr> <td>Введите жанр:</td> <td><input id="track_genre" type="text" name="genre_name" value=""/></td> </tr> <tr> <td>Введите артиста:</td> <td><input id="track_artist" type="text" name="artist_name" value=""/></td> </tr> <td> <input type="submit" value="ok" name="ok"/> </td> </table> </form> <% } else { %> <%! String name; int genre_id; int artist_id; String genre_name; String artist_name; %> <% DaoFactory daoFactory = new MySqlDaoFactory(); TrackDao trackDao = null; GenreDao genreDao = null; ArtistDao artistDao = null; Connection con = daoFactory.getConnection(); trackDao = daoFactory.getTrackDao(con); genreDao = daoFactory.getGenreDao(con); artistDao = daoFactory.getArtistDao(con); name = request.getParameter("track_name"); genre_name = request.getParameter("genre_name"); artist_name = request.getParameter("artist_name"); if (name.length() != 0 && genre_name.length() != 0 && artist_name.length() != 0) { GenreItem genre = genreDao.readByName(genre_name); ArtistItem artist = artistDao.readByName(artist_name); try { if (genre != null && artist != null) { genre_id = genre.getId(); artist_id = artist.getId(); trackDao.create(name, genre_id, artist_id); } } catch (SQLException e) { %> <script> alert('Нет такого жанра или исполнителя'); </script> <% } finally { daoFactory.closeConnection(); } } if (true) { %> <jsp:forward page="track.jsp"></jsp:forward> <% } } %> </body> </html>
  • Look at the code of the received page in the browser. Maybe not at all what you want. In the browser, pop-up windows can also be disabled. IE, for example, writes that he banned ActiveX controls on this page, and if you don’t click on разрешить alert, it will not appear - Sergey
  • @Sergey in the page code for some reason, this alert is not visible. What could be the reason? The scripts placed on the form are beautifully displayed. - Pavel Fadeev
  • some kind of markup is completely invalid: h1 inside the table, if - which breaks the form and table . - Grundy

0