Introduction
In this project, you will learn how to use MyBatis to perform various operations on a course table, including querying course information, updating course teacher, and batch querying course data.
👀 Preview
![Unfinished](https://file.labex.io/namespace/718bace8-27a3-4200-a588-dde4041ceeb9/java/project-operate-the-course-table/lab-operate-the-course-table/assets/img_1.png)
![Unfinished](https://file.labex.io/namespace/718bace8-27a3-4200-a588-dde4041ceeb9/java/project-operate-the-course-table/lab-operate-the-course-table/assets/img_2.png)
![Unfinished](https://file.labex.io/namespace/718bace8-27a3-4200-a588-dde4041ceeb9/java/project-operate-the-course-table/lab-operate-the-course-table/assets/img_3.png)
🎯 Tasks
In this project, you will learn:
- How to query course information whose course name starts with an uppercase "C" using dynamic SQL
- How to update the teaching teacher of a specific course while keeping others unchanged, using dynamic SQL
- How to batch query course information with a list of course numbers, using dynamic SQL
🏆 Achievements
After completing this project, you will be able to:
- Use MyBatis input and output parameters
- Implement dynamic SQL in MyBatis
- Use result mapping to specify the result set mapping
- Use the
<foreach>
tag for batch queries