java queryforobject,java – Spring JDBC给出错误：来自JdbcTemplate类型的“queryForObject(String,Object [],Class...

我在DAO中创建了一个方法：

public String getUserName(int userid){

String sql="SELECT userName from UserDetail where userid=?";

return jdbcTemplate.queryForObject(sql, new Object[]{userid}, String.class);

}

这一行：jdbcTemplate.queryForObject(sql,new Object [] {userid},String.class)给出以下错误：

The method queryForObject(String, Object[], Class) from the type JdbcTemplate refers to the missing type DataAccessException

Multiple markers at this line

- The type org.springframework.dao.DataAccessException cannot be resolved. It is indirectly referenced from required .class files

- The method queryForObject(String, Object[], Class) from the type JdbcTemplate refers to the missing type

DataAccessException

我使用spring-jdbc 4.0.0与mysql-connector 5.1.25,commons-dbcp-1.4和commons-pool-1.6.你能告诉我我在做什么吗？

解决方法:

将春季版本的spring-tx jar添加到类路径中.

标签：spring-jdbc,java,mysql,database

来源： https://codeday.me/bug/20190725/1534199.html