mybatis的xml 文件:
<select id="getGuiZiExceptionList" resultType="com.haier.xiaowei.rpc.rulai.model.Guizi">
SELECT
g.GUIZI_NO as guiziNo,
g.GUIZI_NAME as guiziName,
g.ADDRESS as address,
g.PROVINCE as province,
g.CITY as city,
g.AREA as area,
g.LONGITUDE as longitude,
g.LATITUDE as latitude,
gm.GONGMAO_NAME as gongmao,
gm.GONGMAO_NO as gongMaoNo
FROM
guizi g
LEFT JOIN gongmao gm ON g.GONGMAO = gm.GONGMAO_NO
WHERE
g.GSTATUS = 0
AND
(
g.PROVINCE IS NULL
or g.PROVINCE = ''
or g.CITY IS NULL
or g.CITY = ''
or
g.AREA IS NULL
or g.AREA = ''
)
or (
g.LONGITUDE IS NULL
or g.LONGITUDE = ''
or g.LONGITUDE < '50'
or
g.LATITUDE IS NULL
or g.LATITUDE = ''
or g.LATITUDE > '100'
)
<if test="pageSize!=0">
limit #{start}, #{pageSize}
</if>
</select>
我把
AND
(
g.PROVINCE IS NULL
or g.PROVINCE = ''
or g.CITY IS NULL
or g.CITY = ''
or
g.AREA IS NULL
or g.AREA = ''
)
or (
g.LONGITUDE IS NULL
or g.LONGITUDE = ''
or g.LONGITUDE < '50'
or
g.LATITUDE IS NULL
or g.LATITUDE = ''
or g.LATITUDE > '100'
)
這段刪了項目可以跑起來，不刪的話 控制臺一直七月 25, 2017 5:59:06 下午 org.apache.catalina.core.ApplicationContext log信息: Initializing Spring root WebApplicationContext 卡住是or在mybatis里有啥特殊寫法嗎？
添加回答
舉報
0/150
提交
取消