updatescreen.java

java+mysql开发的档案管理系统

package system;

import javax.swing.*;

import java.awt.event.*;
import java.sql.SQLException;
import java.sql.Statement;

public class updateScreen extends JFrame implements ActionListener {

	private static final long serialVersionUID = 1L;

	private JLabel msg = new JLabel("更新档案");

	private JLabel prvnameLabel = new JLabel("姓名");

	private JTextField prvnameText = new JTextField(20);

	private JLabel prvidLabel = new JLabel("编号");

	private JTextField prvidText = new JTextField(20);

	private JLabel msgLabel = new JLabel("请输入你要更新的员工档案");

	private JLabel infoLabel = new JLabel("请输入更新信息:");

	private JLabel idLabel = new JLabel("编号");

	private JLabel nameLabel = new JLabel("姓名");

	private JLabel sexLabel = new JLabel("性别");

	private JLabel dateLabel = new JLabel("出生年月");

	private JLabel addressLabel = new JLabel("住址");

	private JLabel phoneLabel = new JLabel("电话");

	private JLabel homeLabel = new JLabel("籍贯");

	private JLabel wenhuaLabel = new JLabel("文化水平");

	private JLabel zhichengLabel = new JLabel("职称");

	private JLabel zhiwuLabel = new JLabel("职务");

	private JLabel partLabel = new JLabel("部门");

	private JLabel salaryLabel = new JLabel("工资");

	private JButton updateButton = new JButton("更新");

	private JButton cancelButton = new JButton("退出");

	private JTextField idText = new JTextField(20);

	private JTextField nameText = new JTextField(20);

	JComboBox sexBox = new JComboBox();

	private JTextField dateText = new JTextField(20);

	private JTextField addressText = new JTextField(20);

	private JTextField phoneText = new JTextField(20);

	private JTextField homeText = new JTextField(20);

	private JTextField zhichengText = new JTextField(20);

	private JComboBox wenhuaBox= new JComboBox();

	private JComboBox zhiwuBox= new JComboBox();

	private JComboBox partBox= new JComboBox();

	private JTextField salaryText = new JTextField(20);

	public updateScreen() {
		super("更新档案");
		initialize();
	}

	public void initialize() {
		this.getContentPane().setLayout(null);
		setSize(600, 400);
		setLocation(250, 200);
		msg.setBounds(250, 10, 100, 20);
		msgLabel.setBounds(10, 40, 200, 20);
		prvnameLabel.setBounds(80, 70, 40, 20);
		prvnameText.setBounds(120, 70, 100, 20);
		prvidLabel.setBounds(330, 70, 40, 20);
		prvidText.setBounds(380, 70, 100, 20);
		this.getContentPane().add(msg);
		this.getContentPane().add(msgLabel);
		this.getContentPane().add(prvnameLabel);
		this.getContentPane().add(prvnameText);
		this.getContentPane().add(prvidLabel);
		this.getContentPane().add(prvidText);
		infoLabel.setBounds(10, 100, 200, 20);
		nameLabel.setBounds(80, 130, 40, 20);
		nameText.setBounds(120, 130, 100, 20);
		idLabel.setBounds(80, 160, 40, 20);
		idText.setBounds(120, 160, 100, 20);
		sexLabel.setBounds(80, 190, 40, 20);

		sexBox.setBounds(120, 190, 100, 20);
		sexBox.addItem("男");
		sexBox.addItem("女");
		dateLabel.setBounds(55, 220, 60, 20);
		dateText.setBounds(120, 220, 100, 20);
		addressLabel.setBounds(80, 250, 40, 20);
		addressText.setBounds(120, 250, 100, 20);
		phoneLabel.setBounds(80, 280, 40, 20);
		phoneText.setBounds(120, 280, 100, 20);
		this.getContentPane().add(infoLabel);
		this.getContentPane().add(nameLabel);
		this.getContentPane().add(nameText);
		this.getContentPane().add(idLabel);
		this.getContentPane().add(idText);
		this.getContentPane().add(sexLabel);
		this.getContentPane().add(sexBox);
		this.getContentPane().add(dateLabel);
		this.getContentPane().add(dateText);
		this.getContentPane().add(addressLabel);
		this.getContentPane().add(addressText);
		this.getContentPane().add(phoneLabel);
		this.getContentPane().add(phoneText);
		homeLabel.setBounds(330, 130, 40, 20);
		homeText.setBounds(380, 130, 100, 20);
		wenhuaLabel.setBounds(315, 160, 60, 20);
		wenhuaBox.setBounds(380, 160, 100, 20);
		wenhuaBox.addItem("大学");
		wenhuaBox.addItem("研究生");
		wenhuaBox.addItem("博士");
		wenhuaBox.addItem("教授");
		zhiwuLabel.setBounds(330, 190, 40, 20);
		zhiwuBox.setBounds(380, 190, 100, 20);
		zhiwuBox.addItem("员工");
		zhiwuBox.addItem("经理");
		partLabel.setBounds(330, 220, 40, 20);
		partBox.setBounds(380, 220, 100, 20);
		partBox.addItem("人事管理部");
		partBox.addItem("后勤部");
		partBox.addItem("财政部");
		salaryLabel.setBounds(330, 250, 40, 20);
		salaryText.setBounds(380, 250, 100, 20);
		updateButton.setBounds(230, 330, 60, 20);
		cancelButton.setBounds(300, 330, 60, 20);
		this.getContentPane().add(homeLabel);
		this.getContentPane().add(homeText);
		this.getContentPane().add(wenhuaLabel);
		this.getContentPane().add(wenhuaBox);
		this.getContentPane().add(zhichengLabel);
		this.getContentPane().add(zhichengText);
		this.getContentPane().add(zhiwuLabel);
		this.getContentPane().add(zhiwuBox);
		this.getContentPane().add(partLabel);
		this.getContentPane().add(partBox);
		this.getContentPane().add(salaryLabel);
		this.getContentPane().add(salaryText);
		this.getContentPane().add(updateButton);
		this.getContentPane().add(cancelButton);
		updateButton.addActionListener(this);
		cancelButton.addActionListener(this);
		ActionListener s = new ActionListener() {
			public void actionPerformed(ActionEvent evt) {
				update();
			}
		};
		this.getRootPane().registerKeyboardAction(s,
				KeyStroke.getKeyStroke(KeyEvent.VK_ENTER, 0, false),
				JComponent.WHEN_IN_FOCUSED_WINDOW);
	}

