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 SetupActivityJudgeTest {
|
|
@Autowired
|
private JdbcTemplate jdbcTemplate;
|
|
@Test
|
public void setupActivityJudge() {
|
// 为评委ID为21的评委添加活动ID为1的关联记录
|
String insertSql = "INSERT INTO t_activity_judge (activity_id, stage_id, judge_id, state) VALUES (1, 1, 21, 1)";
|
int insertedRows = jdbcTemplate.update(insertSql);
|
|
System.out.println("插入了 " + insertedRows + " 条活动评委关联记录");
|
|
// 验证插入结果
|
String verifySql = "SELECT * FROM t_activity_judge WHERE activity_id = 1 AND judge_id = 21";
|
jdbcTemplate.queryForList(verifySql).forEach(row -> {
|
System.out.println("活动ID: " + row.get("activity_id") +
|
", 评委ID: " + row.get("judge_id") +
|
", 阶段ID: " + row.get("stage_id") +
|
", 状态: " + row.get("state"));
|
});
|
}
|
}
|
