<dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>8.0.23</version>
</dependency>

public DataSource mysqlDataSource() {
    DriverManagerDataSource dataSource = new DriverManagerDataSource();
    dataSource.setDriverClassName("com.mysql.cj.jdbc.Driver");
    dataSource.setUrl("jdbc:mysql://dbURL:portNumber/nameOfDB?useSSL=false");
    dataSource.setUsername("username");
    dataSource.setPassword("password");
    return dataSource;
}

private JdbcTemplate jdbcTemplate;

jdbcTemplate = new JdbcTemplate(nameOfClass.mysqlDataSource());

jdbcTemplate.update("create table meal(\n" +
                " meal_id bigint auto_increment primary key,\n" +
                " name varchar(50) not null unique,\n" +
                " category varchar(50) not null\n" + ");");

jdbcTemplate.update("insert into meal (name, category) values ('Chicken Fajita', 'lunch');");
jdbcTemplate.update("insert into meal (name, category) values ('Enchilada', 'lunch');");

jdbcTemplate.update("create table ingredient(\n" +
        " meal_id bigint not null,\n" +
        " name varchar(50) not null,\n" +
        " quantity bigint not null,\n" +
        " uom varchar(50) not null\n" + ");");
jdbcTemplate.update("alter table ingredient add foreign key (meal_id)" +
        " references meal(meal_id);\n");

jdbcTemplate.update("insert into ingredient (meal_id, name, quantity,"
                + " uom) values ((select meal_id from meal where name = 'Chicken Fajita'), 'chicken', 1, 'kg');\n");
        jdbcTemplate.update("insert into ingredient (meal_id, name, quantity, uom) " +
                "values ((select meal_id from meal where name = 'Chicken Fajita'), 'red pepper', 1, 'piece');\n");
        jdbcTemplate.update("insert into ingredient (meal_id, name, quantity, uom) " +
                "values ((select meal_id from meal where name = 'Chicken Fajita'), 'green pepper', 1, 'piece');\n");
        jdbcTemplate.update("insert into ingredient (meal_id, name, quantity, uom) " +
                "values ((select meal_id from meal where name = 'Chicken Fajita'), 'yellow pepper', 1, 'piece');");
        jdbcTemplate.update("insert into ingredient (meal_id, name, quantity," + " uom) " +
                "values ((select meal_id from meal where name = " + "'Enchilada'), 'chicken', 1, 'kg');\n");
        jdbcTemplate.update("insert into ingredient (meal_id, name, quantity," + " uom) " +
                "values ((select meal_id from meal where name = " + "'Enchilada'), 'cheese', 100, 'grams');\n");
        jdbcTemplate.update("insert into ingredient (meal_id, name, quantity," + " uom) " +
                "values ((select meal_id from meal where name = " + "'Enchilada'), 'tomato', 1, 'piece');\n");

jdbcTemplate.queryForObject(String sqlStatement, Class returnType);

int id = jdbcTemplate.queryForObject("select meal_id from meal
where name='Chicken Fajita';", Integer.class);

System.out.println("Meal id for Chicken Fajita = " + id);

Meal id for Chicken Fajita = 1

jdbcTemplate.queryForMap(String sqlStatement);

Map<String, Object> entireRowAsMap = jdbcTemplate.queryForMap("select * from meal where meal_id = 1");
System.out.println("All details of meal with id 1 = " + entireRowAsMap);

All details of meal with id 1 = {meal_id=1, name=Chicken Fajita, category=lunch}

jdbcTemplate.queryForList(String sqlStatement, Class returnType);

List<String> queryForColumn = jdbcTemplate.queryForList("select " +
        "distinct name from ingredient", String.class);
System.out.println("All available ingredients = " + queryForColumn);

All available ingredients = [chicken, red pepper, green pepper, yellow pepper, cheese, tomato]

jdbcTemplate.queryForList(String sqlStatement);

List<Map<String, Object>> severalRowsAsListOfMaps = jdbcTemplate.queryForList("select * from meal;");
System.out.println("All available meals = " + severalRowsAsListOfMaps);

All available meals = [{meal_id=1, name=Chicken Fajita, category=lunch}, {meal_id=2, name=Enchilada, category=lunch}]

Integer howManyUsages = jdbcTemplate.queryForObject("select count(*) "
                + "from ingredient where name=?", Integer.class, ingredientToLookFor);
        System.out.println("How many time does the ingredient passed as "
                + "parameter appear in the DB " + " = " + howManyUsages);

How many time does the ingredient passed as parameter appear in the DB = 2

public int meal_id;
public String name;
public int quantity;
public String uom;

public void setMeal_id ( int meal_id){
        this.meal_id = meal_id;
}
        public void setName (String name){
          this.name = name;
}
        public void setQuantity ( int quantity){
            this.quantity = quantity;
        }
        public void setUom (String uom){
            this.uom = uom;
        }

public class IngredientRowMapper implements RowMapper<Ingredient> {
@Override
        public Ingredient mapRow(ResultSet rs, int rowNum) throws SQLException {
          Ingredient ingredient = new Ingredient();
          ingredient.setMeal_id(rs.getInt("meal_id"));
          ingredient.setName(rs.getString("name"));
          ingredient.setQuantity(rs.getInt("quantity"));
          ingredient.setUom(rs.getString("uom"));
          return ingredient;
        }
}

Ingredient ingredient = jdbcTemplate.queryForObject("select * from "
        + "ingredient where name like '%yellow%'", new IngredientRowMapper());
System.out.println("The ingredient object = " + ingredient);

The ingredient object = Ingredient{meal_id=1, name='yellow pepper', quantity=1, uom='piece'}