public static List<Movie> simpleSearch(String category, String keyword) throws SQLException, Exception{
        String stmtToCall = null;
        SearchCategory c = Enum.valueOf(SearchCategory.class, category);
        switch(c){
        case MOVIE_TITLE:
            stmtToCall = searchByTitle;
            keyword = addWildcardsForMysqlLikeCmp(keyword);
            break;
        case MOVIE_CATEGORY:
            stmtToCall = searchByCategoryStmt;
            //HACK ALERT!!!
            try{
                Enum.valueOf(Movie.CATEGORY.class, keyword);
            }
            catch(IllegalArgumentException ex){
                return null;
            }
            break;
        case ACTOR_NAME:
            stmtToCall = searchByActorStmt;
            keyword = addWildcardsForMysqlLikeCmp(keyword);
            break;
        case DIRECTOR_NAME:
            stmtToCall = searchByDirectorStmt;
            keyword = addWildcardsForMysqlLikeCmp(keyword);
            break;
        }

        Connection connection = null;
        CallableStatement stmt = null;
        ResultSet rs = null;
        List<Movie> movies;
        try{
            connection = connector.getUserConnection();
            stmt = connection.prepareCall(stmtToCall);

            stmt.setString(1, keyword);

            rs = stmt.executeQuery();
            movies = getMoviesFromResultSet(rs, false);

        }
        finally{
            if(stmt != null)
                stmt.close();
            if(connection != null)
                connector.releaseUserConnection(connection);
            if(rs != null)
                rs.close();
        }
        return movies;
    }