JavaEE_07_Mybatis操作

《Mybatis操作》

目录

• ORM映射（熟练）

• CRUD操作（熟练）

一、ORM映射

对象关系映射（英语：Object Relational Mapping，简称ORM，或O/RM，或O/R mapping），是一种程序设计技术，用于实现面向对象编程语言里不同类型系统的数据之间的转换。

resultMap

• mappers/TeacherMapper.xml

<resultMap id="BaseResultMap" type="com.hpr.entity.Teacher">
    <id column="teacher_id" property="teacherId"/>
    <result column="teacher_name" property="teacherName"/>
    <result column="age" property="age"/>
    <result column="phone_number" property="phoneNumber"/>
    <result column="info" property="info"/>
</resultMap>

• mappers/StudentMapper.xml

<resultMap id="BaseResultMap" type="com.hpr.entity.Student">
    <id column="student_id" property="studentId"/>
    <result column="student_name" property="studentName"/>
    <result column="chinese" property="chinese"/>
    <result column="math" property="math"/>
    <result column="english" property="english"/>
    <result column="teacher_id" property="teacherId"/>
</resultMap>

二、CRUD操作

select查询

1. com.hpr.mapper.TeacherMapper

...
public interface TeacherMapper {
    ...
    Teacher selectById(int teacherId);
}

2. mappers/TeacherMapper.xml

<!-- select查询 -->
<select id="selectById" resultMap="BaseResultMap">
    select *
    from teacher
    where teacher_id = #{teacherId}
</select>

3. com.hpr.service.ITeacherService

...
public interface ITeacherService {
    ...
    Response<Teacher> selectById(int teacherId);
}

4. com.hpr.service.impl.TeacherService

...
public class TeacherService implements ITeacherService {
    ...
    @Override
    public Response<Teacher> selectById(int teacherId) {
        return new Response<>(200, "success", teacherMapper.selectById(teacherId));
    }
}

5. com.hpr.controller.MybatisController

...
public class MybatisController {
    ...
    @GetMapping("/selectById")
    @ApiOperation("查询指定教师信息")
    public Response<Teacher> selectById(@ApiParam("教师ID") int teacherId) {
        return iTeacherService.selectById(teacherId);
    }
}

6. 启动测试

执行结果

insert新增

1. com.hpr.mapper.TeacherMapper

...
public interface TeacherMapper {
    ...
    int insert(Teacher teacher);
}

2. mappers/TeacherMapper.xml

<!-- insert插入：当数据库表主键自动递增，使用keyProperty及useGeneratedKeys属性，可将自动递增值返回并设置到对象中 -->
<!--  #{}与${}区别：
          #{name}取值"Alice"，多用于数据值获取；
          ${name}取值Alice，多用于数据库对象获取。 -->
<insert id="insert" keyProperty="teacherId" useGeneratedKeys="true">
    insert into teacher(teacher_name, age, phone_number, info)
        value (#{teacherName},"${age}",#{phoneNumber},#{info})
</insert>

3. com.hpr.service.ITeacherService

...
public interface ITeacherService {
    ...
    Response<Teacher> insert(Teacher teacher);
}

4. com.hpr.service.impl.TeacherService

...
public class TeacherService implements ITeacherService {
    ...
    @Override
    public Response<Teacher> insert(Teacher teacher) {
        int count = teacherMapper.insert(teacher);
        if (count > 0) {
            return new Response<>(200, "success", teacher);
        } else {
            return new Response<>(-1, "数据插入失败！");
        }
    }
}

5. com.hpr.controller.MybatisController

...
public class MybatisController {
    ...
    @PostMapping("/insert")
    @ApiOperation("插入教师信息")
    public Response<Teacher> insert(@ApiParam("教师信息") @RequestBody Teacher teacher) {
        return iTeacherService.insert(teacher);
    }
}

6. 启动测试

执行结果

update修改

1. com.hpr.mapper.TeacherMapper

...
public interface TeacherMapper {
    ...
    int updateAge(@Param("age") int age, @Param("teacherId") int teacherId);
}

2. mappers/TeacherMapper.xml

<!-- update修改 -->
<update id="updateAge">
    update teacher
    set age=#{age}
    where teacher_id = #{teacherId}
</update>

3. com.hpr.service.ITeacherService

...
public interface ITeacherService {
    ...
    Response<Object> updateAge(int age, int teacherId);
}

4. com.hpr.service.impl.TeacherService

...
public class TeacherService implements ITeacherService {
    ...
    @Override
    public Response<Object> updateAge(int age, int teacherId) {
        int count = teacherMapper.updateAge(age, teacherId);
        if (count > 0) {
            return new Response<>(200, "success");
        } else {
            return new Response<>(-1, "年龄更新失败！");
        }
    }
}

5. com.hpr.controller.MybatisController

...
public class MybatisController {
    ...
    @GetMapping("/updateAge")
    @ApiOperation("教师年龄更新")
    public Response<Object> updateAge(@ApiParam("年龄") @RequestParam int age,
                                      @ApiParam("教师ID") @RequestParam int teacherId) {
        return iTeacherService.updateAge(age, teacherId);
    }
}

6. 启动测试

执行结果

delete删除

1. com.hpr.mapper.TeacherMapper

...
public interface TeacherMapper {
    ...
    int deleteById(int teacherId);
}

2. mappers/TeacherMapper.xml

<!-- delete删除 -->
<delete id="deleteById">
    delete
    from teacher
    where teacher_id = #{teacherId}
</delete>

3. com.hpr.service.ITeacherService

...
public interface ITeacherService {
    ...
    Response<Object> deleteById(int teacherId);
}

4. com.hpr.service.impl.TeacherService

...
public class TeacherService implements ITeacherService {
    ...
    @Override
    public Response<Object> deleteById(int teacherId) {
        int count = teacherMapper.deleteById(teacherId);
        if (count > 0) {
            return new Response<>(200, "success");
        } else {
            return new Response<>(-1, "数据删除失败！");
        }
    }
}

5. com.hpr.controller.MybatisController

...
public class MybatisController {
    ...
    @GetMapping("/deleteById")
    @ApiOperation("删除用户信息")
    public Response<Object> deleteById(@ApiParam("教师ID") @RequestParam int teacherId) {
        return iTeacherService.deleteById(teacherId);
    }
}

6. 启动测试

执行结果

总结

重点

1. ORM映射相关概念；
2. Mybatis ORM实现；
3. Mybatis 增删改查四大标签。

难点

1. #{}与${}的区别；
2. @Param指定参数名。