Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- // TODO add your handling code here:
- if (txtQuery.getText().length() == 0) {
- JOptionPane.showMessageDialog(null, "Please input query string!", "Message", JOptionPane.WARNING_MESSAGE);
- return;
- }
- txtResult.selectAll();
- txtResult.replaceSelection("");
- String connectionUrl = "jdbc:sqlserver://localhost:1434;databaseName=books;user=sa;password=sa";
- try (Connection con = DriverManager.getConnection(connectionUrl); Statement stmt = con.createStatement();) {
- String SQL = txtQuery.getText();
- ResultSet rs = stmt.executeQuery(SQL);
- // Iterate through the data in the result set and display it.
- // process query results
- StringBuilder results = new StringBuilder();
- ResultSetMetaData metaData = rs.getMetaData();
- int numberOfColumns = metaData.getColumnCount();
- for (int i = 1; i <= numberOfColumns; i++) {
- results.append(metaData.getColumnName(i)).append("\t");
- }
- results.append("\n");
- // Metadata
- while (rs.next()) {
- for (int i = 1; i <= numberOfColumns; i++) {
- results.append(rs.getObject(i)).append("\t");
- }
- results.append("\n");
- }
- txtResult.setText(results.toString());
- } // Handle any errors that may have occurred.
- catch (SQLException e) {
- txtResult.setText(e.getMessage());
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement