MyBatis Database Integration Project

# Introduction

In this project, you will learn how to use MyBatis, a popular Java persistence framework, to interact with a MySQL database. Specifically, you will learn how to use input parameters in SQL queries and retrieve course information based on the teacher's name.

## 👀 Preview

[labex] DEBUG [main] - Setting autocommit to false on JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@642a7222]
[labex] DEBUG [main] - ==>  Preparing: SELECT * FROM course WHERE teacher LIKE CONCAT('%', ?, '%') ORDER BY cNo DESC
[labex] DEBUG [main] - ==> Parameters: Am(String)
[labex] DEBUG [main] - <==      Total: 2
Course Number: 3        Course Name: Python     Teacher: Liam
Course Number: 1        Course Name: HTML       Teacher: Amy

## 🎯 Tasks

In this project, you will learn:

- Implement the `CourseMapper` interface to define a method for retrieving courses based on the teacher's name
- Write the SQL query in the `CourseMapper.xml` file to perform a fuzzy search on the `teacher` column and sort the results in descending order by course number
- Test the `CourseMapper` implementation in the `MyBatisTest` class to ensure the desired functionality

## 🏆 Achievements

After completing this project, you will be able to:

- Use MyBatis to interact with a MySQL database
- Pass input parameters to SQL queries using a `Map`
- Perform a fuzzy search on a database column and sort the results
- Test the functionality of a MyBatis mapper using a JUnit test case