optimizesalsary.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 optimizesalsary {

	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 {
			optimizesalsary window = new optimizesalsary();
			window.frame.setVisible(true);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

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

	/**
	 * Initialize the contents of the frame
	 */
	private void initialize() {
		frame = new JFrame("优化后收入查询");
		frame.getContentPane().setLayout(null);
		frame.setBounds(100, 100, 500, 375);
		frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

		final JLabel label = new JLabel();
		label.setFont(new Font("", Font.BOLD, 16));
		label.setText("优化后收入表");
		label.setBounds(214, 35, 118, 23);
		frame.getContentPane().add(label);

		final JLabel label_1 = new JLabel();
		label_1.setText("机器号：");
		label_1.setBounds(276, 81, 88, 15);
		frame.getContentPane().add(label_1);

		final JLabel label_2 = new JLabel();
		label_2.setText("员工号：");
		label_2.setBounds(58, 81, 88, 15);
		frame.getContentPane().add(label_2);

		final JLabel label_3 = new JLabel();
		label_3.setText("工资年份：");
		label_3.setBounds(58, 114, 88, 15);
		frame.getContentPane().add(label_3);

		final JLabel label_4 = new JLabel();
		label_4.setText("工资月份：");
		label_4.setBounds(58, 148, 88, 15);
		frame.getContentPane().add(label_4);

		final JLabel label_5 = new JLabel();
		label_5.setText("月工资总额：");
		label_5.setBounds(58, 218, 88, 15);
		frame.getContentPane().add(label_5);

		final JLabel label_6 = new JLabel();
		label_6.setText("当月个税：");
		label_6.setBounds(58, 184, 82, 15);
		frame.getContentPane().add(label_6);

		final JLabel label_7 = new JLabel();
		label_7.setText("奖金总额：");
		label_7.setBounds(276, 114, 82, 15);
		frame.getContentPane().add(label_7);

		final JLabel label_8 = new JLabel();
		label_8.setText("奖金个税：");
		label_8.setBounds(276, 148, 82, 15);
		frame.getContentPane().add(label_8);

		final JLabel label_9 = new JLabel();
		label_9.setText("应发总计：");
		label_9.setBounds(276, 184, 82, 15);
		frame.getContentPane().add(label_9);

		final JLabel label_10 = new JLabel();
		label_10.setText("发放日期：");
		label_10.setBounds(276, 218, 82, 15);
		frame.getContentPane().add(label_10);

		textField = new JTextField();
		textField.setBounds(342, 78, 106, 21);
		frame.getContentPane().add(textField);

		textField_1 = new JTextField();
		textField_1.setBounds(134, 78, 106, 21);
		frame.getContentPane().add(textField_1);

		textField_2 = new JTextField();
		textField_2.setBounds(134, 111, 106, 21);
		frame.getContentPane().add(textField_2);

		textField_3 = new JTextField();
		textField_3.setBounds(134, 145, 106, 21);
		frame.getContentPane().add(textField_3);

		textField_4 = new JTextField();
		textField_4.setBounds(134, 215, 106, 21);
		frame.getContentPane().add(textField_4);

		textField_5 = new JTextField();
		textField_5.setBounds(135, 180, 106, 21);
		frame.getContentPane().add(textField_5);

		textField_6 = new JTextField();
		textField_6.setBounds(342, 111, 106, 21);
		frame.getContentPane().add(textField_6);

		textField_7 = new JTextField();
		textField_7.setBounds(342, 145, 106, 21);
		frame.getContentPane().add(textField_7);

		textField_8 = new JTextField();
		textField_8.setBounds(342, 181, 106, 21);
		frame.getContentPane().add(textField_8);

		textField_9 = new JTextField();
		textField_9.setBounds(342, 215, 106, 21);
		frame.getContentPane().add(textField_9);

		final JButton button = new JButton();
		button.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent arg0) {
				frame.dispose();
			}
		});
		button.setText("确定");
		button.setBounds(309, 281, 74, 23);
		frame.getContentPane().add(button);

		final JButton button_1 = new JButton();
		button_1.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent arg0) {
				String employeeid=textField_1.getText();
				String year=textField_2.getText();
				String month=textField_3.getText();
				try{
					Connection con=getConnection();
					Statement stmt=con.createStatement();
					String query="select * from payputoutoptimize where employeeid='"+employeeid+"' ";
					ResultSet rs=stmt.executeQuery(query);
					if(employeeid.equals("")||year.equals("")||month.equals(""))
					{
						Object[] options={"是（y）","否（n）","取消",};
						String str1=new String("警告！员工号不能为空，请重新输入！");
						JOptionPane.showOptionDialog(null,str1,"警告窗口",JOptionPane.DEFAULT_OPTION,JOptionPane.WARNING_MESSAGE,null,options,options[0]);
						textField_1.setText(null);
					}
					else{
						if(rs.next()){
							String e=rs.getString("employeeid");
							String y=rs.getString("year");
							String m=rs.getString("month");
						if(e.equals(employeeid)&&y.equals(year)&&m.equals(month)){
							String values = rs.getString("year");
							String values_1 = rs.getString("month");
							String values_2 = rs.getString("monthsalsary");
							String values_3 = rs.getString("monthtax");
							String values_4 = rs.getString("totalsalsary");
							String values_5 = rs.getString("salsarytax");
							String values_6 = rs.getString("totalpay");
							String values_7 = rs.getString("date");
							String values_8= rs.getString("id");
							textField.setText(values_8);
							textField_2.setText(values);
							textField_3.setText(values_1);
							textField_4.setText(values_2);
							textField_5.setText(values_3);
							textField_6.setText(values_4);
							textField_7.setText(values_5);
							textField_8.setText(values_6);
							textField_9.setText(values_7);
							Object[] options={"是（y）","否（n）","取消",};
							String str1=new String("提示！员工号信息存在！");
							JOptionPane.showOptionDialog(null,str1,"提示窗口",JOptionPane.DEFAULT_OPTION,JOptionPane.WARNING_MESSAGE,null,options,options[0]);
						}
						else{
							Object[] options={"是（y）","否（n）","取消",};
							String str1=new String("连接数据库失败！");
							JOptionPane.showOptionDialog(null,str1,"警告窗口",JOptionPane.DEFAULT_OPTION,JOptionPane.WARNING_MESSAGE,null,options,options[0]);
						}
					}
					else{
						Object[] options={"是（y）","否（n）","取消",};
						String str1=new String("提示！员工信息不存在！");
						JOptionPane.showOptionDialog(null,str1,"提示窗口",JOptionPane.DEFAULT_OPTION,JOptionPane.WARNING_MESSAGE,null,options,options[0]);
						textField.setText(null);
						textField_1.setText(null);
						textField_2.setText(null);
						textField_3.setText(null);
						textField_4.setText(null);
						textField_5.setText(null);
						textField_6.setText(null);
						textField_7.setText(null);
						textField_8.setText(null);
						textField_9.setText(null);
					}
					rs.close();
					stmt.close();
					con.close();
					}
				}
				catch(java.lang.ClassNotFoundException e){			    
					System.err.print(" ClassNotFoundException: ");			         
				    System.err.println(e.getMessage());
				    }		
				catch(SQLException ex){			                 
				    System.err.println(" SQLException: "+ex.getMessage());	
				    }	
				catch(Exception e) {
					e.printStackTrace();
					}
		
			}
		});
		button_1.setText("查询");
		button_1.setBounds(159, 281, 67, 23);
		frame.getContentPane().add(button_1);
	}

}