SpringBoot用jdbcTemplate访问数据库

pom.xml

 <!--用于编译jsp-->

        <dependency>
            <groupId>org.apache.tomcat.embed</groupId>
            <artifactId>tomcat-embed-jasper</artifactId>
            <scope>provided</scope>
        </dependency>
        
        <!--jsp页面使用jstl标签-->
        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>jstl</artifactId>
        </dependency>

<!--jdbcTemplate -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
</dependency>


<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>


<!-- 添加druid数据源依赖 -->
<dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.0.29</version>

</dependency>

这里是yml文件

spring:
  datasource:
    type: com.alibaba.druid.pool.DruidDataSource
    url:jdbc:mysql://localhost:3306/xx
    username: root
    password: 123456
    driver-class-name: com.mysql.jdbc.Driver
   
  mvc:
    view:
      prefix: /WEB-INF/views/

      suffix: .jsp

entity,dao,service,controller和以前的一样

jsp页面新增在src--main--新建webapp下面