springboot启动后访问URL出现空白页面

springboot启动后访问URL出现空白页面

相关截图：


http://img1.sycdn.imooc.com//climg/60209c9c09624e6624071315.jpg


控制台输出

相关代码：

D:\D1\java\jdk\jdk1.8.0_45\bin\java.exe -XX:TieredStopAtLevel=1 -noverify -Dspring.output.ansi.enabled=always -Dcom.sun.management.jmxremote -Dspring.jmx.enabled=true -Dspring.liveBeansView.mbeanDomain -Dspring.application.admin.enabled=true "-javaagent:D:\D1\IDEs\IntelliJ IDEA 2019.3.1\lib\idea_rt.jar=56863:D:\D1\IDEs\IntelliJ IDEA 2019.3.1\bin" -Dfile.encoding=UTF-8 -classpath D:\D1\java\jdk\jdk1.8.0_45\jre\lib\charsets.jar;D:\D1\java\jdk\jdk1.8.0_45\jre\lib\deploy.jar;D:\D1\java\jdk\jdk1.8.0_45\jre\lib\ext\access-bridge-64.jar;D:\D1\java\jdk\jdk1.8.0_45\jre\lib\ext\cldrdata.jar;D:\D1\java\jdk\jdk1.8.0_45\jre\lib\ext\dnsns.jar;D:\D1\java\jdk\jdk1.8.0_45\jre\lib\ext\jaccess.jar;D:\D1\java\jdk\jdk1.8.0_45\jre\lib\ext\jfxrt.jar;D:\D1\java\jdk\jdk1.8.0_45\jre\lib\ext\localedata.jar;D:\D1\java\jdk\jdk1.8.0_45\jre\lib\ext\nashorn.jar;D:\D1\java\jdk\jdk1.8.0_45\jre\lib\ext\sunec.jar;D:\D1\java\jdk\jdk1.8.0_45\jre\lib\ext\sunjce_provider.jar;D:\D1\java\jdk\jdk1.8.0_45\jre\lib\ext\sunmscapi.jar;D:\D1\java\jdk\jdk1.8.0_45\jre\lib\ext\sunpkcs11.jar;D:\D1\java\jdk\jdk1.8.0_45\jre\lib\ext\zipfs.jar;D:\D1\java\jdk\jdk1.8.0_45\jre\lib\javaws.jar;D:\D1\java\jdk\jdk1.8.0_45\jre\lib\jce.jar;D:\D1\java\jdk\jdk1.8.0_45\jre\lib\jfr.jar;D:\D1\java\jdk\jdk1.8.0_45\jre\lib\jfxswt.jar;D:\D1\java\jdk\jdk1.8.0_45\jre\lib\jsse.jar;D:\D1\java\jdk\jdk1.8.0_45\jre\lib\management-agent.jar;D:\D1\java\jdk\jdk1.8.0_45\jre\lib\plugin.jar;D:\D1\java\jdk\jdk1.8.0_45\jre\lib\resources.jar;D:\D1\java\jdk\jdk1.8.0_45\jre\lib\rt.jar;D:\D1\code\MostImportant\framework\springboot\mall\target\classes;D:\D1\java\maven\repo\org\springframework\boot\spring-boot-starter-web\2.2.1.RELEASE\spring-boot-starter-web-2.2.1.RELEASE.jar;D:\D1\java\maven\repo\org\springframework\boot\spring-boot-starter\2.2.1.RELEASE\spring-boot-starter-2.2.1.RELEASE.jar;D:\D1\java\maven\repo\org\springframework\boot\spring-boot\2.2.1.RELEASE\spring-boot-2.2.1.RELEASE.jar;D:\D1\java\maven\repo\org\springframework\boot\spring-boot-autoconfigure\2.2.1.RELEASE\spring-boot-autoconfigure-2.2.1.RELEASE.jar;D:\D1\java\maven\repo\org\springframework\boot\spring-boot-starter-logging\2.2.1.RELEASE\spring-boot-starter-logging-2.2.1.RELEASE.jar;D:\D1\java\maven\repo\ch\qos\logback\logback-classic\1.2.3\logback-classic-1.2.3.jar;D:\D1\java\maven\repo\ch\qos\logback\logback-core\1.2.3\logback-core-1.2.3.jar;D:\D1\java\maven\repo\org\apache\logging\log4j\log4j-to-slf4j\2.12.1\log4j-to-slf4j-2.12.1.jar;D:\D1\java\maven\repo\org\apache\logging\log4j\log4j-api\2.12.1\log4j-api-2.12.1.jar;D:\D1\java\maven\repo\org\slf4j\jul-to-slf4j\1.7.29\jul-to-slf4j-1.7.29.jar;D:\D1\java\maven\repo\jakarta\annotation\jakarta.annotation-api\1.3.5\jakarta.annotation-api-1.3.5.jar;D:\D1\java\maven\repo\org\yaml\snakeyaml\1.25\snakeyaml-1.25.jar;D:\D1\java\maven\repo\org\springframework\boot\spring-boot-starter-json\2.2.1.RELEASE\spring-boot-starter-json-2.2.1.RELEASE.jar;D:\D1\java\maven\repo\com\fasterxml\jackson\core\jackson-databind\2.10.0\jackson-databind-2.10.0.jar;D:\D1\java\maven\repo\com\fasterxml\jackson\core\jackson-annotations\2.10.0\jackson-annotations-2.10.0.jar;D:\D1\java\maven\repo\com\fasterxml\jackson\core\jackson-core\2.10.0\jackson-core-2.10.0.jar;D:\D1\java\maven\repo\com\fasterxml\jackson\datatype\jackson-datatype-jdk8\2.10.0\jackson-datatype-jdk8-2.10.0.jar;D:\D1\java\maven\repo\com\fasterxml\jackson\datatype\jackson-datatype-jsr310\2.10.0\jackson-datatype-jsr310-2.10.0.jar;D:\D1\java\maven\repo\com\fasterxml\jackson\module\jackson-module-parameter-names\2.10.0\jackson-module-parameter-names-2.10.0.jar;D:\D1\java\maven\repo\org\springframework\boot\spring-boot-starter-tomcat\2.2.1.RELEASE\spring-boot-starter-tomcat-2.2.1.RELEASE.jar;D:\D1\java\maven\repo\org\apache\tomcat\embed\tomcat-embed-core\9.0.27\tomcat-embed-core-9.0.27.jar;D:\D1\java\maven\repo\org\apache\tomcat\embed\tomcat-embed-el\9.0.27\tomcat-embed-el-9.0.27.jar;D:\D1\java\maven\repo\org\apache\tomcat\embed\tomcat-embed-websocket\9.0.27\tomcat-embed-websocket-9.0.27.jar;D:\D1\java\maven\repo\org\springframework\boot\spring-boot-starter-validation\2.2.1.RELEASE\spring-boot-starter-validation-2.2.1.RELEASE.jar;D:\D1\java\maven\repo\jakarta\validation\jakarta.validation-api\2.0.1\jakarta.validation-api-2.0.1.jar;D:\D1\java\maven\repo\org\hibernate\validator\hibernate-validator\6.0.18.Final\hibernate-validator-6.0.18.Final.jar;D:\D1\java\maven\repo\org\jboss\logging\jboss-logging\3.4.1.Final\jboss-logging-3.4.1.Final.jar;D:\D1\java\maven\repo\com\fasterxml\classmate\1.5.1\classmate-1.5.1.jar;D:\D1\java\maven\repo\org\springframework\spring-web\5.2.1.RELEASE\spring-web-5.2.1.RELEASE.jar;D:\D1\java\maven\repo\org\springframework\spring-beans\5.2.1.RELEASE\spring-beans-5.2.1.RELEASE.jar;D:\D1\java\maven\repo\org\springframework\spring-webmvc\5.2.1.RELEASE\spring-webmvc-5.2.1.RELEASE.jar;D:\D1\java\maven\repo\org\springframework\spring-aop\5.2.1.RELEASE\spring-aop-5.2.1.RELEASE.jar;D:\D1\java\maven\repo\org\springframework\spring-context\5.2.1.RELEASE\spring-context-5.2.1.RELEASE.jar;D:\D1\java\maven\repo\org\springframework\spring-expression\5.2.1.RELEASE\spring-expression-5.2.1.RELEASE.jar;D:\D1\java\maven\repo\org\slf4j\slf4j-api\1.7.29\slf4j-api-1.7.29.jar;D:\D1\java\maven\repo\org\springframework\spring-core\5.2.1.RELEASE\spring-core-5.2.1.RELEASE.jar;D:\D1\java\maven\repo\org\springframework\spring-jcl\5.2.1.RELEASE\spring-jcl-5.2.1.RELEASE.jar;D:\D1\java\maven\repo\org\mybatis\spring\boot\mybatis-spring-boot-starter\1.3.2\mybatis-spring-boot-starter-1.3.2.jar;D:\D1\java\maven\repo\org\springframework\boot\spring-boot-starter-jdbc\2.2.1.RELEASE\spring-boot-starter-jdbc-2.2.1.RELEASE.jar;D:\D1\java\maven\repo\com\zaxxer\HikariCP\3.4.1\HikariCP-3.4.1.jar;D:\D1\java\maven\repo\org\springframework\spring-jdbc\5.2.1.RELEASE\spring-jdbc-5.2.1.RELEASE.jar;D:\D1\java\maven\repo\org\springframework\spring-tx\5.2.1.RELEASE\spring-tx-5.2.1.RELEASE.jar;D:\D1\java\maven\repo\org\mybatis\spring\boot\mybatis-spring-boot-autoconfigure\1.3.2\mybatis-spring-boot-autoconfigure-1.3.2.jar;D:\D1\java\maven\repo\org\mybatis\mybatis\3.4.6\mybatis-3.4.6.jar;D:\D1\java\maven\repo\org\mybatis\mybatis-spring\1.3.2\mybatis-spring-1.3.2.jar;D:\D1\java\maven\repo\mysql\mysql-connector-java\8.0.18\mysql-connector-java-8.0.18.jar com.fanyu.mall.MallApplication

  .   ____          _            __ _ _
 /\\ / ___'_ __ _ _(_)_ __  __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
 \\/  ___)| |_)| | | | | || (_| |  ) ) ) )
  '  |____| .__|_| |_|_| |_\__, | / / / /
 =========|_|==============|___/=/_/_/_/
 :: Spring Boot ::        (v2.2.1.RELEASE)

