manageframe.java

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

package salary;
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import javax.swing.table.*;
import java.util.*;
/*public class ManageFrame 
{
	public static void main(String[] args)
	{
		Manage mf=new Manage("工资管理系统");
	}

}*/

 class ManageFrame extends JFrame 
{
	JLabel jLabel1,jLabel2,jLabel4,jLabel5,jLabel6,jLabel7;
	JTextField jtf1,jtf2,jtf3,jtf4,jtf5;
	JButton btn1,btn2,btn3,btn4,btn5,btn6,btn7,btn8;
	JComboBox jcb1,jcb2;
	
	ManageFrame(String s)
	{
		super(s);
		setLayout(null);
		setBounds(100,100,500,500);
		
		jcb1=new JComboBox();
		jcb1.addItem("1");
		jcb1.addItem("2");
		jcb1.addItem("3");
		jcb1.addItem("4");
		jcb1.addItem("5");
		jcb1.addItem("6");
		jcb1.addItem("7");
		jcb1.addItem("8");
		jcb1.addItem("9");
		jcb1.addItem("10");
		jcb1.addItem("11");
		jcb1.addItem("12");
		
		jcb2=new JComboBox();
		jcb2.setBorder(BorderFactory.createTitledBorder("请选择月份"));
		jcb2.addItem("1");
		jcb2.addItem("2");
		jcb2.addItem("3");
		jcb2.addItem("4");
		jcb2.addItem("5");
		jcb2.addItem("6");
		jcb2.addItem("7");
		jcb2.addItem("8");
		jcb2.addItem("9");
		jcb2.addItem("10");
		jcb2.addItem("11");
		jcb2.addItem("12");
		jLabel1=new JLabel("员工号:");
		jLabel2=new JLabel("日期:");
		jLabel4=new JLabel("月");
		jLabel5=new JLabel("工作天数:");
		jLabel6=new JLabel("缺席天数:");
		jLabel7=new JLabel("按月份查询员工工资：");
		jtf1=new JTextField(10);
		jtf4=new JTextField(2);
		jtf5=new JTextField(2);
		btn1=new JButton("更改基本工资");
		btn1.addActionListener(new ActionListener()
		{
			public void actionPerformed(ActionEvent e)
			{
				S_change sc=new S_change("修改工资");
			}
		});
		btn2=new JButton("修改员工信息");
		btn2.addActionListener(new ActionListener()
		{
			public void actionPerformed(ActionEvent e)
			{
				Alter al=new Alter("修改");
			}
		});
		btn3=new JButton("增加员工");
		btn3.addActionListener(new ActionListener()
		{
			public void actionPerformed(ActionEvent e) 
			{
				IncreaseFrame inf=new IncreaseFrame("增加员工");
			}
		});
		btn4=new JButton("删除员工");
		btn4.addActionListener(new ActionListener()
		{
			public void actionPerformed(ActionEvent e)
			{
				Delete dl=new Delete("删除员工");
			}
		});
		btn5=new JButton("查看所有员工信息");
		btn5.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent e) {
				// TODO 自动生成方法存根
				lookover();
				
			}
		});
		btn6=new JButton("确定");
		btn6.addActionListener(new ActionListener()
		{
			public void actionPerformed(ActionEvent e) {
				// TODO 自动生成方法存根
				count();
				
			}
		});
		btn7=new JButton("查询");
		btn7.addActionListener(new ActionListener()
		{
			public void actionPerformed(ActionEvent e)
			{
				query();
			}
		});
		btn8=new JButton("退出");
		btn8.addActionListener(new ActionListener()
		{
			public void actionPerformed(ActionEvent e)
			{
				dispose();
			}
		});
		
		jLabel1.setBounds(60, 40, 50, 20);
		jtf1.setBounds(115,40,100,20);
		jLabel2.setBounds(300,40,30,20);
		jcb1.setBounds(340,40,45,20);
		jLabel4.setBounds(395,40,20,20);
		jLabel5.setBounds(60,80,60,20);
		jtf4.setBounds(125,80,30,20);
		jLabel6.setBounds(200,80,60,20);
		jtf5.setBounds(265,80,30,20);
		jLabel7.setBounds(80,120,130,30);
		jcb2.setBounds(215,120,80,50);
		btn1.setBounds(90,230,130,30);
		btn2.setBounds(270,230,130,30);
		btn3.setBounds(100,290,100,30);
		btn4.setBounds(280,290,100,30);
		btn5.setBounds(150,370,200,30);
		btn6.setBounds(340,75,60,30);
		btn7.setBounds(340,130,60,30);
		btn8.setBounds(200,420,80,30);
		Container con=getContentPane();
		con.add(jLabel1);
		con.add(jtf1);
		con.add(jLabel2);
		con.add(jcb1);
		con.add(jLabel4);
		con.add(jLabel5);
		con.add(jtf4);
		con.add(jLabel6);
		con.add(jtf5);
		con.add(jLabel7);
		con.add(jcb2);
		con.add(btn1);
		con.add(btn2);
		con.add(btn3);
		con.add(btn4);
		con.add(btn5);
		
		con.add(btn6);
		con.add(btn7);
		con.add(btn8);
		setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
		setVisible(true);
	}
	void lookover()
	{
		final JFrame jf=new JFrame();
		jf.setLayout(new BoxLayout(jf.getContentPane(),BoxLayout.Y_AXIS));
		JButton jbtn=new JButton("关闭");
		jbtn.addActionListener(new ActionListener()
		{
			public void actionPerformed(ActionEvent e)
			{
				jf.dispose();
			}
		});
		jf.setBounds(100, 100, 700, 500);
		jf.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
		Container con1=jf.getContentPane();
		JTable table;
		
		Object a[][];
		Object name[]={"员工号","姓名","密码","职称","性别","联系电话","文化程度","工作单位"};
		try {
			 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			
		} catch (ClassNotFoundException e) {
			// TODO: handle exception
		}
		try {
			Connection con=DriverManager.getConnection("jdbc:odbc:salary","","");
			Statement sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
			ResultSet rs=sql.executeQuery("select e_num,name,password,post,sex,tel_number,stu_degree,dept from employee_info");
			rs.last();
			int number=rs.getRow();
			a=new Object[number][8];
			rs.beforeFirst();
			int a_num=0;
			while(rs.next())
			{
				String num1=rs.getString(1);
				String name1=rs.getString(2);
				String password1=rs.getString(3);
				String post1=rs.getString(4);
				String sex1=rs.getString(5);
				String tel_number1=rs.getString(6);
				String stu_degree1=rs.getString(7);
				String dept1=rs.getString(8);
				a[a_num][0]=num1;
				a[a_num][1]=name1;
				a[a_num][2]=password1;
				a[a_num][3]=post1;
				a[a_num][4]=sex1;
				a[a_num][5]=tel_number1;
				a[a_num][6]=stu_degree1;
				a[a_num][7]=dept1;
				a_num++;
			}
			table=new JTable(a,name);
//			table.setSize(700, 100);
			//table.setSize(900,10);
	//		con1.add(new JScrollPane(table),BorderLayout.CENTER);
			con1.add(new JScrollPane(table));
			con1.add(jbtn);
	//		con1.add(jbtn,BorderLayout.SOUTH);
			jf.setVisible(true);
			
		} catch (Exception e) {
			// TODO: handle exception
			e.printStackTrace();
		}
	
	}
	void count()
	{
		String str1,str2,str3,str4;
		//float fl1,fl2,fl3;
		str1=jtf1.getText();
		str2=(String)jcb1.getSelectedItem();
		str3=jtf4.getText();
		str4=jtf5.getText();
		try {
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		} catch (ClassNotFoundException e) {
			// TODO: handle exception
		}
		try {
			Connection con=DriverManager.getConnection("jdbc:odbc:salary","","");
			PreparedStatement psmt=con.prepareStatement("insert into check_attend values(?,?,?,?)");
			psmt.setString(1, str1);
			psmt.setString(2, str3);
			psmt.setString(3, str4);
			psmt.setString(4, str2);
			
			psmt.executeUpdate();
			psmt=con.prepareStatement("select post from employee_info where e_num=?");
			psmt.setString(1, str1);
			ResultSet rs=psmt.executeQuery();
			rs.next();
			String post1=rs.getString(1);
			psmt=con.prepareStatement("select basic_salary from post where posttitle like'"+post1+"'");
			ResultSet rs1=psmt.executeQuery();
			rs1.next();
			float bonus1=Float.parseFloat(str3)*20;
			float deduct1=Float.parseFloat(str4)*50;
			float basic_salary1=rs1.getFloat(1);
			float fact_salary1=basic_salary1+bonus1-deduct1;
			psmt=con.prepareStatement("insert into salary values(?,?,?,?,?,?)");
			psmt.setString(1, str1);
			psmt.setFloat(2, bonus1);
			psmt.setFloat(3, deduct1);
			psmt.setFloat(4, basic_salary1);
			psmt.setFloat(5, fact_salary1);
			psmt.setString(6, str2);
			JOptionPane.showMessageDialog(this, "成功输入","提示",JOptionPane.INFORMATION_MESSAGE);
			psmt.executeUpdate();
			
			psmt.close();
			con.close();
			
		} catch (Exception e) {
			// TODO: handle exception
			//e.printStackTrace();
			JOptionPane.showMessageDialog(this, "请输入正确的员工号","错误",JOptionPane.INFORMATION_MESSAGE);
		}
	}
	void query()
	{
		final JFrame jf=new JFrame();
		JButton jbtn=new JButton("关闭");
		jbtn.addActionListener(new ActionListener()
		{
			public void actionPerformed(ActionEvent e)
			{
				jf.dispose();
			}
		});
		jf.setBounds(100,100,700,500);
		jf.setLayout(new BoxLayout(jf.getContentPane(),BoxLayout.Y_AXIS));
		jf.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
		Container con=jf.getContentPane();
		String str;
		str=(String)jcb2.getSelectedItem();
		Object name1[]={"员工号","奖金","扣除","基本工资(元)","实发工资(元)","月份"};
		Object b[][];
		try {
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		} catch (ClassNotFoundException e) {
			// TODO: handle exception
		}
		try {
			Connection con1=DriverManager.getConnection("jdbc:odbc:salary","","");
			Statement sql=con1.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
            ResultSet rs=sql.executeQuery("select s_num,bonus,deduct,s_basicsalary,fact_salary,month" +
					" from salary where month like '"+str+"'");
			
			rs.last();
			int num=rs.getRow();
			b=new Object[num][6];
			int b_num=0;
			rs.beforeFirst();
			while(rs.next())
			{
				String s_num=rs.getString(1);
				String bonus=rs.getString(2);
				String deduct=rs.getString(3);
				String s_basicsalary=rs.getString(4);
				String fact_salary=rs.getString(5);
				String month=rs.getString(6);
				b[b_num][0]=s_num;
				b[b_num][1]=(Object)bonus;
				b[b_num][2]=deduct;
				b[b_num][3]=s_basicsalary;
				b[b_num][4]=fact_salary;
				b[b_num][5]=month;
				b_num++;
			}
			JTable table=new JTable(b,name1);
			con.add(new JScrollPane(table));
			con.add(jbtn);
			
			jf.setVisible(true);
			
			
		} catch (Exception e) {
			// TODO: handle exception
			e.printStackTrace();
		}
	}
	
}