delete.java

个人之前学JAVA编的一个日程管理小系统(用界面操作ACCESS).可当初学JAVA和数据库例子.

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

public class Delete implements ActionListener{
	ConnectAccess CA = new ConnectAccess();
	JFrame delF = new JFrame("删除记录");
	Container delC = new JPanel();
	Container delUp = new JPanel();
	Container delDown = new JPanel();
	JButton one = new JButton("单条记录");
	JButton done = new JButton("已办记录");
	JButton all = new JButton("全部记录");
	JLabel ms = new JLabel("请您选择删除类型:");
	
	public Delete() {
		CA.createConn_Direct();
		delF.add(delC);
		delF.setSize(500, 100);
		delC.setLayout(new BorderLayout());
		delC.add("North", delUp);
		delC.add("South", delDown);
		delUp.setLayout(new GridLayout(1, 1));
		delDown.setLayout(new GridLayout(1, 3));
		delUp.add(ms, SwingConstants.CENTER);
		ms.setFont(new Font("TRUE", Font.TRUETYPE_FONT, 18));
		ms.setForeground(Color.red);
		delDown.add(one);
		delDown.add(done);
		delDown.add(all);
		one.addActionListener(this);
		done.addActionListener(this);
		all.addActionListener(this);
		
		delF.show(true);
	}
	
	public void delOne() {
		String recordID = "";
		recordID = JOptionPane.showInputDialog("请输入要删除的记录编号:");
		System.out.println("ID = " + recordID);
		String sql = "delete from work where ID = " + recordID;
		if (JOptionPane.showConfirmDialog(null, null, "确定删除", 2) == 0) {
			if (CA.exeSQL(sql))
				JOptionPane.showMessageDialog(null, "删除成功!");
			else JOptionPane.showMessageDialog(null, "删除失败!");
		}
	}
	
	public void delDone() {
		String sql = "delete from work where state = 1";
		if (JOptionPane.showConfirmDialog(null, null, "确定删除已办记录", 2) == 0) {
			if (CA.exeSQL(sql))
				JOptionPane.showMessageDialog(null, "删除成功!");
			else JOptionPane.showMessageDialog(null, "删除失败!");
		}
	}
	
	public void delAll() {
		String sql = "delete from work";
		if (JOptionPane.showConfirmDialog(null, null, "确定删除全部记录?", 2) == 0) {
			if (CA.exeSQL(sql))
				JOptionPane.showMessageDialog(null, "删除成功!");
			else JOptionPane.showMessageDialog(null, "删除失败!");
		}
	}
	
	public void actionPerformed(ActionEvent e){
		if (e.getSource() == one)
			delOne();
		else if (e.getSource() == done)
			delDone();
		else if (e.getSource() == all)
			delAll();
	}
	
	public static void main(String[] args) {
		Delete delete1 = new Delete();
	}
}