【Spring Boot 9(1)，rabbitmq原理及作用

			</exclusion>

		</exclusions>

	</dependency>

</dependencies>



<build>

	<plugins>

		<plugin>

			<groupId>org.springframework.boot</groupId>

			<artifactId>spring-boot-maven-plugin</artifactId>

		</plugin>

	</plugins>

</build>

三、springboot集成MySQL

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



![](https://imgconvert.csdnimg.cn/aHR0cHM6Ly9vc2NpbWcub3NjaGluYS5uZXQvb3NjbmV0L3VwLTIwNDMzYzExNGYzNGQ0NjY4ZjhmNmI3ZjNmOWE2NGE1NzYyLnBuZw?x-oss-process=image/format,png)



![](https://imgconvert.csdnimg.cn/aHR0cHM6Ly9vc2NpbWcub3NjaGluYS5uZXQvb3NjbmV0L3VwLTlhZDdmNTIwN2IwNzU5NTE3ZDdkMGI1Y2EwNDk3YTMyMzYyLnBuZw?x-oss-process=image/format,png)



如果不做更改，test connection不会成功。



四、注解版实现增删改查

===========



1、我习惯从controller开写

------------------

package life.majiang.community.controller;

import life.majiang.community.bean.User;

import life.majiang.community.mapper.UserMapper;

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

import org.springframework.stereotype.Controller;

import org.springframework.web.bind.annotation.GetMapping;

import org.springframework.web.bind.annotation.RequestParam;

@Controller

public class UserController {

@Autowired

UserMapper userMapper;

@Autowired

User user;



@GetMapping("/getUserById")

public String getUserById(@RequestParam(name="id") String id){

    System.out.println(userMapper.getUserById(id).name);

    return "index";

}



@GetMapping("/getUsers")

public String getUsers(){

    return "index";

}



@GetMapping("/insertUser")

public String insertUser(@RequestParam(name="id") String id,@RequestParam(name="name") String name,@RequestParam(name="password") String password){

    user.setId(id);

    user.setName(name);

    user.setPassword(password);

    userMapper.insertUser(user);

    return "index";

}

}

2、UserMapper

------------

package life.majiang.community.mapper;

import life.majiang.community.bean.User;

import org.apache.ibatis.annotations.Insert;

import org.apache.ibatis.annotations.Select;

public interface UserMapper {

@Select("select * from user where id=#{id}")

public User getUserById(String id);



@Insert("insert into user(ID,name,password) values (#{id},#{name},#{password})")

public void insertUser(User user);



@Select("select * from user")

public User getUsers();

}

3、测试

----



  

![](https://imgconvert.csdnimg.cn/aHR0cHM6Ly9vc2NpbWcub3NjaGluYS5uZXQvb3NjbmV0L3VwLTM4ZjcxYTVhYWQ5N2IwMDIwNzBmMjU0NjE2MmIxMjEzOWYyLnBuZw?x-oss-process=image/format,png)



五、配置实现增删改查

==========

package life.majiang.community.controller;

import life.majiang.community.bean.User;

import life.majiang.community.mapper.UserMapper;

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

import org.springframework.stereotype.Controller;

import org.springframework.web.bind.annotation.GetMapping;

import org.springframework.web.bind.annotation.RequestParam;

@Controller

public class UserController {

@Autowired

UserMapper userMapper;

@Autowired

User user;



@GetMapping("/getUserById2")

public String getUserById2(@RequestParam(name="id") String id){

    System.out.println(userMapper.getUserById2(id).name);

    return "index";

}



@GetMapping("/insertUser2")

public String insertUser2(@RequestParam(name="id") String id,@RequestParam(name="name") String name,@RequestParam(name="password") String password){

    user.setId(id);

    user.setName(name);

    user.setPassword(password);

    userMapper.insertUser2(user);

    return "index";

}



@GetMapping("/deleteUserById")

public String deleteUserById(@RequestParam(name="id") String id){

    userMapper.deleteUserById(id);

    return "index";

}

}

1、UserMapper

------------

package life.majiang.community.mapper;

import life.majiang.community.bean.User;

import org.apache.ibatis.annotations.Insert;

import org.apache.ibatis.annotations.Select;

public interface UserMapper {

public User getUserById2(String id);

public void insertUser2(User user);

public void deleteUserById(String id);

}

2、UserMapper.xml

----------------

<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" # **结尾**  这不止是一份面试清单，更是一种”被期望的责任“，因为有无数个待面试者，希望从这篇文章中，找出通往期望公司的”钥匙“，所以上面每道选题都是结合我自身的经验于千万个面试题中经过艰辛的两周，一个题一个题筛选出来再次对好答案和格式做出来的，面试的答案也是再三斟酌，深怕误人子弟是小，影响他人仕途才是大过，也希望您能把这篇文章分享给更多的朋友，让他帮助更多的人，帮助他人，快乐自己，最后，感谢您的阅读。 **[CodeChina开源项目：【一线大厂Java面试题解析+核心总结学习笔记+最新讲解视频】](https://codechina.youkuaiyun.com/m0_60958482/java-p7)** 外链图片转存中...(img-kYPvdhAm-1630925201844)] 这不止是一份面试清单，更是一种”被期望的责任“，因为有无数个待面试者，希望从这篇文章中，找出通往期望公司的”钥匙“，所以上面每道选题都是结合我自身的经验于千万个面试题中经过艰辛的两周，一个题一个题筛选出来再次对好答案和格式做出来的，面试的答案也是再三斟酌，深怕误人子弟是小，影响他人仕途才是大过，也希望您能把这篇文章分享给更多的朋友，让他帮助更多的人，帮助他人，快乐自己，最后，感谢您的阅读。 **[CodeChina开源项目：【一线大厂Java面试题解析+核心总结学习笔记+最新讲解视频】](https://codechina.youkuaiyun.com/m0_60958482/java-p7)** **由于细节内容实在太多啦，在这里我花了两周的时间把这些答案整理成一份文档了，在这里只把部分知识点截图出来粗略的介绍，每个小节点里面都有更细化的内容！**