SpringBoot整合Mybatis实现增删改查

痛定思痛。 2022-02-27 05:56 352阅读 0赞

### 源码获取 ###

**源码已上传至GitHub，地址：https://github.com/291685399/springboot-learning/tree/master/springboot-mybatis01 （内含sql文件）**  
pom.xml里添加：

<dependency>
    	<groupId>org.mybatis.spring.boot</groupId>
    	<artifactId>mybatis-spring-boot-starter</artifactId>
    	<version>2.0.0</version>
    </dependency>

ApiApplication.java：

package com.wyj;
    import org.mybatis.spring.annotation.MapperScan;
    import org.springframework.boot.SpringApplication;
    import org.springframework.boot.autoconfigure.SpringBootApplication;
    
    @SpringBootApplication
    @MapperScan(basePackages = "com.wyj.mapper")//用于扫描mybatis中的mapper文件，要是mapper接口的具体路径
    public class ApiApplication { 
        public static void main(String[] args) { 
            SpringApplication.run(ApiApplication.class, args);
        }
    }

application.properties：

# tomcat port
    server.port=8080
    # datasource
    spring.datasource.driver-class-name=com.mysql.jdbc.Driver
    spring.datasource.url=jdbc:mysql://127.0.0.1:3306/springboot-mybatis01?allowMultiQueries=true&useUnicode=true&useSSL=false&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull
    spring.datasource.username=root
    spring.datasource.password=root
    # mybatis
    mybatis.mapper-locations=classpath*:mapper/*.xml
    mybatis.type-aliases-package=com.wyj.entity

UserController.java：

package com.wyj.controller;
    import com.wyj.entity.po.User;
    import com.wyj.entity.vo.APIResponse;
    import com.wyj.service.UserService;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.web.bind.annotation.RequestMapping;
    import org.springframework.web.bind.annotation.RestController;
    import java.util.List;
    
    @RestController
    public class UserController { 
    
        @Autowired
        private UserService userService;
    
        @RequestMapping(value = "/insertUser")
        public APIResponse insertUser() { 
            User user = new User("1", "admin", "admin");
            userService.insertUser(user);
            return APIResponse.success("保存成功");
        }
    
        @RequestMapping(value = "/updateUser")
        public APIResponse updateUser() { 
            User user = new User();
            user.setId("1");
            user.setPassword("abc");
            userService.updateUser(user);
            return APIResponse.success("修改成功");
        }
    
        @RequestMapping(value = "/deleteUser")
        public APIResponse deleteUser() { 
            String id = "1";
            userService.deleteUser(id);
            return APIResponse.success("删除成功");
        }
    
        @RequestMapping(value = "/seleteUser")
        public APIResponse seleteUser() { 
            String id = "1";
            User user = userService.seleteUser(id);
            return APIResponse.success(user);
        }
    
        @RequestMapping(value = "/seleteUserList")
        public APIResponse seleteUserList() { 
            User user = new User();
            user.setUsername("admin");
            List<User> users = userService.seleteUserList(user);
            return APIResponse.success(users);
        }
    }

UserService.java：

package com.wyj.service;
    import com.wyj.entity.po.User;
    import java.util.List;
    
    public interface UserService { 
        /** * 新增数据 * * @param user */
        public void insertUser(User user);
        /** * 修改数据 * * @param user */
        public void updateUser(User user);
        /** * 删除数据 * * @param id */
        public void deleteUser(String id);
        /** * 查找单条数据 * * @param id * @return */
        public User seleteUser(String id);
        /** * 查找多条数据 * * @param user * @return */
        public List<User> seleteUserList(User user);
    }

UserServiceImpl.java：

package com.wyj.service.impl;
    import com.wyj.entity.po.User;
    import com.wyj.mapper.UserMapper;
    import com.wyj.service.UserService;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
    import java.util.List;
    
    @Service("userService")
    public class UserServiceImpl implements UserService { 
    
        @Autowired
        private UserMapper userMapper;
    
        @Override
        public void insertUser(User user) { 
            userMapper.insertUser(user);
        }
    
        @Override
        public void updateUser(User user) { 
            userMapper.updateUser(user);
        }
    
        @Override
        public void deleteUser(String  id) { 
            userMapper.deleteUser(id);
        }
    
        @Override
        public User seleteUser(String id) { 
            return userMapper.seleteUser(id);
        }
    
        @Override
        public List<User> seleteUserList(User user) { 
            return userMapper.seleteUserList(user);
        }
    }

UserMapper：

package com.wyj.mapper;
    import com.wyj.entity.po.User;
    import java.util.List;
    
    public interface UserMapper { 
        /** * 新增数据 * * @param user */
        public void insertUser(User user);
        /** * 修改数据 * * @param user */
        public void updateUser(User user);
        /** * 删除数据 * * @param id */
        public void deleteUser(String id);
        /** * 查找单条数据 * * @param id * @return */
        public User seleteUser(String id);
        /** * 查找多条数据 * * @param user * @return */
        public List<User> seleteUserList(User user);
    }

UserMapper.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.wyj.mapper.UserMapper">
        <insert id="insertUser" parameterType="com.wyj.entity.po.User">
            insert into `user` values (#{id},#{username},#{password})
        </insert>
    
        <update id="updateUser" parameterType="com.wyj.entity.po.User">
            update `user` set password=#{password} where id=#{id}
        </update>
    
        <delete id="deleteUser" parameterType="java.lang.String">
            delete from `user` where id=#{id}
        </delete>
    
        <select id="seleteUser" parameterType="java.lang.String" resultType="com.wyj.entity.po.User">
            select id,username,password from `user` where id=#{id}
        </select>
    
        <select id="seleteUserList" parameterType="com.wyj.entity.po.User" resultType="com.wyj.entity.po.User">
            select id,username,password from `user` where username=#{username}
         </select>
    </mapper>

User.java：

package com.wyj.entity.po;
    import java.io.Serializable;
    
    public class User implements Serializable { 
    
        private String id;
        private String username;
        private String password;
    
        public User() { }
    
        public User(String id, String username, String password) { 
            this.id = id;
            this.username = username;
            this.password = password;
        }
    
        public String getId() { return id;}
    
        public void setId(String id) { this.id = id;}
    
        public String getUsername() { return username;}
    
        public void setUsername(String username) { this.username = username;}
    
        public String getPassword() { return password;}
    
        public void setPassword(String password) { this.password = password;}
    
        @Override
        public String toString() { 
            return "User{" +
                    "id='" + id + '\'' +
                    ", username='" + username + '\'' +
                    ", password='" + password + '\'' +
                    '}';
        }
    }

APIResponse.java：

package com.wyj.entity.vo;
    import java.io.Serializable;
    
    public class APIResponse implements Serializable { 
    
        private String msg;
        private Object data;
    
        public APIResponse() { }
    
        public APIResponse(Object data) { this.data = data;}
    
        public APIResponse(String msg, Object data) { 
            this.msg = msg;
            this.data = data;
        }
    
        public static APIResponse success(Object date) { return new APIResponse(date);}
    
        public String getMsg() { return msg;}
    
        public void setMsg(String msg) { this.msg = msg;}
    
        public Object getData() { return data;}
    
        public void setData(Object data) { this.data = data;}
    
        @Override
        public String toString() { 
            return "APIResponse{" +
                    "msg='" + msg + '\'' +
                    ", data='" + data + '\'' +
                    '}';
        }
    }