deletescreen.java

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

package system;

import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.KeyEvent;
import java.sql.*;
import javax.swing.*;

public class deleteScreen extends JFrame {
	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;

	private JLabel delLabel = new JLabel("删除档案");

	private JLabel infoLabel = new JLabel("请输入你要删除的档案的条件");

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

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

	private JTextField nameText = new JTextField(30);

	private JTextField idText = new JTextField(30);

	private JButton okButton = new JButton("删除");

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

	public deleteScreen() {
		super("删除档案");
		initialize();
	}

	public void initialize() {
		this.getContentPane().setLayout(null);
		setSize(600, 400);
		setLocation(250, 200);
		delLabel.setBounds(230, 10, 60, 20);
		infoLabel.setBounds(20, 40, 180, 20);
		nameLabel.setBounds(80, 70, 60, 20);
		nameText.setBounds(150, 70, 100, 20);
		idLabel.setBounds(350, 70, 60, 20);
		idText.setBounds(420, 70, 100, 20);
		okButton.setBounds(235, 100, 60, 20);
		cancelButton.setBounds(305, 100, 60, 20);
		this.getContentPane().add(delLabel);
		this.getContentPane().add(infoLabel);
		this.getContentPane().add(nameLabel);
		this.getContentPane().add(idLabel);
		this.getContentPane().add(nameText);
		this.getContentPane().add(idText);
		this.getContentPane().add(okButton);
		this.getContentPane().add(cancelButton);
		ActionListener s = new ActionListener() {
			public void actionPerformed(ActionEvent evt) {
				delete();
			}
		};
		this.getRootPane().registerKeyboardAction(s,
				KeyStroke.getKeyStroke(KeyEvent.VK_ENTER, 0, false),
				JComponent.WHEN_IN_FOCUSED_WINDOW);

	
		okButton.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent evt) {
				delete();
			}
		});
		cancelButton.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent evt) {
				dispose();
			}
		});
	}

	public void delete() {
		String sql = "";
		Statement stmt = null;
		int rs = 0;
		if (nameText.getText().equals("")) {
			JOptionPane.showMessageDialog(null, "请输入名字");
			nameText.requestFocus();
			return;
		} else if (idText.getText().equals("")) {
			JOptionPane.showMessageDialog(null, "请输入编号");
			idText.requestFocus();
			return;
		}
		int response = JOptionPane.showConfirmDialog(null, "你确定删除档案吗？");
		switch (response) {
		case JOptionPane.OK_OPTION:
			sql = "delete from user where name='" + nameText.getText()
					+ "'and id='" + idText.getText() + "'";
			sql=changeChar.gbToiso(sql);//向数据库写中文
			DataBase db = new DataBase();
			try {
				stmt = db.conn.createStatement();
				rs = stmt.executeUpdate(sql);
			} catch (SQLException e) {
				e.printStackTrace();
			}
			if (rs != 0) {
				JOptionPane.showMessageDialog(null, "删除成功");
				nameText.setText("");
				idText.setText("");
			} else {
				JOptionPane.showMessageDialog(null, "删除失败，请确认用户和编号正确");
				nameText.setText("");
				idText.setText("");
			}
			break;
		case JOptionPane.NO_OPTION:
			break;
		case JOptionPane.CANCEL_OPTION:
			break;
		}
	}

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