AI 助理
备案控制台
开发者社区 数据库 文章 正文

springmvc+mybatis 无极限树形结构 Mapperxml 映射方法

2017-05-10 1267
版权
版权声明：
本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《 阿里云开发者社区用户服务协议》和 《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写 侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。
简介： 项目中我们可能经常有这样的需求，需要返回二级或三级的菜单，返回一个树形结构，面试中也可能经常被问到。最近的项目中就用到了，这里整理分享一下。应用场景：地区树，国家，省，市，区县共4级。表结构：建表语句：SET NAMES utf8;SET FOREIGN_KEY_CHECKS ...

项目中我们可能经常有这样的需求，需要返回二级或三级的菜单，返回一个树形结构，面试中也可能经常被问到。

最近的项目中就用到了，这里整理分享一下。

应用场景：

地区树，国家，省，市，区县共4级。

表结构：


建表语句：

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `base_area`
-- ----------------------------
DROP TABLE IF EXISTS `base_area`;
CREATE TABLE `base_area` (
  `ID` bigint(20) NOT NULL AUTO_INCREMENT,
  `AREA_NAME` varchar(255) DEFAULT NULL COMMENT '地区名称',
  `AREA_CODE` varchar(255) DEFAULT NULL COMMENT '地区编码',
  `PARENT_ID` bigint(20) DEFAULT NULL,
  `PLAT_MARK` bigint(20) DEFAULT NULL COMMENT '区域标识，也就是平台标识',
  `LEVEL` tinyint(4) DEFAULT '1' COMMENT '层',
  `STATUS` tinyint(4) DEFAULT '1' COMMENT '是否可用、是否显示',
  `EXPAND` tinyint(4) DEFAULT '0' COMMENT '是否展开子节点，非0为展开。',
  PRIMARY KEY (`ID`),
  KEY `index2` (`PLAT_MARK`)
) ENGINE=InnoDB AUTO_INCREMENT=3514 DEFAULT CHARSET=utf8;
SET FOREIGN_KEY_CHECKS = 1;
返回JSON结果示例：

数据比较多，这里只展示一部分，有需要完整表数据的小伙伴，稍后提供下载地址。

