【Spring Boot 9，Java集合面试题及答案

二、项目架构

======

1、pom.xml

---

<?xml version="1.0" encoding="UTF-8"?>

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">

	<modelVersion>4.0.0</modelVersion>

	<parent>

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

		<artifactId>spring-boot-starter-parent</artifactId>

		<version>2.2.4.RELEASE</version>

		<relativePath/>

	</parent>

	<groupId>life.majiang.community</groupId>

	<artifactId>community</artifactId>

	<version>0.0.1-SNAPSHOT</version>

	<name>community</name>

	<description>community</description>



	<properties>

		<java.version>1.8</java.version>

	</properties>



	<dependencies>

		<dependency>

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

			<artifactId>spring-boot-starter-web</artifactId>

		</dependency>



		<dependency>

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

			<artifactId>spring-boot-starter-thymeleaf</artifactId>

		</dependency>



		<!-- https://mvnrepository.com/artifact/org.springframework/spring-jdbc -->

		<dependency>

			<groupId>org.springframework</groupId>

			<artifactId>spring-jdbc</artifactId>

			<version>5.2.3.RELEASE</version>

		</dependency>





		<!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->

		<dependency>

			<groupId>org.mybatis</groupId>

			<artifactId>mybatis</artifactId>

			<version>3.5.4</version>

		</dependency>



		<dependency>

			<groupId>org.mybatis.spring.boot</groupId>

			<artifactId>mybatis-spring-boot-starter</artifactId>

			<version>1.3.2</version>

		</dependency>



		<dependency>

			<groupId>mysql</groupId>

			<artifactId>mysql-connector-java</artifactId>

			<version>8.0.11</version>

		</dependency>



		<dependency>

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

			<artifactId>spring-boot-starter-test</artifactId>

			<scope>test</scope>

			<exclusions>

				<exclusion>

					<groupId>org.junit.vintage</groupId>

					<artifactId>junit-vintage-engine</artifactId>

				</exclusion>

			</exclusions>

		</dependency>

	</dependencies>



	<build>

		<plugins>

			<plugin>

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

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

			</plugin>

		</plugins>

	</build>



</project> 

三、springboot集成MySQL

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

如果不做更改，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();

}



# 总结

在这里，由于面试中MySQL问的比较多，因此也就在此以MySQL为例为大家总结分享。但是你要学习的往往不止这一点，还有一些主流框架的使用，Spring源码的学习，Mybatis源码的学习等等都是需要掌握的，我也把这些知识点都整理起来了

**[CodeChina开源项目：【一线大厂Java面试题解析+核心总结学习笔记+最新讲解视频】](https://codechina.csdn.net/m0_60958482/java-p7)**

![面试真题](https://img-blog.csdnimg.cn/img_convert/23ceb5f8d8d05ba5d8f81d4b89976d3f.png)


ect("select * from user")

    public User getUsers();

}



# 总结

在这里，由于面试中MySQL问的比较多，因此也就在此以MySQL为例为大家总结分享。但是你要学习的往往不止这一点，还有一些主流框架的使用，Spring源码的学习，Mybatis源码的学习等等都是需要掌握的，我也把这些知识点都整理起来了

**[CodeChina开源项目：【一线大厂Java面试题解析+核心总结学习笔记+最新讲解视频】](https://codechina.csdn.net/m0_60958482/java-p7)**

[外链图片转存中...(img-rbcsjw1r-1630925388261)]


![Spring源码笔记](https://img-blog.csdnimg.cn/img_convert/85b25b0078d456e15f8c6a234c15f1a3.png)