SpringBoot在利用JDBCTemplate连接数据库的时候报错 Incorrect column count: expected 1, actual 3] with root cause

需要将你的代码改成如下：

//通过用户id查询
    @RequestMapping("/getUserById/{id}")
    @ResponseBody
    public User getUserById(@PathVariable Integer id){
        String sql = "select * from user where id="+id;
        RowMapper<User> mapper = new RowMapper<User>() {
            @Override
            public User mapRow(ResultSet rs, int i) throws SQLException {
                User user = new User();
                user.setId(rs.getLong("id"));
                user.setName(rs.getString("name"));
                user.setAge(rs.getInt("age"));
                return user;
            }
        };

        User user = jdbcTemplate.queryForObject(sql, mapper);
        return user;
    }

其中的实体类根据具体的情况来定。