2021-02-08 10:16:14.506  INFO 2936 --- [           main] com.fanyu.mall.MallApplication           : Starting MallApplication on LAPTOP-LMMPH4VI with PID 2936 (D:\D1\code\MostImportant\framework\springboot\mall\target\classes started by darli in D:\D1\code\MostImportant\framework\springboot\mall)
2021-02-08 10:16:14.506  INFO 2936 --- [           main] com.fanyu.mall.MallApplication           : No active profile set, falling back to default profiles: default
2021-02-08 10:16:15.874  INFO 2936 --- [           main] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat initialized with port(s): 8083 (http)
2021-02-08 10:16:15.874  INFO 2936 --- [           main] o.apache.catalina.core.StandardService   : Starting service [Tomcat]
2021-02-08 10:16:15.874  INFO 2936 --- [           main] org.apache.catalina.core.StandardEngine  : Starting Servlet engine: [Apache Tomcat/9.0.27]
2021-02-08 10:16:15.874  INFO 2936 --- [           main] o.a.catalina.core.AprLifecycleListener   : An older version [1.2.19] of the APR based Apache Tomcat Native library is installed, while Tomcat recommends a minimum version of [1.2.23]
2021-02-08 10:16:15.890  INFO 2936 --- [           main] o.a.catalina.core.AprLifecycleListener   : Loaded APR based Apache Tomcat Native library [1.2.19] using APR version [1.6.5].
2021-02-08 10:16:15.890  INFO 2936 --- [           main] o.a.catalina.core.AprLifecycleListener   : APR capabilities: IPv6 [true], sendfile [true], accept filters [false], random [true].
2021-02-08 10:16:15.890  INFO 2936 --- [           main] o.a.catalina.core.AprLifecycleListener   : APR/OpenSSL configuration: useAprConnector [false], useOpenSSL [true]
2021-02-08 10:16:15.890  INFO 2936 --- [           main] o.a.catalina.core.AprLifecycleListener   : OpenSSL successfully initialized [OpenSSL 1.1.1a  20 Nov 2018]
2021-02-08 10:16:15.939  INFO 2936 --- [           main] o.a.c.c.C.[Tomcat].[localhost].[/]       : Initializing Spring embedded WebApplicationContext
2021-02-08 10:16:15.939  INFO 2936 --- [           main] o.s.web.context.ContextLoader            : Root WebApplicationContext: initialization completed in 1385 ms
2021-02-08 10:16:16.256  INFO 2936 --- [           main] o.s.s.concurrent.ThreadPoolTaskExecutor  : Initializing ExecutorService 'applicationTaskExecutor'
2021-02-08 10:16:16.378  INFO 2936 --- [           main] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat started on port(s): 8083 (http) with context path ''
2021-02-08 10:16:16.378  INFO 2936 --- [           main] com.fanyu.mall.MallApplication           : Started MallApplication in 2.203 seconds (JVM running for 2.944)
2021-02-08 10:16:23.350  INFO 2936 --- [nio-8083-exec-1] o.a.c.c.C.[Tomcat].[localhost].[/]       : Initializing Spring DispatcherServlet 'dispatcherServlet'
2021-02-08 10:16:23.350  INFO 2936 --- [nio-8083-exec-1] o.s.web.servlet.DispatcherServlet        : Initializing Servlet 'dispatcherServlet'
2021-02-08 10:16:23.352  INFO 2936 --- [nio-8083-exec-1] o.s.web.servlet.DispatcherServlet        : Completed initialization in 2 ms
2021-02-08 10:16:23.368  INFO 2936 --- [nio-8083-exec-1] com.zaxxer.hikari.HikariDataSource       : com_fanyu_datasource - Starting...
2021-02-08 10:16:23.578  INFO 2936 --- [nio-8083-exec-1] com.zaxxer.hikari.HikariDataSource       : com_fanyu_datasource - Start completed.


