SpringBoot--03.SpringBoot2.0整合JdbcTemplate

淩亂°似流年 2022-04-13 03:50 274阅读 0赞

开发环境：jdk1.8  tomcat8.5 maven工程  SpringBoot2.0

项目结构：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Nzd3F6eA_size_16_color_FFFFFF_t_70][]

## 1、pom.xml文件引入 ##

<?xml version="1.0" encoding="UTF-8"?>
    <project xmlns="http://maven.apache.org/POM/4.0.0"
             xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
             xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 
         http://maven.apache.org/xsd/maven-4.0.0.xsd">
        <modelVersion>4.0.0</modelVersion>
    
        
        <parent>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-parent</artifactId>
            <version>2.0.2.RELEASE</version>
        </parent>
    
    
        <groupId>com.day01springBoot</groupId>
        <artifactId>SpringBoot01</artifactId>
        <version>1.0-SNAPSHOT</version>
        <packaging>war</packaging>
    
        
        <properties>
            <java.version>1.8</java.version>
        </properties>
    
        
        <dependencies>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-web</artifactId>
            </dependency>
    
            
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-freemarker</artifactId>
            </dependency>
    
            
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-tomcat</artifactId>
            </dependency>
            <dependency>
                <groupId>org.apache.tomcat.embed</groupId>
                <artifactId>tomcat-embed-jasper</artifactId>
            </dependency>
    
            
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-jdbc</artifactId>
            </dependency>
            
            <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>
    
        </dependencies>
    
    </project>

## 2、application.properties新增配置 ##

spring.datasource.url=jdbc:mysql://localhost:3306/test?useSSL=false
    spring.datasource.username=root
    spring.datasource.password=sswqzx
    spring.datasource.driver-class-name=com.mysql.jdbc.Driver

### 3、创建相关类 ###

**Application.java**

package com.springboot;
    
    import org.springframework.boot.SpringApplication;
    import org.springframework.boot.autoconfigure.SpringBootApplication;
    
    /**
     * @ Author     ：ShaoWei Sun.
     * @ Date       ：Created in 10:52 2018/11/27
     */
    
    @SpringBootApplication
    public class Application {
        public static void main(String[] args) {
            SpringApplication.run(Application.class,args);
        }
    }

**controller/AddUserContorller.java**

package com.springboot.controller;
    
    import com.springboot.service.UserService;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Controller;
    import org.springframework.web.bind.annotation.RequestMapping;
    
    /**
     * @ Author     ：ShaoWei Sun.
     * @ Date       ：Created in 17:51 2018/11/28
     */
    @Controller
    public class AddUserController {
    
        @Autowired
        private UserService userService;
    
        @RequestMapping("/adduser")
        public String createUser(){
            userService.createUser("ssw","pswd");
            return "addu";
        }
    }

**service/Impl/UserServiceImpl.java**

package com.springboot.service.Impl;
    
    import com.springboot.service.UserService;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.jdbc.core.JdbcTemplate;
    import org.springframework.stereotype.Service;
    
    /**
     * @ Author     ：ShaoWei Sun.
     * @ Date       ：Created in 17:19 2018/11/28
     */
    @Service
    public class UserServiceImpl implements UserService {
    
        @Autowired
        private JdbcTemplate jdbcTemplate;
    
        @Override
        public void createUser(String name, String password) {
            jdbcTemplate.update("insert into user values(null, ?,?);",name,password);
        }
    }

**resources/templates/addu.ftl**

<!DOCTYPE html>
    <html>
    <head lang="en">
        <meta charset="UTF-8" />
        <title>首页</title>
    </head>
    <body>
    <h1>添加成功</h1>
    </body>
    </html>

## 4、测试 ##

[http://localhost:8080/adduser][http_localhost_8080_adduser]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Nzd3F6eA_size_16_color_FFFFFF_t_70 1][]

数据库记录：

![20181128181902879.png][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Nzd3F6eA_size_16_color_FFFFFF_t_70]: /images/20220413/49430b351a214da2ae5cc092255e39a6.png
[http_localhost_8080_adduser]: http://localhost:8080/adduser
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Nzd3F6eA_size_16_color_FFFFFF_t_70 1]: /images/20220413/9866c5cda9eb43a68fd7b10c7408ced4.png
[20181128181902879.png]: /images/20220413/7c70190abdd4452d9e6eaf8d2c9659fb.png