{"result":[{"createTimeString":"","updateTimeString":"","level":3,"platMark":100001001000000,"parentId":1,"areaCode":"110000","expand":0,"areaName":"北京市","id":2,"childrenList":[{"createTimeString":"","updateTimeString":"","level":4,"platMark":100001001001000,"parentId":2,"areaCode":"110101","expand":0,"areaName":"东城区","id":4,"childrenList":[]},{"createTimeString":"","updateTimeString":"","level":4,"platMark":100001001002000,"parentId":2,"areaCode":"110102","expand":0,"areaName":"西城区","id":5,"childrenList":[]},{"createTimeString":"","updateTimeString":"","level":4,"platMark":100001001003000,"parentId":2,"areaCode":"110105","expand":0,"areaName":"朝阳区","id":6,"childrenList":[]},{"createTimeString":"","updateTimeString":"","level":4,"platMark":100001001004000,"parentId":2,"areaCode":"110106","expand":0,"areaName":"丰台区","id":7,"childrenList":[]},{"createTimeString":"","updateTimeString":"","level":4,"platMark":100001001005000,"parentId":2,"areaCode":"110107","expand":0,"areaName":"石景山区","id":8,"childrenList":[]},{"createTimeString":"","updateTimeString":"","level":4,"platMark":100001001006000,"parentId":2,"areaCode":"110108","expand":0,"areaName":"海淀区","id":9,"childrenList":[]},{"createTimeString":"","updateTimeString":"","level":4,"platMark":100001001007000,"parentId":2,"areaCode":"110109","expand":0,"areaName":"门头沟区","id":10,"childrenList":[]},{"createTimeString":"","updateTimeString":"","level":4,"platMark":100001001008000,"parentId":2,"areaCode":"110111","expand":0,"areaName":"房山区","id":11,"childrenList":[]},{"createTimeString":"","updateTimeString":"","level":4,"platMark":100001001009000,"parentId":2,"areaCode":"110112","expand":0,"areaName":"通州区","id":12,"childrenList":[]},{"createTimeString":"","updateTimeString":"","level":4,"platMark":100001001010000,"parentId":2,"areaCode":"110113","expand":0,"areaName":"顺义区","id":13,"childrenList":[]},{"createTimeString":"","updateTimeString":"","level":4,"platMark":100001001011000,"parentId":2,"areaCode":"110114","expand":0,"areaName":"昌平区","id":14,"childrenList":[]},{"createTimeString":"","updateTimeString":"","level":4,"platMark":100001001012000,"parentId":2,"areaCode":"110115","expand":0,"areaName":"大兴区","id":15,"childrenList":[]},{"createTimeString":"","updateTimeString":"","level":4,"platMark":100001001013000,"parentId":2,"areaCode":"110116","expand":0,"areaName":"怀柔区","id":16,"childrenList":[]},{"createTimeString":"","updateTimeString":"","level":4,"platMark":100001001014000,"parentId":2,"areaCode":"110117","expand":0,"areaName":"平谷区","id":17,"childrenList":[]},{"createTimeString":"","updateTimeString":"","level":4,"platMark":100001001015000,"parentId":2,"areaCode":"110228","expand":0,"areaName":"密云县","id":18,"childrenList":[]},{"createTimeString":"","updateTimeString":"","level":4,"platMark":100001001016000,"parentId":2,"areaCode":"110229","expand":0,"areaName":"延庆县","id":19,"childrenList":[]}]},{"createTimeString":"","updateTimeString":"","level":3,"platMark":100002001000000,"parentId":1,"areaCode":"120000","expand":0,"areaName":"天津市","id":20,"childrenList":[{"createTimeString":"","updateTimeString":"","level":4,"platMark":100002001001000,"parentId":20,"areaCode":"120101","expand":0,"areaName":"和平区","id":22,"childrenList":[]},{"createTimeString":"","updateTimeString":"","level":4,"platMark":100002001002000,"parentId":20,"areaCode":"120102","expand":0,"areaName":"河东区","id":23,"childrenList":[]},{"createTimeString":"","updateTimeString":"","level":4,"platMark":100002001003000,"parentId":20,"areaCode":"120103","expand":0,"areaName":"河西区","id":24,"childrenList":[]},{"createTimeString":"","updateTimeString":"","level":4,"platMark":100002001004000,"parentId":20,"areaCode":"120104","expand":0,"areaName":"南开区","id":25,"childrenList":[]},{"createTimeString":"","updateTimeString":"","level":4,"platMark":100002001005000,"parentId":20,"areaCode":"120105","expand":0,"areaName":"河北区","id":26,"childrenList":[]},{"createTimeString":"","updateTimeString":"","level":4,"platMark":100002001006000,"parentId":20,"areaCode":"120106","expand":0,"areaName":"红桥区","id":27,"childrenList":[]},{"createTimeString":"","updateTimeString":"","level":4,"platMark":100002001007000,"parentId":20,"areaCode":"120110","expand":0,"areaName":"东丽区","id":28,"childrenList":[]},{"createTimeString":"","updateTimeString":"","level":4,"platMark":100002001008000,"parentId":20,"areaCode":"120111","expand":0,"areaName":"西青区","id":29,"childrenList":[]},{"createTimeString":"","updateTimeString":"","level":4,"platMark":100002001009000,"parentId":20,"areaCode":"120112","expand":0,"areaName":"津南区","id":30,"childrenList":[]},{"createTimeString":"","updateTimeString":"","level":4,"platMark":100002001010000,"parentId":20,"areaCode":"120113","expand":0,"areaName":"北辰区","id":31,"childrenList":[]},{"createTimeString":"","updateTimeString":"","level":4,"platMark":100002001011000,"parentId":20,"areaCode":"120114","expand":0,"areaName":"武清区","id":32,"childrenList":[]},{"createTimeString":"","updateTimeString":"","level":4,"platMark":100002001012000,"parentId":20,"areaCode":"120115","expand":0,"areaName":"宝坻区","id":33,"childrenList":[]},{"createTimeString":"","updateTimeString":"","level":4,"platMark":100002001013000,"parentId":20,"areaCode":"120116","expand":0,"areaName":"滨海新区","id":34,"childrenList":[]},{"createTimeString":"","updateTimeString":"","level":4,"platMark":100002001014000,"parentId":20,"areaCode":"120221","expand":0,"areaName":"宁河县","id":35,"childrenList":[]},{"createTimeString":"","updateTimeString":"","level":4,"platMark":100002001015000,"parentId":20,"areaCode":"120223","expand":0,"areaName":"静海县","id":36,"childrenList":[]},{"createTimeString":"","updateTimeString":"","level":4,"platMark":100002001016000,"parentId":20,"areaCode":"120225","expand":0,"areaName":"蓟县","id":37,"childrenList":[]}]}]}

