📄 change_dialog.java
字号:
package person;import java.awt.*;import javax.swing.*;import com.borland.jbcl.layout.*;import com.borland.dbswing.*;import com.borland.dx.sql.dataset.*;import com.borland.dx.dataset.*;import java.awt.event.*;/** * <p>Title: </p> * <p>Description: </p> * <p>Copyright: Copyright (c) 2005</p> * <p>Company: </p> * @author not attributable * @version 1.0 */public class Change_Dialog extends JDialog { JPanel panel1 = new JPanel(); TableScrollPane tableScrollPane1 = new TableScrollPane(); JdbTable jdbTable1 = new JdbTable(); JPanel jPanel1 = new JPanel(); XYLayout xYLayout2 = new XYLayout(); JLabel jLabel1 = new JLabel(); JdbTextField jdbTextField1 = new JdbTextField(); JLabel jLabel2 = new JLabel(); JdbTextField jdbTextField2 = new JdbTextField(); JLabel jLabel3 = new JLabel(); JdbTextField jdbTextField3 = new JdbTextField(); JLabel jLabel4 = new JLabel(); JdbTextField jdbTextField4 = new JdbTextField(); JLabel jLabel5 = new JLabel(); JdbTextField jdbTextField5 = new JdbTextField(); JPanel jPanel2 = new JPanel(); XYLayout xYLayout3 = new XYLayout(); JButton jButton1 = new JButton(); JButton jButton2 = new JButton(); JButton jButton3 = new JButton(); JButton jButton4 = new JButton(); Database database1 = new Database(); QueryDataSet queryDataSet1 = new QueryDataSet(); Column column1 = new Column(); Column column2 = new Column(); Column column3 = new Column(); Column column4 = new Column(); Column column5 = new Column(); Column column6 = new Column(); Column column7 = new Column(); GridBagLayout gridBagLayout1 = new GridBagLayout(); public Change_Dialog(Frame frame, String title, boolean modal) { super(frame, title, modal); try { jbInit(); pack(); } catch(Exception ex) { ex.printStackTrace(); } } public Change_Dialog() { this(null, "", false); } private void jbInit() throws Exception { panel1.setLayout(gridBagLayout1); jPanel1.setBorder(BorderFactory.createEtchedBorder()); jPanel1.setLayout(xYLayout2); jLabel1.setFont(new java.awt.Font("DialogInput", 0, 12)); jLabel1.setText("员工号:"); jdbTextField1.setFont(new java.awt.Font("DialogInput", 0, 12)); jdbTextField1.setText(""); jdbTextField1.setColumnName("sid"); jdbTextField1.setDataSet(queryDataSet1); jLabel2.setText("原部门:"); jLabel2.setFont(new java.awt.Font("DialogInput", 0, 12)); jdbTextField2.setFont(new java.awt.Font("DialogInput", 0, 12)); jdbTextField2.setText(""); jdbTextField2.setColumnName("sDep"); jdbTextField2.setDataSet(queryDataSet1); jLabel3.setText("新部门:"); jLabel3.setFont(new java.awt.Font("DialogInput", 0, 12)); jdbTextField3.setFont(new java.awt.Font("DialogInput", 0, 12)); jdbTextField3.setText(""); jdbTextField3.setColumnName("dDep"); jdbTextField3.setDataSet(queryDataSet1); jLabel4.setText("变更时间:"); jLabel4.setFont(new java.awt.Font("DialogInput", 0, 12)); jdbTextField4.setText(""); jdbTextField4.setColumnName("cDate"); jdbTextField4.setDataSet(queryDataSet1); jLabel5.setText("变更原因:"); jLabel5.setFont(new java.awt.Font("DialogInput", 0, 12)); jdbTextField5.setFont(new java.awt.Font("DialogInput", 0, 12)); jdbTextField5.setText(""); jdbTextField5.setColumnName("reason"); jdbTextField5.setDataSet(queryDataSet1); jPanel2.setLayout(xYLayout3); jButton1.setFont(new java.awt.Font("DialogInput", 0, 12)); jButton1.setText("添加"); jButton1.addActionListener(new Change_Dialog_jButton1_actionAdapter(this)); jButton2.setText("保存"); jButton2.addActionListener(new Change_Dialog_jButton2_actionAdapter(this)); jButton2.setFont(new java.awt.Font("DialogInput", 0, 12)); jButton3.setText("删除"); jButton3.addActionListener(new Change_Dialog_jButton3_actionAdapter(this)); jButton3.setFont(new java.awt.Font("DialogInput", 0, 12)); jButton4.setText("退出"); jButton4.addActionListener(new Change_Dialog_jButton4_actionAdapter(this)); jButton4.setFont(new java.awt.Font("DialogInput", 0, 12)); database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:odbc:person", "", "", false, "sun.jdbc.odbc.JdbcOdbcDriver")); queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from change;", null, true, Load.ALL)); column1.setCaption("编号"); column1.setColumnName("id"); column1.setDataType(com.borland.dx.dataset.Variant.INT); column1.setRowId(true); column1.setTableName("change"); column1.setVisible(com.borland.jb.util.TriStateProperty.FALSE); column1.setServerColumnName("id"); column1.setSqlType(4); column2.setCaption("员工号"); column2.setColumnName("sid"); column2.setDataType(com.borland.dx.dataset.Variant.STRING); column2.setPrecision(50); column2.setTableName("change"); column2.setServerColumnName("sid"); column2.setSqlType(12); column3.setCaption("原部门"); column3.setColumnName("sDep"); column3.setDataType(com.borland.dx.dataset.Variant.STRING); column3.setPrecision(50); column3.setTableName("change"); column3.setServerColumnName("sDep"); column3.setSqlType(12); column4.setCaption("新部门"); column4.setColumnName("dDep"); column4.setDataType(com.borland.dx.dataset.Variant.STRING); column4.setPrecision(50); column4.setTableName("change"); column4.setServerColumnName("dDep"); column4.setSqlType(12); column5.setCaption("变更日期"); column5.setColumnName("cDate"); column5.setDataType(com.borland.dx.dataset.Variant.STRING); column5.setPrecision(50); column5.setTableName("change"); column5.setServerColumnName("cDate"); column5.setSqlType(12); column6.setCaption("变更原因"); column6.setColumnName("reason"); column6.setDataType(com.borland.dx.dataset.Variant.STRING); column6.setPrecision(50); column6.setTableName("change"); column6.setServerColumnName("reason"); column6.setSqlType(12); column7.setCaption("操作时间"); column7.setColumnName("mDate"); column7.setDataType(com.borland.dx.dataset.Variant.STRING); column7.setPrecision(50); column7.setTableName("change"); column7.setVisible(com.borland.jb.util.TriStateProperty.FALSE); column7.setServerColumnName("mDate"); column7.setSqlType(12); queryDataSet1.setColumns(new Column[] {column1, column2, column3, column4, column5, column6, column7}); jdbTable1.setFont(new java.awt.Font("DialogInput", 0, 12)); jdbTable1.setAutoResizeMode(JTable.AUTO_RESIZE_ALL_COLUMNS); jdbTable1.setDataSet(queryDataSet1); tableScrollPane1.setFont(new java.awt.Font("DialogInput", 0, 12)); this.setResizable(false); this.setTitle("人事变更管理"); getContentPane().add(panel1); panel1.add(tableScrollPane1, new GridBagConstraints(0, 0, 1, 1, 1.0, 1.0 ,GridBagConstraints.CENTER, GridBagConstraints.BOTH, new Insets(19, 16, 0, 15), 111, -239)); panel1.add(jPanel1, new GridBagConstraints(0, 1, 1, 1, 1.0, 1.0 ,GridBagConstraints.CENTER, GridBagConstraints.BOTH, new Insets(8, 16, 0, 15), 6, 11)); jPanel1.add(jLabel1, new XYConstraints(13, 14, -1, -1)); jPanel1.add(jdbTextField1, new XYConstraints(89, 12, 97, -1)); jPanel1.add(jLabel3, new XYConstraints(395, 12, -1, -1)); jPanel1.add(jdbTextField3, new XYConstraints(471, 10, 97, -1)); jPanel1.add(jLabel2, new XYConstraints(201, 13, -1, -1)); jPanel1.add(jdbTextField2, new XYConstraints(277, 11, 97, -1)); jPanel1.add(jLabel4, new XYConstraints(13, 50, -1, -1)); jPanel1.add(jdbTextField4, new XYConstraints(89, 48, 97, -1)); jPanel1.add(jLabel5, new XYConstraints(201, 47, -1, -1)); jPanel1.add(jdbTextField5, new XYConstraints(277, 45, 290, -1)); panel1.add(jPanel2, new GridBagConstraints(0, 2, 1, 1, 1.0, 1.0 ,GridBagConstraints.CENTER, GridBagConstraints.BOTH, new Insets(10, 16, 10, 15), 88, 16)); jPanel2.add(jButton2, new XYConstraints(188, 14, 68, -1)); jPanel2.add(jButton4, new XYConstraints(422, 14, 68, -1)); jPanel2.add(jButton1, new XYConstraints(71, 14, 68, -1)); jPanel2.add(jButton3, new XYConstraints(307, 14, 68, -1)); tableScrollPane1.getViewport().add(jdbTable1, null); } void jButton1_actionPerformed(ActionEvent e) { queryDataSet1.insertRow(false); } void jButton2_actionPerformed(ActionEvent e) { try{ queryDataSet1.post(); queryDataSet1.saveChanges(); queryDataSet1.refresh(); }catch(Exception ex){ queryDataSet1.refresh(); JOptionPane.showMessageDialog(this,"注册失败!","提示",JOptionPane.ERROR_MESSAGE); } } void jButton3_actionPerformed(ActionEvent e) { try{ queryDataSet1.deleteRow(); queryDataSet1.post(); queryDataSet1.saveChanges(); queryDataSet1.refresh(); }catch(Exception ex){ queryDataSet1.refresh(); JOptionPane.showMessageDialog(this,"删除失败","提示",JOptionPane.ERROR_MESSAGE); } } void jButton4_actionPerformed(ActionEvent e) { this.dispose(); }}class Change_Dialog_jButton1_actionAdapter implements java.awt.event.ActionListener { Change_Dialog adaptee; Change_Dialog_jButton1_actionAdapter(Change_Dialog adaptee) { this.adaptee = adaptee; } public void actionPerformed(ActionEvent e) { adaptee.jButton1_actionPerformed(e); }}class Change_Dialog_jButton2_actionAdapter implements java.awt.event.ActionListener { Change_Dialog adaptee; Change_Dialog_jButton2_actionAdapter(Change_Dialog adaptee) { this.adaptee = adaptee; } public void actionPerformed(ActionEvent e) { adaptee.jButton2_actionPerformed(e); }}class Change_Dialog_jButton3_actionAdapter implements java.awt.event.ActionListener { Change_Dialog adaptee; Change_Dialog_jButton3_actionAdapter(Change_Dialog adaptee) { this.adaptee = adaptee; } public void actionPerformed(ActionEvent e) { adaptee.jButton3_actionPerformed(e); }}class Change_Dialog_jButton4_actionAdapter implements java.awt.event.ActionListener { Change_Dialog adaptee; Change_Dialog_jButton4_actionAdapter(Change_Dialog adaptee) { this.adaptee = adaptee; } public void actionPerformed(ActionEvent e) { adaptee.jButton4_actionPerformed(e); }}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -