public void setExistingColumnInfo(TableColumnInfo info) { tableNameTextField.setText(info.getTableName()); columnNameTextField.setText(info.getColumnName()); String dataType = JDBCTypeMapper.getJdbcTypeName(info.getDataType()); typeList.setSelectedItem(dataType); nullableCheckBox.setSelected(info.isNullable().equals("YES")); if (JDBCTypeMapper.isNumberType(info.getDataType())) { precisionSpinner.setValue(Integer.valueOf(info.getColumnSize())); } else { lengthSpinner.setValue(Integer.valueOf(info.getColumnSize())); } commentTextArea.setText(info.getRemarks()); defaultTextField.setText(info.getDefaultValue()); }
public void setExistingColumnInfo(TableColumnInfo info) { tableNameTextField.setText(info.getTableName()); columnNameTextField.setText(info.getColumnName()); String dataType = JDBCTypeMapper.getJdbcTypeName(info.getDataType()); typeList.setSelectedItem(dataType); nullableCheckBox.setSelected(info.isNullable().equals("YES")); if (JDBCTypeMapper.isNumberType(info.getDataType())) { precisionSpinner.setValue(Integer.valueOf(info.getColumnSize())); } else { lengthSpinner.setValue(Integer.valueOf(info.getColumnSize())); } commentTextArea.setText(info.getRemarks()); defaultTextField.setText(info.getDefaultValue()); }
/** * @see net.sourceforge.squirrel_sql.plugins.refactoring.commands.AbstractRefactoringCommand#generateSQLStatements() */ @Override protected String[] generateSQLStatements() throws UserCancelledOperationException { String[] result = new String[0]; if (_dialect.supportsAutoIncrement()) { DatabaseObjectQualifier qualifier = new DatabaseObjectQualifier(columnToModify.getCatalogName(), columnToModify.getSchemaName()); // TODO: Allow the user to specify the sequence name for dialects that don't natively support // auto-increment columns without using sequence/trigger combo. final StringBuilder sequenceName = new StringBuilder(); sequenceName.append(columnToModify.getTableName().toUpperCase()).append("_"); sequenceName.append(columnToModify.getColumnName().toUpperCase()).append("_SEQ"); result = _dialect.getAddAutoIncrementSQL(columnToModify, sequenceName.toString(), qualifier, _sqlPrefs); } else { _session.showMessage(s_stringMgr.getString("AddAutoIncrementCommand.unsupportedOperationMsg", _dialect.getDisplayName())); } return result; }
public void setColumn2(TableColumnInfo c2) { col2Type = c2.getDataType(); col2Length = c2.getColumnSize(); col2IsNullable = c2.isNullable().equalsIgnoreCase("NO") ? false : true; tableName = c2.getTableName(); columnName = c2.getColumnName(); col2remarks = c2.getRemarks(); col2default = c2.getDefaultValue(); }
tableTF.setPreferredSize(mediumField); tableTF.setEditable(false); tableTF.setText(dbInfo.getTableName()); pane.add(tableTF, getFieldConstraints(c));
public void setColumn1(TableColumnInfo c1) { col1Type = c1.getDataType(); col1Length = c1.getColumnSize(); col1IsNullable = c1.isNullable().equalsIgnoreCase("NO") ? false : true; tableName = c1.getTableName(); columnName = c1.getColumnName(); col1remarks = c1.getRemarks(); col1default = c1.getDefaultValue(); }
String sourceTableName = sourceColumn.getTableName(); String sourceColumnName = sourceColumn.getColumnName();
/** * @throws SQLException */ public void showCustomDialog() throws SQLException { ITableInfo ti = (ITableInfo) _info[0]; TableColumnInfo[] columns = _session.getMetaData().getColumnInfo(ti); if (columns == null || columns.length == 0) { _session.showErrorMessage(s_stringMgr.getString("AddPrimaryKeyCommand.noColumns", ti.getSimpleName())); return; } // Show the user a dialog with a list of columns and ask them to select one or more columns to drop customDialog = new ColumnListDialog(columns, ColumnListDialog.ADD_PRIMARY_KEY_MODE); customDialog.setTableName(ti.getQualifiedName()); // Set a default primary key name based on the name of the table customDialog.setPrimaryKeyName("PK_" + columns[0].getTableName().toUpperCase()); customDialog.addColumnSelectionListener(new ExecuteListener()); customDialog.addEditSQLListener(new EditSQLListener(customDialog)); customDialog.addShowSQLListener(new ShowSQLListener(i18n.SHOWSQL_DIALOG_TITLE, customDialog)); customDialog.setLocationRelativeTo(SessionUtils.getOwningFrame(_session)); customDialog.setMultiSelection(); customDialog.setVisible(true); }