实体类：

/**
 * 表名：base_area
 * 备注：BaseArea
 */
@SuppressWarnings("serial")
public class BaseArea {
		
	//date formats
	
	//columns START
	//id
	private Long id;
	//地区名称
	private String areaName;
	//地区编码
	private String areaCode;
	//parentId
	private Long parentId;
	//区域标识，也就是平台标识
	private Long platMark;
	//层
	private Byte level;
	//是否可用、是否显示
	private Integer status;
	//是否展开子节点，非0为展开。
	private Byte expand;
	//columns END
	
	//extend columns START
	//子节点列表
	List<BaseArea> childrenList;
	//extend columns END

	public List<BaseArea> getChildrenList() {
		return childrenList;
	}

	public void setChildrenList(List<BaseArea> childrenList) {
		this.childrenList = childrenList;
	}

	public BaseArea(){
	}

	public BaseArea(Long id){
		this.id = id;
	}

	/**
	 * id
	 * @return
	 */
	public Long getId() {
		return this.id;
	}
	
	/**
	 * id
	 * @param value
	 */
	public void setId(Long value) {
		this.id = value;
	}
	/**
	 * 地区名称
	 * @return
	 */
	public String getAreaName() {
		return this.areaName;
	}
	
	/**
	 * 地区名称
	 * @param value
	 */
	public void setAreaName(String value) {
		this.areaName = value;
	}
	/**
	 * 地区编码
	 * @return
	 */
	public String getAreaCode() {
		return this.areaCode;
	}
	
	/**
	 * 地区编码
	 * @param value
	 */
	public void setAreaCode(String value) {
		this.areaCode = value;
	}
	/**
	 * parentId
	 * @return
	 */
	public Long getParentId() {
		return this.parentId;
	}
	
	/**
	 * parentId
	 * @param value
	 */
	public void setParentId(Long value) {
		this.parentId = value;
	}
	/**
	 * 区域标识，也就是平台标识
	 * @return
	 */
	public Long getPlatMark() {
		return this.platMark;
	}
	
	/**
	 * 区域标识，也就是平台标识
	 * @param value
	 */
	public void setPlatMark(Long value) {
		this.platMark = value;
	}
	/**
	 * 层
	 * @return
	 */
	public Byte getLevel() {
		return this.level;
	}
	
	/**
	 * 层
	 * @param value
	 */
	public void setLevel(Byte value) {
		this.level = value;
	}
	/**
	 * 是否可用、是否显示
	 * @return
	 */
	public Integer getStatus() {
		return this.status;
	}
	
	/**
	 * 是否可用、是否显示
	 * @param value
	 */
	public void setStatus(Integer value) {
		this.status = value;
	}
	/**
	 * 是否展开子节点，非0为展开。
	 * @return
	 */
	public Byte getExpand() {
		return this.expand;
	}
	
	/**
	 * 是否展开子节点，非0为展开。
	 * @param value
	 */
	public void setExpand(Byte value) {
		this.expand = value;
	}
}

Mapperxml 映射方法

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//ibatis.apache.org//DTD Mapper 3.0//EN"
"http://ibatis.apache.org/dtd/ibatis-3-mapper.dtd">


