MyBatis-入参的类型
1. 新增的参数是对象
示例
<!-- 修改 -->
<insert id="updateBook">
update book set book_name=#{bookName},book_auth=#{bookAuth},book_brief=#{bookBrief,jdbcType=VARCHAR} where book_id=#{bookId}
</insert>
2. 空值的处理,占位符
1.字段,jdbcType=VARCHAR (字符串)
2.字段,jdbcType=DATE (日期)
3.字段,jdbcType=INTEGER (数值)
示例
<!-- 插入 -->
<insert id="insertBook">
insert into book(book_id,book_name,book_auth,book_brief,book_Create_Date)
values(seq_book.nextval,#{book.bookName},#{book.bookAuth,jdbcType=INTEGER},#{book.bookBrief,jdbcType=VARCHAR},#{book.bookCreateDate,jdbcType=DATE})
</insert>
3. 插入全部值时,可以不处理空值
<!-- 插入 -->
<select id="insertProduct" >
insert into product(pro_id,pro_name,pro_brief,pro_price,pro_count,pro_status) values(seq_product.nextval,#{product.proName},#{product.proBrief},#{product.proPrice},#{product.proCount},#{product.proStatus})
</select>