1、查询:
T selectById(Serializable var1);
List<T> selectBatchIds(@Param("coll") Collection<? extends Serializable> var1);
List<T> selectByMap(@Param("cm") Map<String, Object> var1);
T selectOne(@Param("ew") T var1);
//分页 List<T> selectPage(RowBounds var1, @Param("ew") Wrapper<T> var2)
注:selectByMap
//map的key为表的列名
Map<String, Object> map=new HashMap();
map.put("id",1);
map.put("user_name","Jone");
//SELECT id AS id,user_name AS `name`,user_age AS age,user_email AS email
//FROM tab_user WHERE user_name = ? AND id = ?
List<Users> users=usersMapper.selectByMap(map);
2、插入:
//非空检验
Integer insert(T var1);
//插入所有字段
Integer insertAllColumn(T var1);
案例