依赖
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
配置application
spring:
datasource:
username: root
password: 123456
url: jdbc:mysql://localhost:3306/mybatis?useUnicdoe=true&characterEncoding=utf-8&serverTimezone=UTC
driver-class-name: com.mysql.jdbc.Driver
使用
@Controller
public class JDBCController {
@Autowired
JdbcTemplate jdbcTemplate;
@RequestMapping("/userList")
@ResponseBody
public List<Map<String,Object>> userList(){
String sql="select * from mybatis.user";
List<Map<String, Object>> maps = jdbcTemplate.queryForList(sql);
System.out.println(maps);
return maps;
}
}