public class TableImpDialogOfORACLE extends AbstractProcessDialog{
/** * */ private static final long serialVersionUID = 1L;
private DebugPrn dMsg = new DebugPrn(TableImpDialogOfORACLE.class.getName()); //private static Logger dMsg = Logger.getLogger(DBResourceDialog.class.getName());
private I18n I18N = null; private String STR_ESCAPE_RELEASED = "ESCAPE_RELEASED"; private KeyStroke ESCAPE_STROKE = KeyStroke.getKeyStroke(KeyEvent.VK_ESCAPE, 0, false); private KeyStroke ENTER_STROKE = KeyStroke.getKeyStroke(KeyEvent.VK_ENTER, 0, false);
private DatabaseInfo dbInfo = null;
private JTextField jvalueTextArea = new JTextField(""); private JCheckBox jcIsTruncateFirst = new JCheckBox();
/**用户(ora) 或者 数据库名 的列表*/ // private ZJList jcmbDBName = new ZJList(); private ZXComboBox jcmbDBName = new ZXComboBox();
/**显示DB信息的JTable控件列名*/ private Vector vecColumnStrDBInfo = null; /**显示table信息的JTable控件列名*/ private Vector vecColumnStrTableInfo = null;
private NonEditableTableModel jtbModelTableInfo = null;
// 各种 监控器 和 动作事件 处理类 private KeyAdapter keyAdpJcmbEnter = null; private KeyAdapter keyAdpEscape = null; private ActionListener actionLsrJbutOk = null; private ActionListener actionLsrJbutEXECUTE = null; private ActionListener actionLsrJbutUpdateDBMSOwnerSystemTables = null;
private ActionListener actionLsrCommon = null;
private ActionListener actionFile = null;
private ActionListener itemLsrJcmbDBName = null; private Action actionEscape = null; private JFrame jfmMain = null; private AbstractProcessJFrame main = null;
private JTextField databaseLocalName = new JTextField(MainFrame.localDbName); private JTable jtblTableInfo = null;
//private final static ImageIcon ICON_DBSVR_RESVIEW_DESC = UIToolKit // .getIcon("uep-dev-d-dbres-browse");
/** * 构造函数 * @param frame * @param title * @param modal * @param inDbInfo */ public TableImpDialogOfORACLE(AbstractProcessJFrame main, String title, DatabaseInfo inDBInfo) { super(main, title, true); I18N = STMConsts.getI18N(); jfmMain = main; this.main = main; this.dbInfo = inDBInfo; boolean bOk = false; this.setCursor(new Cursor(Cursor.WAIT_CURSOR));
try { defineActions(); bOk = initialize();
} catch(Exception ignore) { dMsg.error("", ignore); return; } this.setCursor(new Cursor(Cursor.DEFAULT_CURSOR));
if(bOk) { ToolBox.setDlgCenterDisplayLocation(this); setVisible(true); }
}
/** * *各种事件处理函数 */ private void defineActions() { // Enter键 处理 keyAdpJcmbEnter = new KeyAdapter() {
public void keyPressed(KeyEvent e) { if(e.getSource() instanceof JComboBox) { if(!(((JComboBox) (e.getSource())).isPopupVisible())) { if(e.getKeyCode() == KeyEvent.VK_ENTER) { dMsg.error("111"); importTable(); } } } } }; // keyAdpEscape = new KeyAdapter() {
public void keyPressed(KeyEvent e) { if(e.getKeyCode() == KeyEvent.VK_ESCAPE) { close(); } } }; // actionEscape = new AbstractAction() {
/** * */ private static final long serialVersionUID = 1L;
public void actionPerformed(ActionEvent e) { close(); } }; // itemLsrJcmbDBName = new ActionListener() {
public void actionPerformed(ActionEvent e) { jcmbDBName_itemStateChanged(e); } };
// actionLsrJbutOk = new ActionListener() {
public void actionPerformed(ActionEvent e) { jbutOk_actionPerformed(e); } };
// actionLsrJbutEXECUTE = new ActionListener() {
public void actionPerformed(ActionEvent e) { jbutEXECUTE_actionPerformed(e); } };
// actionLsrJbutUpdateDBMSOwnerSystemTables = new ActionListener() {
public void actionPerformed(ActionEvent e) { jbutUpdateDBMSOwnerSystemTables_actionPerformed(e); } };
actionLsrCommon = new ActionListener() {
public void actionPerformed(ActionEvent ae) { //调度事件 jbRefreshClicked(ae); } };
actionFile = new ActionListener() {
public void actionPerformed(ActionEvent ae) { //调度事件 selectPath(jvalueTextArea); } }; }
/** * 更新 * @param ae ActionEvent */ private void jbRefreshClicked(ActionEvent ae) {
actionLsrJbutUpdateDBMSOwnerSystemTables.actionPerformed(ae);
}
/** * 消息回调方法 * @param msg String 系统表信息更新完成 */ public void addProcessMsg(String msg) { SwingUtilities.invokeLater(new UpdateHandler(this)); }
/** * 初使化操作 * */ private boolean initialize() { this.setSize(new Dimension(780, 550)); UIToolKit.setMinimumSize(this, 780, 550); this.setDefaultCloseOperation(WindowConstants.DISPOSE_ON_CLOSE); this.registerEscapeAction(this.getRootPane(), actionEscape); this.setupColumnStrVector();
//-------------数据表信息----------- jtbModelTableInfo = new NonEditableTableModel(new Vector(), this.vecColumnStrTableInfo);
if(addAllDBNamesToJcmbDBName() == false) { return false; }
jcmbDBName.addActionListener(null); jcmbDBName.addActionListener(itemLsrJcmbDBName); jcmbDBName.setEditable(false); jcmbDBName.setSelectedIndex(0); jcmbDBName.addKeyListener(keyAdpJcmbEnter);
//加载当前库所有表行数信息 jtblTableInfo = TableHelper.createSortableTable(jtbModelTableInfo); jtblTableInfo.setAutoResizeMode(JTable.AUTO_RESIZE_OFF); jtblTableInfo.addKeyListener(keyAdpEscape); setCellRender(jtblTableInfo); jtblTableInfo.setDefaultRenderer(String.class, new CellRender()); jtblTableInfo.setSelectionMode(ListSelectionModel.SINGLE_SELECTION); JScrollPane jscrPaneTableInfo = new JScrollPane(); jscrPaneTableInfo.getViewport().add(jtblTableInfo); if(loadTableInfoofCurrUser() == false) { return false; } JPanel panelTableInfo = new JPanel(); panelTableInfo.setLayout(new BorderLayout(6, 6));
JPanel jscrDBNamesInfo = new JPanel(); jscrDBNamesInfo.setLayout(new BorderLayout(6, 6));
JPanel p1 = new JPanel(); p1.setLayout(new GridBagLayout()); p1.setPreferredSize(new Dimension(300, 30));
/* p1.add(new JLabel("数据库本地服务名称："), new GridBagConstraints(0, 0, 1, 1, 1.0, 1.0, GridBagConstraints.NORTHWEST, GridBagConstraints.BOTH, new Insets(0, 0, 0, 0), 0, 0));
p1.add(databaseLocalName, new GridBagConstraints(1, 0, 1, 1, 0.0, 0.0, GridBagConstraints.NORTHWEST, GridBagConstraints.BOTH, new Insets(0, 0, 0, 0), 0, 0)); */ p1.add(new JLabel(STMConsts.getI18N().getLabelValue("info_dataclear_database")), new GridBagConstraints(0, 0, 1, 1, 1.0, 1.0, GridBagConstraints.NORTHWEST, GridBagConstraints.BOTH, new Insets(0, 0, 0, 0), 0, 0));
p1.add(jcmbDBName, new GridBagConstraints(1, 0, 1, 1, 0.0, 0.0, GridBagConstraints.NORTHWEST, GridBagConstraints.BOTH, new Insets(0, 0, 0, 150), 0, 0));
JPanel dblocalNamePanel = new JPanel(); dblocalNamePanel.setLayout(new BorderLayout(6, 6)); dblocalNamePanel.setPreferredSize(new Dimension(400, 30));
if(!MainFrame.isDbIP_local()) { dblocalNamePanel.add(new JLabel(STMConsts.getI18N().getLabelValue( "info_dataclear_para_localName")), BorderLayout.WEST);
databaseLocalName.setPreferredSize(new Dimension(100, 30)); dblocalNamePanel.add(databaseLocalName, BorderLayout.CENTER); } JPanel p4 = new JPanel(); p4.setLayout(new BorderLayout(6, 6)); p4.setPreferredSize(new Dimension(600, 30)); p4.add(p1, BorderLayout.WEST); p4.add(dblocalNamePanel, BorderLayout.CENTER);
jscrDBNamesInfo.add(p4, BorderLayout.NORTH);
JPanel p2 = new JPanel(); p2.setLayout(new BorderLayout(6, 6)); p2.setPreferredSize(new Dimension(600, 30));
JButton fileButton = new JButton(STMConsts.getI18N().getLabelValue("info_imp_filebutton")); fileButton.setMnemonic('F'); fileButton.addActionListener(actionFile);
JPanel p3 = new JPanel(); p3.setLayout(new BorderLayout(6, 6)); p3.setPreferredSize(new Dimension(200, 30));
p3.add(fileButton, BorderLayout.CENTER);
p2.add(jvalueTextArea, BorderLayout.CENTER); p2.add(p3, BorderLayout.EAST);
jscrDBNamesInfo.add(p2, BorderLayout.CENTER);
panelTableInfo.add(jscrDBNamesInfo, BorderLayout.NORTH); jscrPaneTableInfo.setBorder(BorderFactory.createTitledBorder("")); panelTableInfo.add(jscrPaneTableInfo, BorderLayout.CENTER);
// 增加提示信息： JPanel panelTip = new JPanel(); //panelDBVersion.setPreferredSize(new Dimension(300, 30)); panelTip.setBorder(new TitledBorder(BorderFactory.createTitledBorder(BorderFactory .createEtchedBorder(), STMConsts.getI18N().getLabelValue("info_shrink_help"), TitledBorder.LEFT, TitledBorder.TOP)));
panelTip.setLayout(new BorderLayout()); JTextArea jtaVersionInfo = new JTextArea(); jtaVersionInfo.setLineWrap(true); // jtaVersionInfo.setWrapStyleWord(true); jtaVersionInfo.setBackground(panelTip.getBackground()); jtaVersionInfo.setEditable(false); StringBuffer text = new StringBuffer(); //不同的操作系统提示信息不同
//本地数据库 if(MainFrame.isDbIP_local()) { //solaris if(Common.OS_SOLARIS.equals(MainFrame.getOs())) { text.append(STMConsts.getI18N().getLabelValue("oracle_local_sun_help_info1")) .append(System.getProperty("line.separator")); } //Windows else if(Common.OS_WINDOWS.equals(MainFrame.getOs())) { text.append(STMConsts.getI18N().getLabelValue("oracle_local_win_help_info1")) .append(System.getProperty("line.separator")); } } //远程数据库 else { //solaris if(Common.OS_SOLARIS.equals(MainFrame.getOs())) { text.append(STMConsts.getI18N().getLabelValue("oracle_remote_sun_help_info1")) .append(System.getProperty("line.separator")); text.append(STMConsts.getI18N().getLabelValue("oracle_remote_sun_help_info2")) .append(System.getProperty("line.separator")); text.append(STMConsts.getI18N().getLabelValue("oracle_remote_sun_help_info13")) .append(System.getProperty("line.separator")); } //Windows else if(Common.OS_WINDOWS.equals(MainFrame.getOs())) { text.append(STMConsts.getI18N().getLabelValue("oracle_remote_win_help_info1")) .append(System.getProperty("line.separator")); text.append(STMConsts.getI18N().getLabelValue("oracle_remote_win_help_info2")) .append(System.getProperty("line.separator")); text.append(STMConsts.getI18N().getLabelValue("oracle_remote_win_help_info3")) .append(System.getProperty("line.separator")); } }
jtaVersionInfo.setText(text.toString()); panelTip.add(jtaVersionInfo, BorderLayout.CENTER);
panelTableInfo.add(panelTip, BorderLayout.SOUTH);
JPanel jpTabRoot = new JPanel(); jpTabRoot.setLayout(new GridBagLayout()); jpTabRoot.add(panelTableInfo, new GridBagConstraints(0, 0, 1, 1, 1.0, 1.0, GridBagConstraints.CENTER, GridBagConstraints.BOTH, new Insets(6, 6, 6, 6), 0, 0));
//进程信息panelProcessInfo------------------------
//----this.getContentPane() JButton jbutRefresh = new JButton(I18N.getLabelValue("I18N_REFRESH_R")); jbutRefresh.setMnemonic('R'); jbutRefresh.addActionListener(actionLsrCommon);
JButton jbutClose = new JButton(I18N.getLabelValue("I18N_CANCEL")); jbutClose.setMnemonic('C');
jbutClose.addActionListener(actionLsrJbutOk);
JButton jbutEXECUTE = new JButton(I18N.getLabelValue("info_imp_button")); jbutEXECUTE.setMnemonic('E'); jbutEXECUTE.registerKeyboardAction(actionLsrJbutEXECUTE, ENTER_STROKE, JComponent.WHEN_IN_FOCUSED_WINDOW); jbutEXECUTE.addActionListener(actionLsrJbutEXECUTE);
JPanel jpButtonPanel = new JPanel(); jpButtonPanel.setLayout(new GridBagLayout()); jcIsTruncateFirst.setText(I18N.getLabelValue("info_imp_checkbox_truncate")); jpButtonPanel.add(jcIsTruncateFirst, new GridBagConstraints(0, 0, 1, 1, 0.0, 0.0, GridBagConstraints.NORTHWEST, GridBagConstraints.WEST, new Insets(0, 0, 0, 295), 10, 0)); jpButtonPanel.add(jbutEXECUTE, new GridBagConstraints(1, 0, 1, 1, 0.0, 0.0, GridBagConstraints.NORTHWEST, GridBagConstraints.EAST, new Insets(0, 0, 0, 3), 10, 0)); jpButtonPanel.add(jbutRefresh, new GridBagConstraints(2, 0, 1, 1, 0.0, 0.0, GridBagConstraints.EAST, GridBagConstraints.NONE, new Insets(0, 0, 0, 3), 0, 0));
jpButtonPanel.add(jbutClose, new GridBagConstraints(3, 0, 1, 1, 0.0, 0.0, GridBagConstraints.NORTHWEST, GridBagConstraints.NONE, new Insets(0, 3, 0, 0), 0, 0)); this.getContentPane().setLayout(new GridBagLayout());
/* JPanel jpDesc = UIToolKit.createDialogDescPanel(I18N .getLabelValue("DIALOG_DESC_DBRES_VIEW_TITLE"), I18N .getLabelValue("DIALOG_DESC_DBRES_VIEW_DESC"), ICON_DBSVR_RESVIEW_DESC); this.getContentPane().add( jpDesc, new GridBagConstraints(0, 0, 1, 1, 1.0, 0.0, GridBagConstraints.NORTHWEST, GridBagConstraints.HORIZONTAL, new Insets(0, 0, 3, 0), 0, 0)); */ this.getContentPane().add( jpTabRoot, new GridBagConstraints(0, 1, 1, 1, 1.0, 1.0, GridBagConstraints.CENTER, GridBagConstraints.BOTH, new Insets(3, 12, 6, 12), 385, 242)); this.getContentPane().add( jpButtonPanel, new GridBagConstraints(0, 2, 1, 1, 0.0, 0.0, GridBagConstraints.EAST, GridBagConstraints.NONE, new Insets(6, 0, 12, 12), 0, 0)); jbutClose.requestFocus(); return true; }
/** * 加载当前库的所有表的信息 * @return boolean 失败返回false */ private boolean loadTableInfoofCurrUser() { String dbName = (String) jcmbDBName.getSelectedItem(); Vector vecTableInfo2D = null; try { vecTableInfo2D = DBAction.getAllTableInfoOfOwner(this.jfmMain, dbName, this.dbInfo); for(int i = 0; i < vecTableInfo2D.size(); i++) { Vector vecRowData = (Vector) vecTableInfo2D.get(i); Vector vecParsed = parseData(vecRowData); vecTableInfo2D.setElementAt(vecParsed, i); } jtbModelTableInfo.setDataVector(vecTableInfo2D, this.vecColumnStrTableInfo); int iWidth = this.dbInfo.getDBType() == DatabaseInfo.DBTYPE_ORACLE ? 220 : 150; for(int iIndex = 0; iIndex < vecColumnStrTableInfo.size(); iIndex++) { jtblTableInfo.getColumnModel().getColumn(iIndex).setPreferredWidth(iWidth); } } catch(FIException fiEx) { ZJShowMsgPane.showDetailMessage(this, fiEx); return false; } return true; }
/** * *设置显示DB和Table信息的JTable列名称 */ private void setupColumnStrVector() { vecColumnStrDBInfo = new Vector(); vecColumnStrTableInfo = new Vector();
int iDBType = this.dbInfo.getDBType(); switch(iDBType) { case DatabaseInfo.DBTYPE_ORACLE: //显示DB信息的JTable控件列名 this.vecColumnStrDBInfo.add(I18N.getLabelValue("dbSpaceName")); this.vecColumnStrDBInfo.add(I18N.getLabelValue("assignSize") + "(KB)"); this.vecColumnStrDBInfo.add(I18N.getLabelValue("usedSize") + "(KB)"); this.vecColumnStrDBInfo.add(I18N.getLabelValue("leftSize") + "(KB)"); this.vecColumnStrDBInfo.add(I18N.getLabelValue("leftPercent") + "(%)"); this.vecColumnStrDBInfo.add(I18N.getLabelValue("autoextensible")); this.vecColumnStrDBInfo.add(I18N.getLabelValue("datafile")); //显示table信息的JTable控件列名 this.vecColumnStrTableInfo.add(I18N.getLabelValue("tabName")); this.vecColumnStrTableInfo.add(I18N.getLabelValue("inDbSpace")); this.vecColumnStrTableInfo.add(I18N.getLabelValue("recNum"));
break; case DatabaseInfo.DBTYPE_MSSQL: //显示DB信息的JTable控件列名 this.vecColumnStrDBInfo.add(I18N.getLabelValue("dbName")); this.vecColumnStrDBInfo.add(I18N.getLabelValue("dbSize") + "(MB)"); this.vecColumnStrDBInfo.add(I18N.getLabelValue("UnassignSize") + "(MB)"); this.vecColumnStrDBInfo.add(I18N.getLabelValue("reserveSize") + "(KB)"); this.vecColumnStrDBInfo.add(I18N.getLabelValue("dataSize") + "(KB)"); this.vecColumnStrDBInfo.add(I18N.getLabelValue("indexSize") + "(KB)"); this.vecColumnStrDBInfo.add(I18N.getLabelValue("unusedSize") + "(KB)"); this.vecColumnStrDBInfo.add(I18N.getLabelValue("I18N_MDF_FREE_PERCENT") + "(%)"); //显示table信息的JTable控件列名 this.vecColumnStrTableInfo.add(I18N.getLabelValue("tabName")); this.vecColumnStrTableInfo.add(I18N.getLabelValue("recNum")); this.vecColumnStrTableInfo.add(I18N.getLabelValue("reserveSize") + "(KB)"); this.vecColumnStrTableInfo.add(I18N.getLabelValue("dataSize") + "(KB)"); this.vecColumnStrTableInfo.add(I18N.getLabelValue("indexSize") + "(KB)"); this.vecColumnStrTableInfo.add(I18N.getLabelValue("unusedSize") + "(KB)"); //显示 process info 的JTable控件列名
break;
default: dMsg.error("Wrong database got! iDBType=" + iDBType); break; } }
/** * 将数据库/用户名 添加到 jcmbDBName 中 */ private boolean addAllDBNamesToJcmbDBName() { String[] dbName = new String[3]; if(this.dbInfo.getDBType() == DatabaseInfo.DBTYPE_ORACLE) { dbName[0] = DatabaseInfo.EMS_ORACLE_UEP; dbName[1] = DatabaseInfo.EMS_ORACLE_UEPPM; dbName[2] = DatabaseInfo.EMS_ORACLE_CAFFM;
} else { dbName[0] = DatabaseInfo.EMS_MSSQL_UEP; dbName[1] = DatabaseInfo.EMS_MSSQL_UEPPM; dbName[2] = DatabaseInfo.EMS_MSSQL_CAFFM;
} String[] arrStrDBNames = null; try { arrStrDBNames = DBAction.getDBSOwners(this.jfmMain, this.dbInfo); if(arrStrDBNames != null) { for(int i = 0; i < arrStrDBNames.length; i++) { for(int j = 0; j < dbName.length; j++) { if(dbName[j].equalsIgnoreCase(arrStrDBNames[i])) { jcmbDBName.addItem((arrStrDBNames[i])); } } } jcmbDBName.setSelectedIndex(0); } } catch(FIException fiEx) { ZJShowMsgPane.showDetailMessage(this, fiEx); return false; } return true; }
/** * * @param itemEvent */ private void jcmbDBName_itemStateChanged(ActionEvent itemEvent) { String dbName = (String) jcmbDBName.getSelectedItem(); Vector vecTableInfo2D = null; this.setCursor(new Cursor(Cursor.WAIT_CURSOR)); try { vecTableInfo2D = DBAction.getAllTableInfoOfOwner(this.jfmMain, dbName, this.dbInfo); jtbModelTableInfo.removeAllRow(); for(int i = 0; i < vecTableInfo2D.size(); i++) { Vector vecRawData = (Vector) vecTableInfo2D.get(i); Vector vecParsed = parseData(vecRawData); jtbModelTableInfo.addRow(vecParsed); } } catch(FIException fiEx) { jtbModelTableInfo.setDataVector(vecTableInfo2D, this.vecColumnStrTableInfo); ZJShowMsgPane.showDetailMessage(this, fiEx); } this.setCursor(new Cursor(Cursor.DEFAULT_CURSOR)); }
/** * * @param vec * @return */ private Vector parseData(Vector vec) { Vector vecFolat = new Vector(); int iVecSize = vec.size(); float fvalue = (float) 0.0; int iDBType = this.dbInfo.getDBType(); for(int i = 0; i < iVecSize; i++) { String tempstr = vec.get(i).toString(); tempstr = tempstr.trim(); String oldtemp = tempstr; int iUnit = tempstr.indexOf("MB"); if(iUnit == -1) { iUnit = tempstr.indexOf("KB"); } if(iUnit == -1) { iUnit = tempstr.indexOf("%"); } if(iUnit == -1) { try { //格式化显示剩余空间数据，都显示两位小数 switch(iDBType) { case DatabaseInfo.DBTYPE_MSSQL: if(i == iVecSize - 1) { DecimalFormat df1 = new DecimalFormat("0.00"); vecFolat.addElement(df1.format(Float.valueOf(tempstr))); } else { vecFolat.addElement(Float.valueOf(tempstr)); } break; case DatabaseInfo.DBTYPE_ORACLE: if(i == 4) { DecimalFormat df1 = new DecimalFormat("0.00"); vecFolat.addElement(df1.format(Float.valueOf(tempstr))); } else { vecFolat.addElement(Float.valueOf(tempstr)); } break; } continue; } catch(NumberFormatException ex) { vecFolat.addElement(tempstr); continue; } } try { tempstr = tempstr.substring(0, iUnit); fvalue = Float.parseFloat(tempstr); vecFolat.addElement(new Float(fvalue)); } catch(NumberFormatException ex) { vecFolat.addElement(oldtemp); continue; } } return vecFolat; }
/** * * @param e * @JTIUP */ private void jbutUpdateDBMSOwnerSystemTables_actionPerformed(ActionEvent e) {
// int iOption = ZJShowMsgPane.showConfirmDialog(STMClientView.getSTMMainFrame(), // I18N.getLabelValue("I18N_UPDATE_STAT_TIP"), // I18N.getLabelValue("dialogQuestion"), // ZJShowMsgPane.OK_CANCEL_OPTION, // ZJShowMsgPane.QUESTION_MESSAGE); // if(iOption != ZJShowMsgPane.OK_OPTION) { // return; // } // begin updating... String strOwner = (String) jcmbDBName.getSelectedItem(); this.setCursor(new Cursor(Cursor.WAIT_CURSOR)); try { this.dbInfo.setOwner(strOwner); DBAction.updateDBMSSystemTables(this, this.dbInfo, strOwner); } catch(FIException fiEx) { ZJShowMsgPane.showDetailMessage(this, fiEx); } this.setCursor(new Cursor(Cursor.DEFAULT_CURSOR)); ZJShowMsgPane.showMessageDialog(this, I18N.getLabelValue("I18N_UPDATING_TIP"), ZJShowMsgPane.INFORMATION_MESSAGE); }
/** * 关闭操作 * 也就是唯一按钮ok按钮的action响应方法 * @param e * @JTIUP */ private void jbutOk_actionPerformed(ActionEvent e) { this.close(); }
/** * 关闭操作 * 也就是唯一按钮ok按钮的action响应方法 * @param e * @JTIUP */ private void jbutEXECUTE_actionPerformed(ActionEvent e) { importTable(); //this.close(); }
/** * 注册escape按键事件到指定组件 当指定组件在当前窗口时,action动作会注册到escape按键响应上 * * @param component * @param action */ private void registerEscapeAction(JComponent component, Action action) { component.getInputMap(JComponent.WHEN_IN_FOCUSED_WINDOW).put(ESCAPE_STROKE, STR_ESCAPE_RELEASED); component.getActionMap().put(STR_ESCAPE_RELEASED, action); }
/** * 撤销指定组件的escape事件 * 将escape响应从指定组件上撤销 * @param component */ private void unregisterEscapeAction(JComponent component) { component.getInputMap(JComponent.WHEN_IN_FOCUSED_WINDOW).remove(ESCAPE_STROKE); component.getActionMap().remove(STR_ESCAPE_RELEASED); }
private void importTable() {
try { if(jtblTableInfo.getSelectedRow() == -1) { throw new STMRuntimeException(STMConsts.getI18N().getLabelValue( "info_dataclear_chooseTable")); }
String path = jvalueTextArea.getText().trim();
if(path.equals("")) { throw new STMRuntimeException(STMConsts.getI18N().getLabelValue( "info_imp_inputfile")); }
File file = new File(path); if(file.exists() && file.isFile()) {
} else { throw new STMRuntimeException(STMConsts.getI18N().getLabelValue( "info_imp_inputfile_ag")); }
String localDbName = databaseLocalName.getText().trim(); if(!MainFrame.isDbIP_local() && "".equals(localDbName)) { throw new STMRuntimeException(STMConsts.getI18N().getLabelValue( "info_dataclear_inputDBlocal")); } String dbName = (String) jcmbDBName.getSelectedItem(); String tableName = (String) jtblTableInfo.getModel().getValueAt( jtblTableInfo.getSelectedRow(), 0);
// MainFrame.waitThread = new WaitThread(main, STMConsts.getI18N().getLabelValue(// "info_imp_waitng"), STMConsts.getI18N().getLabelValue("info_imp_waitng"));// MainFrame.waitThread.start(); main.paintStatus(STMConsts.getI18N().getLabelValue("info_imp_waitng")); main.guiChange(false); if(jcIsTruncateFirst.isSelected()) { String sql = "truncate table " + dbName + "." + tableName; DBAction.executeUpdateSql(this.jfmMain, dbInfo, dbName, sql); } //checkData(dbName,tableName); //exp system/system@10.40.182.168_uep tables=caffm.caf_alarm file=d://ueppm.dmp log=ueppm.log //imp system/system@10.40.182.168_uep fromuser=caffm tables=caf_alarm file=d://ueppm.dmp ignore=y log=x.log Date date = new Date(System.currentTimeMillis()); SimpleDateFormat sdf1 = new SimpleDateFormat("yyyyMMdd_HHmm"); String affrix = sdf1.format(date); String fileName = path; //System.out.println(new File(fileName).getParent()); //String logfileName = path+System.getProperty("file.separator")+ tableName+"_"+affrix+".log"; String logfileName = new File(fileName).getParent() + System.getProperty("file.separator") + "imp_" + tableName + "_" + affrix + ".log";
StringBuffer impBuf = new StringBuffer(); impBuf.append("imp ").append(dbInfo.getUser()).append("/").append(dbInfo.getPassword()); if(!MainFrame.isDbIP_local() && !"".equals(localDbName)) { impBuf.append("@").append(localDbName); } impBuf.append(" fromuser=").append(dbName); impBuf.append(" touser=").append(dbName); impBuf.append(" tables=").append(tableName); //expBuf.append("imp ").append(" caffm/U_tywg_2008@10.40.182.168_uep tables=caf_alarm"); impBuf.append(" file=").append(fileName).append(" ignore=y "); //impBuf.append(" file=").append(fileName).append(" ignore=y log=").append(logfileName); close(); MainFrame.localDbName = localDbName;
List cmdList = new ArrayList(); cmdList.add(impBuf.toString());
DBAction.runTableExpImpProcessor(main, cmdList, MainFrame.getOs(), MainFrame.ORACLE_USER_NAME);
//dMsg.error("结束数据导入");
} catch(STMRuntimeException e) { //MainFrame.closeWaitDialog(); //main.clearStatus(); ZJShowMsgPane.showMessageDialog(this, e.toString(), STMConsts.getI18N().getLabelValue( "ZJShowMsgPane_QuestionMessage"), ZJShowMsgPane.WARNING_MESSAGE);
} catch(FIException e) { //MainFrame.closeWaitDialog(); //main.clearStatus(); ZJShowMsgPane.showMessageDialog(this, e.toString(), STMConsts.getI18N().getLabelValue( "ZJShowMsgPane_QuestionMessage"), ZJShowMsgPane.WARNING_MESSAGE); }
}
private void selectPath(JTextField path) { JFileChooser chooser = new JFileChooser(); chooser.setCurrentDirectory(new File("./")); chooser.setFileSelectionMode(JFileChooser.FILES_ONLY);
chooser.setFileFilter(new FileFilterBase("dmp"));
int returnVal = chooser.showOpenDialog(this);
if(returnVal == JFileChooser.APPROVE_OPTION) { path.setText(chooser.getSelectedFile().getPath()); } }
/** * 退出对话框 */ private void close() { unregisterEscapeAction(this.getRootPane());
dispose(); }
private void setCellRender(JTable table) { int size = table.getColumnCount(); for(int i = 0; i < size; i++) { Class cla = table.getColumnClass(i); table.setDefaultRenderer(cla, new CellRender()); } }
/** * <p>Title: </p> * * <p>Description: </p> * * <p>Copyright: Copyright (c) 2007</p> * * <p>Company: 中兴通讯股分有限公司</p> * @author wanghong * @version 3.0 */ private class CellRender extends DefaultTableCellRenderer {
/** * */ private static final long serialVersionUID = 1L;
CellRender() { }
/** * Returns the component used for drawing the cell. * * @param table the <code>JTable</code> that is asking the renderer to draw; can be <code>null</code> * @param value the value of the cell to be rendered. It is up to the specific renderer to interpret and draw * the value. For example, if <code>value</code> is the string "true", it could be rendered as a string or it * could be rendered as a check box that is checked. <code>null</code> is a valid value * @param isSelected true if the cell is to be rendered with the selection highlighted; otherwise false * @param hasFocus if true, render cell appropriately. For example, put a special border on the cell, if the * cell can be edited, render in the color used to indicate editing * @param row the row index of the cell being drawn. When drawing the header, the value of <code>row</code> is -1 * @param column the column index of the cell being drawn * @return Component * @todo Implement this javax.swing.table.TableCellRenderer method */ public Component getTableCellRendererComponent(JTable table, Object value, boolean isSelected, boolean hasFocus, int row, int column) { Object disPlay = value; if(value instanceof Float) { //去掉小数点 if(value.toString().endsWith(".0")) { disPlay = String.valueOf(((Float) value).longValue()); } } return super.getTableCellRendererComponent(table, disPlay, isSelected, hasFocus, row, column); } }
/** * * <p>Title: </p> * <p>Description: </p> * <p>Copyright: Copyright (c) 2007</p> * <p>Company: 中兴通讯股分有限公司</p> * @author not attributable * @version 3.0 */ private class UpdateHandler implements Runnable {
private TableImpDialogOfORACLE dbResDialog = null;
/** * 更新界面 * @param dialog DBResourceDialog */ public UpdateHandler(TableImpDialogOfORACLE dialog) { dbResDialog = dialog; }
/** * 更新界面 */ public void run() { dbResDialog.setCursor(new Cursor(Cursor.WAIT_CURSOR)); try { dbResDialog.loadTableInfoofCurrUser(); } catch(Exception ex) { ex.printStackTrace(); } catch(Throwable ex) { ex.printStackTrace(); } dbResDialog.setCursor(new Cursor(Cursor.DEFAULT_CURSOR));
} }
public AbstractProcessJFrame getMain() { return main; }
public void setMain(AbstractProcessJFrame main) { this.main = main; }}
