public String search(HttpServletRequest request, HttpServletResponse response) {

		try {
			String queryString = request.getQueryString();
			String searchtext = queryString.split("=")[1];
			System.out.println(searchtext);
			searchtext = URLDecoder.decode(searchtext, "utf-8");
			if (searchtext.compareTo("") != 0) {
				String sql = "select * from film where name like '%"
						+ searchtext + "%'";
				FilmDao filmDao = new FilmDao();
				List<Film> films = new ArrayList<Film>();
				films = filmDao.getFilmByCondition(sql);
				List<String> strs=new ArrayList<String>();
				for (int i = 0; i < films.size(); i++) {
					strs.add(films.get(i).getName());
				}
				 request.setAttribute("my-data1",strs);
			} else {
	
			     request.setAttribute("my-data2","search is empty");
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
		return "/my.jsp";

	}