Spring-Boot学习笔记（四）JDBC使用

JDBC使用

1.添加依赖
在spring的pom文件中，添加jdbc的依赖

<!-- MYSQL --><dependency>    <groupId>mysql</groupId>    <artifactId>mysql-connector-java</artifactId></dependency><!-- Spring Boot JDBC --><dependency>    <groupId>org.springframework.boot</groupId>    <artifactId>spring-boot-starter-jdbc</artifactId></dependency>

2.添加数据库信息
在application.properties中添加数据库配置信息

#jdbcspring.datasource.url=jdbc:mysql://localhost:3306/testspring.datasource.username=rootspring.datasource.password=123456spring.datasource.driver-class-name=com.mysql.jdbc.Driver

3.创建表、编写代码
建表

CREATE TABLE `java_class` (  `id` int(11) NOT NULL,  `class_name` varchar(255) DEFAULT NULL,  `package_name` varchar(255) DEFAULT NULL,  PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;

实体类

public class JavaClassBean {    private String id;    private String className;    private String packageName;    //省略 get 和 set}

service

@Servicepublic class ClassBeanService {    @Autowired    private JdbcTemplate jdbcTemplate;    public List<JavaClassBean> getList() {        String sql = "select id,class_name, package_name from java_class";        return (List<JavaClassBean>) jdbcTemplate.query(sql, new RowMapper<JavaClassBean>() {            @Override            public JavaClassBean mapRow(ResultSet rs, int rowNum) throws SQLException {                JavaClassBean javaClassBean = new JavaClassBean();                javaClassBean.setId(rs.getString("id"));                javaClassBean.setClassName(rs.getString("class_name"));                javaClassBean.setPackageName(rs.getString("package_name"));                return javaClassBean;            }        });    }}

controller

@RestController@RequestMapping("/nl")public class JavaClassController {    @Autowired    private ClassBeanService classBeanService;    @RequestMapping("/list")    public List<JavaClassBean> getList() {        return classBeanService.getList();    }}

连接池

配置文件添加

spring.datasource.max-idle=10spring.datasource.max-wait=10000spring.datasource.min-idle=5spring.datasource.initial-size=5spring.datasource.validation-query=SELECT 1spring.datasource.test-on-borrow=falsespring.datasource.test-while-idle=truespring.datasource.time-between-eviction-runs-millis=18800spring.datasource.jdbc-interceptors=ConnectionState;SlowQueryReport(threshold=0)