<!-- 不使用namespace的话sql搜索定位会比较方便 -->
<!-- BaseArea -->
<mapper namespace="BaseArea">
	
	<resultMap id="baseAreaResult" type="com.wanyu.smarthome.model.BaseArea">
        <id property="id" column="ID"/>
        <result property="areaName" column="AREA_NAME"/>
        <result property="areaCode" column="AREA_CODE"/>
        <result property="parentId" column="PARENT_ID"/>
        <result property="platMark" column="PLAT_MARK"/>
        <result property="level" column="LEVEL"/>
        <result property="status" column="STATUS"/>
        <result property="expand" column="EXPAND"/>
        <collection property="childrenList" javaType="java.util.ArrayList" column="id"
                    ofType="com.wanyu.smarthome.model.BaseArea" select="childrenSelect"></collection>
	</resultMap>
	
	<resultMap id="childrenResult" type="com.wanyu.smarthome.model.BaseArea">
        <id property="id" column="ID"/>
        <result property="areaName" column="AREA_NAME"/>
        <result property="areaCode" column="AREA_CODE"/>
        <result property="parentId" column="PARENT_ID"/>
        <result property="platMark" column="PLAT_MARK"/>
        <result property="level" column="LEVEL"/>
        <result property="status" column="STATUS"/>
        <result property="expand" column="EXPAND"/>
        <collection property="childrenList" javaType="java.util.ArrayList" column="id"
                    ofType="com.wanyu.smarthome.model.BaseArea" select="childrenSelect"></collection>
	</resultMap>
	
	<!-- 用于select查询公用抽取的列 -->
	<sql id="commonColumns">
	    <![CDATA[
        	ID,
        	AREA_NAME,
        	AREA_CODE,
        	PARENT_ID,
        	PLAT_MARK,
        	LEVEL,
        	STATUS,
        	EXPAND
	    ]]>
	</sql>
	
	<sql id="commonAliasColumns">
	    <![CDATA[
        	x.ID,
        	x.AREA_NAME,
        	x.AREA_CODE,
        	x.PARENT_ID,
        	x.PLAT_MARK,
        	x.LEVEL,
        	x.STATUS,
        	x.EXPAND
	    ]]>
	</sql>

	<!-- useGeneratedKeys="true" keyProperty="xxx" for sqlserver and mysql -->
	<insert id="insert" useGeneratedKeys="true" keyProperty="id" parameterType="com.wanyu.smarthome.model.BaseArea">
    <![CDATA[
        INSERT INTO base_area (
        	ID,
        	AREA_NAME,
        	AREA_CODE,
        	PARENT_ID,
        	PLAT_MARK,
        	LEVEL,
        	STATUS,
        	EXPAND
        ) VALUES (
        	#{id},
        	#{areaName},
        	#{areaCode},
        	#{parentId},
        	#{platMark},
        	#{level},
        	#{status},
        	#{expand}
        )
    ]]>
	</insert>
    
	<update id="update" parameterType="com.wanyu.smarthome.model.BaseArea">
    <![CDATA[
        UPDATE base_area SET
	        AREA_NAME = #{areaName},
	        AREA_CODE = #{areaCode},
	        PARENT_ID = #{parentId},
	        PLAT_MARK = #{platMark},
	        LEVEL = #{level},
	        STATUS = #{status},
	        EXPAND = #{expand}
        WHERE 
	        ID = #{id}
    ]]>
	</update>
	
	<delete id="delete" parameterType="map">
    <![CDATA[
        delete from base_area
    ]]>
		<include refid="dynamicWhere"/>
    </delete>
    
    <delete id="batchDelete" parameterType="list">
        delete from base_area where ID IN 
        <foreach collection="list" item="ids"  open="(" separator="," close=")">   
#{ids}        </foreach> 
    </delete>
    
    <delete id="batchDeleteByLocalId" parameterType="list">
        delete from base_area where LOCAL_ID in
        <foreach collection="list" item="ids"  open="(" separator="," close=")">   
