Advertisement
Guest User

File code

a guest
Apr 24th, 2020
1,435
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 1.55 KB | None | 0 0
  1. // TODO add your handling code here:
  2.         if (txtQuery.getText().length() == 0) {
  3.             JOptionPane.showMessageDialog(null, "Please input query string!", "Message", JOptionPane.WARNING_MESSAGE);
  4.             return;
  5.         }
  6.         txtResult.selectAll();
  7.         txtResult.replaceSelection("");
  8.         String connectionUrl = "jdbc:sqlserver://localhost:1434;databaseName=books;user=sa;password=sa";
  9.  
  10.         try (Connection con = DriverManager.getConnection(connectionUrl); Statement stmt = con.createStatement();) {
  11.             String SQL = txtQuery.getText();
  12.             ResultSet rs = stmt.executeQuery(SQL);
  13.  
  14.             // Iterate through the data in the result set and display it.
  15.             // process query results
  16.             StringBuilder results = new StringBuilder();
  17.             ResultSetMetaData metaData = rs.getMetaData();
  18.             int numberOfColumns = metaData.getColumnCount();
  19.             for (int i = 1; i <= numberOfColumns; i++) {
  20.                 results.append(metaData.getColumnName(i)).append("\t");
  21.             }
  22.             results.append("\n");
  23.             //  Metadata
  24.             while (rs.next()) {
  25.                 for (int i = 1; i <= numberOfColumns; i++) {
  26.                     results.append(rs.getObject(i)).append("\t");
  27.                 }
  28.                 results.append("\n");
  29.             }
  30.             txtResult.setText(results.toString());
  31.         } // Handle any errors that may have occurred.
  32.         catch (SQLException e) {            
  33.             txtResult.setText(e.getMessage());
  34.         }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement