java.net.SocketException: Software caused connection abort: socket write erro问题-程序员宅基地

技术标签: 错误问题总结  

导出报错

  1. 所有导出excel无法实现,查询的所有的导出都有问题

ClientAbortException:  java.net.SocketException: Software caused connection abort: socket write error

at org.apache.catalina.connector.OutputBuffer.realWriteBytes(OutputBuffer.java:413)

at org.apache.tomcat.util.buf.ByteChunk.append(ByteChunk.java:371)

at org.apache.catalina.connector.OutputBuffer.writeBytes(OutputBuffer.java:438)

at org.apache.catalina.connector.OutputBuffer.write(OutputBuffer.java:426)

at org.apache.catalina.connector.CoyoteOutputStream.write(CoyoteOutputStream.java:91)

at java.io.BufferedOutputStream.write(BufferedOutputStream.java:122)

at java.io.FilterOutputStream.write(FilterOutputStream.java:97)

at com.googosoft.controller.base.FileController.fileDownload(FileController.java:116)

at sun.reflect.GeneratedMethodAccessor38.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:606)

at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:215)

at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)

at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)

at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:745)

at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:685)

at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80)

at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:919)

at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:851)

at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:953)

at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:855)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)

at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:829)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)

at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:106)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61)

at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)

at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)

at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)

at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)

at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449)

at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365)

at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)

at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)

at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:383)

at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)

at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)

at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343)

at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)

at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)

at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1041)

at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:603)

at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

at java.lang.Thread.run(Thread.java:745)

Caused by: java.net.SocketException: Software caused connection abort: socket write error

at java.net.SocketOutputStream.socketWrite0(Native Method)

at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:113)

at java.net.SocketOutputStream.write(SocketOutputStream.java:159)

at org.apache.coyote.http11.InternalOutputBuffer.realWriteBytes(InternalOutputBuffer.java:215)

at org.apache.tomcat.util.buf.ByteChunk.flushBuffer(ByteChunk.java:480)

at org.apache.tomcat.util.buf.ByteChunk.append(ByteChunk.java:366)

at org.apache.coyote.http11.InternalOutputBuffer$OutputStreamOutputBuffer.doWrite(InternalOutputBuffer.java:240)

at org.apache.coyote.http11.filters.IdentityOutputFilter.doWrite(IdentityOutputFilter.java:84)

at org.apache.coyote.http11.AbstractOutputBuffer.doWrite(AbstractOutputBuffer.java:192)

at org.apache.coyote.Response.doWrite(Response.java:517)

at org.apache.catalina.connector.OutputBuffer.realWriteBytes(OutputBuffer.java:408)

... 65 more

 

原因

①:服务器的并发连接数超过了其承载量,服务器会将其中一些连接Down掉; 
②:客户关掉了浏览器,而服务器还在给客户端发送数据; 
③:浏览器端按了Stop 

④:用servlet的outputstream输出流下载图片时,当用户点击取消也会报这个错

 

花了些功夫最后找出来的原因是:用servlet的response.getOutputStream时,写回多个数据,而客户端没全部接收,可能会报下面这个错误。如: 

服务器上写了两条数据

out.writeObject("1");

out.writeObject("2");

 

客户端只接收一条

in.readObject(url);

 

这样的话也会报ClientAbortException这个错,以后注意。

解决办法

这些原因太过笼统,细查错误很难。 
偶然在一个英文网页上看到了条有关这个异常的,本人英语水平差,只能说个大意: 
这个已知异常出现在IE浏览器显示tif格式的图片的时候。 

亲自试验了下,的确在chrome和火狐上显示时,后台不会报次错误,不过图片显示有点异样。因为图片是存于数据库的BLOB类型的字段中,所以一直没注意图片的格式,后来才发现,原来图片是gif格式,而我使用ImageIO.write(img, "jpeg", response.getOutputStream());输出成jpg格式的图片,以致导致IE浏览器对图片解析有问题。在此将jpeg改成gif后不再出现异常。 

忙乎了一天多,结果问题出在这里。 

其问题导致的原因可能是:IE浏览器在解析错误图片格式或不支持的图片格式时,可能向服务器发送了多次请求或是直接关闭了连接,从而导致了tomcat报次异常。 

 

 

问题二

 

加载页面异常

ClientAbortException:  java.net.SocketException: Software caused connection abort: socket write error

at org.apache.catalina.connector.OutputBuffer.doFlush(OutputBuffer.java:371)

at org.apache.catalina.connector.OutputBuffer.flush(OutputBuffer.java:333)

at org.apache.catalina.connector.CoyoteOutputStream.flush(CoyoteOutputStream.java:101)

at sun.nio.cs.StreamEncoder.implFlush(StreamEncoder.java:297)

at sun.nio.cs.StreamEncoder.flush(StreamEncoder.java:141)

