SpringBoot 整合使用JdbcTemplate (四)

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以上

源码下载：https://github.com/ruiace/springboot-jdbc.git