提示：以下是本篇文章正文内容，下面案例可供参考
pom坐标

<?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 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <groupId>org.example</groupId>
    <artifactId>spring</artifactId>
    <packaging>pom</packaging>
    <version>1.0-SNAPSHOT</version>
    <modules>
        <module>spring_ioc_anno</module>
        <module>spring_mvc</module>
        <module>springMVC-demo2</module>
        <module>springMVC-demo3</module>
        <module>springMVC-rest</module>
        <module>springMVC-demo4</module>
    </modules>
    <properties>
        <maven.compiler.source>1.8</maven.compiler.source>
        <maven.compiler.target>1.8</maven.compiler.target>
    </properties>
    <dependencies>
        <!-- SpringMVC -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-webmvc</artifactId>
            <version>5.3.13</version>
        </dependency>
        <!-- 日志 -->
        <dependency>
            <groupId>ch.qos.logback</groupId>
            <artifactId>logback-classic</artifactId>
            <version>1.2.3</version>
        </dependency>
        <!-- ServletAPI -->
        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>javax.servlet-api</artifactId>
            <version>4.0.1</version>
            <scope>provided</scope>
        </dependency>
        <!-- Spring5和Thymeleaf整合包 -->
        <dependency>
            <groupId>org.thymeleaf</groupId>
            <artifactId>thymeleaf-spring5</artifactId>
            <version>3.0.12.RELEASE</version>
        </dependency>
        <!-- https://mvnrepository.com/artifact/commons-fileupload/commons-fileupload -->
        <dependency>
            <groupId>commons-fileupload</groupId>
            <artifactId>commons-fileupload</artifactId>
            <version>1.3.1</version>
        </dependency>
<!--        springMVC end-->
        <!--    导入spring坐标-->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-context</artifactId>
            <version>5.3.11</version>
        </dependency>
<!--        导入测试坐标-->
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.12</version>
            <scope>test</scope>
        </dependency>
        <!--    测试坐标-->
<!--        导入集成测试坐标-->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-test</artifactId>
            <version>5.3.13</version>
        </dependency>
        <!--        集成测试坐标end-->
        <!--        导入mysql坐标-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.24</version>
        </dependency>
        <!--        mysql坐标end-->
        <!--        导入druid连接池-->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.2.8</version>
        </dependency>
        <!--        导入druid连接池end-->
        <!--        导入spring上下文-->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-context</artifactId>
            <version>5.3.11</version>
        </dependency>
        <!--        导入spring上下文end-->
<!--        导入spring web开发api start-->
        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>javax.servlet-api</artifactId>
            <version>4.0.1</version>
            <scope>provided</scope>
        </dependency>
        <dependency>
            <groupId>javax.servlet.jsp</groupId>
            <artifactId>javax.servlet.jsp-api</artifactId>
            <version>2.3.3</version>
        </dependency>
        <!--        导入spring web开发end-->
<!--        导入jackson的依赖-->
        <dependency>
            <groupId>com.fasterxml.jackson.core</groupId>
            <artifactId>jackson-databind</artifactId>
            <version>2.12.1</version>
        </dependency>
    </dependencies>
