Spring MVC JDBC

[karl czukoski]

Hello Everybody, I am trying to figure out how to get the following query to work. In a jsp file, so named page1.jsp, contains

a href with a property listing name that a user selects such as "Phillies" ( ${teamsNLEast.name} ). This property name is then

passed into a variable called teamName to then be subsequently directed to the where clause in the following query.

<a href="page2.htm?teamName=${teamsNLEast.name}">${teamsNLEast.name}</a> 

Here is the class that contains the query and uses the getJdbcTemplate and query methods to process the sql statement, with the

where clause set to teamName, and assigns it to a List of players.

public class JdbcPlayerDao extends SimpleJdbcDaoSupport implements PlayerDao {
@Override
public List<Player> getPlayerListTest(String teamName){
		 
	String sql = "SELECT player_name FROM player WHERE team = ?";

	List<Player> players = (List<Player>)getJdbcTemplate().query(
		sql, new Object[] { teamName }, new PlayerMapper());
	 
	return players;
}

This is where the returned sql result from above will call the mapRow() method to match the value player_name in the database

and set it to the player object.

    private static class PlayerMapper implements ParameterizedRowMapper<Player> {
    	
    	public Player mapRow(ResultSet rs, int rowNum) throws SQLException {
    	Player player = new Player();
    	player.setPlayerName(rs.getString("player_name"));
		
    	return player;
    	}
    }
}

This class implements a getPlayers method that returns a playerlisting to a player data access object from the provided

teamName argument.

public class SimplePlayerManager implements PlayerManager {

	@Override
	public List<Player> getPlayers(String teamName) {
		return playerDao.getPlayerListTest(teamName);
	}

}

And finally my question arises at the Controller where the getPlayers method ought to be passed the teamName string. Though,

when I try to do that I'm receiving a compilation error. Does anyone have an idea on what I'm doing wrong? Your help is

greatly appreciated.

public class MLBControllerPage2 implements Controller {

	@Override
	public ModelAndView handleRequest(HttpServletRequest request, HttpServletResponse response) 
			throws ServletException, IOException {
		
		String now = (new Date()).toString();
		
		Map<String, Object> myModel2 = new HashMap<String, Object>();
		
		   myModel2.put("playersTeam", this.playerManager.getPlayers([color=red]teamName[/color]);
		
		return new ModelAndView("page2", "model2", myModel2);
		
	}
}

[Jeanne Boyarsky]

MLBControllerPage2 doesn't have a player manager injected or passed as a parameter. Therefore it can't compile because a dependency is missing.

[karl czukoski]

Jeanne Boyarsky wrote:MLBControllerPage2 doesn't have a player manager injected or passed as a parameter. Therefore it can't compile because a dependency is missing.

Thanks Jeanne, could you provide some more detail or an example on how this particular injection is performed?