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

太过爱你忘了你带给我的痛 2023-09-28 23:54 15阅读 0赞

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>
    
        <insert id="saveUser2" parameterType="org.example.entity.MyUser">
            insert into users(id,name,age) values(#{id},#{name},#{age})
        </insert>
    
    </mapper>

![c654b47f5e2c02d7d5693ce1e11a14e6.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);
    
        int saveUser2(MyUser user);
    
    }

![650712f7a359adc75dae55e060e9f5c4.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);
    
        int saveUser2(MyUser user);
    
    }

![9eb5a3024c9f00e358dec1d556e3a092.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);
        }
    
        public int saveUser2(MyUser user)
        {
            return userMapper.saveUser2(user);
        }
    }

![8335c6aa3203a2694ea1cb39b39f481a.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(7878);
    
            userService.saveUser(user2);
    
        }
    
        @GetMapping(value = "/3")
        public int home3()
        {
            MyUser user2 = new MyUser();
            user2.setName("RRR");
            user2.setAge(6666);
    
            int a = userService.saveUser2(user2);
    
            System.out.println(a);
    
            return a;
    
        }
    
    }

![ff7d29b48d2c158e683f72e48f40bd0d.png][]

之前数据如下：

![3994183a21779449f88ac388ce2392fa.png][]

运行后如下：

![d22175a3968f7d18412e1a8451e80c7c.png][]

![0b066e76cd5a331fd2adb857979b95c5.png][]

![a25eee06af0eb535269253c07dda1ce9.png][]

[c654b47f5e2c02d7d5693ce1e11a14e6.png]: https://img-blog.csdnimg.cn/img_convert/c654b47f5e2c02d7d5693ce1e11a14e6.png
[650712f7a359adc75dae55e060e9f5c4.png]: https://img-blog.csdnimg.cn/img_convert/650712f7a359adc75dae55e060e9f5c4.png
[9eb5a3024c9f00e358dec1d556e3a092.png]: https://img-blog.csdnimg.cn/img_convert/9eb5a3024c9f00e358dec1d556e3a092.png
[8335c6aa3203a2694ea1cb39b39f481a.png]: https://img-blog.csdnimg.cn/img_convert/8335c6aa3203a2694ea1cb39b39f481a.png
[ff7d29b48d2c158e683f72e48f40bd0d.png]: https://img-blog.csdnimg.cn/img_convert/ff7d29b48d2c158e683f72e48f40bd0d.png
[3994183a21779449f88ac388ce2392fa.png]: https://img-blog.csdnimg.cn/img_convert/3994183a21779449f88ac388ce2392fa.png
[d22175a3968f7d18412e1a8451e80c7c.png]: https://img-blog.csdnimg.cn/img_convert/d22175a3968f7d18412e1a8451e80c7c.png
[0b066e76cd5a331fd2adb857979b95c5.png]: https://img-blog.csdnimg.cn/img_convert/0b066e76cd5a331fd2adb857979b95c5.png
[a25eee06af0eb535269253c07dda1ce9.png]: https://img-blog.csdnimg.cn/img_convert/a25eee06af0eb535269253c07dda1ce9.png