【SpringBoot】111.Springboot整合Springmvc+Mybatis增删改查操作（下）

整合过程：https://www.isdxh.com/68.html

一、增——增加用户

1.创建实体类

package com.dxh.pojo;
public class Users {
	private Integer id;
	private String name;
	private Integer age;
	public Integer getId() {
		return id;
	}
	public void setId(Integer id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public Integer getAge() {
		return age;
	}
	public void setAge(Integer age) {
		this.age = age;
	}
}

2.创建mapper接口以及映射配置文件

package com.dxh.mapper;
import com.dxh.pojo.Users;
public interface UsersMapper {
	void insertUser(Users users);
}

	
	
		insert into users(name,age) values (#{name},#{age})
	

3.创建业务层

package com.dxh.service.impl;

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

import com.dxh.mapper.UsersMapper;
import com.dxh.pojo.Users;
import com.dxh.service.UsersService;

@Service
@Transactional
public class UserServiceImpl implements UsersService{

	@Autowired
	private UsersMapper usersMapper;
	
	@Override
	public void addUser(Users users) {
		this.usersMapper.insertUser(users);
	}
}

package com.dxh.service;

import com.dxh.pojo.Users;

public interface UsersService {
	void addUser(Users users);
}

4.创建Controller

package com.dxh.controller;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;

import com.dxh.pojo.Users;
import com.dxh.service.UsersService;

@Controller
@RequestMapping("/users")
public class UsersController {
	@Autowired
	private UsersService usersService;
	/**
	 * 页面跳转的方法
	 */
	@RequestMapping("/{page}")
	public String showPage(@PathVariable String page) {
		return page;
	}
	/**
	 * 添加用户
	 */
	@RequestMapping("/addUser")
	public String addUser(Users users) {
		this.usersService.addUser(users);
		return "ok";
	}
}

5.编写页面:src/main/resources/templates/ input.html 和 ok.html

	
		userName: 

		userAge: 

		
	

	 addUser Success!

6.启动类:

• 新增注解：@MapperScan("com.dxh.mapper") //用于扫描mybatis的Mapper接口

package com.dxh;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication
@MapperScan("com.dxh.mapper")	//用于扫描mybatis的Mapper接口
public class App {
	public static void main(String[] args) {
		SpringApplication.run(App.class, args);
	}
}

二、查——查询用户

1.在mapper接口中以及映射配置文件中添加相关代码

List selectUserAll();

	SELECT id,name,age from users

2.在业务层中添加查询方法

List findUserAll();

	@Override
	public List findUserAll() {
		return this.usersMapper.selectUserAll();
	}

3.编写controller

/**
	 * 查询全部用户
	 */
	@RequestMapping("/findUserAll")
	public String findUserAll(Model model) {
		List list =  this.usersService.findUserAll();
		model.addAttribute("list",list);
		return "showUsers";
	}

4.创建页面

在src/main/resources/templates/showUsers.html

	

		

			
ID
		
			
名称
			
年龄
		
		

			

			

			

		
	

5.访问

http://localhost:8080/users/findUserAll

三、改——用户更新

分为两部分，一是数据回显，二是提交页面

1.修改Mapper文件和映射配置

Users selectUsersById(Integer id);

		SELECT id,name,age from users where id = #{id}

2.修改业务层代码

Users findUserById(Integer id);

	@Override
	public Users findUserById(Integer id) {
		return this.usersMapper.selectUsersById(id);
	}

3.编写Controller

	/**
	 * 根据用户id查询用户
	 */
	@RequestMapping("/findUserById")
	public String findUserById(Integer id ,Model model) {
		Users user = this.usersService.findUserById(id);
		model.addAttribute("user",user);
		return "updatePage";
	}

4.在src/main/resources/templates/updatePage.html创建html页面

	
	
		userName: 

		userAge: 

		
	

5.编辑showUsers.html文件

	

		

			
ID
		
			
名称
			
年龄
			
操作
		
		

			

			

			

			

				更新用户
			
		
	

6.修改Mapper接口和映射配置文件

void updateUser(Users users);

	
		update users set name=#{name} , age=#{age} where id=#{id}
	

7.修改业务层代码

void updateUser(Users users);

	@Override
	public void updateUser(Users users) {
		this.usersMapper.updateUser(users);
	}

8.编写controller

	@RequestMapping("/editUser")
	public String editUser(Users users,Model model) {
		this.usersService.updateUser(users);
		return "ok";
	}

四、删——删除用户

1.修改Mapper以及映射配置文件

void deleteUserByid(Integer id);

	
		delete from users where id = #{id}
	

2.修改业务层方法

void deleteUserById(Integer id);

	@Override
	public void deleteUserById(Integer id) {
		this.usersMapper.deleteUserByid(id);
	}

3.修改controller

	/**
	 * 删除用户
	 */
	@RequestMapping("/delUser")
	public String delUser(Integer id) {
		this.usersService.deleteUserById(id);
		return "redirect:/users/findUserAll";
	}

4.修改showUsers.html

	

		

			
ID
		
			
名称
			
年龄
			
操作
		
		

			

			

			

			

				更新用户

				删除用户
			
		
	

5.完成！