at java.io.OutputStreamWriter.flush(OutputStreamWriter.java:229)

at org.springframework.util.StreamUtils.copy(StreamUtils.java:107)

at org.springframework.http.converter.StringHttpMessageConverter.writeInternal(StringHttpMessageConverter.java:106)

at org.springframework.http.converter.StringHttpMessageConverter.writeInternal(StringHttpMessageConverter.java:40)

at org.springframework.http.converter.AbstractHttpMessageConverter.write(AbstractHttpMessageConverter.java:180)

at org.springframework.web.servlet.mvc.method.annotation.AbstractMessageConverterMethodProcessor.writeWithMessageConverters(AbstractMessageConverterMethodProcessor.java:143)

at org.springframework.web.servlet.mvc.method.annotation.AbstractMessageConverterMethodProcessor.writeWithMessageConverters(AbstractMessageConverterMethodProcessor.java:89)

at org.springframework.web.servlet.mvc.method.annotation.RequestResponseBodyMethodProcessor.handleReturnValue(RequestResponseBodyMethodProcessor.java:189)

at org.springframework.web.method.support.HandlerMethodReturnValueHandlerComposite.handleReturnValue(HandlerMethodReturnValueHandlerComposite.java:69)

at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:122)

at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:745)

at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:685)

at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80)

at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:919)

at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:851)

at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:953)

at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:844)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)

at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:829)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)

at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:106)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61)

at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)

at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)

at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)

at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)

at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449)

at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365)

at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)

at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)

at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:383)

at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)

at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)

at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343)

at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)

at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)

at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1041)

at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:603)

at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

at java.lang.Thread.run(Thread.java:745)

Caused by: java.net.SocketException: Software caused connection abort: socket write error

at java.net.SocketOutputStream.socketWrite0(Native Method)

at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:113)

at java.net.SocketOutputStream.write(SocketOutputStream.java:159)

at org.apache.coyote.http11.InternalOutputBuffer.realWriteBytes(InternalOutputBuffer.java:215)

at org.apache.tomcat.util.buf.ByteChunk.flushBuffer(ByteChunk.java:480)

at org.apache.coyote.http11.InternalOutputBuffer.flush(InternalOutputBuffer.java:119)

at org.apache.coyote.http11.AbstractHttp11Processor.action(AbstractHttp11Processor.java:805)

at org.apache.coyote.Response.action(Response.java:174)

at org.apache.catalina.connector.OutputBuffer.doFlush(OutputBuffer.java:366)

... 66 more

版权声明:本文为博主原创文章,遵循 CC 4.0 BY-SA 版权协议,转载请附上原文出处链接和本声明。
本文链接:https://blog.csdn.net/qq_39162772/article/details/94661378

智能推荐

Oracle 10g RAC 维护工具完全详解_rac olsnodes-程序员宅基地

文章浏览阅读2.8k次。节点层:olsnodes网络层:oifcfg集群层:crsctl、ocrcheck、ocrdump、ocrconfig应用层:srvctl、onsctl、crs_stat一、olsnodes 的使用[root@rac22 ~]# olsnodes -hUsage: olsnodes [-n] [-p] [-i] [ | -l] [-g] [-v]_rac olsnodes

2024年腾讯云服务器地域节点怎么选择?地域是啥?-程序员宅基地

文章浏览阅读594次,点赞26次,收藏24次。腾讯云服务器地域有什么区别?怎么选择比较好?地域选择就近原则,距离地域越近网络延迟越低,速度越快。关于地域的选择还有很多因素,地域节点选择还要考虑到网络延迟速度方面、内网连接、是否需要备案、不同地域价格因素,可用区还要考虑到高容灾、高可用因素,腾讯云服务器网txyfwq.com来详细说下什么云服务器地域?什么是可用区?以及地域和可用区选择要考虑到的几点因素,可以在腾讯云百科查看当前最新的优惠券和服务器报价单。

react项目中使用react-dnd实现列表的拖拽排序_react dnd 做一个可拖动列表-程序员宅基地

文章浏览阅读1.8w次,点赞6次,收藏27次。现在有一个新需求就是需要对一个列表,实现拖拽排序的功能,要实现的效果如下图:可以通过 react-dnd 或者 react-beautiful-dnd 两种方式实现,今天先讲下使用react-dnd是如何实现的,github地址:https://react-dnd.github.io/react-dnd/docs/api/dnd-provider1.先安装依赖npm ire..._react dnd 做一个可拖动列表

流媒体技术在宽带网络的应用与发展_流媒体实现了在高带宽中的应用-程序员宅基地

文章浏览阅读1.9k次。流媒体技术在宽带网络的应用与发展作者/来源:中国电信梁晓辉 游志胜  摘 要 文章介绍了流媒体的概念与特点,深入分析了流媒体系统及其关键技术,研究了流媒体技术在宽带网络中的应用及在国内外的发展情况,对流媒体技术在发展中遇到的问题做了说明。还针对我国目前的宽带网络现状,提出了流媒体技术的应用和发展建议。   关键词 流媒体 宽带网络 编码方式 传输协议   在_流媒体实现了在高带宽中的应用

