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

绝地灬酷狼 2024-03-30 14:42 21阅读 0赞

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 +
                    '}';
        }
    }

![26530e4e12663a4d4366198c4a0e6552.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>
    
        <update id="updateUser" parameterType="org.example.entity.MyUser">
            update users set name = #{name},age = #{age} where id = #{id}
        </update>
    
        <delete id="deleteUser" parameterType="java.lang.Integer">
            delete from users where id = #{id}
        </delete>
    
        <delete id="deleteUserByName" parameterType="java.lang.String">
            delete from users where name = #{name}
        </delete>
    
        <select id="findById" parameterType="java.lang.Integer" resultType="org.example.entity.MyUser">
            select * from USERs where id = #{id}
        </select>
    
        <select id="findByName" parameterType="java.lang.String" resultType="org.example.entity.MyUser">
            select * from USERs where name = #{name}
        </select>
    
    </mapper>

![38c6918af7eb92916579bb32b9403903.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);
    
        int updateUser(MyUser user);
    
        int deleteUser(Integer id);
    
        int deleteUserByName(String name);
    
        MyUser findById(Integer id);
    
        List<MyUser> findByName(String name);
    
    }

![7771946470b89bad8c619a68fae1b7bc.png][]

service接口：

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);
    
        int updateUser(MyUser user);
    
        int deleteUser(Integer id);
    
        int deleteUserByName(String name);
    
        MyUser findById(Integer id);
    
        List<MyUser> findByName(String name);
    
    }

![ca51be76a2bdc22ac00f1bf49fa50cb0.png][]

实现service接口：

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);
        }
    
        public int updateUser(MyUser user)
        {
            return userMapper.updateUser(user);
        }
    
    
        public int deleteUser(Integer id)
        {
            return userMapper.deleteUser(id);
        }
    
        public int deleteUserByName(String name)
        {
            return userMapper.deleteUserByName(name);
        }
    
        public MyUser findById(Integer id)
        {
            return userMapper.findById(id);
        }
    
        public List<MyUser> findByName(String name)
        {
            return userMapper.findByName(name);
        }
    
    }

![1e4bde5c7e9c907e8e386ead3570ff75.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;
    
        }
    
        @GetMapping(value = "/5")
        public int updateUser()
        {
            MyUser user2 = new MyUser();
            user2.setId(1013);
            user2.setName("sprint-boot-1013");
            user2.setAge(199999);
    
            int a = userService.updateUser(user2);
    
            System.out.println(a);
    
            return a;
    
        }
    
    
        @GetMapping(value = "/6")
        public int deleteUser()
        {
            int a = userService.deleteUser(1012);
    
            System.out.println(a);
    
            return a;
    
        }
    
        @GetMapping(value = "/7")
        public int deleteUserByName()
        {
            int a = userService.deleteUserByName("sprint-boot-1013");
    
            System.out.println(a);
    
            return a;
    
        }
    
        @GetMapping(value = "/8")
        public void findById()
        {
            MyUser user001 = userService.findById(1011);
    
            System.out.println(user001);
    
        }
    
        @GetMapping(value = "/9")
        public List<MyUser> findByName()
        {
            List<MyUser> users= userService.findByName("aaa");
    
            for (MyUser user : users)
            {
                System.out.println(user.getId()+"  "+user.getName()+"  "+user.getAge());
            }
    
            return users;
    
        }
    
    }

![f3ff503cbc575e0e02d65c8503664537.png][]

执行：

![acd9fda1c580f50c185cca1ca94edf65.png][]

![ad6e452fc93276c3b8da58399158b55b.png][]

![52b7f67a527b08321b1cc8ad2d5944f9.png][]

[26530e4e12663a4d4366198c4a0e6552.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/30/e40e156ca8f84ab988703e3e67584a4f.png
[38c6918af7eb92916579bb32b9403903.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/30/d3f937d9cfd0414d8f5b2e7eeee4000e.png
[7771946470b89bad8c619a68fae1b7bc.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/30/0ab17c7e16484cc8a565f3de1a97f3e6.png
[ca51be76a2bdc22ac00f1bf49fa50cb0.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/30/bf12f40880c94d6fa5ff3b7ae42fccb4.png
[1e4bde5c7e9c907e8e386ead3570ff75.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/30/c8ddac4732c94710ab7b5d410e78a375.png
[f3ff503cbc575e0e02d65c8503664537.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/30/c70c65fd53bb4cbca7fb27f69bd8b94f.png
[acd9fda1c580f50c185cca1ca94edf65.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/30/fc32e56b65794d59bad9fd511207754d.png
[ad6e452fc93276c3b8da58399158b55b.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/30/5c8ba07ab66d4eaea43351d63b1dfe15.png
[52b7f67a527b08321b1cc8ad2d5944f9.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/30/b9283bdbb4d0483c8a8dd47909d3dddb.png