使用idea和maven写spring mvc的时候,配置jdbc以后运行,提示找不到jdbcTemplate。
错误提示:
2018-04-11 22:37:07.936 WARN 10096 --- [ main] ConfigServletWebServerApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'helloController': Unsatisfied dependency expressed through field 't'; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'test': Unsatisfied dependency expressed through field 'jdbcTemplate'; nested exception is org.springframework.beans.factory.NoSuchBeanDefinitionException: No qualifying bean of type 'org.springframework.jdbc.core.JdbcTemplate' available: expected at least 1 bean which qualifies as autowire candidate. Dependency annotations: {@org.springframework.beans.factory.annotation.Autowired(required=true)}
2018-04-11 22:37:07.938 INFO 10096 --- [ main] o.apache.catalina.core.StandardService : Stopping service [Tomcat]
2018-04-11 22:37:07.953 INFO 10096 --- [ main] ConditionEvaluationReportLoggingListener :
Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled.
2018-04-11 22:37:08.024 ERROR 10096 --- [ main] o.s.b.d.LoggingFailureAnalysisReporter :
***************************
APPLICATION FAILED TO START
***************************
Description:
Field jdbcTemplate in cqupt.stu.automaker.dao.test required a bean of type 'org.springframework.jdbc.core.JdbcTemplate' that could not be found.
Action:
Consider defining a bean of type 'org.springframework.jdbc.core.JdbcTemplate' in your configuration.
Process finished with exit code 1
依赖已经注入了
部分代码
import cqupt.stu.automaker.model.User;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.stereotype.Service;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;
@Service
public class test {
@Autowired
private JdbcTemplate jdbcTemplate;
public List<User> getList(){
String sql = "SELECT * FORM USER WHERE USERID = 1";
return (List<User>)jdbcTemplate.query(sql, new RowMapper<User>() {
@Override
public User mapRow(ResultSet rs, int rowNum) throws SQLException {
User user = new User();
user.setUserid(rs.getInt("userid"));
user.setPassword(rs.getString("password"));
user.setUsername(rs.getString("username"));
return user;
}
});
}
}