然小梨的博客

问题描述postman请求报错java.lang.NumberFormatException: For input string:“2210200001”dao层写法String getResRegion(@Param(value = "resTypeId") String resTypeId, @Param(value = "resId") String resId);原始错误xml写法 <select id="getResRegion" parameterType="String

java.io.IOException: Connection reset by peer具体报错内容如上图分析了很久，朋友说连接池问题解决方案：重启坐等过年????

1. 场景一：在数据库中执行语句时想让表中字段A不等于字段Bpostgresql的写法 <>select* from tablename A <> B or A IS NULL这里or A IS NULL是因为postgresql会在对比时直接去除A中空值；2. 场景二：在mybatis中执行postgresql的写法 <![CDATA[ <> ]]>select* from tablename A <![CDATA[ <> ]]