1.添加依赖
<dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-jdbc</artifactId> </dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>6.0.5</version> </dependency>
spring-boot-starter-jdbc带来两个jar包:
<dependency> <groupId>com.zaxxer</groupId> <artifactId>HikariCP</artifactId> <version>2.7.9</version> <scope>compile</scope> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-jdbc</artifactId> <version>5.0.7.RELEASE</version> <scope>compile</scope> </dependency>
mysql-connector-java 数据库驱动
2.增加MySQL配置信息
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC&useSSL=false spring.datasource.username=root spring.datasource.password=123456 spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver spring.datasource.max-idle=10 spring.datasource.min-idle=5
3.增加数据源配置类DataSourceConfig:
common\config\DataSourceConfig.java
@Configuration public class DataSourceConfig { @Bean(name="dataSource") public DataSource datasource(Environment env) { HikariDataSource ds = new HikariDataSource(); ds.setJdbcUrl(env.getProperty("spring.datasource.url")); ds.setUsername(env.getProperty("spring.datasource.username")); ds.setPassword(env.getProperty("spring.datasource.password")); ds.setDriverClassName(env.getProperty("spring.datasource.driver-class-name")); ds.setMaximumPoolSize(Integer.parseInt(env.getProperty("spring.datasource.max-idle"))); ds.setMinimumIdle(Integer.parseInt(env.getProperty("spring.datasource.min-idle"))); return ds; } }
3.测试JdbcTemplate
@Controller public class LoginController { @Autowired private JdbcTemplate jdbcTemplate; @RequestMapping("toLogin") public String loginIndex(){ int count = jdbcTemplate.queryForObject("select count(1) from user",Integer.class); System.out.println(count); return "admin/login"; } }