|
From: Gerd W. <ger...@us...> - 2004-05-16 10:23:13
|
Update of /cvsroot/squirrel-sql/sql12/plugins/editextras/src/net/sourceforge/squirrel_sql/plugins/editextras In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv19968 Modified Files: EditExtrasPlugin.java Resources.properties Added Files: EscapeDateAction.java EscapeDateController.java EscapeDateFrame.java Log Message: New right mouse click item in SQL entry area: 'Escape date' --- NEW FILE: EscapeDateController.java --- package net.sourceforge.squirrel_sql.plugins.editextras; import net.sourceforge.squirrel_sql.client.mainframe.MainFrame; import net.sourceforge.squirrel_sql.client.session.ISession; import net.sourceforge.squirrel_sql.fw.gui.GUIUtils; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.util.Calendar; public class EscapeDateController { private EscapeDateFrame _frame; private ISession _session; public EscapeDateController(ISession session, MainFrame mainFrame) { _session = session; _frame = new EscapeDateFrame(mainFrame); _frame.btnTimestamp.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { onTimeStamp(); } }); _frame.btnDate.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { onDate(); } }); _frame.btnTime.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { onTime(); } }); Calendar cal = Calendar.getInstance(); _frame.txtYear.setText("" + cal.get(Calendar.YEAR)); _frame.txtMonth.setText("" + (cal.get(Calendar.MONTH) + 1)); _frame.txtDay.setText("" + cal.get(Calendar.DAY_OF_MONTH)); _frame.txtHour.setText("" + cal.get(Calendar.HOUR_OF_DAY)); _frame.txtMinute.setText("" + cal.get(Calendar.MINUTE)); _frame.txtSecond.setText("" + cal.get(Calendar.SECOND)); GUIUtils.centerWithinParent(_frame); _frame.setVisible(true); } private String prefixNulls(String toPrefix, int digitCount) { String ret = "" + toPrefix; while(ret.length() < digitCount) { ret = 0 + ret; } return ret; } private void onTime() { String esc = "{t '" + prefixNulls(_frame.txtHour.getText(), 2) + ":" + prefixNulls(_frame.txtMinute.getText(), 2) + ":" + prefixNulls(_frame.txtSecond.getText(),2) + "'}"; _session.getSQLEntryPanel().replaceSelection(esc); _frame.setVisible(false); _frame.dispose(); } private void onDate() { String esc = "{d '" + prefixNulls(_frame.txtYear.getText(), 4) + "-" + prefixNulls(_frame.txtMonth.getText(), 2) + "-" + prefixNulls(_frame.txtDay.getText(), 2) + "'}"; _session.getSQLEntryPanel().replaceSelection(esc); _frame.setVisible(false); _frame.dispose(); } private void onTimeStamp() { String esc = "{ts '" + prefixNulls(_frame.txtYear.getText(), 4) + "-" + prefixNulls(_frame.txtMonth.getText(), 2) + "-" + prefixNulls(_frame.txtDay.getText(), 2) + " "+ prefixNulls(_frame.txtHour.getText(), 2) + ":" + prefixNulls(_frame.txtMinute.getText(), 2) + ":" + prefixNulls(_frame.txtSecond.getText(), 2) + "'}"; _session.getSQLEntryPanel().replaceSelection(esc); _frame.setVisible(false); _frame.dispose(); } } Index: EditExtrasPlugin.java =================================================================== RCS file: /cvsroot/squirrel-sql/sql12/plugins/editextras/src/net/sourceforge/squirrel_sql/plugins/editextras/EditExtrasPlugin.java,v retrieving revision 1.6 retrieving revision 1.7 diff -C2 -d -r1.6 -r1.7 *** EditExtrasPlugin.java 26 Apr 2004 12:49:10 -0000 1.6 --- EditExtrasPlugin.java 16 May 2004 10:22:50 -0000 1.7 *************** *** 252,255 **** --- 252,259 ---- coll.add(act); _resources.addToMenu(act, menu); + + act = new EscapeDateAction(getApplication(), _resources); + coll.add(act); + _resources.addToMenu(act, menu); } *************** *** 262,265 **** --- 266,270 ---- api.addToSQLEntryAreaMenu(actions.get(ConvertToStringBufferAction.class)); api.addToSQLEntryAreaMenu(actions.get(FormatSQLAction.class)); + api.addToSQLEntryAreaMenu(actions.get(EscapeDateAction.class)); } Index: Resources.properties =================================================================== RCS file: /cvsroot/squirrel-sql/sql12/plugins/editextras/src/net/sourceforge/squirrel_sql/plugins/editextras/Resources.properties,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** Resources.properties 27 Apr 2004 21:13:24 -0000 1.2 --- Resources.properties 16 May 2004 10:22:50 -0000 1.3 *************** *** 36,39 **** --- 36,41 ---- action.net.sourceforge.squirrel_sql.plugins.editextras.searchandreplace.ReplaceAction.tooltip=Replace ... + action.net.sourceforge.squirrel_sql.plugins.editextras.EscapeDateAction.name=Escape Date + action.net.sourceforge.squirrel_sql.plugins.editextras.EscapeDateAction.tooltip=Create Escape for Date/Time/TimeStamp ######## *************** *** 71,72 **** --- 73,76 ---- menuitem.net.sourceforge.squirrel_sql.plugins.editextras.searchandreplace.ReplaceAction.mnemonic= + menuitem.net.sourceforge.squirrel_sql.plugins.editextras.EscapeDateAction.accelerator= + menuitem.net.sourceforge.squirrel_sql.plugins.editextras.EscapeDateAction.mnemonic=E --- NEW FILE: EscapeDateAction.java --- package net.sourceforge.squirrel_sql.plugins.editextras; import net.sourceforge.squirrel_sql.client.IApplication; import net.sourceforge.squirrel_sql.client.action.SquirrelAction; import net.sourceforge.squirrel_sql.client.session.ISession; import net.sourceforge.squirrel_sql.client.session.action.ISessionAction; import java.awt.event.ActionEvent; public class EscapeDateAction extends SquirrelAction implements ISessionAction { private ISession _session; public EscapeDateAction(IApplication app, net.sourceforge.squirrel_sql.fw.util.Resources rsrc) { super(app, rsrc); } public void actionPerformed(ActionEvent e) { new EscapeDateController(_session, getApplication().getMainFrame()); } public void setSession(ISession session) { _session = session; } } --- NEW FILE: EscapeDateFrame.java --- package net.sourceforge.squirrel_sql.plugins.editextras; import javax.swing.*; import java.awt.*; public class EscapeDateFrame extends JDialog { JTextField txtYear = new JTextField(); JTextField txtMonth = new JTextField(); JTextField txtDay = new JTextField(); JTextField txtHour = new JTextField(); JTextField txtMinute = new JTextField(); JTextField txtSecond = new JTextField(); JButton btnTimestamp = new JButton("Time stamp"); JButton btnDate = new JButton("Date"); JButton btnTime = new JButton("Time"); public EscapeDateFrame(Frame owner) { super(owner, "Escape date"); JPanel pnlEdit = new JPanel(); pnlEdit.setLayout(new GridLayout(6,2)); pnlEdit.add(new JLabel("Year")); pnlEdit.add(txtYear); pnlEdit.add(new JLabel("Month")); pnlEdit.add(txtMonth); pnlEdit.add(new JLabel("Day")); pnlEdit.add(txtDay); pnlEdit.add(new JLabel("Hour")); pnlEdit.add(txtHour); pnlEdit.add(new JLabel("Minute")); pnlEdit.add(txtMinute); pnlEdit.add(new JLabel("Second")); pnlEdit.add(txtSecond); JPanel pnlButtons = new JPanel(new GridLayout(3,1)); pnlButtons.add(btnTimestamp); pnlButtons.add(btnDate); pnlButtons.add(btnTime); JPanel pnlMain = new JPanel(); pnlMain.setLayout(new BorderLayout()); pnlMain.add(pnlEdit, BorderLayout.CENTER); pnlMain.add(pnlButtons, BorderLayout.SOUTH); getContentPane().add(pnlMain); setSize(250, 250); getRootPane().setDefaultButton(btnTimestamp); } } |
