학원에서 팀프로젝트하고 있는데 검색어가 출력이 안되요.. 코드한번봐주세요..

Question

MovieMain.jsp MovieDAO.JAVApublic MovieListBean getSearchMovie(String MovieName) { MovieListBean bean = new MovieListBean(); getcon(); try { String sql = "SELECT * FROM test.movie WHERE replace(moviename , '','') like'%?%'"; pstmt = con.prepareStatement(sql); pstmt.setString(1, MovieName); rs = pstmt.executeQuery(); while(rs.next()){ bean = new MovieListBean(); bean.setMovieNo(rs.getInt(1)); bean.setMovieName(rs.getString(2)); bean.setMovieContent(rs.getString(3)); bean.setMovieImage(rs.getString(4)); bean.setMoviePrice(rs.getInt(5)); bean.setMovieCategoryNo1(rs.getInt(6)); bean.setMovieCategoryNo2(rs.getInt(7)); bean.setMovieAvgRating(rs.getInt(8)); bean.setMovieLink(rs.getString(9)); bean.setMovieReleasedate(rs.getString(10)); bean.setMovieWritedate(rs.getString(11)); bean.setMovieUpdatedate(rs.getString(12)); } con.close(); }catch (Exception e) { e.printStackTrace(); } return bean;} Moviesearh.jsp<% request.setCharacterEncoding("UTF-8"); String MovieName = request.getParameter("MovieName"); MovieDAO rdao = new MovieDAO(); MovieListBean bean = rdao.getSearchMovie(MovieName); %> ">" width="300" height="200">

검책상에 영화를 입력하면 출력이되야하는데 코드가 잘못됬는지 출력이안되요. 결과값은 null 이 뜹니다. bean에 못담는거 같은데 왜이럴까요??입력하면 출력이되야하는데 코드가 잘못됬는지 출력이안되요. 결과값은 null 이 뜹니다. bean에 못담는거 같은데 왜이럴까요??

학원에서 팀프로젝트하고 있는데 검색어가 출력이 안되요.. 코드한번봐주세요..

0개의 답변

Q&A 목록