/** * Set the SQL. * * @param sql The SQL statement. * * @throws IllegalArgumentException * Thrown if a <TT>null</TT> SQL statement passed. */ public void setSQL(String sql) { if (sql == null) { throw new IllegalArgumentException("sql == null"); } _sql = sql.trim(); _shortSql = StringUtilities.cleanString(sql); }
/** * Set the SQL. * * @param sql The SQL statement. * * @throws IllegalArgumentException * Thrown if a <TT>null</TT> SQL statement passed. */ public void setSQL(String sql) { if (sql == null) { throw new IllegalArgumentException("sql == null"); } _sql = sql.trim(); _shortSql = StringUtilities.cleanString(sql); }
/** * @see net.sourceforge.squirrel_sql.client.session.mainpanel.IResultTab#getViewableSqlString() */ public String getViewableSqlString() { return StringUtilities.cleanString(getSqlString()); }
/** * @see net.sourceforge.squirrel_sql.client.session.mainpanel.IResultTab#getViewableSqlString() */ public String getViewableSqlString() { return StringUtilities.cleanString(getSqlString()); }
void load(int rowCount, SQLExecutionInfo exInfo) { _queryLbl.setText(StringUtilities.cleanString(exInfo.getSQL())); displayRowCount(rowCount); _executedLbl.setText(exInfo.getSQLExecutionStartTime().toString()); _elapsedLbl.setText(formatElapsedTime(exInfo)); }
void load(int rowCount, SQLExecutionInfo exInfo) { _queryLbl.setText(StringUtilities.cleanString(exInfo.getSQL())); displayRowCount(rowCount); _executedLbl.setText(exInfo.getSQLExecutionStartTime().toString()); _elapsedLbl.setText(formatElapsedTime(exInfo)); }
private JPanel createNorthPanel(ISession session, ArrayList<String> sqlExecErrorMsgs, String lastExecutedStatement) { JPanel ret = new JPanel(new GridBagLayout()); String msg = s_stringMgr.getString("ErrorPanel.NoErrorStatement") ; if(1 < sqlExecErrorMsgs.size() && false == session.getProperties().getAbortOnError()) { msg = s_stringMgr.getString("ErrorPanel.MultibleStatements") ; } else if(null != lastExecutedStatement && 0 < lastExecutedStatement.trim().length()) { msg = s_stringMgr.getString("ErrorPanel.occuredIn", StringUtilities.cleanString(lastExecutedStatement.trim())) ; } String escapedMsg = Utilities.escapeHtmlChars(msg); String htmlMsg = "<html><pre> " + escapedMsg + "</pre></html>"; GridBagConstraints gbc; gbc = new GridBagConstraints(0,0,1,1,1,1, GridBagConstraints.NORTHWEST, GridBagConstraints.HORIZONTAL, new Insets(0,0,0,5),0,0 ); ret.add(new JLabel(htmlMsg), gbc); gbc = new GridBagConstraints(1,0,1,1,0,0, GridBagConstraints.NORTHEAST, GridBagConstraints.NONE, new Insets(0,0,0,0),0,0 ); _btnClose = new TabButton(new CloseAction(session)); ret.add(_btnClose, gbc); return ret; }
private JPanel createNorthPanel(ISession session, ArrayList<String> sqlExecErrorMsgs, String lastExecutedStatement) { JPanel ret = new JPanel(new GridBagLayout()); String msg = s_stringMgr.getString("ErrorPanel.NoErrorStatement") ; if(1 < sqlExecErrorMsgs.size() && false == session.getProperties().getAbortOnError()) { msg = s_stringMgr.getString("ErrorPanel.MultibleStatements") ; } else if(null != lastExecutedStatement && 0 < lastExecutedStatement.trim().length()) { msg = s_stringMgr.getString("ErrorPanel.occuredIn", StringUtilities.cleanString(lastExecutedStatement.trim())) ; } String escapedMsg = Utilities.escapeHtmlChars(msg); String htmlMsg = "<html><pre> " + escapedMsg + "</pre></html>"; GridBagConstraints gbc; gbc = new GridBagConstraints(0,0,1,1,1,1, GridBagConstraints.NORTHWEST, GridBagConstraints.HORIZONTAL, new Insets(0,0,0,5),0,0 ); ret.add(new JLabel(htmlMsg), gbc); gbc = new GridBagConstraints(1,0,1,1,0,0, GridBagConstraints.NORTHEAST, GridBagConstraints.NONE, new Insets(0,0,0,0),0,0 ); _btnClose = new TabButton(new CloseAction(session)); ret.add(_btnClose, gbc); return ret; }
public void sqlToBeExecuted(final String sql) { _cancelPanelCtrl.incCurrentQueryIndex(); int currentStmtCount = _cancelPanelCtrl.getCurrentQueryIndex(); if (!shouldRenderSQL(currentStmtCount, _cancelPanelCtrl.getTotalCount())) { return; } final String cleanSQL = StringUtilities.cleanString(sql); sqlToBeExecuted = cleanSQL; sqlType = getSQLType(cleanSQL); _cancelPanelCtrl.setSQL(sqlToBeExecuted); // i18n[SQLResultExecuterPanel.execStatus=Executing SQL...] String status = s_stringMgr.getString("SQLResultExecuterPanel.execStatus"); _cancelPanelCtrl.setStatusLabel(status); }
public void sqlToBeExecuted(final String sql) { _cancelPanelCtrl.incCurrentQueryIndex(); int currentStmtCount = _cancelPanelCtrl.getCurrentQueryIndex(); if (!shouldRenderSQL(currentStmtCount, _cancelPanelCtrl.getTotalCount())) { return; } final String cleanSQL = StringUtilities.cleanString(sql); sqlToBeExecuted = cleanSQL; sqlType = getSQLType(cleanSQL); _cancelPanelCtrl.setSQL(sqlToBeExecuted); // i18n[SQLResultExecuterPanel.execStatus=Executing SQL...] String status = s_stringMgr.getString("SQLResultExecuterPanel.execStatus"); _cancelPanelCtrl.setStatusLabel(status); }
/** * @see net.sourceforge.squirrel_sql.client.session.mainpanel.IResultTab#showResults(net.sourceforge.squirrel_sql.fw.datasetviewer.ResultSetDataSet, net.sourceforge.squirrel_sql.fw.datasetviewer.ResultSetMetaDataDataSet, net.sourceforge.squirrel_sql.client.session.SQLExecutionInfo) */ public void showResults(ResultSetDataSet rsds, ResultSetMetaDataDataSet mdds, SQLExecutionInfo exInfo) throws DataSetException { _exInfo = exInfo; _sql = StringUtilities.cleanString(exInfo.getSQL()); _rsds = rsds; // Display the result set. _dataSetViewerFindDecorator.getDataSetViewer().show(rsds, null); initContinueReadChannel(_dataSetViewerFindDecorator); final int rowCount = _rsds.currentRowCount(); _currentSqlLblCtrl.setSql(_sql); _currentSqlLblCtrl.reInit(_rsds.currentRowCount(), _rsds.areAllPossibleResultsOfSQLRead()); // Display the result set metadata. if (mdds != null && _metaDataOutput != null) { _metaDataOutput.show(mdds, null); // Why null?? } _queryInfoPanel.load(rowCount, _exInfo); }
/** * @see net.sourceforge.squirrel_sql.client.session.mainpanel.IResultTab#showResults(net.sourceforge.squirrel_sql.fw.datasetviewer.ResultSetDataSet, net.sourceforge.squirrel_sql.fw.datasetviewer.ResultSetMetaDataDataSet, net.sourceforge.squirrel_sql.client.session.SQLExecutionInfo) */ public void showResults(ResultSetDataSet rsds, ResultSetMetaDataDataSet mdds, SQLExecutionInfo exInfo) throws DataSetException { _exInfo = exInfo; _sql = StringUtilities.cleanString(exInfo.getSQL()); _rsds = rsds; // Display the result set. _dataSetViewerFindDecorator.getDataSetViewer().show(rsds, null); initContinueReadChannel(_dataSetViewerFindDecorator); final int rowCount = _rsds.currentRowCount(); _currentSqlLblCtrl.setSql(_sql); _currentSqlLblCtrl.reInit(_rsds.currentRowCount(), _rsds.areAllPossibleResultsOfSQLRead()); // Display the result set metadata. if (mdds != null && _metaDataOutput != null) { _metaDataOutput.show(mdds, null); // Why null?? } _queryInfoPanel.load(rowCount, _exInfo); }