goodtypefatherjpanel.java

JAVA实现的酒店管理系统

package file1;
/*
 * @Author:黄顺武
 * Create Time:2008-2-15
 * Description:货品类型显示和录入等操作的主界面
 */
import java.sql.*;
import sun.jdbc.rowset.*;
import javax.swing.*;
import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;

public class GoodTypeFatherJPanel extends JPanel implements ActionListener {

	private JLabel goodType = new JLabel("货品类型名称:");
	private JTextField goodTypeTF = new JTextField(10);
	private JPanel p1 = new JPanel();
	private JTable recTable = null;
	private String[] head = { "ID", "货品类型名称" };
	private int headNum = 0;
	private String[][] data = null;
	private JScrollPane recScrollPane = null;
	private JPanel p2 = new JPanel();
	private JButton add = new JButton("增加记录");
	private JButton delete = new JButton("删除记录");
	private String[] goodTypeIDs;

	public GoodTypeFatherJPanel() {
		headNum = head.length;
		goodTypeTF.setBorder(null);
		p1.setLayout(new FlowLayout(FlowLayout.CENTER, 30, 5));
		p1.add(goodType);
		p1.add(goodTypeTF);
		add.setBorder(null);
		add.setBackground(Color.LIGHT_GRAY);
		delete.setBorder(null);
		delete.setBackground(Color.LIGHT_GRAY);
		p2.setLayout(new FlowLayout(FlowLayout.CENTER, 15, 5));
		p2.add(add);
		p2.add(delete);
		doIt();//刷新显示记录的表格，以使最新的变化反映到界面的显示表格上
		add.addActionListener(this);
		delete.addActionListener(this);
	}

	private void doIt() {//从数据库中读取所有要显示的记录并显示在表格中
		try {
			DBConnection con = new DBConnection();
			String sql = "select* from GoodType";
			CachedRowSet crs = con.getResultSet(sql);
			int count = 0;
			while (crs.next()) {
				count++;
			}
			if(count==0){
				delete.setEnabled(false);
			}else{
				delete.setEnabled(true);
			}
			data = new String[count][headNum];
			crs.beforeFirst();
			goodTypeIDs = new String[count];
			count = 0;
			while (crs.next()) {
				String id = String.valueOf(crs.getInt(1));
				goodTypeIDs[count] = id;
				data[count][0] = id;
				data[count][1] = crs.getString(2).trim();
				count++;
			}
			recTable = new JTable(data, head);
			recScrollPane = new JScrollPane(recTable);
			this.setLayout(new BorderLayout(0, 15));
			this.add(p1, BorderLayout.NORTH);
			this.add(recScrollPane, BorderLayout.CENTER);
			this.add(p2, BorderLayout.SOUTH);
			this.validate();
		} catch (SQLException sqle) {
			sqle.printStackTrace();
		} catch (ClassNotFoundException cnfe) {
			cnfe.printStackTrace();
		}
	}

	public void actionPerformed(ActionEvent e) {
		if (e.getSource() == add) {
			String type = goodTypeTF.getText().trim();
			if (type.equals("")) {
				JOptionPane.showMessageDialog(null, "货品名称不能为空!", "提示",
						JOptionPane.INFORMATION_MESSAGE);
				return;
			}
			GoodType goodType=new GoodType();
			goodType.setTypeName(type);
			GoodTypeOperate goodTypeOperate=new GoodTypeOperate();
			goodTypeOperate.insertToDB(goodType);
			doIt();//刷新显示记录的表格，以使最新的变化反映到界面的显示表格上
		}
		if (e.getSource() == delete) {
			String typeID = (String) JOptionPane.showInputDialog(null,
					"请您选择要删除的原因ID!", "", JOptionPane.INFORMATION_MESSAGE, null,
					goodTypeIDs, goodTypeIDs[0]);
			if (typeID == null) {
				return;
			}
			int confirm = JOptionPane.showConfirmDialog(null, "您真的确认删除吗?", "",
					JOptionPane.INFORMATION_MESSAGE);
			if (confirm == JOptionPane.YES_OPTION) {
				GoodType goodType=new GoodType();
				goodType.setID(Integer.valueOf(typeID));
				GoodTypeOperate goodTypeOperate=new GoodTypeOperate();
				goodTypeOperate.deleteFromDB(goodType);
			}
			doIt();//刷新显示记录的表格，以使最新的变化反映到界面的显示表格上
		}
	}
}