spring boot——spring boot的基本配置——spring boot整合mybatis——本地实例运行——保存操作——int类型——获取返回自增id...

素颜马尾好姑娘i 2023-09-28 23:53 25阅读 0赞

![43acca3616e883bf0db044539b0af947.png][]

![5a7b554f4ddfb389aaf305863bdefc38.png][]

==================================================================================

pojo类：

package org.example.entity;
    
    public class MyUser
    {
        private int id;
        private String name;
        private int age;
    
    
        public int getId() {
            return id;
        }
    
        public void setId(int id) {
            this.id = id;
        }
        
        public String getName() {
            return name;
        }
    
        public void setName(String name) {
            this.name = name;
        }
    
        public int getAge() {
            return age;
        }
    
        public void setAge(int age) {
            this.age = age;
        }
    
        @Override
        public String toString() {
            return "MyUser{" +
                    "id=" + id +
                    ", name='" + name + '\'' +
                    ", age=" + age +
                    '}';
        }
    }

![31c083a5a48ab54aebdab1a77504313e.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>
    
        <insert id="saveUser2" parameterType="org.example.entity.MyUser">
            insert into users(id,name,age) values(#{id},#{name},#{age})
        </insert>
    
        <insert id="saveInsertUser" parameterType="org.example.entity.MyUser">
            <selectKey keyProperty="id" keyColumn="id" order="AFTER" resultType="int">
                SELECT LAST_INSERT_ID();
            </selectKey>
            insert into users(id,name,age) values(#{id},#{name},#{age})
        </insert>
    
    </mapper>

![73b099fc53d40a0246d88a3019f17825.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);
    
    
        int saveInsertUser(MyUser user);
    
    }

![412ff9af0c157e15fd28f8dfcc71f604.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);
    
        int saveInsertUser(MyUser user);
    
    }

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

![2271ab0b210ebdb97f330ec5ee7a7f60.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;
    
        }
    
        @GetMapping(value = "/4")
        public int home4()
        {
            MyUser user2 = new MyUser();
            user2.setName("ccc");
            user2.setAge(321123);
    
            userService.saveInsertUser(user2);
    
            int a = user2.getId();
    
            System.out.println(a);
    
            System.out.println(user2);
    
            return a;
    
        }
    
    }

![17a48f96257178bf84949d12034a0e3e.png][]

运行之前数据：

![ff3e4ed31a78b6388ce96966b14ce139.png][]

运行：

![4e5150de7bc068f38e18ee40be28a02a.png][]

![09bffacdd7beae3bfade62db51580db4.png][]

![513e1e51b78ab8ec1344e71ba7ae6a03.png][]

[43acca3616e883bf0db044539b0af947.png]: https://img-blog.csdnimg.cn/img_convert/43acca3616e883bf0db044539b0af947.png
[5a7b554f4ddfb389aaf305863bdefc38.png]: https://img-blog.csdnimg.cn/img_convert/5a7b554f4ddfb389aaf305863bdefc38.png
[31c083a5a48ab54aebdab1a77504313e.png]: https://img-blog.csdnimg.cn/img_convert/31c083a5a48ab54aebdab1a77504313e.png
[73b099fc53d40a0246d88a3019f17825.png]: https://img-blog.csdnimg.cn/img_convert/73b099fc53d40a0246d88a3019f17825.png
[412ff9af0c157e15fd28f8dfcc71f604.png]: https://img-blog.csdnimg.cn/img_convert/412ff9af0c157e15fd28f8dfcc71f604.png
[b54eaad8c49379bb1366598af28da029.png]: https://img-blog.csdnimg.cn/img_convert/b54eaad8c49379bb1366598af28da029.png
[2271ab0b210ebdb97f330ec5ee7a7f60.png]: https://img-blog.csdnimg.cn/img_convert/2271ab0b210ebdb97f330ec5ee7a7f60.png
[17a48f96257178bf84949d12034a0e3e.png]: https://img-blog.csdnimg.cn/img_convert/17a48f96257178bf84949d12034a0e3e.png
[ff3e4ed31a78b6388ce96966b14ce139.png]: https://img-blog.csdnimg.cn/img_convert/ff3e4ed31a78b6388ce96966b14ce139.png
[4e5150de7bc068f38e18ee40be28a02a.png]: https://img-blog.csdnimg.cn/img_convert/4e5150de7bc068f38e18ee40be28a02a.png
[09bffacdd7beae3bfade62db51580db4.png]: https://img-blog.csdnimg.cn/img_convert/09bffacdd7beae3bfade62db51580db4.png
[513e1e51b78ab8ec1344e71ba7ae6a03.png]: https://img-blog.csdnimg.cn/img_convert/513e1e51b78ab8ec1344e71ba7ae6a03.png

spring boot——spring boot的基本配置——spring boot整合mybatis——本地实例运行——保存操作——int类型——获取返回自增id...

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 spring boot——spring boot的基本配置——spring boot整合mybatis——本地实例运行——查询操作——返回int类型——查询总行数...

相关 spring boot——spring boot的基本配置——spring boot整合mybatis——本地实例运行——查询操作——返回list列表-pojo类型——根据name查询数据...

相关 spring boot——spring boot的基本配置——spring boot整合mybatis——本地实例运行——查询操作——返回pojo类型——根据id查询数据...

相关 spring boot——spring boot的基本配置——spring boot整合mybatis——本地实例运行——删除操作——int类型——根据name删除数据...

相关 spring boot——spring boot的基本配置——spring boot整合mybatis——本地实例运行——MyBatis动态SQL——MyBatis set标签...

相关 spring boot——spring boot的基本配置——spring boot整合mybatis——本地实例运行——删除操作——int类型——根据id删除数据...

相关 spring boot——spring boot的基本配置——spring boot整合mybatis——本地实例运行——更新操作——int类型——根据id修改数据&根据name修改数据...

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

相关 spring boot——spring boot的基本配置——spring boot整合mybatis——本地实例运行——保存操作——int类型——获取返回自增id...

相关 spring boot——spring boot的基本配置——spring boot整合mybatis——本地实例运行