</project>
web.xml




    
 
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd"
         version="4.0">
    <!--配置springMVC的编码过滤器-->
    <!--    SpringMVC中处理编码的过滤器一定要配置到其他过滤器之前，否则无效-->
    <!-- 字符集过滤器 -->
    <filter>
        <description>字符集过滤器</description>
        <filter-name>characterEncodingFilter</filter-name>
        <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
        <init-param>
            <description>字符集编码</description>
            <param-name>encoding</param-name>
            <param-value>UTF-8</param-value>
        </init-param>
        <init-param>
            <param-name>forceEncoding</param-name>
            <param-value>true</param-value>
        </init-param>
    </filter>
    <!-- 字符集拦截 -->
    <filter-mapping>
        <filter-name>characterEncodingFilter</filter-name>
        <url-pattern>/*</url-pattern>
    </filter-mapping>
    <filter>
        <filter-name>HiddenHttpMethodFilter</filter-name>
        <filter-class>org.springframework.web.filter.HiddenHttpMethodFilter</filter-class>
    </filter>
    <filter-mapping>
        <filter-name>HiddenHttpMethodFilter</filter-name>
        <url-pattern>/*</url-pattern>
    </filter-mapping>
    <!--    注册前端控制器DispatcherServlet-->
    <servlet>
        <servlet-name>DispatcherServlet</servlet-name>
        <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
        <init-param>
            <param-name>contextConfigLocation</param-name>
            <param-value>classpath:springMVC.xml</param-value>
        </init-param>
        <load-on-startup>1</load-on-startup>
    </servlet>
    <servlet-mapping>
        <servlet-name>DispatcherServlet</servlet-name>
        <url-pattern>/</url-pattern>
    </servlet-mapping>
</web-app>
springMVC.xml




    
 
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:mvc="http://www.springframework.org/schema/mvc"
       xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/mvc https://www.springframework.org/schema/mvc/spring-mvc.xsd">
    <!--    扫描组件-->
    <context:component-scan base-package="com.vector"/>
    <!-- 配置Thymeleaf视图解析器 -->
    <bean id="viewResolver" class="org.thymeleaf.spring5.view.ThymeleafViewResolver">
        <property name="order" value="1"/>
        <property name="characterEncoding" value="UTF-8"/>
        <property name="templateEngine">
            <bean class="org.thymeleaf.spring5.SpringTemplateEngine">
                <property name="templateResolver">
                    <bean class="org.thymeleaf.spring5.templateresolver.SpringResourceTemplateResolver">
                        <!-- 视图前缀 -->
                        <property name="prefix" value="/WEB-INF/templates/"/>
                        <!-- 视图后缀 -->
                        <property name="suffix" value=".html"/>
                        <property name="templateMode" value="HTML5"/>
                        <property name="characterEncoding" value="UTF-8" />
                    </bean>
                </property>
            </bean>
        </property>
    </bean>
    <!-- 处理响应中文内容乱码 -->
    <bean class="org.springframework.http.converter.StringHttpMessageConverter">
        <property name="defaultCharset" value="UTF-8" />
        <property name="supportedMediaTypes">
                <value>text/html</value>
                <value>application/json</value>
            </list>
        </property>
    </bean>
    <mvc:view-controller path="/" view-name="index"/>
    <mvc:default-servlet-handler/>
    <mvc:annotation-driven/>
</beans>
封装实体类对象
 
package com.vector.controller.pojo;
public class User {
    private Integer id;
    private String username;
    private String password;
    private Integer age;
    private String sex;
    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", username='" + username + '\'' +
                ", password='" + password + '\'' +
                ", age=" + age +
                ", sex='" + sex + '\'' +
                '}';
    public Integer getId() {
        return id;
    public void setId(Integer id) {
        this.id = id;
    public String getUsername() {
        return username;
    public void setUsername(String username) {
        this.username = username;
    public String getPassword() {
        return password;
    public void setPassword(String password) {
        this.password = password;
    public Integer getAge() {
        return age;
    public void setAge(Integer age) {
        this.age = age;
    public String getSex() {
        return sex;
    public void setSex(String sex) {
        this.sex = sex;
    public User() {
    public User(Integer id, String username, String password, Integer age, String sex) {
        this.id = id;
        this.username = username;
        this.password = password;
        this.age = age;
        this.sex = sex;
HttpController控制层




    
 
package com.vector.controller;
import com.vector.controller.pojo.User;
import org.springframework.http.RequestEntity;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.ResponseBody;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
@Controller
public class HttpController {
    @RequestMapping("/testResponseUser")
    @ResponseBody
    public User testResponseUser(){
        return new User(1001,"admin","123456",21,"male");
index.html内容
 
<!DOCTYPE html>
<html lang="en" xmlns:th="http://www.thymeleaf.org">
    <meta charset="UTF-8">
    <title>首页</title>
</head>
    <h1>首页</h1>
    <form th:action="@{/testRequestBody}" method="post">
        <input type="text" name="username">
        <input type="password" name="password">
        <input type="submit" value="测试@RequestBody">
    </form>
    <form th:action="@{/testRequestEntity}" method="post">
        <input type="text" name="username">
        <input type="password" name="password">
        <input type="submit" value="测试@RequestEntity">
    </form>
<a th:href="@{/testResponse}">通过servletAPI的response对象响应浏览器数据</a><br>
<a th:href="@{/testResponseBody}">通过servletAPI的responseBody对象响应浏览器数据</a><br>
<a th:href="@{/testResponseUser}">通过servletAPI的responseUser对象响应浏览器数据</a>
</body>
</html>

 通过这个学习.我学会了java对象转换成能被浏览器解析的json数据格式
 
				
在web开发中，前台页面经常会发送ajax请求从后台请求数据，ajax请求给前台的数据一般都是json 数据。
SpringMVC支持自动将对象转换JSON格式的数据响应给客户端
SpringMVC默认使用的是 jackson 作为对象转json的工具
第一步：在原有的基础上导入json相关依赖包
第二步：编写controller
package cn.zj.springmvc.controller;
import java.io.IOException;
import java.util.A
				
poi解析excel功能参数说明
此项目是基于springMVC实现的，基本流程为从前台jsp页面使用Ajax文件上传导入excel文件（.xls(97-03)/.xlsx(07以后)）,传到后台controller调用相应工具类解析后返回指定参数做后续处理.
1. POIUtil.java工具类
解析通过MutilpartFile导入的Excel并解析里面数据，先判断文件的类型(excel处理有两种此处为两种通用)是.xls/.xlsx，通过workbook.getNumberOfSheets()获取工作簿数量，遍历工作簿，sheet.getLastRowNum()获取最大行数，将每行数据放入List list = new Array List()，并根据excel数据类型将器转换为字符串、数字、Boolean、公式、空值类型防止出现错误，最后返回一个list.
2. ExcelUtil.java工具类
解析通过MutilpartFile导入的Excel并解析里面数据，先判断文件的类型(excel处理有两种此处为两种通用)是.xls/.xlsx，采用Apache的POI的API来操作Excel，读取内容后保存到List中，再将List转Json（使用Linked，增删快，与Excel表顺序保持一致），Sheet表1————>List1<Map>
步骤1：根据Excel版本类型创建对于的Workbook以及CellSytle
步骤2：遍历每一个表中的每一行的每一列，这里做了些小改动，因为后续可能解析过后可能会保存入数据库，这里为第一行数据添加一个自定义表头
String[] p = new String[]{"name","age","sex","tel","address","e-mail","phone"};
遍历的列数量以p的length为准
步骤3：一个sheet表就是一个Json，多表就多Json，对应一个 List
一个sheet表的一行数据就是一个 Map
一行中的一列，就把当前列头为key，列值为value存到该列的Map中
Map  一个线性Hash Map，以Excel的sheet表顺序，并以sheet表明作为key，sheet表转换Json后的字符串作为value
最后返回一个LinkedHashMap
3. ExcelToJsonPoi.java工具类
这个与上面工具类类似，不过这个是解析本地excel文件不是使用的流，使用迭代遍历sheet工作簿与每行每列的值，将所有类型作为String类型处理返回一个json对象输出至控制台
				npm安装依赖报错——npm ERR gyp verb cli的解决方法 Node Sass version 7.0.1 is incompatible with ^4.0.0. 因为在此系统上禁止运
					10158
                    买房也用券: 
                    logback从1.2.8开始已经把dbAppender从classic包中删除。需要重新下载logback-classic-db包才能支持把日志存入数据库，这是官方的原话：The DBAppender inserts logging events into three database tables in a format independent of the Java programming language.
As of logback version 1.2.8 DBAppender no longer ships with logback-classic. However, DBAppender for logback-classic is available under the following Maven coordinates:
ch.qos.logback.db:logback-classic-db:1.2.11.1
                springboot+vue音乐网站实战项目
                    呆萌小新@渊洁: 
                    不好意思,之前改名字了.https://github.com/YuanJie2001/music-backEnd
https://github.com/YuanJie2001/music-server
                springboot+vue音乐网站实战项目
                    m0_68539881: 
                    地址打不开呀，博主