嵌入式 H264中的SPS、PPS提取与作用-程序员宅基地

文章浏览阅读3次。使用RTP传输H264的时候,需要用到sdp协议描述,其中有两项:Sequence ParameterSets(SPS) 和Picture ParameterSet(PPS)需要用到,那么这两项从哪里获取呢?答案是从H264码流中获取.在H264码流中,都是以"0x00 0x00 0x01"或者"0x00 0x00 0x00 0x01"为开始码的,找到开始码之后,使用开始码之后的第一个字...

STM32使用中断方式实现串口通信_stm32串口中断怎么用-程序员宅基地

文章浏览阅读164次。项目配置。_stm32串口中断怎么用

随便推点

576页30万字智慧化工园区(一期)总体设计方案(公开)_化工园区信息化系统设计方案包括哪些内容-程序员宅基地

文章浏览阅读511次。目录1 概述 1.1 港区概况 1.2 项目背景 1.3 项目建设必要性 1.3.1 智慧园区建设是顺应时代发展潮流的战略选择 1.3.2 智慧园区建设是提升园区安全环保水平的本质要求 1.3.3 智慧园区建设是促进园区转型发展的内在需要 1.4 项目编制依据 1.4.1 依据文件 1.4.2 法律法规 1.4.3 标准规范 2 现状分析 2.1 国外现状分析 2.1.1 国外发展现状 2.1.2 经验启示 2.2 国内发展分析 2.2.1 特色园区情况 2.2.2 国内政策要求 2.3 园区建设现状分析 _化工园区信息化系统设计方案包括哪些内容

AI孙燕姿项目实现_ai孙燕姿 github-程序员宅基地

文章浏览阅读1w次,点赞20次,收藏148次。最近在b站刷到很多关于ai孙笑川唱的歌曲,加上最近大火的ai孙燕姿,这下“冷门歌手”整成热门歌手了于是写下一篇文章, 如何实现属于的ai歌手。注意滥用ai,侵犯他人的名誉是要承担法律责任的下面是一些所需的文件链接:一鍵包:www.bilibili.com/video/BV1Cc411H74D/123盤:www.123pan.com/s/RiyA-LjS03夸克網盤:pan.quark.cn/s/f9791f6790d3。_ai孙燕姿 github

用C语言做引用素材做游戏,C/C++编程笔记:C语言实现连连看游戏,小白练手项目(源码分享)...-程序员宅基地

文章浏览阅读145次。/*课程内容:练练看,很简单开发环境:vs2013+easyx图形库知识点:数组,结构体,分支结构,图形库函数*/#include#include#define IMG_SIZE 39 //隔一个动物图片的宽度#define MAX_ANIMAL_NUM 42 //总共的动物数量#define MAP_SIZE 10 //每行动物的数量#define WIN_SIZE (MAP_SIZE*IMG..._连连看编程素材

python 5-1 如何读写文本文件str1.encode('utf8')/decode('utf8')/open("text2.txt","wt",encoding="utf8")_python s.send(str1.encode('utf-8'))-程序员宅基地

文章浏览阅读3.7k次。python 5-1 如何读写文本文件 python2.x 写入文件前对unicode编码,读入文件后对二进制字符串编码python3.x open函数指定’t’的文本模式,encoding指定编码格式python2.x 写入文件前对unicode编码,读入文件后对二进制字符串编码默认是通过unicode编码写进文件,通过unicode解码读出文件可以 可以通过str1.encode(“utf8_python s.send(str1.encode('utf-8'))

三维模型obj文件的格式解析与读取-程序员宅基地

文章浏览阅读1.8k次。请先看这两个中文博客中对于obj的介绍:读取Obj格式的模型文件(Dx10) C++读入obj格式模型文件 更为详细的英文资料(用google或者aol搜索 "obj format"即可得到):http://en.wikipedia.org/wiki/Wavefront_.obj_fileWavefront OBJ File Format Summary最详细的资料 o..._.解析obj模型文件路径,返回一个对象,包含该模型的路径,后缀,文件名等 * * @param

pgsql 筛选中文字符正则_Postgresql 中的 正则表达式 模式匹配-程序员宅基地

文章浏览阅读3.9k次。参考链接:PostgreSQL 模式匹配​www.yiibai.com1. likestring LIKE pattern [ESCAPE escape-character]string NOT LIKE pattern [ESCAPE escape-character]比较特别的地方:在pattern里的下划线 (_)代表(匹配)任何单个字符; 而一个百分号(%)匹配任何零或更多个字符的序列。L..._pgsql 匹配中文汉字

推荐文章

热门文章

相关标签