SQLMyBatis增删查改:
1.在dao层写需要增删查改的语句
public interface SysUserMapper {
//查询全部用户数据
List selectAll();
//单表 查询by id
//只有一个参数时可以不写@Param
SysUser selectById(@Param(“id”) int id);
//单表 查询 by name 多个参数
List selectByName(@Param(“userName”) String userName,
@Param(“realName”) String realName);
/*
单表:模糊查询 根据用户名、真实姓名、手机、微信等模糊查询
/
List selectByCondition(String condition);
/*
*
*多表查询
/
List selectAllUserVo();
/
新增
*/
int insert(SysUser user);
/**
*新增返回主键
/
int insertReturnKey(SysUser user);
/
修改 根据主键
/
int updateById(SysUser user);
/
删除 根据主键
*/
int deleteById(int id);
}
2.mapping层写数据库增删查改的SQL语句,连表需要重新定义映射器
id, gmt_create, gmt_modified, is_deleted, user_name, user_password, salt, department_id, position_id, role_id, real_name, gender, birthday, portrait, email, mobile, qq, wechat, user_status, login_count, remark select from sys_user select * from sys_user where id=#{id} select * from sys_user where user_name=#{userName} and real_name=#{realName} select * from sys_user where user_name like CONCAT('%',CONCAT(#{userName},'%')) SELECT sys_user.*,sys_role.id AS rid,sys_role.role_name FROM sys_user INNER JOIN sys_role ON sys_user.role_id = sys_role.id insert into sys_user (id, gmt_create, gmt_modified, is_deleted, user_name, user_password, salt, department_id, position_id, role_id, real_name, gender, birthday, portrait, email, mobile, qq, wechat, user_status, login_count, remark ) values (#{id,jdbcType=INTEGER}, #{gmtCreate,jdbcType=TIMESTAMP}, #{gmtModified,jdbcType=TIMESTAMP}, #{isDeleted,jdbcType=TINYINT}, #{userName,jdbcType=VARCHAR}, #{userPassword,jdbcType