public List<Film>  getFilmByCondition(String sql)
	{
		
		if(conn!=null&&sql!="")
		{
			try{
				
			Statement stmt=conn.createStatement();
		     //	PreparedStatement pstmt=conn.prepareStatement();
		    ResultSet rs = stmt.executeQuery(sql) ;
		    if(!rs.wasNull())
		    {
		    	List<Film> films=new ArrayList<Film>();
		    	while(rs.next())
		    	{
		    		Film newFilm=new Film();
		    		newFilm.setName(rs.getString("name"));
		    		newFilm.setFilmId(Integer.parseInt(rs.getString("film_id")));
		    		newFilm.setDescription("description");
		    		newFilm.setDouBanUrl("filmurl");
		    		films.add(newFilm);
		    	    //System.out.println(rs.getString("name"));
		    	  
		    	}
		    	stmt.close();
		    	rs.close();
		    	closeConnection();
		    	return films;
		    }
			}
			
			catch(Exception e)
			{
				e.printStackTrace();
			}
			
		}
		
		closeConnection();
		return null;
	}