delete.java

人类,不同人有不同的职业,通过吃套餐来增加能量,通过做运动来减少能量

package com.person;

import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import javax.swing.*;
import javax.swing.event.*;

class Delete implements ActionListener {
	static int hit = 0;// 记录点击"修改密码"的次数

	int ID;

	JInternalFrame internalframe;

	JLabel message = new JLabel("请输入要删除的人的ID:");

	JTextField id = new JTextField(10);

	JButton confirm = new JButton("确定");

	JButton cancel = new JButton("取消");

	JPanel panel = new JPanel();

	JPanel panel1 = new JPanel();

	JPanel panel2 = new JPanel();

	JPanel panel3 = new JPanel();

	JPanel panel4 = new JPanel();

	Delete() {
		hit++;
		if (hit == 1) {
			internalframe = new JInternalFrame("删除", true, true, false, true);
			internalframe
					.setFrameIcon(new ImageIcon("images/delete_title.gif"));
			internalframe.setLocation(250, 150);
			internalframe.setSize(350, 150);
			internalframe.setVisible(true);
			internalframe.setResizable(false);
			internalframe.addInternalFrameListener(new WinLis());
			final Container cp = internalframe.getContentPane();
			cp.setLayout(new GridLayout(2, 1));
			Box hBox = Box.createHorizontalBox();
			message.setForeground(Color.BLUE);
			hBox.add(Box.createHorizontalStrut(5));
			message.setPreferredSize(new Dimension(150, 30));
			hBox.add(message);
			hBox.add(Box.createHorizontalStrut(5));
			id.setBorder(BorderFactory.createLoweredBevelBorder());
			id.setForeground(Color.RED);
			hBox.add(id);
			panel1.add(hBox);
			panel1.setBackground(new Color(240, 248, 255));
			panel.add(panel1);
			panel.setBackground(new Color(240, 248, 255));
			cp.add(panel);
			panel2.setLayout(new GridLayout(1, 2));
			panel3.setLayout(new FlowLayout());
			confirm.setPreferredSize(new Dimension(80, 30));
			panel3.add(confirm);
			panel3.setBackground(new Color(240, 248, 255));
			panel4.setLayout(new FlowLayout());
			cancel.setPreferredSize(new Dimension(80, 30));
			panel4.add(cancel);
			panel4.setBackground(new Color(240, 248, 255));
			panel2.add(panel3);
			panel2.add(panel4);
			panel2.setBackground(new Color(240, 248, 255));
			cp.add(panel2);
			Person.desktopPane.add(internalframe);
			try {
				internalframe.setSelected(true);
			} catch (java.beans.PropertyVetoException e) {
				System.out.println("PropertyVetoException:" + e.getMessage());
			}
		} else {
		}
		confirm.addActionListener(this);
		cancel.addActionListener(this);
	}

	public void actionPerformed(ActionEvent e) {
		if (e.getSource() == confirm) {
			if (judge()) {
				internalframe.dispose();
				ID = Integer.parseInt(id.getText());
				String JDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
				String conURL = "jdbc:odbc:TestDB";
				try {
					Class.forName(JDriver);
				} catch (java.lang.ClassNotFoundException e1) {
					System.out.println("ForName:" + e1.getMessage());
				}
				try {
					Connection con = DriverManager.getConnection(conURL);
					Statement s = con.createStatement(
							ResultSet.TYPE_SCROLL_INSENSITIVE,
							ResultSet.CONCUR_UPDATABLE);
					ResultSet rs = s.executeQuery("select * from person");
					PreparedStatement ps = con
							.prepareStatement("delete from person where id=?");
					while (rs.next()) {
						if (ID == rs.getInt("id")) {
							ps.setInt(1, ID);
							ps.executeUpdate();
							break;
						}
						if (rs.isLast())
							JOptionPane.showMessageDialog(internalframe,
									"没有该ID", "错误信息",
									JOptionPane.WARNING_MESSAGE);
					}
					s.close();
					con.close();
				} catch (SQLException e1) {
					System.out.println("SQLException:" + e1.getMessage());
				}
			}
		}
		if (e.getSource() == cancel)
			internalframe.dispose();
	}

	/**
	 * 以下代码判断用户输入的ID是否为空或不是数字等非法字符
	 */
	public boolean judge() {
		if (id.getText().equals("")) {
			JOptionPane.showMessageDialog(internalframe, "ID不能为空", "错误信息",
					JOptionPane.WARNING_MESSAGE);
			return false;
		}
		byte[] tempbyte = id.getText().getBytes();
		for (int i = 0; i < id.getText().length(); i++) {
			if ((tempbyte[i] < 48) || (tempbyte[i] > 57)) {
				JOptionPane.showMessageDialog(internalframe, "输入的值不合法", "错误信息",
						JOptionPane.WARNING_MESSAGE);
				return false;
			}
		}
		return true;
	}

	class WinLis extends InternalFrameAdapter {
		public void internalFrameClosed(InternalFrameEvent e) {
			hit = 0;
		}
	}
}