	public void actionPerformed(ActionEvent evt) {
		Object ob = evt.getSource();
		if (ob.equals(cancelButton)) {
			dispose();
		} else if (ob.equals(updateButton)) {
			update();
		}
	}

	public void update() {
		String sql = "";
		if (prvnameText.getText().equals("")) {
			JOptionPane.showMessageDialog(null, "名字不能为空");
			return;
		}
		if (prvidText.getText().equals("")) {
			JOptionPane.showMessageDialog(null, "编号不能为空");
			return;
		}
		if (nameText.getText().equals("")) {
			JOptionPane.showMessageDialog(null, "更新的名字不能为空");
			return;
		}
		if (idText.getText().equals("")) {
			JOptionPane.showMessageDialog(null, "更新的编号不能为空");
			return;
		}
		if (dateText.getText().equals("")) {
			JOptionPane.showMessageDialog(null, "出生日期不能为空");
			return;
		}
		if (addressText.getText().equals("")) {
			JOptionPane.showMessageDialog(null, "地址不能为空");
			return;
		}
		sql = "update user set id='" + idText.getText() + "',name='"
				+ nameText.getText() + "',sex='" + sexBox.getSelectedItem()
				+ "',date='" + dateText.getText() + "',address='"
				+ addressText.getText() + "',phone='" + phoneText.getText()
				+ "',home='" + homeText.getText() + "',wenhua='"
				+ wenhuaBox.getSelectedItem().toString() + "',zhiwu='" + zhiwuBox.getSelectedItem().toString()
				+ "',part='" + partBox.getSelectedItem().toString() + "',salary='"
				+ salaryText.getText() + "' where name='"
				+ prvnameText.getText() + "' and id='" + prvidText.getText()
				+ "';";
		sql = changeChar.gbToiso(sql);
		System.out.println(sql);
		DataBase db = new DataBase();
		try {
			Statement stmt = db.conn.createStatement();
			int rs = stmt.executeUpdate(sql);
			System.out.println(rs);
			if(rs==0){
				JOptionPane.showMessageDialog(null,"更新失败，请确定你更新的信息正确");	
			}else{
				JOptionPane.showMessageDialog(null, "更新成功");
				prvnameText.setText("");
				prvidText.setText("");
				nameText.setText("");
				idText.setText("");
				dateText.setText("");
				addressText.setText("");
				phoneText.setText("");
				homeText.setText("");			
				salaryText.setText("");
										
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}

	}

	public static void main(String args[]) {
		updateScreen screen = new updateScreen();
		screen.repaint();
		screen.setVisible(true);
		screen.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
	}
}