Spring框架详解 - 03

缺乏、安全感 2022-03-07 10:06 219阅读 0赞

原

# Spring框架详解 - 03 #

置顶 2019年01月07日 00:17:07 [沐荔][Link 1] 阅读数：18721

## **前言** ##

Spring boot + Mybatis + Thymeleaf + Druid +mySql

## 开发环境（小编使用的版本） ##

*  JDK版本 ：1.8及以上 （JDK１.８）；
 *  开发工具 ：Intellij IDEA （IDEA２０１８.２）；
 *  服务器 ：Tomcat(务必比JDK版本高，小编不在解释（Jar包不用配置、War需要配置）)　（Tomcat９） ；
 *  JRE包 ：Maven仓库 （Maven３.６）；
 *  数据库 ：MySql（MySql５.５） ；

## 正题 ##

Spring boot ：2.１.１RELEASE ；

Thymeleaf

Mybatis

[阿里云][Link 2]的连接池 : Druid ；

## 步骤 ##

１．创建Springboot：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxOTIwNzMy_size_16_color_FFFFFF_t_70][]

２．创建项目文件结构

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxOTIwNzMy_size_16_color_FFFFFF_t_70 1][]

３.POM依赖

如果使用阿里云的连接池不选择JDBC，小编用的阿里云这里不选择  
![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxOTIwNzMy_size_16_color_FFFFFF_t_70 2][]

点击Finish；  
注：可能Maven中无Jar包需要从仓库下载，需要耐心等待（可以去听首歌）

４.项目结构  
![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxOTIwNzMy_size_16_color_FFFFFF_t_70 3][]

５.POM

<?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.1.1.RELEASE</version>
            <relativePath/> 
        </parent>
        <groupId>com.spring</groupId>
        <artifactId>boot</artifactId>
        <version>0.0.1-SNAPSHOT</version>
        <name>boot</name>
        <description>Demo project for Spring Boot</description>
    
        <properties>
            <java.version>1.8</java.version>
        </properties>
    
        <dependencies>
            
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-devtools</artifactId>
                <optional>true</optional>
            </dependency>
            
            <dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>druid-spring-boot-starter</artifactId>
                <version>1.1.10</version>
            </dependency>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-thymeleaf</artifactId>
            </dependency>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-web</artifactId>
            </dependency>
            <dependency>
                <groupId>org.mybatis.spring.boot</groupId>
                <artifactId>mybatis-spring-boot-starter</artifactId>
                <version>1.3.2</version>
            </dependency>
    
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <scope>runtime</scope>
            </dependency>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-test</artifactId>
                <scope>test</scope>
            </dependency>
        </dependencies>
    
        <build>
            <plugins>
                <plugin>
                    <groupId>org.springframework.boot</groupId>
                    <artifactId>spring-boot-maven-plugin</artifactId>
                </plugin>
            </plugins>
        </build>
    
    </project>

注：IDEA失效解决方法

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxOTIwNzMy_size_16_color_FFFFFF_t_70 4][]

６.小编使用的**application.properties文件，项目启动识别两种格式的文件properties和yml文件：**

#缓存设置为false, 修改之后马上生效
    spring.thymeleaf.cache=false
    spring.thymeleaf.encoding=UTF-8
    #spring.thymeleaf.prefix=classpath:/templates/
    #spring.thymeleaf.suffix=.html
    
    server.port=8080
    server.tomcat.uriEncoding=utf-8
    
    spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
    spring.datasource.url=jdbc:mysql://localhost:3306/web?useUnicode=true&serverTimezone=GMT%2B8&characterEncoding=utf-8&allowMultiQueries=true&useSSL=false
    spring.datasource.username=root
    spring.datasource.password=root
    spring.datasource.druid.driverClassName=com.mysql.cj.jdbc.Driver
    #初始化连接
    spring.datasource.initialSize=20
    #最大空闲数
    spring.datasource.maxActive=50
    #最小空闲数
    spring.datasource.minIdle=10
    #获取连接等待时间
    #spring.datasource.druid.max-wait=60000
    #最小等待时间
    #spring.datasource.minEvictableIdleTimeMillis=3600000

7.其他文件生成

User.java

package com.spring.boot.bean;
    
    public class User {
    
        public Integer uid;
        public String uname;
        public String upassword;
    
        public Integer getUid() {
            return uid;
        }
    
        public void setUid(Integer uid) {
            this.uid = uid;
        }
    
        public String getUanme() {
            return uname;
        }
    
        public void setUanme(String uanme) {
            this.uname = uanme;
        }
    
        public String getUpassword() {
            return upassword;
        }
    
        public void setUpassword(String upassword) {
            this.upassword = upassword;
        }
    
        @Override
        public String toString() {
            return "User{" +
                    "uid=" + uid +
                    ", uname='" + uname + '\'' +
                    ", upassword='" + upassword + '\'' +
                    '}';
        }
    }

