2019/12/12 学习笔记

2019/12/12 学习笔记

模糊查询

ssm的模糊查询
上面是模糊查询 下面是根据排序分页

 <!-- 分页查询书籍 -->
       <select id="queryStudentsBySql" resultMap="bookResult">
              select * FROM book 
              <where>
            		bname like CONCAT('%',#{cond},'%')
            		or detail like CONCAT('%',#{cond},'%')
            		or writer like CONCAT('%',#{cond},'%')
            		or printer like CONCAT('%',#{cond},'%')
            		or type like CONCAT('%',#{cond},'%')
            		or price like CONCAT('%',#{cond},'%')
            </where>
              order by ${sort} limit #{currIndex} , #{pageSize} 
       </select>

百度ueditor config.json报错

看看是不是有哪个少了引号。另外注释也有可能影响，可以先删掉一行注释，重新打开，如果还是不行，删掉所有注释。

mysql 连接错误

#€ÊẼ: Cannot create PoolableConnectionFactory (The server time zonevalue 'ÖĐ-útêxVÊ+V4ä' is unrecognized or represents more than one timezone. You must configure either the server or JDBC driver (via the
server Timezone configuration property) to use a more specifc time zonevalue if you want to utilize time zone support,)

时区问题：更改时区就行，更改MySQL的时区：set global time_zone = ‘+8:00’;