textArea1.setText(null);
                Class.forName("com.mysql.jdbc.Driver");
                Connection connect = DriverManager.getConnection("jdbc:mysql://localhost/entity?user=root&password=");
                java.sql.Statement statement = connect.createStatement();
                ResultSet resultSet = statement.executeQuery("SELECT * FROM info");
                ResultSetMetaData metaData = resultSet.getMetaData();
                int colCount = metaData.getColumnCount();

                /////////COUNTING MAX LEN/////////////////

                int maxLen = 0;

                for (int i = 1; i < colCount; i++) {
                    if (metaData.getColumnName(i).length() > maxLen) {
                        maxLen = metaData.getColumnName(i).length();
                    }
                }

                while (resultSet.next()) {
                    for (int i = 1; i < colCount + 1; i++) {
                        if (resultSet.getString(i).length() > maxLen) {
                            maxLen = resultSet.getString(i).length();
                        }
                    }
                }

                //////////WRITE RESULT////////////////////

                int spaces = 0;
                int symbols = 0;

                //write column names with spaces;

                for (int i = 1; i <= colCount; i++) {
                    spaces = maxLen - metaData.getColumnName(i).length();
                    symbols = symbols + spaces + metaData.getColumnName(i).length();
                    textArea1.setText(textArea1.getText() + metaData.getColumnName(i));

                    for (int y = 0; y < spaces; y++) {
                        textArea1.setText(textArea1.getText() + " ");
                    }
                    textArea1.setText(textArea1.getText() + "|");
                }

                textArea1.setText(textArea1.getText() + "\n");

                //write column values with spaces;

                resultSet.beforeFirst();
                while (resultSet.next()) {

                    for (int i = 1; i <= colCount; i++) {

                        spaces = maxLen - resultSet.getString(i).length();
                        textArea1.setText(textArea1.getText() + resultSet.getString(i));

                        for (int y = 0; y < spaces; y++) {
                            textArea1.setText(textArea1.getText() + " ");
                        }

                        textArea1.setText(textArea1.getText() + "|");

                    }

                    textArea1.setText(textArea1.getText() + "\n");
                }