vehiclemanagerjpanel.java

客运售票管理信息系统

/*
 * VehicleManagerJPanel.java
 *
 * Created on 2009年1月11日, 下午12:13
 */

package passengertransportmis;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import javax.swing.table.DefaultTableModel;

import org.jdesktop.application.Action;

/**
 * 
 * @author Degree41
 */
public class VehicleManagerJPanel extends javax.swing.JPanel {

	/** Creates new form VehicleManagerJPanel */
	public VehicleManagerJPanel() {
		initComponents();
	}

	@Action
	public void newRecord() {
		this.returnInitState();

		this.idField.setEnabled(true);
		this.route_idField.setEnabled(true);
		this.typeField.setEnabled(true);
		this.fareQuotietyField.setEnabled(true);
		this.saveButton.setEnabled(true);
	}

	@Action
	public void deleteRecord() {
		String sql = new String("delete from vehicle where vehicle_id = '"
				+ this.idField.getText() + "'");
		int i = Database.executeUpdate(stmt, sql);
		if (i == 1) {
			javax.swing.JOptionPane.showMessageDialog(this, "删除车辆信息成功！", "提示",
					1/* infomation */);
			this.returnInitState();
		} else {
			javax.swing.JOptionPane.showMessageDialog(this,
					"删除车辆信息失败，请查看系统日志，维护系统！", "错误", 0/* erroe */);
			this.returnInitState();
		}
	}

	@Action
	public void update() {
		if (this.typeField.getText().isEmpty()
				|| this.route_idField.getText().isEmpty()
				|| this.fareQuotietyField.getText().isEmpty()) {
			javax.swing.JOptionPane.showMessageDialog(this,
					"以上3个字段均不得为空，请保持正确的数据输入！", "警告", 2/* warning */);
			return;
		}

		String sql = new String("update vehicle set type = '"
				+ this.typeField.getText() + "',route_id = "
				+ Integer.parseInt(this.route_idField.getText()) + ", fare_Quotiety = "
				+ Double.parseDouble(this.fareQuotietyField.getText())
				+ "where vehicle_id = '" + this.idField.getText() + "'");
		int i = Database.executeUpdate(stmt, sql);
		if (i == 1) {
			javax.swing.JOptionPane.showMessageDialog(this, "更新车辆信息成功！", "提示",
					1/* infomation */);
			this.returnInitState();

		} else {
			javax.swing.JOptionPane.showMessageDialog(this,
					"更新车辆信息失败，请确保输入信息正确！", "错误", 0/* erroe */);
			this.returnInitState();
		}
	}

	@Action
	public void save() {
		if (this.idField.getText().isEmpty()
				|| this.route_idField.getText().isEmpty()
				|| this.typeField.getText().isEmpty()
				|| this.fareQuotietyField.getText().isEmpty()) {
			javax.swing.JOptionPane.showMessageDialog(this,
					"以上4个字段均不得为空，请输入相应数据！", "请输入", 2/* warning */);
			return;
		}
		String sql = new String("insert into vehicle values ('"
				+ this.idField.getText() + "'," + Integer.parseInt(this.route_idField.getText()) + ",'"+ this.typeField.getText()
				+ "'," + Double.parseDouble(this.fareQuotietyField.getText())
				+ ")");
		int i = Database.executeUpdate(stmt, sql);
		if (i == 1) {
			javax.swing.JOptionPane.showMessageDialog(this, "插入车辆信息成功！", "提示",
					1/* infomation */);
			this.returnInitState();

		} else
			javax.swing.JOptionPane.showMessageDialog(this,
					"插入车辆信息失败，请确保输入信息正确！", "错误", 0/* erroe */);
	}

	/**
	 * This method is called from within the constructor to initialize the form.
	 * WARNING: Do NOT modify this code. The content of this method is always
	 * regenerated by the Form Editor.
	 */
	@SuppressWarnings("unchecked")
	// <editor-fold defaultstate="collapsed" desc="Generated
    // <editor-fold defaultstate="collapsed" desc="Generated Code">//GEN-BEGIN:initComponents
    private void initComponents() {

        vehicleManagerPanel = new javax.swing.JPanel();
        masterScrollPane = new javax.swing.JScrollPane();
        masterTable = new javax.swing.JTable();
        idLabel = new javax.swing.JLabel();
        typeLabel = new javax.swing.JLabel();
        fareQuotietyLabel = new javax.swing.JLabel();
        idField = new javax.swing.JTextField();
        typeField = new javax.swing.JTextField();
        fareQuotietyField = new javax.swing.JTextField();
        updateButton = new javax.swing.JButton();
        newButton = new javax.swing.JButton();
        deleteButton = new javax.swing.JButton();
        saveButton = new javax.swing.JButton();
        route_idLabel = new javax.swing.JLabel();
        route_idField = new javax.swing.JTextField();

        setName("Form"); // NOI18N

        vehicleManagerPanel.setName("vehicleManagerPanel"); // NOI18N

        masterScrollPane.setName("masterScrollPane"); // NOI18N

        masterTable.setName("masterTable"); // NOI18N
        masterTable.addFocusListener(new java.awt.event.FocusAdapter() {
			public void focusGained(java.awt.event.FocusEvent evt) {
				masterTableFocusGained(evt);
			}
		});
        masterScrollPane.setViewportView(masterTable);

        javax.swing.ActionMap actionMap = org.jdesktop.application.Application.getInstance(passengertransportmis.PassengerTransportMISApp.class).getContext().getActionMap(VehicleManagerJPanel.class, this);

        org.jdesktop.application.ResourceMap resourceMap = org.jdesktop.application.Application.getInstance(passengertransportmis.PassengerTransportMISApp.class).getContext().getResourceMap(VehicleManagerJPanel.class);
          idLabel.setFont(resourceMap.getFont("typeLabel.font")); // NOI18N
        idLabel.setText(resourceMap.getString("idLabel.text")); // NOI18N
        idLabel.setName("idLabel"); // NOI18N

        typeLabel.setFont(resourceMap.getFont("typeLabel.font")); // NOI18N
        typeLabel.setText(resourceMap.getString("typeLabel.text")); // NOI18N
        typeLabel.setName("typeLabel"); // NOI18N

        fareQuotietyLabel.setFont(resourceMap.getFont("typeLabel.font")); // NOI18N
        fareQuotietyLabel.setText(resourceMap.getString("fareQuotietyLabel.text")); // NOI18N
        fareQuotietyLabel.setName("fareQuotietyLabel"); // NOI18N

        idField.setFont(resourceMap.getFont("typeLabel.font")); // NOI18N
        idField.setName("idField"); // NOI18N

        typeField.setFont(resourceMap.getFont("typeLabel.font")); // NOI18N
        typeField.setName("typeField"); // NOI18N

        fareQuotietyField.setFont(resourceMap.getFont("typeLabel.font")); // NOI18N
        fareQuotietyField.setName("fareQuotietyField"); // NOI18N

        updateButton.setAction(actionMap.get("update")); // NOI18N
        updateButton.setFont(resourceMap.getFont("typeLabel.font")); // NOI18N
        updateButton.setText(resourceMap.getString("updateButton.text")); // NOI18N
        updateButton.setName("updateButton"); // NOI18N
       

        newButton.setAction(actionMap.get("newRecord")); // NOI18N
        newButton.setFont(resourceMap.getFont("typeLabel.font")); // NOI18N