这个是sqlServer 数据库
<insert id="addHouseLocation" parameterType="HouseLocation">
IF
NOT EXISTS (
SELECT
*
FROM
HouseLocation
WHERE
CONVERT (VARCHAR(10), ParentID) + '-' + CONVERT (VARCHAR(10), Row) + '-' + CONVERT (VARCHAR(10), Col) + '-' + CONVERT (VARCHAR(10), Layer) = CONVERT (
VARCHAR (10) ,#{parentid }
) + '-' + CONVERT (VARCHAR(10) ,#{ row }) + '-' + CONVERT (VARCHAR(10) ,#{ col }) + '-' + CONVERT (VARCHAR(10) ,#{ layer })
)
INSERT INTO HouseLocation(
Name,
Pinyin,
ParentID,
Memo,
AddUser,
AddDate,
EditUser,
EditDate,
IPAddress,
IsEnable,
Row,
Col,
Layer,
FullPath,
AllOrPart
)VALUES(
#{name},
#{pinyin},
#{parentid},
#{memo},
#{adduser},
#{adddate},
#{edituser},
#{editdate},
#{ipaddress},
#{isenable},
#{row},
#{col},
#{layer},
#{fullpath},
#{allorpart}
)
</insert>
====================================================================================
mysql 带条件去重新增数据 示例如下:
INSERT INTO t_user (
province,
city,
msisdn,
NAME,
packageName,
imei1,
imei2,
machineModel,
registTime,
address,
state
) SELECT
?,
?,
?,
?,
?,
?,
?,
?,
?,
?,
?
FROM
DUAL
WHERE
NOT EXISTS (
SELECT
*
FROM
app_user
WHERE
条件 =?
)
用所值替换?号