con=JDBConnect.getConn();
st=con.createStatement();
}
private class Handler implements ItemListener{
public void itemStateChanged(ItemEvent e){ if(e.getStateChange() == e.SELECTED){ select=selects[jcomboBox.getSelectedIndex()]; }
}
}
private class BHandler implements ActionListener{ public void actionPerformed(ActionEvent e){ if(e.getSource()==jMenuItem1){//上页 dispose();
Management m= new Management(Name);
m.setVisible(true);
}
else if(e.getSource()==jMenuItem2){//主页 dispose();
index i=
new index(); i.setVisible(true);
}
else if(e.getSource()==jMenuItem3){//帮助 int i=0; dispose();
help help1= new help(Name,i,\
help1.setVisible(true); }
else if(e.getSource()==jMenuItem4){//退出 System.exit(0); }
else if(e.getSource()==FINDButton){ //显示数据查询数据库
try{
ResultSet RS = null; if(select.equals(\职工编号\
RS=st.executeQuery(\
*
EmployID='\
} else if(select.equals(\姓名\ RS=st.executeQuery(\
*
EmployName='\
}
from
Employee
from
Employee
where
where
26
功!\
}
}
}
}
else if(select.equals(\职务\ }
// else JOptionPane.showMessageDialog(null, \查找失败\if(RS.next()){
String[] columnNames = { \编号\\姓名\性别\年龄\部门\住址 RS=st.executeQuery(\
*
from
Employee
where
EmployJob='\
\职务\电话\密码\
DefaultTableModel model = new DefaultTableModel(columnNames, 9);
table1.setModel(model);// 设置表格数据模型
table1.setValueAt(RS.getString(\
table1.setValueAt(RS.getString(\table1.setValueAt(RS.getString(\table1.setValueAt(RS.getInt(\table1.setValueAt(RS.getString(\table1.setValueAt(RS.getString(\table1.setValueAt(RS.getString(\table1.setValueAt(RS.getString(\table1.setValueAt(RS.getString(\ scrollPane1.setViewportView(table1);
else JOptionPane.showMessageDialog(null, \查找失败\
}catch(Exception ex){}
else if(e.getSource()==SUBButton){ //删除员工
try{
if(select.equals(\职工编号\
if(JOptionPane.showConfirmDialog(null,\{
try{
//利用st对象执行SQL删除操作 st.executeQuery(\
//利用消息对话框提示删除操作成功
JOptionPane.showMessageDialog(null,\职工删除操作，执行成//清空输入学号的文本行 }
from
Employee
where
确
认
要
删
除
吗
？
\
EmployID='\
catch(Exception ex){
//利用消息对话框提示不能删除
//JOptionPane.showMessageDialog(null,\职工删除操作，执行失败!\
27
功!\
} 功!\
}
确
认
要
删
除
吗
？
else if(select.equals(\姓名\
if(JOptionPane.showConfirmDialog(null,\{ } }
if(JOptionPane.showConfirmDialog(null,\{
try{
//利用st对象执行SQL删除操作 st.executeQuery(\
from
Employee
where
确
认
要
删
除
吗
？
try{
//利用st对象执行SQL删除操作 st.executeQuery(\
from
Employee
where
\
EmployName='\
//利用消息对话框提示删除操作成功
JOptionPane.showMessageDialog(null,\职工删除操作，执行成//清空输入学号的文本行
catch(Exception ex){
//利用消息对话框提示不能删除
//JOptionPane.showMessageDialog(null,\职工删除操作，执行失败!\}
else if(select.equals(\职务\
\
EmployJob='\
//利用消息对话框提示删除操作成功
JOptionPane.showMessageDialog(null,\职工删除操作，执行成}
catch(Exception ex){}}}
text1.setText(\
JOptionPane.showMessageDialog(null, \职工删除操作，执行失败!\
}catch(Exception ex){ }}}}} 3.2.4 普通用户模块
下表其他的基本属性 文件名 Person.java 成员变量 JMenu jMenu0=new JMenu(\系统\JMenuItem jMenuItem1=new JMenuItem(\退出\子菜单 JMenuBar menuBar = new JMenuBar(); JMenuItem jMenuItem3=new 成员方法 private class BHandler implements ActionListener{ public void actionPerformed(ActionEvent e){ if(e.getSource()==jMenuItem1){//主页}} public Person(String s,String id){//姓名 编号} 28
JMenuItem(\姓名\子菜单JMenuItem(\回到上页\子菜单
代码如下：
public class Person extends JFrame{
Connection con;//声明连接数据库对象
Statement st;//声明SQL语句对象 JPanel contentPane = new JPanel();// 创建内容面板 JMenuBar jMenuBar1=new JMenuBar();//菜单条 JMenu jMenu0=new JMenu(\系统\菜单
JMenuItem jMenuItem2=new JMenuItem(\回到主页\子菜单 JMenuItem jMenuItem1=new JMenuItem(\退出\子菜单
JMenuBar menuBar = new JMenuBar();
//String []jMenuItem=new
String[15];
JMenu editMenu = new person_menu(\更新信息\ JMenuItem jMenuItem3=new JMenuItem(\姓名\子菜单 JMenuItem jMenuItem4=new JMenuItem(\性别\子菜单 JMenuItem jMenuItem5=new JMenuItem(\年龄\子菜单 JMenuItem jMenuItem6=new JMenuItem(\住址\子菜单 JMenuItem jMenuItem7=new JMenuItem(\电话号\子菜单 JMenuItem jMenuItem16=new JMenuItem(\密码\子菜单 JMenu salaryMenu = new person_menu(\薪 水 单\ JMenuItem jMenuItem8=new JMenuItem(\基本工资\子菜单 JMenuItem jMenuItem9=new JMenuItem(\奖金\子菜单 JMenuItem jMenuItem10=new JMenuItem(\罚金\子菜单 JMenuItem jMenuItem11=new JMenuItem(\工资卡\子菜单
JMenu seeMenu = new person_menu(\查 看\
JMenuItem jMenuItem12=new JMenuItem(\基本信息\子菜单 JMenuItem jMenuItem13=new JMenuItem(\薪水\子菜单 JMenu helpMenu = new person_menu(\帮 助\
29
JMenuItem jMenuItem14=new JMenuItem(\子菜单 JMenuItem jMenuItem15=new JMenuItem(\退出\子菜单 JScrollPane scrollPane1 = new JScrollPane();
JTextArea jTextArea1=new JTextArea(); int I=1; String name,ID;
public Person(String s,String id){//姓名 编号
name=s; ID=id;
setTitle(\设置窗体标题
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); this.setBounds(100, 100, 550, 340);// 设置窗体位置
setContentPane(contentPane);// 设置窗体内容面板 indexBackgroundP backgroundPanel = new indexBackgroundP();// 创建背景面板
backgroundPanel.setImage(getToolkit().getImage( getClass().getResource(\设置面板背景图 contentPane.setBorder(new EmptyBorder(5, 5, 5, 5)); contentPane.setLayout(new BorderLayout(0, 0));
menuBar.setLayout(new BoxLayout(menuBar, BoxLayout.PAGE_AXIS)); editMenu.add(jMenuItem3);// 菜单项添加 editMenu.add(jMenuItem4); editMenu.add(jMenuItem5); editMenu.add(jMenuItem6);
editMenu.add(jMenuItem7);editMenu.add(jMenuItem16); salaryMenu.add(jMenuItem8); salaryMenu.add(jMenuItem9); salaryMenu.add(jMenuItem10); salaryMenu.add(jMenuItem11); seeMenu.add(jMenuItem12); seeMenu.add(jMenuItem13); helpMenu.add(jMenuItem14); helpMenu.add(jMenuItem15);
editMenu.setFont(new Font(\微软雅黑\ salaryMenu.setFont(new Font(\微软雅黑\ seeMenu.setFont(new Font(\微软雅黑\ helpMenu.setFont(new Font(\微软雅黑\ menuBar.add(editMenu); menuBar.add(salaryMenu); menuBar.add(seeMenu); menuBar.add(helpMenu); jMenuBar1.add(jMenu0); jMenu0.add(jMenuItem1); jMenu0.add(jMenuItem2); setJMenuBar(jMenuBar1);
30