package com.rongyichuang;
|
|
import org.junit.jupiter.api.Test;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.boot.test.context.SpringBootTest;
|
import org.springframework.jdbc.core.JdbcTemplate;
|
import org.springframework.test.context.ActiveProfiles;
|
|
@SpringBootTest
|
@ActiveProfiles("test")
|
public class SetupJudgeUserTest {
|
|
@Autowired
|
private JdbcTemplate jdbcTemplate;
|
|
@Test
|
public void setupJudgeUser() {
|
// 为第一个评委设置user_id为1，以便测试评分功能
|
String updateSql = "UPDATE t_judge SET user_id = 1 WHERE id = 21";
|
int updatedRows = jdbcTemplate.update(updateSql);
|
|
System.out.println("更新了 " + updatedRows + " 条评委记录");
|
|
// 验证更新结果
|
String verifySql = "SELECT id, name, user_id FROM t_judge WHERE user_id = 1";
|
jdbcTemplate.queryForList(verifySql).forEach(row -> {
|
System.out.println("评委ID: " + row.get("id") +
|
", 姓名: " + row.get("name") +
|
", 用户ID: " + row.get("user_id"));
|
});
|
}
|
}
|
