SpringBoot之整合Mybatis（增，改，删）

时间 2019-11-30 标签 springboot 整合 mybatis 增改删

一，在上一篇文章SpringBoot之整合Mybatis中，咱们使用spring boot整合了Mybatis，并演示了查询操做。接下来咱们将完善这个示例，增长增，删，改的功能。html

二，改动代码java

　　1.修改UserMapper.xml,修改以后的代码：git

<?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.zcz.dao.UserDao">
    
    <sql id="base_column_list">
        id,name
    </sql>
    <select id="findAllUser" resultType="com.zcz.entity.User">
        select id,name from user
    </select>
     <select id="findUserById" resultType="com.zcz.entity.User">
         select 
        <include refid="base_column_list"></include>
        from user
        where id = #{id}
     </select>
     <update id="updateUserById" parameterType="com.zcz.entity.User">
         update user set name = #{name} where id = #{id}
     </update>
     <insert id="insertUser" parameterType="com.zcz.entity.User">
         insert into user(name) values (#{name})
     </insert>
     <delete id="deleteById" parameterType="java.lang.Integer">
         delete from user where id = #{id}
     </delete>
</mapper>

　　2.修改UserDao ,修改后的代码：github

package com.zcz.dao;

import java.util.List;

import org.apache.ibatis.annotations.Mapper;

import com.zcz.entity.User;

@Mapper
public interface UserDao {
    public List<User> findAllUser();
    public User findUserById(int id);
    public boolean updateUserById(User user);
    public boolean insertUser(User user);
    public boolean deleteById(int id);
}

　　3.修改UserService和UserServiceImplweb

　　UserService代码以下：spring

package com.zcz.service;

import java.util.List;

import com.zcz.entity.User;

public interface UserService {
    public List<User> getUsers();
    public User findUserById(int id);
    public boolean updateUserById(User user);
    public boolean insertUser(User user);
    public boolean deleteById(int id);
}

　　UserServiceImpl代码以下：sql

package com.zcz.service.impl;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.zcz.dao.UserDao;
import com.zcz.entity.User;
import com.zcz.service.UserService;

@Service
public class UserServiceImpl implements UserService {

    @Autowired
    private UserDao userDao;
    
    @Override
    public List<User> getUsers() {
        // TODO Auto-generated method stub
        return userDao.findAllUser();
    }

    @Override
    public User findUserById(int id) {
        // TODO Auto-generated method stub
        return userDao.findUserById(id);
    }

    @Override
    public boolean updateUserById(User user) {
        // TODO Auto-generated method stub
        userDao.updateUserById(user);
        return true;
    }

    @Override
    public boolean insertUser(User user) {
        // TODO Auto-generated method stub
        userDao.insertUser(user);
        return true;
    }

    @Override
    public boolean deleteById(int id) {
        // TODO Auto-generated method stub
        userDao.deleteById(id);
        return true;
    }

}

4.修改UserController.代码以下数据库

package com.zcz.controller;

import java.util.List;

import javax.servlet.http.HttpServletRequest;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import com.zcz.entity.User;
import com.zcz.service.UserService;

@RestController
@RequestMapping("/user")
public class UserController {
    
    @Autowired
    private UserService userService;
    
    @RequestMapping("/getUser")
    public List<User> getUsers(){
        return userService.getUsers();
    }
    
    @RequestMapping("/addUser")
    public void addUser(HttpServletRequest request) {
        String name = request.getParameter("name");
        User user = new User();
        user.setName(name);
        userService.insertUser(user);
    }
    @RequestMapping("/updateUser")
    public void updateUser(HttpServletRequest request) {
        String name = request.getParameter("name");
        int id = Integer.parseInt(request.getParameter("id"));
        User user = new User();
        user.setName(name);
        user.setId(id);
        userService.updateUserById(user);
    }
    
    @RequestMapping("/getUserOne")
    public User getUserOne(HttpServletRequest request) {
        int id = Integer.parseInt(request.getParameter("id"));
        return userService.findUserById(id);
    }
    @RequestMapping("/deleteUser")
    public void deleteUser(HttpServletRequest request) {
        int id = Integer.parseInt(request.getParameter("id"));
        userService.deleteById(id);
    }
}

三，接下来就是测试apache

　　首先看一下数据库的数据：mybatis

　　1，测试新增，访问：http://localhost:8080/user/addUser?name=zhangchengzi

　　成功

　　2，测试更新,访问：http://localhost:8080/user/updateUser?id=6&name=zhangchengzilala

　　成功

　　3.测试更具id查询，访问：http://localhost:8080/user/getUserOne?id=6

　　成功

　　4,测试删除，访问：http://localhost:8080/user/deleteUser?id=6

　　成功

　　5.我把源代码上传到了github仓库：https://github.com/ZCC1/learnSpringBootWithMybatis2.git。能够clone下来参考。欢迎star。

好了，这样以来，Spring Boot整合Mybatis，经常使用的操做，增，删，改，查所有都实现了。

原创不易，转载请注明出处：https://www.cnblogs.com/zhangchengzi/p/9662639.html