<!-- 數(shù)據(jù)源配置 -->
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
    <property name="driverClassName" value="com.mysql.cj.jdbc.Driver" />
    <property name="url" value="jdbc:mysql://localhost:3306/school_db" />
    <property name="username" value="your_username" />
    <property name="password" value="your_password" />
</bean>
<!-- 事務(wù)管理器配置 -->
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
    <property name="dataSource" ref="dataSource" />
</bean>

import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
@Service
public class GradeService {
    @Transactional
    public void enterGrades(long studentId, Map<String, Double> grades) {
        // 假設(shè)在數(shù)據(jù)庫中有一個(gè)grade表，字段包括student_id, course, score等
        // 遍歷grades，依次將學(xué)生成績錄入數(shù)據(jù)庫
        for (Map.Entry<String, Double> entry : grades.entrySet()) {
            String course = entry.getKey();
            Double score = entry.getValue();
            // 執(zhí)行insert語句，將學(xué)生studentId在課程course的成績錄入數(shù)據(jù)庫
            // ...
        }
        // 如果任何一門課程的成績錄入失敗，事務(wù)將會回滾，保持?jǐn)?shù)據(jù)的一致性
    }
}

public static void main(String[] args) {
    ApplicationContext context = new ClassPathXmlApplicationContext("spring-config.xml");
    GradeService gradeService = context.getBean(GradeService.class);
    Map<String, Double> grades = new HashMap<>();
    grades.put("Math", 95.0);
    grades.put("English", 88.5);
    grades.put("Science", 78.0);
    try {
        gradeService.enterGrades(101, grades);
        System.out.println("Grades entered successfully!");
    } catch (Exception e) {
        System.out.println("Failed to enter grades!");
    }
}