泗水六年的博客

mysql计算某列数据的除数并保留两位小数。

【代码】springboot项目启动后创建文件夹。

第一种：原符号 < >=&'"替换符号 < <=>>=&&apos; "第二种：大于等于 = ]]>小于等于

SpringBoot官方对我们平时开发过程中涉及到的场景(数据访问，Web开发)封装成一个个的启动器，我们只需要在项目中引入某个场景的启动器，则该场景相关的所有依赖都会被导入进来，而且会为我们进行自动配置。...

我理解的SpringBoot优点呢，有三个，第一个就是使用SpringBoot可以快速的构建出来一个可以独立运行Spring项目。第三个就是SpringBoot内嵌了很多Servlet容器，比如说tomcat/jetty，使得我们无需依赖外部的Servlet容器就可以运行我们的项目。接下来我也来说说我认为的SpringBoot的缺点吧，第一个就是SpringBoot的版本迭代很快，有些模块可能会有很大改动，如果对现有的SpringBoot版本进行升级，有可能会带来一些问题。...

我对SpringBoot的理解就是SpringBoot是一个用于快速构建项目和简化开发的框架，我认为SpringBoot最大的一个特点就是自动配置。SpringBoot官方对我们平时开发过程中涉及到的场景(数据访问，Web开发)封装成一个个的启动器，我们只需要在项目中引入某个场景的启动器，则该场景相关的所有依赖都会被导入进来，而且会为我们进行自动配置。...

1.问题2020-10-28 16:09:41.918 ERROR 8908 --- [io-13000-exec-1] o.h.engine.jdbc.spi.SqlExceptionHelper : Unknown column 'org0_.create_by' in 'field list'2020-10-28 16:09:55.154 ERROR 8908 --- [io-13000-exec-1] c.y.a.controller.v1.org.OrgController : o...

错误：sql语句中尽量不要使用*，只查询需要的字段出来。解决：select id,tran_code,tran_name,tran_date,tran_time,tran_amount,1 as count from app_cash_trans_log order by app_cash_trans_log.id desc limit 5select id,tran_code,tran_name,tran_date,tran_time,tran_amount,1 as count from ap

