const mysql = require('mysql2/promise');
|
|
async function checkUserJudgeInfo() {
|
const connection = await mysql.createConnection({
|
host: '139.155.104.10',
|
port: 3306,
|
user: 'ryc',
|
password: 'KiYap3E8X8RLcM6T',
|
database: 'ryc'
|
});
|
|
try {
|
console.log('检查用户ID=152的信息...\n');
|
|
// 检查用户基本信息
|
const [userRows] = await connection.execute(
|
'SELECT id, name, phone, wx_openid FROM t_user WHERE id = ?',
|
[152]
|
);
|
|
if (userRows.length > 0) {
|
console.log('用户基本信息:');
|
console.log(userRows[0]);
|
} else {
|
console.log('未找到用户ID=152的记录');
|
return;
|
}
|
|
// 检查评委信息
|
const [judgeRows] = await connection.execute(
|
'SELECT id, user_id, name, title, company, state FROM t_judge WHERE user_id = ?',
|
[152]
|
);
|
|
if (judgeRows.length > 0) {
|
console.log('\n评委信息:');
|
console.log(judgeRows[0]);
|
} else {
|
console.log('\n未找到该用户的评委记录');
|
}
|
|
// 检查员工信息
|
const [employeeRows] = await connection.execute(
|
'SELECT id, user_id, name, phone, role_id, state FROM t_employee WHERE user_id = ?',
|
[152]
|
);
|
|
if (employeeRows.length > 0) {
|
console.log('\n员工信息:');
|
console.log(employeeRows[0]);
|
} else {
|
console.log('\n未找到该用户的员工记录');
|
}
|
|
// 检查学员信息
|
const [playerRows] = await connection.execute(
|
'SELECT id, user_id, name, phone, state FROM t_player WHERE user_id = ?',
|
[152]
|
);
|
|
if (playerRows.length > 0) {
|
console.log('\n学员信息:');
|
console.log(playerRows[0]);
|
} else {
|
console.log('\n未找到该用户的学员记录');
|
}
|
|
} catch (error) {
|
console.error('查询失败:', error);
|
} finally {
|
await connection.end();
|
}
|
}
|
|
checkUserJudgeInfo().catch(console.error);
|
