33 lines
1.6 KiB
Java
33 lines
1.6 KiB
Java
|
package scripts.qa;
|
||
|
|
|
||
|
|
import java.io.File;
|
||
|
|
import java.nio.file.Files;
|
||
|
|
import java.sql.*;
|
||
|
|
|
||
|
|
public class CheckBindings {
|
||
|
|
public static void main(String[] args) throws Exception {
|
||
|
|
Class.forName("com.kingbase8.Driver");
|
||
|
|
File yml = new File("RuoYi-Vue/ruoyi-admin/src/main/resources/application-druid.yml");
|
||
|
|
String pass = "";
|
||
|
|
for (String line : Files.readAllLines(yml.toPath())) {
|
||
|
|
if (line.trim().startsWith("password:")) pass = line.trim().substring("password:".length()).trim();
|
||
|
|
}
|
||
|
|
try (Connection conn = DriverManager.getConnection("jdbc:kingbase8://127.0.0.1:4321/railwaysystem_integrated_qa_20260916?useUnicode=true&characterEncoding=utf8", "kingbase", pass)) {
|
||
|
|
System.out.println("--- TEACHERS WITH USER_ID ---");
|
||
|
|
try (Statement st = conn.createStatement();
|
||
|
|
ResultSet rs = st.executeQuery("SELECT t_id, t_name, user_id FROM public.train_teacher WHERE user_id IS NOT NULL")) {
|
||
|
|
while (rs.next()) {
|
||
|
|
System.out.println("Teacher t_id=" + rs.getString(1) + ", name=" + rs.getString(2) + ", user_id=" + rs.getObject(3));
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
System.out.println("--- STUDENTS WITH USER_ID ---");
|
||
|
|
try (Statement st = conn.createStatement();
|
||
|
|
ResultSet rs = st.executeQuery("SELECT s_id, s_name, user_id FROM public.train_student WHERE user_id IS NOT NULL")) {
|
||
|
|
while (rs.next()) {
|
||
|
|
System.out.println("Student s_id=" + rs.getString(1) + ", name=" + rs.getString(2) + ", user_id=" + rs.getObject(3));
|
||
|
|
}
|
||
|
|
}
|
||
|
|
}
|
||
|
|
}
|
||
|
|
}
|