id,name,age,
email
insert into user
id,name,age,email,
values
#{id,jdbcType=BIGINT},#{name,jdbcType=VARCHAR},#{age,jdbcType=INTEGER},#{email,jdbcType=VARCHAR},
我们再来看看之前我们mybatis的map写法
直接sql+rebid
insert into tb_clazz(
clazz_name,
remark,
subject_id
)values(
#{clazzName},
#{remark},
#{subjectId}
)
select * from tb_clazz
limit ${offset} , ${rows}
select count(1) from tb_clazz
select * from tb_clazz
limit 1
delete from tb_clazz
update tb_clazz
and clazz_name like concat('%',#{clazzName},'%')and id = #{id}and remark = #{remark}and subject_id = #{subjectId}clazz_name = #{updateClazzName},id = #{updateId},remark = #{updateRemark},subject_id = #{updateSubjectId},
package com.yanzhen.utils;
import java.util.HashMap;
import java.util.Map;
public class MapParameter {
//目标对象
private Map paramMap = new HashMap<>();
//私有构造
private MapParameter(){
}
public static MapParameter getInstance(){
return new MapParameter();
}
public MapParameter add(String key,Object value){
paramMap.put(key,value);
return this;
}
public MapParameter addId(Object value){
paramMap.put("id",value);
return this;
}
public MapParameter add(Map map){
for (Map.Entry entry : map.entrySet()) {
paramMap.put(entry.getKey(),entry.getValue());
}
return this;
}
public Map getMap(){
return paramMap;
}
}