Medium SQLI - Fixed model class

SqliModel.java

@Component
public class SqliModel {

    @Autowired
    private JdbcTemplate jdbcTemplate;

    public List<Page> getPage(String pageId) {
        String sql = "SELECT pageId, title, content FROM pages WHERE pageId=?";
        List<Page> pages = jdbcTemplate.query(
                sql,
                new Object[]{pageId},
                (resultSet, rowNum) -> new Page(
                        resultSet.getInt("pageId"),
                        resultSet.getString("title"),
                        resultSet.getString("content"))
        );
        return pages;
    }
}