Spring Boot 整合jdbc其实非常简单,只需要加入依赖的pom、加入配置文件即可,下面我们来搭建一下吧。
下面是我的目录结构:
一.引入jdbc的依赖
<!-- 引入spring boot的依赖 -->
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>1.4.3.RELEASE</version>
</parent>
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
</dependencies>
二.编写application.properties配置文件
Spring Boot中的配置都放在application.properties配置文件中统一管理,在其中加入数据源的配置,如下:
spring.datasource.url=jdbc:mysql://localhost/springboot
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
三.使用jdbcTemplate编写Service
首先在数据库中创建表:
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`age` int(11) DEFAULT NULL,
`birth` date DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
编写UserService:
@Service
public class UserService {
@Autowired
private JdbcTemplate jdbcTemplate;
public void addUser(User user) {
jdbcTemplate.update("insert into User values (null,?,?,?);", user.getName(), user.getAge(), user.getBirth());
System.out.println("addUser success!");
}
}
四.编写Controller
@RestController
public class UserController {
@Autowired
private UserService userService;
@RequestMapping("/createUser")
public String cresteUser(String name, int age) {
User user = new User(name, age, new Date());
userService.addUser(user);
return "create user success!! \n" + user;
}
}
五.启动SpringBoot
@ComponentScan("com.sheliming.springboot.jdbc")
@EnableAutoConfiguration
public class App {
public static void main(String[] args) {
SpringApplication.run(App.class,args);
}
}
六.使用浏览器访问
检查下数据库:
至此SpringBoot整合jdbc就完成了,是不是非常的方便!!!