dMapper下载地址1:https://pan.baidu.com/s/1gj95X-ndTsSnSFL8t7oevw
数据库文件
文件路径:mapper\test.xml
<?xml version="1.0" encoding="utf-8" ?>
<mapper>
<fields>*</fields>
<select id="test" attr="fetchAll">
SELECT
#fields#
FROM
test
</select>
<select id="test1" attr="fetch">
SELECT
#fields#
FROM
test
WHERE
id = :id
</select>
<select id="test2" attr="fetchColumn">
SELECT
id
FROM
test
WHERE
id = :id
</select>
<insert id="add">
insert into test(`title`,`remarks`) #VALUES#
</insert>
<update id="upd">
update test set `title`=:title,`remarks`=:remarks where id=:id
</update>
<delete i