#{ids}		</foreach> 
    </delete>
    
    <select id="getById" resultMap="baseAreaResult">
		SELECT <include refid="commonColumns" />
	    <![CDATA[
		    FROM base_area 
	        WHERE 
		        ID = #{id}
	    ]]>
	</select>
	
	<select id="getByIds" resultMap="baseAreaResult">
		SELECT <include refid="commonColumns" />
		FROM base_area WHERE ID IN 
		<foreach collection="list" item="ids"  open="(" separator="," close=")">   
#{ids}        </foreach>  
	</select>
	
	<sql id="dynamicWhere">
		<!-- ognl访问静态方法的表达式 为@class@method(args),以下为调用rapid中的Ognl.isNotEmpty()方法,还有其它方法如isNotBlank()可以使用，具体请查看Ognl类 -->
		<where>	      				
	       <if test="@Ognl@isNotEmpty(id)">
				AND ID = #{id}
			</if>
	       <if test="@Ognl@isNotEmpty(areaName)">
				AND AREA_NAME = #{areaName}
			</if>
	       <if test="@Ognl@isNotEmpty(areaCode)">
				AND AREA_CODE = #{areaCode}
			</if>
	       <if test="@Ognl@isNotEmpty(parentId)">
				AND PARENT_ID = #{parentId}
			</if>
	       <if test="@Ognl@isNotEmpty(platMark)">
				AND PLAT_MARK = #{platMark}
			</if>
	       <if test="@Ognl@isNotEmpty(level)">
				AND LEVEL = #{level}
			</if>
	       <if test="@Ognl@isNotEmpty(status)">
				AND STATUS = #{status}
			</if>
	       <if test="@Ognl@isNotEmpty(expand)">
				AND EXPAND = #{expand}
			</if>
		</where>
	</sql>
		
    <select id="count" resultType="long">
        SELECT count(*) FROM base_area 
		<include refid="dynamicWhere"/>    
    </select>
    
    <!--
    	分页查询已经使用Dialect进行分页,也可以不使用Dialect直接编写分页
    	因为分页查询将传 offset,pageSize,lastRows 三个参数,不同的数据库可以根于此三个参数属性应用不同的分页实现
    -->
    <select id="pageSelect" resultMap="baseAreaResult">
    	SELECT <include refid="commonColumns" />
	    FROM base_area 
		<include refid="dynamicWhere"/>
		
		<if test="@Ognl@isNotEmpty(sortColumns)">
			ORDER BY ${sortColumns}
		</if>
    </select>
    
    <select id="childrenSelect" resultMap="childrenResult">
    	SELECT <include refid="commonColumns" />
	    FROM base_area 
		WHERE PARENT_ID = #{id}
		ORDER BY ID ASC
    </select>
	
</mapper>

Mapperxml 解析

1、主查询语句为： pageSelect

2、结果映射 resultMap id="baseAreaResult" 

这里的关键在于：

<id property="id" column="ID"/>
<collection property="childrenList" javaType="java.util.ArrayList" column="id"
                    ofType="com.wanyu.smarthome.model.BaseArea" select="childrenSelect"></collection>

collection 标签中定义属性名称为 childrenList，对应实体类中的：childrenList

属性类型为：java.util.ArrayList

column="id" 将 id 列的值做为参数传递给子查询

ofType 定义List 中保存的数据类型

select 定义子查询

3、注意子查询 childrenSelect 对应的结果映射 childrenResult ，又包含了 collection 标签，形成了循环递归调用

小结

不知道我有没有描述清楚，有不明白的地方请留言。

强烈不推荐这种循环递归调用的写法，因为性能非常差。

最好是有几级就写几级，也就是写几个 resultMap。

本粟中是演示同一个表相同实体类的实现方式，同样也可以不同的表不同的实体类，只要把子节点类型修改一下就可以了。

为了性能，这种查询最好配合缓存使用。

======================文档信息======================

版权声明：非商用自由转载-保持署名-注明出处

署名(BY) ：testcs_dn(微wx笑)

