feat: 微信项目详情支持阶段评分时间轴

lrj

昨天 8337c34fcc761d07acaad796d10f3e12e9bbe2d1

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
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 java.util.List;
import java.util.Map;
 
@SpringBootTest
public class DatabaseConnectionTest {
 
    @Autowired
    private JdbcTemplate jdbcTemplate;
 
    @Test
    public void testDatabaseConnection() {
        try {
            // 检查数据库连接
            String result = jdbcTemplate.queryForObject("SELECT 1", String.class);
            System.out.println("✅ 数据库连接成功: " + result);
            
            // 检查t_wx_login_record表是否存在
            try {
                String checkTableSql = "SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = 'ryc' AND table_name = 't_wx_login_record'";
                Integer tableExists = jdbcTemplate.queryForObject(checkTableSql, Integer.class);
                
                if (tableExists != null && tableExists > 0) {
                    System.out.println("✅ t_wx_login_record表存在");
                    
                    // 查看表结构
                    String describeTableSql = "DESCRIBE t_wx_login_record";
                    List<Map<String, Object>> columns = jdbcTemplate.queryForList(describeTableSql);
                    System.out.println("表结构:");
                    for (Map<String, Object> column : columns) {
                        System.out.println("- " + column.get("Field") + ": " + column.get("Type") + 
                                         (column.get("Null").equals("NO") ? " NOT NULL" : " NULL") +
                                         (column.get("Default") != null ? " DEFAULT " + column.get("Default") : ""));
                    }
                    
                    // 检查表中是否有数据
                    String countSql = "SELECT COUNT(*) FROM t_wx_login_record";
                    Integer recordCount = jdbcTemplate.queryForObject(countSql, Integer.class);
                    System.out.println("表中记录数: " + recordCount);
                    
                } else {
                    System.out.println("❌ t_wx_login_record表不存在");
                }
            } catch (Exception e) {
                System.out.println("❌ 检查t_wx_login_record表时出错: " + e.getMessage());
                e.printStackTrace();
            }
            
        } catch (Exception e) {
            System.out.println("❌ 数据库连接失败: " + e.getMessage());
            e.printStackTrace();
        }
    }
}