Java数据库系统项目开发实践2

//将这一程序加入包中 package enterpriseemployeeadministrate; //引入必要的包，为程序以后的需要服务 import java.awt.*; import java.awt.event.*; import javax.swing.*; import com.borland.jbcl.layout.*; import com.borland.dx.sql.dataset.*; import com.borland.dbswing.*; import javax.swing.event.*; import com.borland.dx.dataset.*; import java.sql.*; import java.io.*; //编写主窗口程序 public class Frame1 extends JFrame { JPanel contentPane; Database database1 = new Database(); JMenuBar jMenuBar1 = new JMenuBar(); JMenu jMenu1 = new JMenu(); JMenu jMenu2 = new JMenu(); JMenu jMenu3 = new JMenu(); JMenu jMenu4 = new JMenu(); JMenuItem jMenuItem6 = new JMenuItem(); JMenuItem jMenuItem7 = new JMenuItem(); JMenuItem jMenuItem8 = new JMenuItem(); JMenuItem jMenuItem12 = new JMenuItem(); JMenuItem jMenuItem13 = new JMenuItem(); JMenuItem jMenuItem14 = new JMenuItem(); JMenu jMenu5 = new JMenu(); JMenuItem jMenuItem15 = new JMenuItem(); JMenuItem jMenuItem16 = new JMenuItem(); JMenuItem jMenuItem17 = new JMenuItem(); JMenuItem jMenuItem18 = new JMenuItem(); JMenuItem jMenuItem19 = new JMenuItem(); JMenuItem jMenuItem20 = new JMenuItem(); JMenuItem jMenuItem21 = new JMenuItem(); JMenuItem jMenuItem22 = new JMenuItem(); JMenuItem jMenuItem23 = new JMenuItem(); JMenuItem jMenuItem24 = new JMenuItem(); JMenuItem jMenuItem26 = new JMenuItem(); JMenuItem jMenuItem3 = new JMenuItem(); JMenuItem jMenuItem11 = new JMenuItem(); 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(); Column column8 = new Column(); Column column9 = new Column(); JMenuItem jMenuItem28 = new JMenuItem(); JMenuItem jMenuItem1 = new JMenuItem(); JMenuItem jMenuItem27 = new JMenuItem(); //构造窗口 public Frame1() { enableEvents(AWTEvent.WINDOW_EVENT_MASK); try { jbInit(); } catch(Exception e) { e.printStackTrace(); } } //参数初始化 private void jbInit() throws Exception { jMenuItem27.addActionListener(new Frame1_jMenuItem27_actionAdapter(this)); jMenu1.setForeground(Color.black); jMenu1.setActionCommand(""); jMenuItem28.addActionListener(new Frame1_jMenuItem28_actionAdapter(this)); contentPane = (JPanel) this.getContentPane(); database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:odbc:person", "", "", false, "sun.jdbc.odbc.JdbcOdbcDriver")); database1.setDatabaseName(""); contentPane.setLayout(xYLayout2); this.setFont(new java.awt.Font("SansSerif", 0, 12)); this.setForeground(Color.white); this.setJMenuBar(jMenuBar1); this.setSize(new Dimension(400, 300)); this.setTitle("会员理系统"); contentPane.setBackground(Color.pink); contentPane.setForeground(Color.pink); contentPane.setAlignmentY((float) 0.5); jMenu1.setFont(new java.awt.Font("Dialog", 0, 13)); jMenu1.setText("会员信息管理"); jMenu2.setFont(new java.awt.Font("Dialog", 0, 13)); jMenu2.setText("用户权限管理"); jMenu3.setFont(new java.awt.Font("Dialog", 0, 13)); jMenu3.setText("信息处理"); //jMenuBar1.setBackground(Color.pink); jMenuBar1.setFont(new java.awt.Font("Dialog", 0, 13)); jMenuBar1.setForeground(new Color(212, 208, 200)); jMenuBar1.setRequestFocusEnabled(true); jMenuBar1.setToolTipText(""); jMenuBar1.setInputVerifier(null); jMenu4.setFont(new java.awt.Font("Dialog", 0, 13)); jMenu4.setText("系统使用帮助"); jMenuItem6.setFont(new java.awt.Font("Dialog", 0, 12)); jMenuItem6.setText("用户管理"); jMenuItem6.addActionListener(new Frame1_jMenuItem6_actionAdapter(this)); jMenuItem7.setFont(new java.awt.Font("Dialog", 0, 12)); jMenuItem7.setText("设置权限"); jMenuItem7.addActionListener(new Frame1_jMenuItem7_actionAdapter(this)); jMenuItem8.setFont(new java.awt.Font("Dialog", 0, 12)); jMenuItem8.setText("关于帮助"); jMenuItem8.addActionListener(new Frame1_jMenuItem8_actionAdapter(this)); jMenuItem12.setFont(new java.awt.Font("Dialog", 0, 12)); jMenuItem12.setText("会员信息管理"); jMenuItem12.addActionListener(new Frame1_jMenuItem12_actionAdapter(this)); jMenuItem13.setFont(new java.awt.Font("Dialog", 0, 12)); jMenuItem13.setText("用户信息管理"); jMenuItem13.addActionListener(new Frame1_jMenuItem13_actionAdapter(this)); jMenuItem14.setFont(new java.awt.Font("Dialog", 0, 12)); jMenuItem14.setText("退出"); jMenuItem14.addActionListener(new Frame1_jMenuItem14_actionAdapter(this)); jMenu5.setFont(new java.awt.Font("Dialog", 0, 12)); jMenu5.setText("会员信息查询 "); jMenuItem15.setFont(new java.awt.Font("Dialog", 0, 12)); jMenuItem15.setText("按会员号"); jMenuItem15.addActionListener(new Frame1_jMenuItem15_actionAdapter(this)); jMenuItem16.setFont(new java.awt.Font("Dialog", 0, 12)); jMenuItem16.setText("按姓名"); jMenuItem16.addActionListener(new Frame1_jMenuItem16_actionAdapter(this)); jMenuItem17.setFont(new java.awt.Font("Dialog", 0, 12)); jMenuItem17.setText("按生日"); jMenuItem17.addActionListener(new Frame1_jMenuItem17_actionAdapter(this)); jMenuItem18.setFont(new java.awt.Font("Dialog", 0, 12)); jMenuItem18.setText("按职务"); jMenuItem18.addActionListener(new Frame1_jMenuItem18_actionAdapter(this)); jMenuItem18.addAncestorListener(new Frame1_jMenuItem18_ancestorAdapter(this)); jMenuItem19.setFont(new java.awt.Font("Dialog", 0, 12)); jMenuItem19.setText("按部门"); jMenuItem19.addActionListener(new Frame1_jMenuItem19_actionAdapter(this)); jMenuItem19.addAncestorListener(new Frame1_jMenuItem19_ancestorAdapter(this)); jMenuItem20.setFont(new java.awt.Font("Dialog", 0, 12)); jMenuItem20.setText("按身份证号"); jMenuItem20.addActionListener(new Frame1_jMenuItem20_actionAdapter(this)); jMenuItem21.setFont(new java.awt.Font("Dialog", 0, 12)); jMenuItem21.setText("按年龄"); jMenuItem21.addActionListener(new Frame1_jMenuItem21_actionAdapter(this)); jMenuItem22.setFont(new java.awt.Font("Dialog", 0, 12)); jMenuItem22.setText("按电话号吗"); jMenuItem22.addActionListener(new Frame1_jMenuItem22_actionAdapter(this)); jMenuItem23.setFont(new java.awt.Font("Dialog", 0, 12)); jMenuItem23.setText("按银行卡号"); jMenuItem23.setArmed(false); jMenuItem23.addActionListener(new Frame1_jMenuItem23_actionAdapter(this)); jMenuItem24.setFont(new java.awt.Font("Dialog", 0, 12)); jMenuItem24.setText("按毕业院校"); jMenuItem24.addActionListener(new Frame1_jMenuItem24_actionAdapter(this)); jMenuItem26.setFont(new java.awt.Font("Dialog", 0, 12)); jMenuItem26.setText("打印会员信息"); jMenuItem3.setFont(new java.awt.Font("Dialog", 0, 12)); jMenuItem3.setText("打印生成报表"); jMenuItem11.setFont(new java.awt.Font("Dialog", 0, 12)); jMenuItem11.setText("按手机号码"); jMenuItem11.addActionListener(new Frame1_jMenuItem11_actionAdapter(this)); // author2.setRowId(false); column1.setColumnName("bookNo"); column1.setDataType(com.borland.dx.dataset.Variant.INT); column1.setDefault(""); column1.setRowId(true); column1.setResolvable(true); column1.setServerColumnName("bookNo"); column1.setSqlType(4); column2.setColumnName("bookName"); column2.setDataType(com.borland.dx.dataset.Variant.STRING); column2.setPrecision(50); column2.setRowId(true); column2.setServerColumnName("bookName"); column2.setSqlType(12); column3.setColumnName("author2"); column3.setDataType(com.borland.dx.dataset.Variant.STRING); column3.setPrecision(50); column3.setRowId(false); column3.setServerColumnName("aut