generatorConfig.xml：

相关代码：

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE generatorConfiguration
  PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
  "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
<generatorConfiguration>
  <!-- 配置文件，放在resource目录下即可 -->
  <!--数据库驱动个人配置-->
  <classPathEntry
    location="D:/D1/code/MostImportant/framework/springboot/mall/src/main/resources/mysql-connector-java-8.0.18.jar"/>
  <context id="MysqlTables" targetRuntime="MyBatis3">
    <property name="autoDelimitKeywords" value="true"/>
    <!--可以使用``包括字段名，避免字段名与sql保留字冲突报错-->
    <property name="beginningDelimiter" value="`"/>
    <property name="endingDelimiter" value="`"/>
    <!-- optional，旨在创建class时，对注释进行控制 -->
    <commentGenerator>
      <property name="suppressDate" value="true"/>
      <property name="suppressAllComments" value="true"/>
    </commentGenerator>
    <!--数据库链接地址账号密码-->
    <jdbcConnection driverClass="com.mysql.cj.jdbc.Driver"
      connectionURL="jdbc:mysql://127.0.0.1:3306/fanyu_mall?useUnicode=true&amp;serverTimezone=Asia/Shanghai&amp;characterEncoding=UTF-8&amp;zeroDateTimeBehavior=convertToNull"
      userId="root"
      password="123456">
      <property name="nullCatalogMeansCurrent" value="true"/>
    </jdbcConnection>
    <!-- 非必需，类型处理器，在数据库类型和java类型之间的转换控制-->
    <javaTypeResolver>
      <property name="forceBigDecimals" value="false"/>
    </javaTypeResolver>
    <!--生成Model类存放位置-->
    <javaModelGenerator targetPackage="com.fanyu.mall.model.pojo"
      targetProject="src/main/java">
      <!-- 是否允许子包，即targetPackage.schemaName.tableName -->
      <property name="enableSubPackages" value="true"/>
      <!-- 是否对类CHAR类型的列的数据进行trim操作 -->
      <property name="trimStrings" value="true"/>
      <!-- 建立的Model对象是否 不可改变  即生成的Model对象不会有 setter方法，只有构造方法 -->
      <property name="immutable" value="false"/>
    </javaModelGenerator>
    <!--生成mapper映射文件存放位置-->
    <sqlMapGenerator targetPackage="mappers" targetProject="src/main/resources">
      <property name="enableSubPackages" value="true"/>
    </sqlMapGenerator>
    <!--生成Dao类存放位置-->
    <javaClientGenerator type="XMLMAPPER" targetPackage="com.fanyu.mall.model.dao"
      targetProject="src/main/java">
      <property name="enableSubPackages" value="true"/>
    </javaClientGenerator>
    <!--生成对应表及类名-->
    <table schema="root" tableName="fanyu_mall_cart" domainObjectName="Cart"
      enableCountByExample="false"
      enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false"
      selectByExampleQueryId="false">
    </table>
    <table tableName="fanyu_mall_category" domainObjectName="Category" enableCountByExample="false"
      enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false"
      selectByExampleQueryId="false">
    </table>
    <table tableName="fanyu_mall_order" domainObjectName="Order" enableCountByExample="false"
      enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false"
      selectByExampleQueryId="false">
    </table>
    <table tableName="fanyu_mall_order_item" domainObjectName="OrderItem"
      enableCountByExample="false"
      enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false"
      selectByExampleQueryId="false">
    </table>
    <table tableName="fanyu_mall_product" domainObjectName="Product" enableCountByExample="false"
      enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false"
      selectByExampleQueryId="false">
    </table>
    <table tableName="fanyu_mall_user" domainObjectName="User" enableCountByExample="false"
      enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false"
      selectByExampleQueryId="false">
    </table>

  </context>