错误：idea:2020-12-23 17:11:18.611 ERROR 2572 --- [MessageBroker-2] o.h.engine.jdbc.spi.SqlExceptionHelper : Column 'create_by' not found.2020-12-23 17:11:18.619 ERROR 2572 --- [MessageBroker-2] c.y.a.controller.v1.trans.TransMonitor : 获取连续交易失败：[could ..

错误：idea：2020-12-23 15:26:13.885 ERROR 17972 --- [MessageBroker-2] o.h.engine.jdbc.spi.SqlExceptionHelper : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'count >.

错误1：mysql：select * ,count(*)as count from app_cash_trans_log group by app_cash_trans_log.tran_code having count(*)>=(select pla_config.cfg_value from pla_config where pla_config.cfg_name='tranMaxContinuity') order by app_cash_trans_log.id desc limit 5

问题：2020-11-12 15:15:14.082 WARN 15972 --- [ main] ConfigServletWebServerApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creat...

getJPAQueryFactory与getJPAQuery使用？JPAQueryFactoryJPAQuery//用这个例如： public QueryResults<CardParameterTemplate> getCardType(Pageable pageable, CardParameterTemplateQuery cardTypeQuery) { JPAQuery jpaQuery = cardTypeDao.getJPAQuery();

问题：Hibernate: insert into vm_card_parameter_template (template_name) values (?)2021-05-11 13:56:18.342 WARN 19100 --- [io-12000-exec-3] o.h.engine.jdbc.spi.SqlExceptionHelper : SQL Error: 1054, SQLState: 42S222021-05-11 13:56:18.342 ERROR 19100 --- [..

问题：2021-05-07 16:40:02.003 INFO 25776 --- [io-12000-exec-1] c.y.cols.controller.CardTypeController :{FITVersion=00000001, RecordsSupported=[{MatchOffset=1, MatchTrack=3}, {MatchOffset=1, MatchTrack=3}, {MatchOffset=1, MatchTrack=3}, {MatchOffset=1, M...

问题：{ "success": false, "code": "S0000", "error": "null [java.lang.IndexOutOfBoundsException,Index: 5, Size: 5]", "serviceName": "cols-service", "paramErrors": null}原因：HashMap<String, Object> objectHashMap = new HashMap<>...

问题：{ "success": false, "code": "S0000", "error": "null [org.springframework.web.method.annotation.MethodArgumentTypeMismatchException,Failed to convert value of type 'java.lang.String' to required type 'java.lang.Integer'; nested exception is ...

注解整理1、实体类中：@Data@Entity@Table(name="vm_card_type")@GeneratedValue(strategy = GenerationType.AUTO,generator = "SEQ_vm_card_trans_log")@SequenceGenerator(name = "SEQ_vm_card_trans_log",sequenceName = "SEQ_vm_card_trans_log")@Id@Column(name = "id")例如：

问题：2021-04-29 15:06:16.795 ERROR 30460 --- [io-12000-exec-1] c.y.w.c.GlobalControllerExceptionHandler : Exception: Required request body is missing: public org.springframework.ui.ModelMap cn.yihuazt.cols.controller.CardTypeController.deleteCardType(long)原

问题：2021-04-29 14:45:50.871 ERROR 8324 --- [io-12000-exec-8] c.y.cols.controller.CardTypeController : 修改失败：Method Not Implemented!原因：CardType cardType1 = cardTypeService.findById(cardType.getId());findById方法是IBaseService的方法，没有被CardService实现。解决：@PutMap.

问题：Hibernate: insert into vm_card_type (type_name) values (?)2021-04-29 14:37:17.522 WARN 13112 --- [io-12000-exec-5] o.h.engine.jdbc.spi.SqlExceptionHelper : SQL Error: 1048, SQLState: 230002021-04-29 14:37:17.522 ERROR 13112 --- [io-12000-exec-5] o..

HttpJsonResult：用在select方法中ModelMap：用在insert，update，delete方法中例如：/** * 查询卡信息 * @param pageable * @param query * @return */@ApiPermission@RequestMapping(method = RequestMethod.GET)public HttpJsonResult<Card> searchParams(Pageable pageable,

问题：Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled.2021-04-28 10:19:01.135 ERROR 19308 --- [ main] o.s.boot.SpringApplication : Application run failedorg.springfra...

问题：2021-04-27 19:48:09.528 ERROR 27192 --- [ main] o.s.b.d.LoggingFailureAnalysisReporter :***************************APPLICATION FAILED TO START***************************Description:Field cardTypeService in cn.yihuazt.cols.controlle...

问题：2021-03-24 17:31:05.391 ERROR 12756 --- [io-12000-exec-2] c.y.w.c.GlobalControllerExceptionHandler : Exception: Missing URI template variable 'id' for method parameter of type Long原因：id在接口中没有定义成参数，去掉@PathVariable解决：@DeleteMapping("/delete")@Ap

SpringBoot项目打成War包1. 首先在pom.xml里添加Tomcat依赖 <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-tomcat</artifactId> <scope>provided</scope> <...

idea2020.1使用Lombok注解，点击运行项目提示找不到get,set方法？javabean：@Datapublic class ReponseData { private Map<String,String> head; private Map<String,Object> body;}问题解决（1）查看IDEA中是否正确安装了Lombok插件并开启了使用（2）普通项目没有默认开启注解生成器找到 File | Settings | Buil...

1、问题Cannot resolve plugin org.springframework.boot:spring-boot-maven-plugin:2.2.6.RELEASECannot resolve plugin org.apache.maven.plugins:maven-resources-plugin:3.1.0Cannot resolve plugin org.apache.maven.plugins:maven-jar-plugin:3.1.22、原因：mav.

1、问题：Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled.2020-05-04 00:17:07.847 ERROR 6192 --- [ main] o.s.b.d.LoggingFailureAnalysisReporter :***************************A...

1、问题：com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failureThe last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.at com.mysql.cj.jdbc.exceptions.SQLE

1、问题：java.sql.SQLSyntaxErrorException: Table 'sell.hibernate_sequence' doesn't existat com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)at com.my

1、问题：Error:(29, 41) java: 无法将类 com.imooc.dataobject.ProductCategory中的构造器 ProductCategory应用到给定类型;需要: java.lang.String,java.lang.Integer找到: 没有参数原因: 实际参数列表和形式参数列表长度不同Error:(44, 41) java: 无法将类 com.imooc.dataobject.ProductCategory中的构造器 Produc...

1、问题：java.lang.Exception: No runnable methodsat org.junit.runners.BlockJUnit4ClassRunner.validateInstanceMethods(BlockJUnit4ClassRunner.java:191)at org.junit.runners.BlockJUnit4ClassRunner.collectInitializationErrors(BlockJUnit4ClassRunner.java:.

1、问题：2、原因：springboot版本问题3、解决：降低springboot版本

1、问题：Whitelabel Error PageThis application has no explicit mapping for /error, so you are seeing this as a fallback.Tue May 05 15:46:50 CST 2020There was an unexpected error (type=Not Found, status=404).No message available2、原因：server格式错.

win7下hosts文件位置

异常捕获，返回错误码code给前端

1、端口8080被占用解决办法方法一：点击左下角“开始”，在搜索框中输入“cmd”回车;在命令行输入“netstat -ano”回车;找到需要关闭的端口对应的PID;打开“任务管理器”找到PID;选中，点击“结束进程”即可。方法二：查看被占用的端口号：netstat -ano | findstr 8080杀死占用的端口号taskkill /pid 1604 /f补充：查看pid 1604对应的应用：tasklist|findstr “160..

修改模板文件后，Build Project(ctrl+F9)可以快速运行

success.ftlh与error.ftlh