delete.java

java实现的工资管理系统 可以运行的源代码

package salary;
import javax.swing.*;
import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.*;

/*public class Delete 
{
	public static void main(String[] args)
	{
		D_Frame df=new D_Frame("删除");
	}

}*/

class Delete extends JFrame
{
	JLabel jLabel;
	JTextField jtf;
	JButton jbtn,jbtn1;
	Delete(String s)
	{
		super(s);
		setLayout(null);
		setBounds(200,200,300,200);
		jLabel=new JLabel("请输入您要删除的员工的员工号:");
		jtf=new JTextField(10);
		jbtn=new JButton("提交");
		jbtn.addActionListener(new ActionListener()
		{
			public void actionPerformed(ActionEvent e) {
				delete();
				
			}
		});
		jbtn1=new JButton("退出");
		jbtn1.addActionListener(new ActionListener()
		{
			public void actionPerformed(ActionEvent e)
			{
				dispose();
			}
		});
		jLabel.setBounds(50,30,200,30);
		jtf.setBounds(90,65,100,20);
		jbtn.setBounds(60,100,60,30);
		jbtn1.setBounds(170,100,60,30);
		Container con=getContentPane();
		con.add(jLabel);
		con.add(jtf);
		con.add(jbtn);
		con.add(jbtn1);
		setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
		setVisible(true);
		
		
	}
	void delete()
	{
		String str;
		str=jtf.getText();
		try
		{
			Class.forName("sun.jbdc.odbc.JdbcOdbcDriver");
		}
		catch(ClassNotFoundException e){}
		try
		{
			Connection con=DriverManager.getConnection("jdbc:odbc:salary","","");
			PreparedStatement psmt1=con.prepareStatement("select name from employee_info where e_num=?");
			psmt1.setString(1, str);
			ResultSet rs=psmt1.executeQuery();
			if(rs.next())
			{
			
				Connection con1=DriverManager.getConnection("jdbc:odbc:salary","","");
				PreparedStatement psmt=con1.prepareStatement("delete salary where s_num=?");
				psmt.setString(1, str);
				psmt.executeUpdate();
				psmt=con1.prepareStatement("delete check_attend where c_num=?");
				psmt.setString(1, str);
				psmt.executeUpdate();
				psmt=con1.prepareStatement("delete employee_info where e_num=?");
				psmt.setString(1, str);
				psmt.executeUpdate();
				
				
				JOptionPane.showMessageDialog(this, "删除成功","删除",JOptionPane.INFORMATION_MESSAGE);
				
				psmt.close();
				con.close();
			}
			else JOptionPane.showMessageDialog(this, "无此员工", "错误", JOptionPane.ERROR_MESSAGE);
		}
		catch(Exception e){e.printStackTrace();}
	}
}