</generatorConfiguration>

application.properties

相关代码：

spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.url=jdbc:mysql://localhost:3306/fanyu_mall?serverTimezone=Asia/Shanghai&useUnicode
=true&characterEncoding=utf-8&useSSL=true
spring.datasource.name=com_fanyu_datasource

mybatis.mapper-locations=classpath:mappers/*.xml

server.port=8083

User类：

相关代码：

package com.fanyu.mall.model.pojo;

import java.util.Date;

public class User {
    private Integer id;

    private String username;

    private String password;

    private String personalizedSignature;

    private Integer role;

    private Date createTime;

    private Date updateTime;

    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 == null ? null : username.trim();
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password == null ? null : password.trim();
    }

    public String getPersonalizedSignature() {
        return personalizedSignature;
    }

    public void setPersonalizedSignature(String personalizedSignature) {
        this.personalizedSignature = personalizedSignature == null ? null : personalizedSignature.trim();
    }

    public Integer getRole() {
        return role;
    }

    public void setRole(Integer role) {
        this.role = role;
    }

    public Date getCreateTime() {
        return createTime;
    }

    public void setCreateTime(Date createTime) {
        this.createTime = createTime;
    }

    public Date getUpdateTime() {
        return updateTime;
    }

    public void setUpdateTime(Date updateTime) {
        this.updateTime = updateTime;
    }
}

UserMapper

相关代码：

package com.fanyu.mall.model.dao;

import com.fanyu.mall.model.pojo.User;
import org.springframework.stereotype.Repository;

@Repository
public interface UserMapper {
    int deleteByPrimaryKey(Integer id);

    int insert(User record);

    int insertSelective(User record);

    User selectByPrimaryKey(Integer id);

    int updateByPrimaryKeySelective(User record);

    int updateByPrimaryKey(User record);
}

UserService

相关代码：

package com.fanyu.mall.service;

import com.fanyu.mall.model.pojo.User;

public interface UserService {

    User getUser();
}


UserMapper.xml

相关代码：

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.fanyu.mall.model.dao.UserMapper">
  <resultMap id="BaseResultMap" type="com.fanyu.mall.model.pojo.User">
    <id column="id" jdbcType="INTEGER" property="id" />
    <result column="username" jdbcType="VARCHAR" property="username" />
    <result column="password" jdbcType="VARCHAR" property="password" />
    <result column="personalized_signature" jdbcType="VARCHAR" property="personalizedSignature" />
    <result column="role" jdbcType="INTEGER" property="role" />
    <result column="create_time" jdbcType="TIMESTAMP" property="createTime" />
    <result column="update_time" jdbcType="TIMESTAMP" property="updateTime" />
  </resultMap>
  <sql id="Base_Column_List">
    id, username, `password`, personalized_signature, `role`, create_time, update_time
  </sql>
  <select id="selectByPrimaryKey" parameterType="java.lang.Integer" resultMap="BaseResultMap">
    select 
    <include refid="Base_Column_List" />
    from fanyu_mall_user
    where id = #{id,jdbcType=INTEGER}
  </select>
  <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer">
    delete from fanyu_mall_user
    where id = #{id,jdbcType=INTEGER}
  </delete>
  <insert id="insert" parameterType="com.fanyu.mall.model.pojo.User">
    insert into fanyu_mall_user (id, username, `password`, 
      personalized_signature, `role`, create_time, 
      update_time)
    values (#{id,jdbcType=INTEGER}, #{username,jdbcType=VARCHAR}, #{password,jdbcType=VARCHAR}, 
      #{personalizedSignature,jdbcType=VARCHAR}, #{role,jdbcType=INTEGER}, #{createTime,jdbcType=TIMESTAMP}, 
      #{updateTime,jdbcType=TIMESTAMP})
  </insert>
  <insert id="insertSelective" parameterType="com.fanyu.mall.model.pojo.User">
    insert into fanyu_mall_user
    <trim prefix="(" suffix=")" suffixOverrides=",">
      <if test="id != null">
        id,
      </if>
      <if test="username != null">
        username,
      </if>
      <if test="password != null">
        `password`,
      </if>
      <if test="personalizedSignature != null">
        personalized_signature,
      </if>
      <if test="role != null">
        `role`,
      </if>
      <if test="createTime != null">
        create_time,
      </if>
      <if test="updateTime != null">
        update_time,
      </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides=",">
      <if test="id != null">
        #{id,jdbcType=INTEGER},
      </if>
      <if test="username != null">
        #{username,jdbcType=VARCHAR},
      </if>
      <if test="password != null">
        #{password,jdbcType=VARCHAR},
      </if>
      <if test="personalizedSignature != null">
        #{personalizedSignature,jdbcType=VARCHAR},
      </if>
      <if test="role != null">
        #{role,jdbcType=INTEGER},
      </if>
      <if test="createTime != null">
        #{createTime,jdbcType=TIMESTAMP},
      </if>
      <if test="updateTime != null">
        #{updateTime,jdbcType=TIMESTAMP},
      </if>
    </trim>
  </insert>
  <update id="updateByPrimaryKeySelective" parameterType="com.fanyu.mall.model.pojo.User">
    update fanyu_mall_user
    <set>
      <if test="username != null">
        username = #{username,jdbcType=VARCHAR},
      </if>
      <if test="password != null">
        `password` = #{password,jdbcType=VARCHAR},
      </if>
      <if test="personalizedSignature != null">
        personalized_signature = #{personalizedSignature,jdbcType=VARCHAR},
      </if>
      <if test="role != null">
        `role` = #{role,jdbcType=INTEGER},
      </if>
      <if test="createTime != null">
        create_time = #{createTime,jdbcType=TIMESTAMP},
      </if>
      <if test="updateTime != null">
        update_time = #{updateTime,jdbcType=TIMESTAMP},
      </if>
    </set>
    where id = #{id,jdbcType=INTEGER}
  </update>
  <update id="updateByPrimaryKey" parameterType="com.fanyu.mall.model.pojo.User">
    update fanyu_mall_user
    set username = #{username,jdbcType=VARCHAR},
      `password` = #{password,jdbcType=VARCHAR},
      personalized_signature = #{personalizedSignature,jdbcType=VARCHAR},
      `role` = #{role,jdbcType=INTEGER},
      create_time = #{createTime,jdbcType=TIMESTAMP},
      update_time = #{updateTime,jdbcType=TIMESTAMP}
    where id = #{id,jdbcType=INTEGER}
  </update>
</mapper>


UserServiceImlp

相关代码：

package com.fanyu.mall.service.impl;

import com.fanyu.mall.model.dao.UserMapper;
import com.fanyu.mall.model.pojo.User;
import com.fanyu.mall.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

@Service
public class UserServiceImpl implements UserService {
    @Autowired
    private UserMapper userMapper;
    @Override
    public User getUser() {
        return userMapper.selectByPrimaryKey(3);
    }
}

UserController

相关代码：

package com.fanyu.mall.controller;

import com.fanyu.mall.model.pojo.User;
import com.fanyu.mall.service.UserService;
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.ResponseBody;

@Controller
public class UserController {
    @Autowired
    UserService userService;
    @GetMapping("/test")
    @ResponseBody  //这个注解表明返回json格式的内容
    public User findUser(){
        return userService.getUser();
    }
}

启动类：

相关代码：

package com.fanyu.mall;

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

@SpringBootApplication
@MapperScan(basePackages = "com.fanyu.mall.model.dao")
public class MallApplication {

    public static void main(String[] args) {
        SpringApplication.run(MallApplication.class, args);
    }

}

辛苦老师解答
cloudonthesun 2021-02-07
源自：Spring Boot电商项目   3-4 打通数据库链路
44
收起

正在回答 回答被采纳积分+1

登陆购买课程后可参与讨论，去登陆吧

2回答
好帮手慕小脸 2021-02-08 18:25:26

同学你好，建议同学在启动类上加如下注解再试试。

​http://img1.sycdn.imooc.com//climg/602111920968ab6607780352.jpg

祝学习愉快~

0
收起回答
点开查看后面1条评论
好帮手慕小脸 2021-02-08 10:44:29

同学你好，findUser是方法名，这里同学访问有误，应访问test才可以，如下：

http://img1.sycdn.imooc.com//climg/6020a56a09e38d5202920055.jpg

祝学习愉快~

1
收起回答
  • 提问者 cloudonthesun #1

    http://img1.sycdn.imooc.com//climg/6020bd7309997a1018230846.jpg

    老师，访问test也是这样

    2021-02-08 12:26:48
  • 好帮手慕小脸 回复 提问者 cloudonthesun #2

    同学你好，测试运行上述代码是可以正确访问的，这里建议同学检查自己的编译目录是否正确编译：

    ​http://img1.sycdn.imooc.com//climg/6020e579093e4c6c13700344.jpg

    祝学习愉快~

    2021-02-08 15:17:29
  • 提问者 cloudonthesun 回复 好帮手慕小脸 #3

    编译目录是这样，

    http://img1.sycdn.imooc.com//climg/6020f43b095368fd20661139.jpg​

    2021-02-08 16:26:39
点开查看后面1条评论
问题已解决，确定采纳
还有疑问，暂不采纳

恭喜解决一个难题，获得1积分~

来为老师/同学的回答评分吧

0 星

相似问题

好几次按照视频启动以后页面是空白的？
0 0 9
访问tomcat页面显示空白页
24 0 3
idea 怎么访问默认网页
3 0 11
老师，跳转出现空白页面。
33 0 10
网页存在白板页面
13 0 4

登录后可查看更多问答，登录/注册

java工程师2020版
  • 参与学习           人
  • 提交作业       9410    份
  • 解答问题       16556    个

综合就业常年第一，编程排行常年霸榜，无需脱产即可学习，北上广深月薪过万 无论你是未就业的学生还是想转行的在职人员，不需要基础，只要你有梦想，想高薪

了解课程

本课精华内容

问答 作业

安装了MySQL 之后有时候自己会跳出来个黑窗口是为什么呢？

80 1

什么时候用List中的ArrayList呢，什么时候用HashSet，什么时候应该用HashMap

81 1

创建字符串的过程理解

62 1

如何干净的卸载数据库

135 1

请教一下没太懂

48 3

查看更多本课问答
请稍等 ...
微信客服

购课补贴
联系客服咨询优惠详情

 帮助反馈 APP下载

慕课网APP
您的移动学习伙伴

 公众号

扫描二维码
关注慕课网微信公众号

在线咨询

领取优惠

免费试听

领取大纲

扫描二维码，添加
你的专属老师