动吧项目第一天（202093）

tech2022-09-17 102

项目经验

在项目中，有时会给你一个sql文件，此时应谨慎小心如下面这张图，打开sql后，存在一条删除数据库语句，有可能所在公司存在这样一个同名数据库，而且还是公司需要用的，此时执行sql文件会删除数据库若已经误删，此时可以找teamleader沟通，查看有无备份，另外对于某些数据库有恢复数据的功能

动吧旅游生态系统

1、项目简介

1.1、原型分析

基于用户需求,进行原型设计（基于html+css+js进行静态页面实现）。例如系统登录页面: 系统登录成功页面(例如starter.html) 菜单展示页面

1.2、应用分层

参照阿里开发手册嵩山版

1.3、API应用架构

1.2、项目开始

1.2.3、环境准备

启动mysql客户端并登陆，然后执行 1）set names utf8 2)source d:/jtsys.sql 假如在mysql客户端查询表中的数据，可以先执行set names gbk，否则可能会出现乱码在数据库操作中，输入status可以查看编码相关属性 client:客户端编码 conn:连接编码

1.2.4、创建项目

导入依赖 yml文件配置编写yml文件时，一定要注意行与行之间的缩进（有缩进就成，不用在乎几个空格；平级间缩进相同），属性名和属性值之间的空格编写yml文件时，可能因为网络原因导致没有提示，一般关闭，选择合适打开方式再试或者其他行重复试一试，也有可能入idea需要开启此功能

注意配置文件中加入 logging:level:com.cy: debug 后，会将com.cy中方法进行的操作信息打印到控制台中，方便查找bug

引入相关文件

1.2.5、编辑项目

创建通用conreoller 启动项目测试经典错误剖析当浏览器访问地址时，报了500错误，一般情况下我们发现500错误后去查看后端服务器代码，但这个问题特殊在可能是前端问题，比如说前端取值失败在代码中的体现浏览器中报错 Whitelabel Error Page This application has no explicit mapping for /error, so you are seeing this as a fallback.

Thu Sep 03 14:39:15 CST 2020 There was an unexpected error (type=Internal Server Error, status=500). An error happened during template parsing (template: “class path resource [templates/pages/starter.html]”) org.thymeleaf.exceptions.TemplateInputException: An error happened during template parsing (template: “class path resource [templates/pages/starter.html]”) at org.thymeleaf.templateparser.markup.AbstractMarkupTemplateParser.parse(AbstractMarkupTemplateParser.java:241) at org.thymeleaf.templateparser.markup.AbstractMarkupTemplateParser.parseStandalone(AbstractMarkupTemplateParser.java:100) at org.thymeleaf.engine.TemplateManager.parseAndProcess(TemplateManager.java:666) at org.thymeleaf.TemplateEngine.process(TemplateEngine.java:1098) at org.thymeleaf.TemplateEngine.process(TemplateEngine.java:1072) at org.thymeleaf.spring5.view.ThymeleafView.renderFragment(ThymeleafView.java:362) at org.thymeleaf.spring5.view.ThymeleafView.render(ThymeleafView.java:189) at org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1373) at org.springframework.web.servlet.DispatcherServlet.processDispatchResult(DispatcherServlet.java:1118) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1057) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006) at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898) at javax.servlet.http.HttpServlet.service(HttpServlet.java:626) at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883) at javax.servlet.http.HttpServlet.service(HttpServlet.java:733) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:93) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:373) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol $C o n n e c t i o n H a n d l e r . p r o c e s s (A b s t r a c t P r o t o c o l . j a v a : 868) a t o r g . a p a c h e . t o m c a t . u t i l . n e t . N i o E n d p o i n t$ SocketProcessor.doRun(NioEndpoint.java:1589) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor $W o r k e r . r u n (T h r e a d P o o l E x e c u t o r . j a v a : 617) a t o r g . a p a c h e . t o m c a t . u t i l . t h r e a d s . T a s k T h r e a d$ WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745) Caused by: org.attoparser.ParseException: Exception evaluating SpringEL expression: “user.username” (template: “starter” - line 184, col 58) at org.attoparser.MarkupParser.parseDocument(MarkupParser.java:393) at org.attoparser.MarkupParser.parse(MarkupParser.java:257) at org.thymeleaf.templateparser.markup.AbstractMarkupTemplateParser.parse(AbstractMarkupTemplateParser.java:230) … 52 more Caused by: org.thymeleaf.exceptions.TemplateProcessingException: Exception evaluating SpringEL expression: “user.username” (template: “starter” - line 184, col 58) at org.thymeleaf.spring5.expression.SPELVariableExpressionEvaluator.evaluate(SPELVariableExpressionEvaluator.java:290) at org.thymeleaf.standard.expression.VariableExpression.executeVariableExpression(VariableExpression.java:166) at org.thymeleaf.standard.expression.SimpleExpression.executeSimple(SimpleExpression.java:66) at org.thymeleaf.standard.expression.Expression.execute(Expression.java:109) at org.thymeleaf.standard.expression.Expression.execute(Expression.java:138) at org.thymeleaf.standard.processor.AbstractStandardExpressionAttributeTagProcessor.doProcess(AbstractStandardExpressionAttributeTagProcessor.java:144) at org.thymeleaf.processor.element.AbstractAttributeTagProcessor.doProcess(AbstractAttributeTagProcessor.java:74) at org.thymeleaf.processor.element.AbstractElementTagProcessor.process(AbstractElementTagProcessor.java:95) at org.thymeleaf.util.ProcessorConfigurationUtils$ElementTagProcessorWrapper.process(ProcessorConfigurationUtils.java:633) at org.thymeleaf.engine.ProcessorTemplateHandler.handleOpenElement(ProcessorTemplateHandler.java:1314) at org.thymeleaf.engine.TemplateHandlerAdapterMarkupHandler.handleOpenElementEnd(TemplateHandlerAdapterMark 经典错误剖析出现上图的异常原因是css样式未成功加载，解决的方法是f12查看控制台中css加载路径

然后查看项目中的目录结构经过检查，resource下面是没有page目录的，然后我们检查controller与web资源我们的解决方式，也可以将静态web资源掐面加斜杠，加斜杠后默认拼接在端口号后面

页面响应式布局采用bootstrap框架，动态的设置高度和宽度 bootstrap模板网址：adminlte.io

1.3、日志模块

在设计表时，可以将字段默认值设置为别的值，太多的null会影响查询性能。

设计思想

当一个页面会被多个页面引用时，可以把它独立出去，从而达到被多个页面引用

注册点击事件函数

查看页面元素的方法：浏览器窗口先f12在f10,然后将鼠标移到你需要查看的页面元素，就会显示出该页面元素的id值。 js函数最好写在页面元素下面，为了防止加载js函数时，由于页面元素未加载上。导致js函数未被注册上的问题；或者用$(function(){})将代码包起来，此函数页面加载完成以后执行。项目中的一些概念

最新回复(0)