Spring Boot实战演练Demo

快来打我* 2024-04-07 13:21 82阅读 0赞

**需求**：使用SSM+SpringBoot 实现 账户 的CRUD功能

数据库准备：

CREATE TABLE `account` ( 
    	`id` int(11) NOT NULL AUTO_INCREMENT, 
    	`name` varchar(32) DEFAULT NULL, 
    	`money` double DEFAULT NULL, 
    	PRIMARY KEY (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
    
    insert into `account`(`id`,`name`,`money`) values (1,'tom',1000), (2,'jerry',1000);

### （1）创建springboot工程 ###

![在这里插入图片描述][da51a9eae9aa49feb0f699a4c00e0081.png]  
![在这里插入图片描述][3d5ab844a6104030a11c339a7d077d36.png]

![在这里插入图片描述][bc32efd3dd3944869a2ec972194edbcc.png]  
![在这里插入图片描述][1947f0d4ebb14f4bb434494798ea5e03.png]  
![在这里插入图片描述][36f7c0b495ab4c899c4646383cfa98af.png]

![在这里插入图片描述][6ff68b86155f4147b76ea51c3bceb260.png]  
next —> finish  
删除以下多余目录  
![在这里插入图片描述][9ebb85cc4585488bb7c01f8f8d12df46.png]  
删除后目录  
![在这里插入图片描述][12062d6ad4d94b8291abab19e63b3133.png]

### （2）导入pom.xml ###

<dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>druid</artifactId>
                <version>1.1.3</version>
            </dependency>

为了扫描mapper可做下面两个操作  
![在这里插入图片描述][6147c3375854434493f241cdc79aa74e.png]  
![在这里插入图片描述][1e69a08012de42c4b0cc2bf9cfe7cad9.png]  
SpringboottestApplication.java![在这里插入图片描述][3d3929272479441094009cb136689544.png]

### (3) 配置数据库信息 ###

![在这里插入图片描述][d2412ea4eb6f46d1a40aad3f081a3c4f.png]  
application.yml

## 数据库连接信息
    spring:
      datasource:
        name: druid
        type: com.alibaba.druid.pool.DruidDataSource
        url: jdbc:mysql://localhost:3306/test?characterEncoding=utf-8&serverTimezone=UTC
        username: root
        password: zhangwt

IDEA连接数据库  
![在这里插入图片描述][c58c009c9694414a8df8a563713a96d1.png]  
![在这里插入图片描述][b447e01fa5e245d191d5b32b3172d650.png]  
![在这里插入图片描述][88c62cd1d7704985a29302558e474652.png]  
![在这里插入图片描述][44f8a764a4584fb5a8a5ea0816935640.png]

### (4) Free Mybatis plugin插件安装(新MyBatisX) ###

安装目的：自动生成Mybatis相关代码  
[https://plugins.jetbrains.com/plugin/8321-free-mybatis-plugin/versions/stable/74577][https_plugins.jetbrains.com_plugin_8321-free-mybatis-plugin_versions_stable_74577]这个插件已经闭源了，版本更新截止到2019.12.18，可以用上面链接下载旧版本。

也可以使用插件MyBatisX代替，二者选其一

**MyBatisX插件在线安装**  
![在这里插入图片描述][3f74df0eb9af4d8ab9b8c7e24369ca36.png]  
![在这里插入图片描述][d2f6bcccb60b446b854db48b58491b09.png]  
![在这里插入图片描述][98a013bb96824dab8b42f0ecbf114586.png]

**Free Mybatis plugin插件本地安装**  
将 Free Mybatis plugin 下载在本地磁盘，然后导入安装  
![在这里插入图片描述][247b2cd3140e45efb6b2a809c2386f02.png]  
![在这里插入图片描述][129a9f9212674fcc8b5f49537fec93a2.png]  
![在这里插入图片描述][ab55aa4f9da442ffae7aa166548aa15d.png]  
**注：为节省时间，后面两个步骤代码可使用Mybatis-X 或 Free Mybatis plugin插件生成**  
**Mybatis-X生成步骤**  
![在这里插入图片描述][ad80c5504dc245a7864aa7eb1799bf13.png]  
![在这里插入图片描述][dbd7dc8e3d7848c7a04032d9667e7dad.png]  
next  
![在这里插入图片描述][5eae91ed84bb4cb4b0878f11124dd8ce.png]  
生成后结构如下  
![在这里插入图片描述][75dac9c130db40d0816aa1e545b50a5b.png]  
AccountMapper.java

/**
    * @Entity com.zwt.domain.Account
    */
    public interface AccountMapper extends BaseMapper<Account> {
        
    
    }

但是，Mapper文件中并没有自动生成单表操作的方法，为了方便，还是使用Free Mybatis plugin插件生成好一点

**Free Mybatis plugin生成步骤**  
![在这里插入图片描述][81a3d32231e5475a855fc2b4ca7179e9.png]  
![在这里插入图片描述][59992d5a16244c1e96acedbda23c9265.png]  
生成后结构如下：  
![在这里插入图片描述][3d89dcfe732647a1906de73ec8bfd349.png]

### （5）Account 实体类编写 ###

/**
     * account
     * @author 
     */
    @Data
    public class Account implements Serializable {
        
        private Integer id;
    
        private String name;
    
        private Double money;
    
        private static final long serialVersionUID = 1L;
    }

### （6）AccountMapper 编写及Mapper文件 ###

AccountMapper.java

public interface AccountMapper {
        
        int deleteByPrimaryKey(Integer id);
    
        int insert(Account record);
    
        int insertSelective(Account record);
    
        Account selectByPrimaryKey(Integer id);
    
        int updateByPrimaryKeySelective(Account record);
    
        int updateByPrimaryKey(Account record);
    
        List<Account> queryAll();
    }

AccountMapper.xml

<?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
    <mapper namespace="com.zwt.mapper.AccountMapper">
      <resultMap id="BaseResultMap" type="com.zwt.pojo.Account">
        <id column="id" jdbcType="INTEGER" property="id" />
        <result column="name" jdbcType="VARCHAR" property="name" />
        <result column="money" jdbcType="DOUBLE" property="money" />
      </resultMap>
      <sql id="Base_Column_List">
        id, `name`, money
      </sql>
      <select id="selectByPrimaryKey" parameterType="java.lang.Integer" resultMap="BaseResultMap">
        select 
        <include refid="Base_Column_List" />
        from account
        where id = #{id,jdbcType=INTEGER}
      </select>
      <select id="queryAll" resultMap="BaseResultMap">
        select
        <include refid="Base_Column_List" />
        from account
      </select>
      <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer">
        delete from account
        where id = #{id,jdbcType=INTEGER}
      </delete>
      <insert id="insert" keyColumn="id" keyProperty="id" parameterType="com.zwt.pojo.Account" useGeneratedKeys="true">
        insert into account (`name`, money)
        values (#{name,jdbcType=VARCHAR}, #{money,jdbcType=DOUBLE})
      </insert>
      <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.zwt.pojo.Account" useGeneratedKeys="true">
        insert into account
        <trim prefix="(" suffix=")" suffixOverrides=",">
          <if test="name != null">
            `name`,
          </if>
          <if test="money != null">
            money,
          </if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
          <if test="name != null">
            #{name,jdbcType=VARCHAR},
          </if>
          <if test="money != null">
            #{money,jdbcType=DOUBLE},
          </if>
        </trim>
      </insert>
      <update id="updateByPrimaryKeySelective" parameterType="com.zwt.pojo.Account">
        update account
        <set>
          <if test="name != null">
            `name` = #{name,jdbcType=VARCHAR},
          </if>
          <if test="money != null">
            money = #{money,jdbcType=DOUBLE},
          </if>
        </set>
        where id = #{id,jdbcType=INTEGER}
      </update>
      <update id="updateByPrimaryKey" parameterType="com.zwt.pojo.Account">
        update account
        set `name` = #{name,jdbcType=VARCHAR},
          money = #{money,jdbcType=DOUBLE}
        where id = #{id,jdbcType=INTEGER}
      </update>
    </mapper>

### （7）配置XML映射文件路径 ###

在项目中编写的XML映射文件，Spring Boot并无从知晓，所以无法扫描到该自定义编写的XML配置文件，还必须在全局配置文件application.properties中添加MyBatis映射文件路径的配置，同时需要添加实体类别名映射路径，示例代码如下

application.yml

mybatis: 
    	#配置MyBatis的xml配置文件路径 
    	mapper-locations: classpath:mapper/*.xml 
    	#配置XML映射文件中指定的实体类别名路径 
    	type-aliases-package: com.zwt.pojo

### （8）AccountService接口及实现类编写 ###

![在这里插入图片描述][31d906ecdabe4e20a053e33ac6c7cace.png]

AccountService.java

public interface AccountService {
        
        /**
         * 查询所有
         * @return
         */
        List<Account> queryAll();
    
        /**
         * 通过ID查询
         * @param id
         * @return
         */
        Account findById(Integer id);
    
        /**
         * 新增
         * @param Account
         */
        void insert(Account Account);
    
        /**
         * 通过ID删除
         * @param id
         */
        void deleteById(Integer id);
    
        /**
         * 修改
         * @param Account
         */
        void update(Account Account);
    }

AccountServiceImpl.java

@Service
    public class AccountServiceImpl implements AccountService {
        
    
        @Autowired
        private com.zwt.mapper.AccountMapper AccountMapper;
    
        @Override
        public List<Account> queryAll() {
        
            return AccountMapper.queryAll();
        }
    
        @Override
        public Account findById(Integer id) {
        
            return AccountMapper.selectByPrimaryKey(id);
        }
    
        @Override
        public void insert(Account Account) {
        
            //AccountMapper.insert(Account);        //将除id所有的列都拼SQL
            AccountMapper.insertSelective(Account); //只是将不为空的列才拼SQL
        }
    
        @Override
        public void deleteById(Integer id) {
        
            AccountMapper.deleteByPrimaryKey(id);
        }
    
        @Override
        public void update(Account Account) {
        
            AccountMapper.updateByPrimaryKeySelective(Account);
        }
    }

### （9）AccountController编写 ###

AccountController.java

@RestController
    @RequestMapping("/account")
    public class AccountController {
        
    
        @Autowired
        private AccountService accountService;
    
        /**
         * restful格式进行访问
         * 查询：GET
         * 新增: POST
         * 更新：PUT
         * 删除: DELETE
         */
        /**
         * 查询所有
         * @return
         */
        @GetMapping("/query")
        public List<Account> queryAll(){
        
            return accountService.queryAll();
        }
    
        /**
         * 通过ID查询
         */
        @GetMapping("/query/{id}")
        public Account queryById(@PathVariable Integer id){
        
            return accountService.findById(id);
        }
    
        /**
         * 删除
         * @param id
         * @return
         */
        @DeleteMapping("/delete/{id}")
        public String delete(@PathVariable Integer id){
        
            accountService.deleteById(id);
            return "删除成功";
        }
    
        /**
         * 新增
         * @param Account
         * @return
         */
        @PostMapping("/insert")
        public String insert(Account Account){
        
            accountService.insert(Account);
            return "新增成功";
        }
    
        /**
         * 修改
         * @param Account
         * @return
         */
        @PutMapping("/update")
        public String update(Account Account){
        
            accountService.update(Account);
            return "修改成功";
        }
    }

使用postman测试  
查询  
![在这里插入图片描述][9018a16ffae648278dc1551d3f67d61e.png]  
![在这里插入图片描述][567dae7e8f4f484ab49d7e2b27de6a75.png]  
删除  
![在这里插入图片描述][c918d10a06d14779a24eb4b4cb7acb22.png]  
新增![在这里插入图片描述][22a99e7595104763a2cae563b7396758.png]  
修改  
![在这里插入图片描述][28e91186bfd748988e5edcd0d4a9b851.png]

### （10）Spring Boot项目部署 ###

需求：将Spring Boot项目使用maven指令打成jar包并运行测试  
**1、修改端口号**  
端口号一般不使用默认的  
application.yml

##服务器配置
    server:
      port: 8090

**2、添加打包组件**

<build>
            <plugins>
                <plugin>
                    
                    <groupId>org.springframework.boot</groupId>
                    <artifactId>spring-boot-maven-plugin</artifactId>
                </plugin>
            </plugins>
    
        </build>

需要添加打包组件将项目中的资源、配置、依赖包打到一个jar包中；可以使用maven的 package ；  
![在这里插入图片描述][bf56e71ac9e545adaa0c435e2e8b0061.png]  
双击package![在这里插入图片描述][d1459519c13d4e6ea534c203a5f37dd0.png]  
![在这里插入图片描述][71b7af86ffd9497d837fbd0f243bbeed.png]  
jar包一般在项目根目录的 target文件下  
![在这里插入图片描述][f0b208a11f2b4712b270a19deea770dc.png]  
**3、部署运行**  
打开powershell 窗口（Windows10系统）

1、在当前文件夹，然后点击左上角的“文件”菜单。

![Win10的windows powershell在哪里][Win10_windows powershell]

2、接下来在打开的文件下拉菜单中找到“打开Windows Powershell”菜单项，点击“以管理员身份打开Windows Powershell”菜单项即可。

![在这里插入图片描述][b29e2ecfc59a450a8dec2e7ee622c694.png]  
在windows下模拟Linux运行以下命令

java -jar 包名

java -jar .\\springboottest-0.0.1-SNAPSHOT.jar  
![在这里插入图片描述][06ab403b13d949f3bc9f5975a1704e4b.png]  
这个和在IDEA中启动项目类似  
注意，此处有可能运行报错，原因为部署的环境和pom.xml中指定的JDK版本不一致  
![在这里插入图片描述][30892660e56448798acd33217d67bcc9.png]

pom.xml

解决办法：

*  方法1：将pom.xml中的版本号修改为Linux中对应的版本。Clean后重新Package打包。
 *  方法2：将Linux中的jdk卸载，然后重新安装pom.xml中定义对应的jdk版本即可。
 *

**4、验证**  
![在这里插入图片描述][ad6c9042ea5a468488d117d77b302a66.png]  
至此，整个SpringBoot Demo演练完毕，

我已将源码上传，可以在资源链接中下载  
[https://download.csdn.net/download/u012660464/86510033][https_download.csdn.net_download_u012660464_86510033]

[da51a9eae9aa49feb0f699a4c00e0081.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/07/30427e4522df4703bfd0418a14f41712.png
[3d5ab844a6104030a11c339a7d077d36.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/07/fbed1a3c9e5343418cde1f0646e54723.png
[bc32efd3dd3944869a2ec972194edbcc.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/07/031c714f541d4bd3a2ca88560475ff4d.png
[1947f0d4ebb14f4bb434494798ea5e03.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/07/8183743630074b8598f804bc0dcda6d8.png
[36f7c0b495ab4c899c4646383cfa98af.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/07/14813cec71cb4a928b9f62cdeb75f738.png
[6ff68b86155f4147b76ea51c3bceb260.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/07/a8bf82d5060f40bc94f009a2f653a05e.png
[9ebb85cc4585488bb7c01f8f8d12df46.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/07/e99645594afd4e1cb682a0eda0c1ef3b.png
[12062d6ad4d94b8291abab19e63b3133.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/07/2efd37674e5d4e42b342040906c04ba2.png
[6147c3375854434493f241cdc79aa74e.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/07/a17e4f49a58b41ffb99b44bfec25ed89.png
[1e69a08012de42c4b0cc2bf9cfe7cad9.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/07/a600920d84aa4678aa9d1ea7473f28d9.png
[3d3929272479441094009cb136689544.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/07/fd00d17373324d85a99c8f787732e3bf.png
[d2412ea4eb6f46d1a40aad3f081a3c4f.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/07/be20248cba5645e3b74c73bb90a7198f.png
[c58c009c9694414a8df8a563713a96d1.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/07/3011857f6a66438987535007a4f267ce.png
[b447e01fa5e245d191d5b32b3172d650.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/07/8787c243e3d349fc9f9f1fc7f859ece6.png
[88c62cd1d7704985a29302558e474652.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/07/9f7b889695e84abfb4303f3b0a78865b.png
[44f8a764a4584fb5a8a5ea0816935640.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/07/c5cfeaa8d4484b1989bcf9431a75f293.png
[https_plugins.jetbrains.com_plugin_8321-free-mybatis-plugin_versions_stable_74577]: https://plugins.jetbrains.com/plugin/8321-free-mybatis-plugin/versions/stable/74577
[3f74df0eb9af4d8ab9b8c7e24369ca36.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/07/57b505e9112440998de5037622bdb668.png
[d2f6bcccb60b446b854db48b58491b09.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/07/151b6621b2af48f5b63ba7b347ccf39a.png
[98a013bb96824dab8b42f0ecbf114586.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/07/8bd8209e40794f98b83c81ee49b80a88.png
[247b2cd3140e45efb6b2a809c2386f02.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/07/1b7531620ab74b5eb3dc3afcb74ead77.png
[129a9f9212674fcc8b5f49537fec93a2.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/07/3478f0a5be7f41fa8c23e33ad1baed54.png
[ab55aa4f9da442ffae7aa166548aa15d.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/07/650dd1db840e4d7db104b67e94026905.png
[ad80c5504dc245a7864aa7eb1799bf13.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/07/8a57a1af7a5d475e867aee7b5670ce49.png
[dbd7dc8e3d7848c7a04032d9667e7dad.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/07/abb56243b25d451aa1f3dc5b4f5b6da1.png
[5eae91ed84bb4cb4b0878f11124dd8ce.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/07/cfe202e6ac06443eb75fc2ff4641eafe.png
[75dac9c130db40d0816aa1e545b50a5b.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/07/1bdee94a6a08413eb7f737625134478c.png
[81a3d32231e5475a855fc2b4ca7179e9.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/07/0d4aedcbb38e4067afe48b1827f1bdce.png
[59992d5a16244c1e96acedbda23c9265.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/07/f84edf876afa42b3b7c8b9642b911ea6.png
[3d89dcfe732647a1906de73ec8bfd349.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/07/c1e06c122bf24ebca54d99abbf93032e.png
[31d906ecdabe4e20a053e33ac6c7cace.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/07/314bd44da3c8491e9be1243d42863d60.png
[9018a16ffae648278dc1551d3f67d61e.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/07/7bf683cb637048619c3236f0cb39f1b0.png
[567dae7e8f4f484ab49d7e2b27de6a75.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/07/211a28085fbf4f7a96cc84e6abfa9584.png
[c918d10a06d14779a24eb4b4cb7acb22.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/07/cb064b4ef0d2447eac4572a3bf949842.png
[22a99e7595104763a2cae563b7396758.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/07/9de6ddfbdcaa4b4db1dfb1a1e2dd6a02.png
[28e91186bfd748988e5edcd0d4a9b851.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/07/d43bb8d4ada44e81b418c66048e76ffa.png
[bf56e71ac9e545adaa0c435e2e8b0061.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/07/5873b8cf9825451cbd2a558ead434bcd.png
[d1459519c13d4e6ea534c203a5f37dd0.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/07/d5d8bdea2fad4c02b712f29e1c3a0bf8.png
[71b7af86ffd9497d837fbd0f243bbeed.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/07/e55dffb10b4646b7a4285d47fa353a8b.png
[f0b208a11f2b4712b270a19deea770dc.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/07/127e03dc802e4a818093f2c77f88395b.png
[Win10_windows powershell]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/07/ac3f7b43fa554145a0d30ab5c86ed648.png
[b29e2ecfc59a450a8dec2e7ee622c694.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/07/ca6f505dcc064f5da58c779d39cb3b51.png
[06ab403b13d949f3bc9f5975a1704e4b.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/07/710508516c7747e98125d2b85717b05c.png
[30892660e56448798acd33217d67bcc9.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/07/e05bd960771c4c9a9eb3d5a7403caa13.png
[ad6c9042ea5a468488d117d77b302a66.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/07/4a2d716ec4cb45cbad82fb8eca7a0aa4.png
[https_download.csdn.net_download_u012660464_86510033]: https://download.csdn.net/download/u012660464/86510033