springboot整合使用JdbcTemplate
1.1 pom文件引入
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.0.5.RELEASE</version>
</parent>
<dependencies>
<!-- jdbcTemplate 依赖 -->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
<!-- mysql 依赖 -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
<!-- 测试 -->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
<!-- springboot-web组件 -->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
</dependencies>
1.2 application.properties新增配置
spring.datasource.url=jdbc:mysql://localhost:3306/jdbc
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
1.3 DeptServiceImpl类
@Service
public class DeptServiceImpl implements DeptService {
@Autowired
public JdbcTemplate jdbcTemplate;
@Override
public int createDept(int id, String name) {
int update = jdbcTemplate.update("insert into department values(?,?);", id, name);
return update;
}
}
1.4 SpringbootJdbcApplication启动类
@SpringBootApplication
public class SpringbootJdbcApplication {
public static void main(String[] args) {
SpringApplication.run(SpringbootJdbcApplication.class, args);
}
}
1.5 DeptController
@RestController
public class DeptController {
@Autowired
public DeptService deptService;
@GetMapping("/insert/{id}/{name}")
public boolean insertDept(@PathVariable("id") int id,@PathVariable("name") String name){
int result = deptService.createDept(id, name);
return 1>= result;
}
}
注意: spring-boot-starter-parent要在1.5以上