Spring jdbcTemplate.query example


      Click here to attend Spring Framework 4.x and certification course with a discount

   public List<User> getAllUsers() {
    	
    	List<User> users = this.jdbcTemplate.query("select iduser, email, firstname," +
    			"lastname FROM kameroom.user",
        new RowMapper<User>() {
            public User mapRow(ResultSet rs, int rowNum) throws SQLException {
                User user = new User();
                user.setIdUser(rs.getInt("iduser"));
                user.setEmail(rs.getString("email"));
                user.setFirstname(rs.getString("firstname"));
                user.setLastname(rs.getString("lastname"));
                return user;
            }
        });
        return users;
    }
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s