依赖

  1.   <dependencies>
  2.         <dependency>
  3.             <groupId>org.springframework.boot</groupId>
  4.             <artifactId>spring-boot-starter-web</artifactId>
  5.         </dependency>
  7.         <dependency>
  8.             <groupId>org.springframework.boot</groupId>
  9.             <artifactId>spring-boot-devtools</artifactId>
  10.             <scope>runtime</scope>
  11.             <optional>true</optional>
  12.         </dependency>
  13.         <dependency>
  14.             <groupId>org.springframework.boot</groupId>
  15.             <artifactId>spring-boot-starter-tomcat</artifactId>
  16.             <scope>provided</scope>
  17.         </dependency>
  18.         <dependency>
  19.             <groupId>org.springframework.boot</groupId>
  20.             <artifactId>spring-boot-starter-test</artifactId>
  21.             <scope>test</scope>
  22.         </dependency> <dependency>
  23.         <groupId>mysql</groupId>
  24.         <artifactId>mysql-connector-java</artifactId>
  25.     </dependency>
  26.         <dependency>
  27.             <groupId>org.springframework</groupId>
  28.             <artifactId>spring-jdbc</artifactId>
  29.             <version>4.3.15.RELEASE</version>
  30.         </dependency>
  31.     </dependencies>

代码

  1.     @GetMapping("/hello")
  2.     public String c_()   {
  4.         DriverManagerDataSource dataSource = new DriverManagerDataSource();
  5.         dataSource.setDriverClassName("com.mysql.jdbc.Driver");
  6.         dataSource.setUrl("jdbc:mysql://url地址:3306/数据库名字?useSSL=false&characterEncoding=utf8&serverTimezone=Asia/Shanghai");
  7.         dataSource.setUsername("cz_item");
  8.         dataSource.setPassword("QAZwsx123");
  10.         JdbcTemplate template = new JdbcTemplate(dataSource);
  11.         List<Map<String, Object>> maps = template.queryForList("SELECT * FROM cz_item limit 10");
  12.         return "你好";
  13.     }

就是那么简单粗暴