我想在xml JDBCTemolate上进行配置。
看起来是这样的
<context:property-placeholder location="classpath:db/postgres.properties"/>
<bean id="dataSource"
class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="${database.driverClassName}"/>
<property name="url" value="${database.url}"/>
<property name="username" value="${database.username}"/>
<property name="password" value="${database.password}"/>
</bean>
<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
<constructor-arg ref="dataSource"/>
</bean>
<bean id="namedJdbcTemplate" class="org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate">
<constructor-arg ref="dataSource"/>
</bean>
@Service
public class JdbcMealServiceImpl implements MealService {
@Autowired
JdbcMealRepository jdbcMealRepository;
@Override
public Meal save(Meal meal) {
return jdbcMealRepository.save(meal);
}
@Override
public Meal get(int id) {
return jdbcMealRepository.get(id);
}
@Override
public List<Meal> getAll() {
return jdbcMealRepository.getAll();
}
@Override
public void delete(int id) {
jdbcMealRepository.delete(id);
}
@Override
public void update(Meal meal) {
jdbcMealRepository.update(meal);
}
}
JDBCrepository:
@Repository
public abstract class JdbcMealRepository implements MealRepository {
private static final BeanPropertyRowMapper<Meal> ROW_MAPPER = BeanPropertyRowMapper.newInstance(Meal.class);
@Autowired
private final JdbcTemplate jdbcTemplate;
private final SimpleJdbcInsert insertMeals;
@Autowired
private final NamedParameterJdbcTemplate namedParameterJdbcTemplate;
@Autowired
protected JdbcMealRepository(JdbcTemplate jdbcTemplate, NamedParameterJdbcTemplate namedParameterJdbcTemplate) {
this.insertMeals = new SimpleJdbcInsert(jdbcTemplate)
.withTableName("meals")
.usingGeneratedKeyColumns("id");
this.jdbcTemplate = jdbcTemplate;
this.namedParameterJdbcTemplate = namedParameterJdbcTemplate;
}
@Override
public Meal save(Meal meal) {
MapSqlParameterSource map = new MapSqlParameterSource()
.addValue("id", meal.getId())
.addValue("date_time", meal.getDatetime())
.addValue("description", meal.getDatetime())
.addValue("calories", meal.getCalories());
namedParameterJdbcTemplate.update("INSERT INTO meals(id, date_time, description, calories) " +
"VALUES(id=:id, date_time=:date_time, description=:description, calories=:calories)", map);
return meal;
}
}
控制器:
@Controller
public class JspMealController {
@Autowired
JdbcMealServiceImpl mealService;
@GetMapping(value = "/list")
public String getAll(Model model) {
model.addAttribute("meals", mealService.getAll());
return "meals";
}
@GetMapping(value = "/createForm")
public String addForm(Model model) {
Meal meal = new Meal();
model.addAttribute("mealsCreate", meal);
return "createmealForm";
}
@PostMapping(value = "/create")
public String save(@ModelAttribute("mealsCreate") Meal meal) {
mealService.save(meal);
return "redirect:/list";
}
@GetMapping(value = "/delete")
public String deleteMeal(@RequestParam("mealId") int id) {
mealService.delete(id);
return "redirect:/list";
}
@GetMapping(value = "/updateForm")
public String updateForm(@RequestParam("mealId") int id, Model model) {
Meal meal = mealService.get(id);
model.addAttribute("mealsUpdate", meal);
return "updatemealForm";
}
@PostMapping(value = "/update")
public String update(@ModelAttribute("mealsUpdate") Meal meal) {
mealService.update(meal);
return "redirect:/list";
}
}
JdbcMealRepository不应是抽象类。我们必须提供一个具体的实现类。尝试从JdbcMealRepository类中删除abstract关键字。
我正在使用Spring Boot 2.2.4并尝试自定义执行器 以下是相关的课程
控制器: 型号: 存储库: web.xml
我尝试构建简单的Maven springMVC应用程序。当我试图将应用程序部署到我的服务器时,下面抛出了异常。 unsatisfiedDependencyException:创建com.phapp.comfiguration.webconfiguration中定义的名为“View Resolver”的bean时出错:通过方法“View Resolver”参数0表示未满足的依赖关系;嵌套异常是org
我试图遵循一个Spring Boot的例子,我在互联网上搜索了几个小时,但没有找到解决方案。大多数的解决方案我发现他们说把@componentscan扫描包,我是不是遗漏了什么,任何hep都很感激。 SpringBootApplication类: PersonRepository类: 按建议更新包结构:
当我尝试自动连接扩展CrudRepository的接口时,我遇到了这个错误。我有两个用于两个数据库的hibernate xml配置。整个堆栈是 unsatisfiedDependencyException:创建名为“Hello Controller”的bean时出错:通过字段“stock service”表示的不满足的依赖项;嵌套异常为org.springframework.beans.facto