文章出处：[无知人生，记录点滴](http://blog.csdn.NET/testcs_dn)

==============本文首发于个人微信订阅号（微wx笑）============

文章标签：
SQL
关键词：
MyBatis映射
Spring MVC方法
Spring mvc mybatis
MyBatis方法
Mybatis SpringMVC
微wx笑
目录
相关文章
蓝易云
|
13天前
|
设计模式 前端开发 Java
步步深入SpringMvc DispatcherServlet源码掌握springmvc全流程原理
通过对 `DispatcherServlet`源码的深入剖析，我们了解了SpringMVC请求处理的全流程。`DispatcherServlet`作为前端控制器，负责请求的接收和分发，处理器映射和适配负责将请求分派到具体的处理器方法，视图解析器负责生成和渲染视图。理解这些核心组件及其交互原理，有助于开发者更好地使用和扩展SpringMVC框架。
蓝易云
24 4
蓝染-惣右介
|
1月前
|
SQL 缓存 Java
【详细实用のMyBatis教程】获取参数值和结果的各种情况、自定义映射、动态SQL、多级缓存、逆向工程、分页插件
本文详细介绍了MyBatis的各种常见用法MyBatis多级缓存、逆向工程、分页插件 包括获取参数值和结果的各种情况、自定义映射resultMap、动态SQL
蓝染-惣右介
136 1
【详细实用のMyBatis教程】获取参数值和结果的各种情况、自定义映射、动态SQL、多级缓存、逆向工程、分页插件
最好zzz
|
1月前
|
前端开发 Java 开发者
Spring MVC中的请求映射：@RequestMapping注解深度解析
在Spring MVC框架中，`@RequestMapping`注解是实现请求映射的关键，它将HTTP请求映射到相应的处理器方法上。本文将深入探讨`@RequestMapping`注解的工作原理、使用方法以及最佳实践，为开发者提供一份详尽的技术干货。
最好zzz
123 2
蓝易云
|
1月前
|
前端开发 Java Spring
Spring MVC源码分析之DispatcherServlet#getHandlerAdapter方法
`DispatcherServlet`的 `getHandlerAdapter`方法是Spring MVC处理请求的核心部分之一。它通过遍历预定义的 `HandlerAdapter`列表，找到适用于当前处理器的适配器，并调用适配器执行具体的处理逻辑。理解这个方法有助于深入了解Spring MVC的工作机制和扩展点。
蓝易云
39 1
蓝易云
|
1月前
|
前端开发 Java Spring
Spring MVC源码分析之DispatcherServlet#getHandlerAdapter方法
`DispatcherServlet`的 `getHandlerAdapter`方法是Spring MVC处理请求的核心部分之一。它通过遍历预定义的 `HandlerAdapter`列表，找到适用于当前处理器的适配器，并调用适配器执行具体的处理逻辑。理解这个方法有助于深入了解Spring MVC的工作机制和扩展点。
蓝易云
35 1
杀死一只知更鸟debug
|
3月前
|
SQL XML Java
mybatis复习04高级查询 一对多，多对一的映射处理，collection和association标签的使用
文章介绍了MyBatis中高级查询的一对多和多对一映射处理，包括创建数据库表、抽象对应的实体类、使用resultMap中的association和collection标签进行映射处理，以及如何实现级联查询和分步查询。此外，还补充了延迟加载的设置和用法。
杀死一只知更鸟debug
96 1
mybatis复习04高级查询 一对多，多对一的映射处理，collection和association标签的使用
明弟有理想
|
2月前
|
JSON 前端开发 Java
SSM:SpringMVC
本文介绍了SpringMVC的依赖配置、请求参数处理、注解开发、JSON处理、拦截器、文件上传下载以及相关注意事项。首先，需要在`pom.xml`中添加必要的依赖，包括Servlet、JSTL、Spring Web MVC等。接着，在`web.xml`中配置DispatcherServlet，并设置Spring MVC的相关配置，如组件扫描、默认Servlet处理器等。然后，通过`@RequestMapping`等注解处理请求参数，使用`@ResponseBody`返回JSON数据。此外，还介绍了如何创建和配置拦截器、文件上传下载的功能，并强调了JSP文件的放置位置，避免404错误。
明弟有理想
37 1
蓝易云
|
1月前
|
前端开发 Java Spring
Spring MVC源码分析之DispatcherServlet#getHandlerAdapter方法
`DispatcherServlet`的 `getHandlerAdapter`方法是Spring MVC处理请求的核心部分之一。它通过遍历预定义的 `HandlerAdapter`列表，找到适用于当前处理器的适配器，并调用适配器执行具体的处理逻辑。理解这个方法有助于深入了解Spring MVC的工作机制和扩展点。
蓝易云
33 0
椰椰椰耶
|
2月前
|
前端开发 Java 应用服务中间件
【Spring】Spring MVC的项目准备和连接建立
【Spring】Spring MVC的项目准备和连接建立
椰椰椰耶
65 2
程序员小海绵
|
3月前
|
缓存 前端开发 Java
【Java面试题汇总】Spring,SpringBoot,SpringMVC,Mybatis,JavaWeb篇（2023版）
Soring Boot的起步依赖、启动流程、自动装配、常用的注解、Spring MVC的执行流程、对MVC的理解、RestFull风格、为什么service层要写接口、MyBatis的缓存机制、$和#有什么区别、resultType和resultMap区别、cookie和session的区别是什么？session的工作原理
程序员小海绵
112 4

热门文章

最新文章

  • 1
    探索Spring MVC：@Controller注解的全面解析
  • 2
    Spring MVC核心：深入理解@RequestMapping注解
  • 3
    步步深入SpringMvc DispatcherServlet源码掌握springmvc全流程原理
  • 4
    Spring Cloud Alibaba：一站式微服务解决方案
  • 5
    详解Spring Batch：在Spring Boot中实现高效批处理
  • 6
    从单体到微服务：如何借助 Spring Cloud 实现架构转型
  • 7
    深入 Spring Cloud Gateway 过滤器
  • 8
    使用 Spring Boot 执行数据库操作：全面指南
  • 9
    什么是JWT？如何使用Spring Boot Security实现它？
  • 10
    Spring MVC中的请求映射：@RequestMapping注解深度解析
  • 1
    Mybatis逆向工程的2种方法，一键高效快速生成Pojo、Mapper、XML，摆脱大量重复开发
    88
  • 2
    mybatis的一对多
    48
  • 3
    mybatis动态sql
    47
  • 4
    【JAVA进阶篇教学】第九篇：MyBatis-Plus用法介绍
    279
  • 5
    解决一个mybatisplus left join里有ur报错问题
    80
  • 6
    java mysql druid mybatis-plus里使用多表删除出错的一种处理方式
    107
  • 7
    nbcio-boot升级springboot、mybatis-plus和JSQLParser后的LocalDateTime日期json问题
    94
  • 8
    基于jeecg-boot的nbcio-boot因升级mybatis-plus到3.5.3.1和JSQLParser 到4.6而引起的在线报表配置报错处理
    190
  • 9
    升级mybatis-plus到3.5.3.1和JSQLParser 从4.3升级到4.6版本引起的插入问题解决
    629
  • 10
    MyBatis #与$的区别以及动态SQL
    51

    • 相关课程

    更多
  • 精通Spring Cloud Alibaba
  • 微服务框架 Spring Cloud 快速入门
  • Java Web开发系列课程 - Spring框架入门
  • Spring Boot 2.5.x开发实战
  • Spring Cloud微服务架构设计与开发实战
  • MyBatis持久层框架入门

    • 相关电子书

    更多
  • Spring Cloud Hoxton 新版本介绍 & 未来展望
  • Java Spring Boot开发实战系列课程【第6讲】：Spring Boot 2.0实战MyBatis与优化(Java面试题)
  • Java Spring Boot开发实战系列课程【第7讲】：Spring Boot 2.0安全机制与MVC身份验证实战(Java面试题)

    • 相关实验场景

    更多
  • 从零搭建Spring Boot的Hello World
    • 下一篇
    手把手教你白嫖阿里云服务器(免费领服务器)