alter.java

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

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

/*public class Alter
{
	public static void main(String[] args)
	{
		A_Frame af=new A_Frame("修改");
	}
}*/
public class Alter extends JFrame
{
    JLabel jLabel1,jLabel2,jLabel3,jLabel4;
	JLabel jLabel5,jLabel6,jLabel7,jLabel8;
	JTextField jtf1,jtf2,jtf3,jtf6,jtf7,jtf8;
	JComboBox jcb1,jcb2;
	JButton jbtn,jbtn1;
	Alter(String s)
	{
		super(s);
		setLayout(null);
		setBounds(200,200,300,350);
		jLabel1=new JLabel("员工号:");
		jLabel2=new JLabel("姓名:");
		jLabel3=new JLabel("密码:");
		jLabel4=new JLabel("职称:");
		jLabel5=new JLabel("性别:");
		jLabel6=new JLabel("联系电话:");
		jLabel7=new JLabel("文化程度:");
		jLabel8=new JLabel("工作单位:");
		jtf1=new JTextField(10);
		jtf2=new JTextField(5);
		jtf3=new JTextField(10);
		jcb1=new JComboBox();
		jcb1.addItem("讲师");
		jcb1.addItem("辅导员");
		jcb1.addItem("系主任");
		jcb1.addItem("教授");
		jcb1.addItem("校长");
		jcb1.addItem("助教");
		jcb2=new JComboBox();
		jcb2.addItem("男");
		jcb2.addItem("女");
		
		jtf6=new JTextField(10);
		jtf7=new JTextField(10);
		jtf8=new JTextField(10);
		jbtn=new JButton("提交");
		jbtn.addActionListener(new ActionListener()
		{
			public void actionPerformed(ActionEvent e)
			{
				alter();
				
			}
		});
		jbtn1=new JButton("退出");
		jbtn1.addActionListener(new ActionListener()
		{
			public void actionPerformed(ActionEvent e)
			{
				dispose();
			}
		});
		jLabel1.setBounds(60,20,50,20);
		jtf1.setBounds(115,20,100,20);
		jLabel2.setBounds(60,50,50,20);
		jtf2.setBounds(115,50,100,20);
		jLabel3.setBounds(60,80,50,20);
		jtf3.setBounds(115,80,100,20);
		jLabel4.setBounds(60,110,50,20);
		jcb1.setBounds(115,110,100,20);
		jLabel5.setBounds(60,140,50,20);
		jcb2.setBounds(115,140,50,20);
		jLabel6.setBounds(55,170,60,20);
		jtf6.setBounds(120,170,100,20);
		jLabel7.setBounds(55,200,60,20);
		jtf7.setBounds(120,200,100,20);
		jLabel8.setBounds(55,230,60,20);
		jtf8.setBounds(120,230,100,20);
		jbtn.setBounds(60,270,60,30);
		jbtn1.setBounds(180,270,60,30);
		Container con=getContentPane();
		con.add(jLabel1);
		con.add(jtf1);
		con.add(jLabel2);
		con.add(jtf2);
		con.add(jLabel3);
		con.add(jtf3);
		con.add(jLabel4);
		con.add(jcb1);
		con.add(jLabel5);
		con.add(jcb2);
		con.add(jLabel6);
		con.add(jtf6);
		con.add(jLabel7);
		con.add(jtf7);
		con.add(jLabel8);
		con.add(jtf8);
		con.add(jbtn);
		con.add(jbtn1);
		
		setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
		setVisible(true);
	}
	void alter()
	{
        String e_num1,name1,password1,post1,sex1,tel_number1,stu_degree1,dept1;
		e_num1=jtf1.getText();
		name1=jtf2.getText();
		password1=jtf3.getText();
		post1=(String)jcb1.getSelectedItem();
		sex1=(String)jcb2.getSelectedItem();
		tel_number1=jtf6.getText();
		stu_degree1=jtf7.getText();
		dept1=jtf8.getText();
		if(e_num1.equals(""))
		{
			JOptionPane.showMessageDialog(this, "请输入员工号","提示", JOptionPane.INFORMATION_MESSAGE);
		}
		else
		{
			try
			{
				Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			}
			catch(ClassNotFoundException e){}
		    try
		    {
				Connection con=DriverManager.getConnection("jdbc:odbc:salary","","");
				PreparedStatement psmt1=con.prepareStatement("select name,password,post,sex,tel_number,stu_degree,dept " +
						"from employee_info where e_num LIKE '"+e_num1+"'");
				ResultSet rs=psmt1.executeQuery();
				boolean bl=rs.next();
				if(bl)
				{
			        if(name1.equals("")) name1=rs.getString(1);
					if(password1.equals("")) password1=rs.getString(2);
					if(tel_number1.equals("")) tel_number1=rs.getString(5);
					if(stu_degree1.equals("")) stu_degree1=rs.getString(6);
					if(dept1.equals("")) dept1=rs.getString(7);
					psmt1.close();
					con.close();
					try 
					{
					    Connection con1=DriverManager.getConnection("jdbc:odbc:salary","","");
						PreparedStatement psmt2=con1.prepareStatement("update employee_info set name=?,password=?,post=?,sex=?," +
								"tel_number=?,stu_degree=?,dept=? where e_num='"+e_num1+"'");
						psmt2.setString(1, name1);
						psmt2.setString(2,password1);
						psmt2.setString(3,post1);
						psmt2.setString(4,sex1);
						psmt2.setString(5,tel_number1);
						psmt2.setString(6,stu_degree1);
						psmt2.setString(7,dept1);
						psmt2.executeUpdate();
						JOptionPane.showMessageDialog(this, "修改成功","修改",JOptionPane.INFORMATION_MESSAGE);
						dispose();
						psmt2.close();
						con.close();
						
						
					}
					catch (Exception e) 
					{
						// TODO: handle exception
						e.printStackTrace();
					}
				}
				else JOptionPane.showMessageDialog(this, "请输入正确的员工号","错误",JOptionPane.ERROR_MESSAGE);
						
				}catch(Exception e){e.printStackTrace();} 
		    
		}
		
		
	
      
	}
		
}