import java.sql.*; /** 阶段4 验收辅助:对 dev 库执行只读查询,打印结果(UTF-8)。用法: java -cp pg.jar DbQuery.java "SELECT ..." */ public class DbQuery { public static void main(String[] args) throws Exception { String url = "jdbc:postgresql://192.168.0.106:5432/zsjz-ai"; try (Connection c = DriverManager.getConnection(url, "postgres", "postgres")) { for (String sql : args) { System.out.println("SQL> " + sql); try (Statement st = c.createStatement(); ResultSet rs = st.executeQuery(sql)) { ResultSetMetaData md = rs.getMetaData(); int n = 0; while (rs.next()) { StringBuilder sb = new StringBuilder(" "); for (int i = 1; i <= md.getColumnCount(); i++) { sb.append(md.getColumnLabel(i)).append('=').append(rs.getString(i)).append(" | "); } System.out.println(sb); n++; } System.out.println(" (" + n + " rows)"); } } } } }