| 1234567891011121314151617181920212223242526 |
- 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)");
- }
- }
- }
- }
- }
|