goodnotequalrecordjpanel.java

JAVA实现的酒店管理系统

package file1;

/*
 * @Author:
 * Create Time:2008-2-22
 * Description:货品的损益情况记录显示表
 */
import java.awt.FlowLayout;
import java.sql.SQLException;
import javax.swing.*;
import sun.jdbc.rowset.CachedRowSet;
import tools.StringToInsertToDBFilter;;

public class GoodNotEqualRecordJPanel extends JPanel {

	private JTable recTable = new JTable();
	private JScrollPane recScrollPane = null;
	private String[] head = { "记录编号", "损益货品名称", "损益发生时间", "损益数量", "损益状态",
			"损益原因" };// 表格的标题
	private String[][] data = null;// 表格的数据
	private int headNum = 0;// 表格标题的列数
	private DBConnection con = null;// 数据库联接操作类
	private String[] ids = null;// 存储所有货品损益记录的id
	private int totalRecordCount = 0;// 存储所有记录总数的变量

	public GoodNotEqualRecordJPanel() {

		con = new DBConnection();
		headNum = head.length;
		this.setLayout(new FlowLayout());
		getRecords();// 调用从数据库中读取指定字段数据的方法

	}

	public int getRecords() {// 从数据库中读取指定的字段数据并显示到表格中
		int totalRecord = 0;
		String sqlStr = "select GoodNotEqual.ID,goodName,check_time,not_equal_number,not_equal_state,not_equal_reason from GoodNotEqual,Good where GoodNotEqual.good_id=Good.ID";
		try {
			CachedRowSet crs = con.getResultSet(sqlStr);
			while (crs.next()) {
				totalRecord++;
			}
			data = new String[totalRecord][headNum];// 定义表格的数据
			ids = new String[totalRecord];
			crs.beforeFirst();
			totalRecord = 0;
			while (crs.next()) {
				data[totalRecord][0] = String.valueOf(crs.getInt(1));
				ids[totalRecord] = String.valueOf(crs.getInt(1));
				data[totalRecord][1] = String.valueOf(crs.getString(2).trim());
				data[totalRecord][2] = crs.getString(3).trim();
				data[totalRecord][3] = String.valueOf(crs.getInt(4));
				data[totalRecord][4] = crs.getString(5).trim();
				data[totalRecord][5] = StringToInsertToDBFilter.doReverseFilter(crs.getString(6).trim());
				totalRecord++;
			}
			totalRecordCount = totalRecord;// 用以变量临时存储记录数
			totalRecord = 0;// 重新从零开始查询数组
			recTable = new JTable(data, head);
			recTable.setRowHeight(20);
			recScrollPane = new JScrollPane(recTable);
			if (this.getComponentCount() != 0) {
				this.removeAll();// 删除已有的组件
			}
			this.add(recScrollPane);
			this.validate();// 使新的布局生效
		} catch (ClassNotFoundException cnfe) {
			JOptionPane.showMessageDialog(null, "发生ClassNotFound错误!", "",
					JOptionPane.INFORMATION_MESSAGE);
			return 0;
		} catch (SQLException sqle) {
			JOptionPane.showMessageDialog(null, "发生Sql错误!", "",
					JOptionPane.INFORMATION_MESSAGE);
			return 0;
		}
		return totalRecordCount;// 返回记录总数
	}

	public String[] getIDS() {// 取得存储所有货品损益记录的id的数组
		return ids;
	}
}