spring boot——spring boot的基本配置——spring boot整合mybatis——本地实例运行——保存操作——void类型...

骑猪看日落 2023-09-28 23:53 5阅读 0赞

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>
    
        <groupId>org.example</groupId>
        <artifactId>spring_boot</artifactId>
        <version>1.0-SNAPSHOT</version>
    
        <properties>
            <maven.compiler.source>8</maven.compiler.source>
            <maven.compiler.target>8</maven.compiler.target>
        </properties>
        
        <parent>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-parent</artifactId>
            <version>2.4.5</version>
            <relativePath/> 
        </parent>
    
        <dependencies>
            <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>2.1.1</version>
            </dependency>
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <scope>runtime</scope>
            </dependency>
        </dependencies>
    </project>

![cd3965f8c2a0d8b5ad1d82d39a1e767f.png][]

mapper文件：

<?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="org.example.mapper.UserMapper">
        <select id="findAll" resultType="org.example.entity.MyUser">
            select * from users
        </select>
    
        <insert id="saveUser" parameterType="org.example.entity.MyUser">
            insert into users(id,name,age) values(#{id},#{name},#{age})
        </insert>
    
    </mapper>

![7a97046ba0f1681992b87d32096bce7e.png][]

mapper接口：

package org.example.mapper;
    
    import org.example.entity.MyUser;
    import org.apache.ibatis.annotations.Mapper;
    
    import java.util.List;
    
    @Mapper
    public interface UserMapper
    {
    
        public List<MyUser> findAll();
    
        void saveUser(MyUser user);
    
    }

![7775421ba4a845d6a81e43d23b5e17a3.png][]

dao接口：

package org.example.service;
    
    
    import org.example.entity.MyUser;
    
    import java.util.List;
    
    public interface UserService
    {
        List<MyUser> findAll();
    
        void saveUser(MyUser user);
    
    
    }

![a36ff482e8af2cf0b911b80d25922d9e.png][]

实现dao接口：

package org.example.service.Impl;
    
    
    import org.example.entity.MyUser;
    import org.example.mapper.UserMapper;
    import org.example.service.UserService;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
    
    import java.util.List;
    
    @Service
    public class UserServiceImpl implements UserService
    {
        @Autowired
        UserMapper userMapper;
    
        @Override
        public List<MyUser> findAll()
        {
    
            return userMapper.findAll();
        }
    
        @Override
        public void saveUser(MyUser user)
        {
    
            userMapper.saveUser(user);
    
    
        }
    }

![a831091047e7e31e5c2a2d18df478963.png][]

控制器：

package org.example.controller;
    
    import java.util.List;
    import org.example.entity.MyUser;
    import org.example.service.UserService;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.web.bind.annotation.GetMapping;
    import org.springframework.web.bind.annotation.RestController;
    
    @RestController
    public class MyUserController
    {
        @Autowired
        private UserService userService;
    
        @GetMapping(value = "/1")
        public List<MyUser> home1()
        {
            // 查询所有网站
            List<MyUser> users = userService.findAll();
    
            for (MyUser user : users)
            {
                System.out.println(user.getId()+"  "+user.getName()+"  "+user.getAge());
            }
    
            return users;
        }
    
        @GetMapping(value = "/2")
        public void home2()
        {
            MyUser user2 = new MyUser();
            user2.setName("ttt");
            user2.setAge(25198);
    
            userService.saveUser(user2);
    
        }
    
    
    }

![8309cce1d1fe8d4391843b7b7319bc59.png][]

启动运行：

![b740a505a0e1497e5cf7ab9afa1065c5.png][]

![4e6d98727db0c7a928127e589983b0b9.png][]

再次运行，换个数据：

![e60489293e9d0084c326bfa2f67afa2f.png][]

![464c548abc3796277e1709a11b5cddd5.png][]

![5c7266f30d47af08cb8f21db16d256ef.png][]

![79a45f5e1ad1befd8fe1975abd7844e6.png][]

[cd3965f8c2a0d8b5ad1d82d39a1e767f.png]: https://img-blog.csdnimg.cn/img_convert/cd3965f8c2a0d8b5ad1d82d39a1e767f.png
[7a97046ba0f1681992b87d32096bce7e.png]: https://img-blog.csdnimg.cn/img_convert/7a97046ba0f1681992b87d32096bce7e.png
[7775421ba4a845d6a81e43d23b5e17a3.png]: https://img-blog.csdnimg.cn/img_convert/7775421ba4a845d6a81e43d23b5e17a3.png
[a36ff482e8af2cf0b911b80d25922d9e.png]: https://img-blog.csdnimg.cn/img_convert/a36ff482e8af2cf0b911b80d25922d9e.png
[a831091047e7e31e5c2a2d18df478963.png]: https://img-blog.csdnimg.cn/img_convert/a831091047e7e31e5c2a2d18df478963.png
[8309cce1d1fe8d4391843b7b7319bc59.png]: https://img-blog.csdnimg.cn/img_convert/8309cce1d1fe8d4391843b7b7319bc59.png
[b740a505a0e1497e5cf7ab9afa1065c5.png]: https://img-blog.csdnimg.cn/img_convert/b740a505a0e1497e5cf7ab9afa1065c5.png
[4e6d98727db0c7a928127e589983b0b9.png]: https://img-blog.csdnimg.cn/img_convert/4e6d98727db0c7a928127e589983b0b9.png
[e60489293e9d0084c326bfa2f67afa2f.png]: https://img-blog.csdnimg.cn/img_convert/e60489293e9d0084c326bfa2f67afa2f.png
[464c548abc3796277e1709a11b5cddd5.png]: https://img-blog.csdnimg.cn/img_convert/464c548abc3796277e1709a11b5cddd5.png
[5c7266f30d47af08cb8f21db16d256ef.png]: https://img-blog.csdnimg.cn/img_convert/5c7266f30d47af08cb8f21db16d256ef.png
[79a45f5e1ad1befd8fe1975abd7844e6.png]: https://img-blog.csdnimg.cn/img_convert/79a45f5e1ad1befd8fe1975abd7844e6.png