dealwithfine.java

java语言编写的基于sql2000开发的图书馆管理系统

package reception;

import java.awt.GridBagLayout;
import javax.swing.JPanel;
import java.awt.Dimension;
import javax.swing.JLabel;
import java.awt.Rectangle;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JButton;
import javax.swing.JTextField;
import javax.swing.table.DefaultTableModel;

import main.DataBase;

class DealWithFine extends JPanel {

	private static final long serialVersionUID = 1L;
	private JLabel jLabel = null;
	private JScrollPane jScrollPane = null;
	private JTable jTable = null;
	private JButton deal = null;
	private JLabel jLabel3 = null;
	private JTextField money = null;
	private JButton submit = null;
	private JLabel jLabel1 = null;
	private JTextField penal_number = null;
	private DefaultTableModel modelForTable;
	/**
	 * This is the default constructor
	 */
	public DealWithFine() {
		super();
		initialize();
		this.setModelForTable();
	}

	/**
	 * This method initializes this
	 * 
	 * @return void
	 */
	private void initialize() {
		jLabel1 = new JLabel();
		jLabel1.setBounds(new Rectangle(16, 249, 75, 16));
		jLabel1.setText("罚单号");
		jLabel3 = new JLabel();
		jLabel3.setBounds(new Rectangle(16, 282, 75, 16));
		jLabel3.setText("罚款金额");
		jLabel = new JLabel();
		jLabel.setBounds(new Rectangle(17, 15, 64, 18));
		jLabel.setText("罚单浏览");
		this.setSize(579, 400);
		this.setLayout(null);
		this.add(jLabel, null);
		this.add(getJScrollPane(), null);
		this.add(getDeal(), null);
		this.add(jLabel3, null);
		this.add(getMoney(), null);
		this.add(getSubmit(), null);
		this.add(jLabel1, null);
		this.add(getPenal_number(), null);
	}

	/**
	 * This method initializes jScrollPane	
	 * 	
	 * @return javax.swing.JScrollPane	
	 */
	private JScrollPane getJScrollPane() {
		if (jScrollPane == null) {
			jScrollPane = new JScrollPane();
			jScrollPane.setBounds(new Rectangle(14, 45, 542, 169));
			jScrollPane.setViewportView(getJTable());
		}
		return jScrollPane;
	}

	/**
	 * This method initializes jTable	
	 * 	
	 * @return javax.swing.JTable	
	 */
	private JTable getJTable() {
		if (jTable == null) {
			jTable = new JTable();
		}
		return jTable;
	}

	/**
	 * This method initializes deal	
	 * 	
	 * @return javax.swing.JButton	
	 */
	private JButton getDeal() {
		if (deal == null) {
			deal = new JButton();
			deal.setBounds(new Rectangle(453, 224, 86, 22));
			deal.setText("处理罚单");
			deal.addActionListener(new java.awt.event.ActionListener() {
				public void actionPerformed(java.awt.event.ActionEvent e) {
					int i=DealWithFine.this.getJTable().getSelectedRow();
					if(i<0){
						javax.swing.JOptionPane.showMessageDialog(null,
								"图书馆管理系统\n" + "请选择一个罚单!!\n");						
					}else{
						String penal_number=(String)DealWithFine.this.modelForTable.
									getValueAt(i,0);
						DealWithFine.this.getPenal_number().
									setText(penal_number);
					}
				}
			});
		}
		return deal;
	}

	/**
	 * This method initializes money	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getMoney() {
		if (money == null) {
			money = new JTextField();
			money.setBounds(new Rectangle(117, 281, 100, 17));
		}
		return money;
	}

	/**
	 * This method initializes submit	
	 * 	
	 * @return javax.swing.JButton	
	 */
	private JButton getSubmit() {
		if (submit == null) {
			submit = new JButton();
			submit.setBounds(new Rectangle(16, 327, 75, 16));
			submit.setText("提交");
			submit.addActionListener(new java.awt.event.ActionListener() {
				public void actionPerformed(java.awt.event.ActionEvent e) {
					//处理罚单，输入罚款金额，提交
					String penal_number=DealWithFine.this.
								getPenal_number().getText();
					String money=DealWithFine.this.
									getMoney().getText();
					String sql="update penalty set penal_sum=" +money+
							" ,if_pay=1 where penal_number='"+penal_number+"'";
					DataBase.execute(sql);
					javax.swing.JOptionPane.showMessageDialog(null,
							"图书馆管理系统\n" + "罚单处理成功!!\n");
					DealWithFine.this.setModelForTable();
					}
			});
		}
		return submit;
	}

	private JTextField getPenal_number() {
		if (penal_number == null) {
			penal_number = new JTextField();
			penal_number.setBounds(new Rectangle(117, 250, 100, 17));
		}
		return penal_number;
	}

//	 该方法用来给jtable传入数据
	private void setModelForTable() {
		String sql="select penal_number,ID_Number,reason from " +
				"penalty where if_pay=0";
		String[] englishColumns = { "penal_number", "ID_Number", "reason" };
		String[] chineseColumns = { "罚款单号", "会员号", "原因" };
		DefaultTableModel modelForTable = DataBase.createModelForTable(
				englishColumns, chineseColumns, sql);
		this.modelForTable=modelForTable;
		this.getJTable().setModel(modelForTable);	
		this.getJTable().repaint();
	}
}  //  @jve:decl-index=0:visual-constraint="7,30"