Package org.geekhub.objects

Examples of org.geekhub.objects.Actor

56
57
58
59
60
61
62
63
64
65
66
                            preparedStatement.setString(1, String.valueOf(movie.getId()));
                        }
                    }, new RowMapper<Actor>() {
                        @Override
                        public Actor mapRow(ResultSet resultSet, int i) throws SQLException {
                            return new Actor(resultSet.getInt(1), resultSet.getString(2), resultSet.getString(3),
                                    resultSet.getDate(4));
                        }
                    }
            );
            movie.setActorList(actorList);
View Full Code Here
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
    public Actor getById(final int id) {
        String sql = "SELECT * FROM actor WHERE actor.id = ?";
        String moviesSql = "SELECT * FROM movie INNER JOIN movies_actors ON movie.id = movies_actors.movie_id WHERE " +
                "movies_actors.actor_id = ?";

        Actor actor = jdbcTemplate.queryForObject(sql, new Object[]{id}, new BeanPropertyRowMapper<Actor>(Actor.class));
        List<Movie> movieList = jdbcTemplate.query(moviesSql, new Object[]{actor.getId()}, new RowMapper<Movie>() {
            @Override
            public Movie mapRow(ResultSet resultSet, int i) throws SQLException {
                return new Movie(resultSet.getInt(1), resultSet.getString(2), resultSet.getString(3));
            }
        });
        actor.setMovieList(movieList);
        return actor;
    }
View Full Code Here
46
47
48
49
50
51
52
53
54
55
56
  }

    @RequestMapping(value = "/create-actor.html", method = RequestMethod.GET)
    public String createActor(ModelMap model) {
        List<Movie> movies = movieDAO.queryMovies();
        Actor actor = new Actor();
        model.addAttribute("actor", actor);
        model.addAttribute("movies", movies);
        model.addAttribute("save_or_update", "Save");
        return "actor_form";
    }
View Full Code Here
111
112
113
114
115
116
117
118
119
120
121
        return "redirect:/";
    }

    @RequestMapping(value = "/edit-actor.html", method = RequestMethod.POST)
    public String editActor(@RequestParam("id") int actorId, ModelMap model) {
        Actor actor = actorDAO.getById(actorId);
        model.addAttribute("actor", actor);
        model.addAttribute("movies", movieDAO.queryMovies());
        model.addAttribute("save_or_update", "Update");
        return "actor_form";
    }
View Full Code Here
TOP

Related Classes of org.geekhub.objects.Actor

  • org.geekhub.database.ActorDAO
  • org.geekhub.database.MovieDAO
  • org.geekhub.MainController
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.