Abstract: In order to improve students' ability to use advanced knowledge of JDBC for complex database operations, lay the foundation for understanding and applying persistence framework knowledge in the future, and cultivate preliminary software literacy, a comprehensive teaching case consisting of four tasks was designed based on the integration of advanced knowledge of JDBC, object-oriented design principles, design patterns, reflection, generics, and annotations. Propose, analyze, solve, and understand problems based on PBL teaching methods for each task, gradually improving students' ability to comprehensively apply the knowledge they have learned to solve problems. The practical results show that this case can attract students' interest in learning, achieve good results, and achieve the expected goals.