DbQuery.java 1.2 KB

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