【问题】
先说版本,win 11,idea 2023.1
如标题,想去格式化mybatis中写的sql,但是ctrl alt L 一顿处理,其中的sql没有按照sql命令的格式去格式化,此外写sql 无提示也无高亮
【问题示例】
未格式化前,显然格式已经差不多了,按理来说再格式化也就稍微调整
<select id="selectxx" resultType="java.util.HashMap">
SELECT * from (SELECT p.project_code projectCode,
p.project_name projectName,
(SELECT count(*)
FROM table_os os
where os.project_code = p.project_code
and os.del_flag = '0'
<if test="query.saleCode!='' and query.saleCode!=null ">
and os.sale_code like concat('%',#{
query.saleCode},'%')
</if>
) as size
FROM table_p p
where p.del_flag='0'
<if test="query.projectType!='' and query.projectType!=null">
and p.project_type like concat('%',#{
query.projectType},'%')
</if>
<if test="query.projectCode!='' and query.projectCode!=null">
and p.project_code like concat