MyBatis的SQL映射文件头

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.offcn.springcloud.mapper.ProductMapper">
    <select id="findById" resultType="Product" parameterType="Long">
        select id,product_name,db_source from product where id=#{id}
    </select>
    <select id="findAll" resultType="Product">
        select id,product_name,db_source from product
    </select>
    <insert id="addProduct"  parameterType="Product">
        INSERT INTO product(product_name,db_source) VALUES(#{productName},DATABASE())
    </insert>
</mapper>

  

原文地址:https://www.cnblogs.com/cmxblog/p/11812850.html