最近在复习sqping,选择看spring实战第五版,但是其中总会有不理解的地方,所以选择解决之后并记录
package tacos.data;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Repository;
import tacos.Ingredient;
import java.sql.ResultSet;
import java.sql.SQLException;
@Repository
public class JdbcIngredientRepository implements IngredientRepository {
@Autowired
JdbcTemplate jdbc;
public JdbcIngredientRepository(JdbcTemplate jdbc){
this.jdbc=jdbc;
}
@Override
public Iterable<Ingredient> findAll() {
return jdbc.query("select id,name,type from Ingredient",this::mapRowToIngredient);
}
@Override
public Ingredient findOne(String id) {
return jdbc.queryForObject("select * from Ingredient where id=?",this::mapRowToIngredient,id);
}
@Override
public Ingredie