modifypay.java

修改工资的界面程序

import java.awt.Font;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JTextField;


public class modifypay {

	private JTextField textField_32;
	private JTextField textField_31;
	private JTextField textField_30;
	private JTextField textField_29;
	private JTextField textField_28;
	private JTextField textField_27;
	private JTextField textField_26;
	private JTextField textField_25;
	private JTextField textField_24;
	private JTextField textField_23;
	private JTextField textField_22;
	private JTextField textField_21;
	private JTextField textField_20;
	private JTextField textField_19;
	private JTextField textField_18;
	private JTextField textField_17;
	private JTextField textField_16;
	private JTextField textField_15;
	private JTextField textField_14;
	private JTextField textField_13;
	private JTextField textField_12;
	private JTextField textField_11;
	private JTextField textField_10;
	private JTextField textField_9;
	private JTextField textField_8;
	private JTextField textField_7;
	private JTextField textField_6;
	private JTextField textField_5;
	private JTextField textField_4;
	private JTextField textField_3;
	private JTextField textField_2;
	private JTextField textField_1;
	private JTextField textField;
	public JFrame frame;

	/**
	 * Launch the application
	 * @param args
	 */
	public static Connection getConnection() throws SQLException,java.lang.ClassNotFoundException 
	{		                       
		String url="jdbc:mysql://localhost:3306/optimizesystem";
        Class.forName("com.mysql.jdbc.Driver");		        
        String userName="root";		
        String password="123";		
        Connection con=DriverManager.getConnection(url, userName, password);	
        return con;			
    }		
	public static void main(String args[]) {
		try {
			modifypay window = new modifypay();
			window.frame.setVisible(true);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	/**
	 * Create the application
	 */
	public modifypay() {
		initialize();
	}

	/**
	 * Initialize the contents of the frame
	 */
	private void initialize() {
		frame = new JFrame("修改职工工资信息");
		frame.getContentPane().setLayout(null);
		frame.setBounds(100, 100, 588, 728);
		frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

		final JLabel label = new JLabel();
		label.setFont(new Font("", Font.BOLD, 16));
		label.setText("修改工资信息");
		label.setBounds(229, 28, 143, 23);
		frame.getContentPane().add(label);

		final JLabel label_1 = new JLabel();
		label_1.setText("机器号：");
		label_1.setBounds(268, 140, 60, 15);
		frame.getContentPane().add(label_1);

		textField = new JTextField();
		textField.setBounds(339, 137, 114, 21);
		frame.getContentPane().add(textField);

		final JLabel label_2 = new JLabel();
		label_2.setText("员工号：");
		label_2.setBounds(55, 75, 60, 15);
		frame.getContentPane().add(label_2);

		final JLabel label_3 = new JLabel();
		label_3.setText("薪级工资：");
		label_3.setBounds(45, 140, 78, 15);
		frame.getContentPane().add(label_3);

		final JLabel label_4 = new JLabel();
		label_4.setText("保留津贴：");
		label_4.setBounds(45, 170, 78, 15);
		frame.getContentPane().add(label_4);

		final JLabel label_5 = new JLabel();
		label_5.setText("离退休金：");
		label_5.setBounds(45, 200, 78, 15);
		frame.getContentPane().add(label_5);

		final JLabel label_6 = new JLabel();
		label_6.setText("其他工资：");
		label_6.setBounds(45, 230, 78, 15);
		frame.getContentPane().add(label_6);

		final JLabel label_7 = new JLabel();
		label_7.setText("月生补：");
		label_7.setBounds(45, 260, 78, 15);
		frame.getContentPane().add(label_7);

		final JLabel label_8 = new JLabel();
		label_8.setText("政府津贴：");
		label_8.setBounds(45, 290, 78, 15);
		frame.getContentPane().add(label_8);

		final JLabel label_9 = new JLabel();
		label_9.setText("卫生费：");
		label_9.setBounds(45, 320, 78, 15);
		frame.getContentPane().add(label_9);

		final JLabel label_10 = new JLabel();
		label_10.setText("生活补助：");
		label_10.setBounds(45, 350, 78, 15);
		frame.getContentPane().add(label_10);

		final JLabel label_11 = new JLabel();
		label_11.setText("误餐费：");
		label_11.setBounds(45, 380, 78, 15);
		frame.getContentPane().add(label_11);

		final JLabel label_12 = new JLabel();
		label_12.setText("郊补：");
		label_12.setBounds(45, 410, 78, 15);
		frame.getContentPane().add(label_12);

		final JLabel label_13 = new JLabel();
		label_13.setText("煤龄补贴：");
		label_13.setBounds(45, 440, 78, 15);
		frame.getContentPane().add(label_13);

		final JLabel label_14 = new JLabel();
		label_14.setText("抚恤金：");
		label_14.setBounds(45, 470, 78, 15);
		frame.getContentPane().add(label_14);

		final JLabel label_15 = new JLabel();
		label_15.setText("补发工资：");
		label_15.setBounds(45, 500, 78, 15);
		frame.getContentPane().add(label_15);

		final JLabel label_16 = new JLabel();
		label_16.setText("研究生补助：");
		label_16.setBounds(45, 530, 87, 15);
		frame.getContentPane().add(label_16);

		textField_1 = new JTextField();
		textField_1.setBounds(130, 75, 113, 21);
		frame.getContentPane().add(textField_1);

		textField_2 = new JTextField();
		textField_2.setBounds(130, 135, 114, 21);
		frame.getContentPane().add(textField_2);

		textField_3 = new JTextField();
		textField_3.setBounds(130, 165, 113, 21);
		frame.getContentPane().add(textField_3);

		textField_4 = new JTextField();
		textField_4.setBounds(130, 195, 113, 21);
		frame.getContentPane().add(textField_4);

		textField_5 = new JTextField();
		textField_5.setBounds(130, 225, 114, 21);
		frame.getContentPane().add(textField_5);

		textField_6 = new JTextField();
		textField_6.setBounds(130, 255, 114, 21);
		frame.getContentPane().add(textField_6);

		textField_7 = new JTextField();
		textField_7.setBounds(129, 285, 114, 21);
		frame.getContentPane().add(textField_7);

		textField_8 = new JTextField();
		textField_8.setBounds(130, 315, 113, 21);
		frame.getContentPane().add(textField_8);

		textField_9 = new JTextField();
		textField_9.setBounds(130, 345, 113, 21);
		frame.getContentPane().add(textField_9);

		textField_10 = new JTextField();
		textField_10.setBounds(130, 375, 114, 21);
		frame.getContentPane().add(textField_10);

		textField_11 = new JTextField();
		textField_11.setBounds(130, 405, 113, 21);
		frame.getContentPane().add(textField_11);

		textField_12 = new JTextField();
		textField_12.setBounds(130, 435, 113, 21);
		frame.getContentPane().add(textField_12);

		textField_13 = new JTextField();
		textField_13.setBounds(130, 465, 113, 21);
		frame.getContentPane().add(textField_13);

		textField_14 = new JTextField();
		textField_14.setBounds(130, 495, 113, 21);
		frame.getContentPane().add(textField_14);

		textField_15 = new JTextField();
		textField_15.setBounds(130, 525, 113, 21);
		frame.getContentPane().add(textField_15);

		final JLabel label_17 = new JLabel();
		label_17.setText("督导津贴：");
		label_17.setBounds(268, 200, 78, 15);
		frame.getContentPane().add(label_17);

		final JLabel label_18 = new JLabel();
		label_18.setText("其他收入：");
		label_18.setBounds(45, 560, 78, 15);
		frame.getContentPane().add(label_18);

		final JLabel label_19 = new JLabel();
		label_19.setText("养老保险：");
		label_19.setBounds(268, 170, 78, 15);
		frame.getContentPane().add(label_19);

		final JLabel label_20 = new JLabel();
		label_20.setText("公积金：");
		label_20.setBounds(265, 230, 81, 15);
		frame.getContentPane().add(label_20);

		final JLabel label_21 = new JLabel();
		label_21.setText("医疗保险：");
		label_21.setBounds(265, 260, 81, 15);
		frame.getContentPane().add(label_21);

		final JLabel label_22 = new JLabel();
		label_22.setText("补退保险：");
		label_22.setBounds(265, 290, 81, 15);
		frame.getContentPane().add(label_22);

		final JLabel label_23 = new JLabel();
		label_23.setText("失业保险：");
		label_23.setBounds(265, 320, 81, 15);
		frame.getContentPane().add(label_23);

		final JLabel label_24 = new JLabel();
		label_24.setText("工会会费：");
		label_24.setBounds(265, 350, 81, 15);
		frame.getContentPane().add(label_24);

		final JLabel label_25 = new JLabel();
		label_25.setText("住房租金：");
		label_25.setBounds(265, 380, 81, 15);
		frame.getContentPane().add(label_25);

		final JLabel label_26 = new JLabel();
		label_26.setText("补退房租：");
		label_26.setBounds(265, 410, 81, 15);
		frame.getContentPane().add(label_26);

		final JLabel label_27 = new JLabel();
		label_27.setText("校园宽带：");
		label_27.setBounds(265, 440, 81, 15);
		frame.getContentPane().add(label_27);

		final JLabel label_28 = new JLabel();
		label_28.setText("代扣有线：");
		label_28.setBounds(265, 470, 81, 15);
		frame.getContentPane().add(label_28);

		final JLabel label_29 = new JLabel();
		label_29.setText("代扣电费：");
		label_29.setBounds(265, 500, 81, 15);
		frame.getContentPane().add(label_29);

		final JLabel label_30 = new JLabel();
		label_30.setText("代扣水费：");
		label_30.setBounds(265, 530, 81, 15);
		frame.getContentPane().add(label_30);

		final JLabel label_31 = new JLabel();
		label_31.setText("其他扣款：");
		label_31.setBounds(265, 560, 81, 15);
		frame.getContentPane().add(label_31);
		
		final JLabel label_32 = new JLabel();
		label_32.setText("年份：");
		label_32.setBounds(65, 110, 60, 15);
		frame.getContentPane().add(label_32);

		final JLabel label_33 = new JLabel();
		label_33.setText("月份：");
		label_33.setBounds(281, 106, 60, 15);
		frame.getContentPane().add(label_33);