1 .操作对象入参,空值的处理方法
- 新增的参数是对象
- 空值的处理,占位符
字段,jdbcType=VARCHAR 字符串
字段,jdbcType=DATE 日期
字段,jdbcType=INTEGER 数值 - 插入全部值时,可以不处理空值
2.熟练使用java.util.map来接收处理多表的关联
<select id="selecMutil" resultType="java.util.Map">
select t1.book_id as bookId,t1.book_name as "bookName",
t1.book_brief as bookBrief,t2.sale_id as saleId,t2.sale_num as saleNum
from book t1 left join book_saleNum t2 on t1.book_id=t2.book_id
</select>
public List<Map<String,Object>> selecMutil();
public List<Map<String,Object>> selecMutil()throws IOException;
//多表查询
public List<Map<String,Object>> selecMutil()throws IOException{
// SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(is);
//session是