发布时间 : 星期一 文章java人事管理系统更新完毕开始阅读
WorkerDelete(){
super(\删除职工信息\
c=getContentPane();
c.setLayout(new BorderLayout()); WnoLabel=new JLabel(\职工号:\ WTextField=new JTextField(15);
Btnselect=new JButton(\显示所有职工\ Btndelete=new JButton(\删除\
String[] n={\职工号\姓名\地址\电话\部门\工资\参加工作时间
String[][] data=new String[0][0];
defaultModel=new DefaultTableModel(data,n); table=new JTable(defaultModel);
table.setPreferredScrollableViewportSize(new Dimension(700,350)); JScrollPane s=new JScrollPane(table); panel2=new JPanel();
panel2.setBorder(new EmptyBorder(5, 5, 5, 5)); panel2.add(s);
c.add(BorderLayout.NORTH, createTopPane()); c.add(BorderLayout.SOUTH, panel2); pack();
this.setSize(740,520 ); setVisible(true);
Btnselect.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent ex){
try
\职务\
{
Class.forName(\ }
catch(java.lang.ClassNotFoundException e) {
System.out.println(\ }
String Wno= WTextField.getText();
37
String str=null;
String str1=\职工号,姓名,地址,电话,部门,工资,参加工作时间,职务 from 员工信息\ try{
if(Wno.equals(\
{
str=str1; }
//str=str1+\职工号='\ Connection con = DriverManager.getConnection(\ Statement stmt = con.createStatement(); System.out.println(\连接数据库成功!\ ResultSet rs=stmt.executeQuery(str); while(rs.next()){
Vector data=new Vector();
data.addElement(rs.getString(1)); data.addElement(rs.getString(2)); data.addElement(rs.getString(3)); data.addElement(rs.getString(4)); data.addElement(rs.getString(5)); data.addElement(rs.getString(6)); data.addElement(rs.getString(7)); data.addElement(rs.getString(8)); defaultModel.addRow(data);
}
table.revalidate();
}catch(SQLException e)
System.out.println(\
{
} });
Btndelete.addActionListener(new ActionListener(){ public void actionPerformed(ActionEvent ex){
try
38
}
{
Class.forName(\ }
catch(java.lang.ClassNotFoundException e) {
System.out.println(\ }
String Wno=WTextField.getText(); String str=null; try{
if(Wno.equals(\
{
JOptionPane.showMessageDialog(null,\职工号不能为空\消
息提示\
}
else{
str=\ From 员工信息\where 职工号='\
Connection con = DriverManager.getConnection(\ Statement stmt = con.createStatement(); stmt.executeUpdate(str);
JOptionPane.showMessageDialog(null,\删除成功!\消息提示\ }
}catch(SQLException e)
System.out.println(\
{
} });
}
}
private JPanel createTopPane(){
JPanel pane=new JPanel(new BorderLayout()); pane.setBorder(new EmptyBorder(5, 5, 5, 5)); JPanel top=new JPanel(new FlowLayout()); pane.add(BorderLayout.NORTH, top);
39
top.add(WnoLabel); top.add(WTextField);
pane.add(BorderLayout.SOUTH, createBtnPane()); return pane; }
private JPanel createBtnPane(){
JPanel pane=new JPanel(new FlowLayout()); pane.add(Btnselect); pane.add(Btndelete); return pane; }
public static void main(String[] args){ new WorkerDelete(); } }
40