UserDao.java

注解的形式，小编感觉比XML好用

package com.spring.boot.dao;
    
    import com.spring.boot.bean.User;
    import org.apache.ibatis.annotations.Select;
    import org.apache.ibatis.annotations.Update;
    
    import java.util.List;
    
    public interface UserDao {
    
        @Select("select * from user")
        public List<User> AllUser();
    
        @Update("<script> " + "update user" +
                "<set>"+  "<if test='uname!=null'>uname=#{uname},</if>"+
                "<if test='upassword!=null'>upassword=#{upassword},</if>"+
                "</set>"+ "where uid=#{uid}"+
                " </script> ")
        public int Update(User user);
    
    }

UserService.java

package com.spring.boot.service;
    
    import com.spring.boot.bean.User;
    
    import java.util.List;
    
    public interface UserService {
    
        public List<User> AllUser();
    
        public int Update(User user);
    
    }

UserImpl.java  
主要是注解问题Service可以命名，主要还是看自己的日常使用

package com.spring.boot.service.impl;
    
    import com.spring.boot.bean.User;
    import com.spring.boot.dao.UserDao;
    import com.spring.boot.service.UserService;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
    
    import java.util.List;
    
    @Service
    public class UserImpl implements UserService {
    
        @Autowired
        private UserDao userDao;
    
        @Override
        public List<User> AllUser() {
    
            return userDao.AllUser();
        }
    
        @Override
        public int Update(User user) {
            return userDao.Update(user);
        }
    }

注：userDao报红解决方法

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxOTIwNzMy_size_16_color_FFFFFF_t_70 5][]

UserController.java

package com.spring.boot.controller;
    
    import com.spring.boot.bean.User;
    import com.spring.boot.service.impl.UserImpl;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Controller;
    import org.springframework.ui.Model;
    import org.springframework.web.bind.annotation.RequestMapping;
    
    @Controller
    public class UserController {
    
        @Autowired
        private UserImpl userimpl;
    
        @RequestMapping("/index")
        public String index(Model model, User user){
            model.addAttribute("user",userimpl.AllUser());
            user.uid = 2;
            user.uname = "nan";
            user.upassword = "lou";
            userimpl.Update(user);
            System.out.println("******************"+userimpl.AllUser());
            System.out.println("******************"+userimpl.Update(user));
            return "index";
        }
    
    }

index.html

<!DOCTYPE html>
    <html xmlns:th="http://www.thymeleaf.org">
    <head>
        <meta charset="UTF-8">
        <title>Title</title>
    </head>
    <body>
    Spring boot+Thymeleaf!<br>
    <span th:text="${user}"></span>
    </body>
    </html>

8.[界面][Link 3]显示

注：后续功能再写！  
小编这是Java web项目，@Controller注解是界面、@RestController是写接口  
哪里又不对的给提醒

[Link 1]: https://me.csdn.net/qq_41920732
[Link 2]: https://www.baidu.com/s?wd=%E9%98%BF%E9%87%8C%E4%BA%91&tn=24004469_oem_dg&rsv_dl=gh_pl_sl_csd
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxOTIwNzMy_size_16_color_FFFFFF_t_70]: /images/20220307/b1baafef65c646e5b5c8e0fd18fef031.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxOTIwNzMy_size_16_color_FFFFFF_t_70 1]: /images/20220307/4a5f10b37e0a4a938ce69116214b0ffc.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxOTIwNzMy_size_16_color_FFFFFF_t_70 2]: /images/20220307/10cbb6d7426448ff8ee9e480bf60b962.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxOTIwNzMy_size_16_color_FFFFFF_t_70 3]: /images/20220307/c557351f09c14ba2a7b1276993d3bf91.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxOTIwNzMy_size_16_color_FFFFFF_t_70 4]: /images/20220307/b9ba6d77f7c74f9d9d7c7aa01ed66588.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxOTIwNzMy_size_16_color_FFFFFF_t_70 5]: /images/20220307/0067c03bf3e048768e396f3b7e2df1fc.png
[Link 3]: https://www.baidu.com/s?wd=%E7%95%8C%E9%9D%A2&tn=24004469_oem_dg&rsv_dl=gh_pl_sl_csd