routemanagerjpanel.java

客运售票管理信息系统

/*
 * RouteManagerJPanel.java
 *
 * Created on 2009年1月13日, 下午2:58
 */

package passengertransportmis;
import java.sql.Connection;
import java.sql.Statement;

import org.jdesktop.application.Action;
/**
 *
 * @author  Degree41
 */
public class RouteManagerJPanel extends javax.swing.JPanel {

    /** Creates new form RouteManagerJPanel */
    public RouteManagerJPanel() {
        initComponents();
    }
	@Action
	public void newRecord() {
		this.returnInitState();

		this.idField.setEnabled(true);
		this.startPointField.setEnabled(true);
		this.endPointField.setEnabled(true);
		this.fareField.setEnabled(true);
		this.saveButton.setEnabled(true);
	}

	@Action
	public void deleteRecord() {
		String sql = new String("delete from route where route_id = "
				+ Integer.parseInt(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/* error */);
			this.returnInitState();
		}
	}

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

		String sql = new String("update route set start_point = '"
				+ this.startPointField.getText() + "', end_point = '"
				+ this.endPointField.getText() + "', fare = "
				+ Double.parseDouble(this.fareField.getText())
				+ "where route_id = " + Integer.parseInt(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.startPointField.getText().isEmpty()
				|| this.endPointField.getText().isEmpty()
				|| this.fareField.getText().isEmpty()) {
			javax.swing.JOptionPane.showMessageDialog(this,
					"以上4个字段均不得为空，请输入相应数据！", "请输入", 2/* warning */);
			return;
		}
		String sql = new String("insert into route values ("
				+ Integer.parseInt(this.idField.getText()) + ",'" + this.startPointField.getText() + "','" + this.endPointField.getText()
				+ "'," + Double.parseDouble(this.fareField.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 Code">//GEN-BEGIN:initComponents
    private void initComponents() {

        newButton = new javax.swing.JButton();
        deleteButton = new javax.swing.JButton();
        updateButton = new javax.swing.JButton();
        idLabel = new javax.swing.JLabel();
        startPointLabel = new javax.swing.JLabel();
        endPointLabel = new javax.swing.JLabel();
        fareLabel = new javax.swing.JLabel();
        idField = new javax.swing.JTextField();
        startPointField = new javax.swing.JTextField();
        endPointField = new javax.swing.JTextField();
        fareField = new javax.swing.JTextField();
        masterScrollPane = new javax.swing.JScrollPane();
        masterTable = new javax.swing.JTable();
        saveButton = new javax.swing.JButton();

        setName("Form"); // NOI18N

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

        org.jdesktop.application.ResourceMap resourceMap = org.jdesktop.application.Application.getInstance(passengertransportmis.PassengerTransportMISApp.class).getContext().getResourceMap(RouteManagerJPanel.class);
        
        newButton.setAction(actionMap.get("newRecord")); // NOI18N
        newButton.setFont(resourceMap.getFont("endPointLabel.font")); // NOI18N
        newButton.setName("newButton"); // NOI18N

        deleteButton.setAction(actionMap.get("deleteRecord")); // NOI18N
        deleteButton.setFont(resourceMap.getFont("endPointLabel.font")); // NOI18N
        deleteButton.setName("deleteButton"); // NOI18N

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

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

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

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

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

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

        startPointField.setFont(resourceMap.getFont("endPointLabel.font")); // NOI18N
        startPointField.setName("startPointField"); // NOI18N

        endPointField.setFont(resourceMap.getFont("endPointLabel.font")); // NOI18N
        endPointField.setName("endPointField"); // NOI18N

        fareField.setFont(resourceMap.getFont("endPointLabel.font")); // NOI18N
        fareField.setName("fareField"); // 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);

        saveButton.setAction(actionMap.get("save")); // NOI18N
        saveButton.setFont(resourceMap.getFont("saveButton.font")); // NOI18N
        saveButton.setText(resourceMap.getString("saveButton.text")); // NOI18N
        saveButton.setName("saveButton"); // NOI18N

        javax.swing.GroupLayout layout = new javax.swing.GroupLayout(this);
        this.setLayout(layout);
        layout.setHorizontalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(layout.createSequentialGroup()
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
                        .addComponent(newButton)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addComponent(deleteButton)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addComponent(updateButton)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                        .addComponent(saveButton))
                    .addGroup(layout.createSequentialGroup()
                        .addContainerGap()
                        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addComponent(idLabel)
                            .addComponent(startPointLabel)
                            .addComponent(endPointLabel)
                            .addComponent(fareLabel))
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addComponent(idField, javax.swing.GroupLayout.DEFAULT_SIZE, 455, Short.MAX_VALUE)
                            .addComponent(startPointField, javax.swing.GroupLayout.DEFAULT_SIZE, 455, Short.MAX_VALUE)
                            .addComponent(endPointField, javax.swing.GroupLayout.DEFAULT_SIZE, 455, Short.MAX_VALUE)
                            .addComponent(fareField, javax.swing.GroupLayout.DEFAULT_SIZE, 455, Short.MAX_VALUE)))
                    .addGroup(layout.createSequentialGroup()
                        .addContainerGap()
                        .addComponent(masterScrollPane, javax.swing.GroupLayout.DEFAULT_SIZE, 567, Short.MAX_VALUE)))
                .addContainerGap())
        );
        layout.setVerticalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(layout.createSequentialGroup()
                .addContainerGap()
                .addComponent(masterScrollPane, javax.swing.GroupLayout.DEFAULT_SIZE, 258, Short.MAX_VALUE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(idLabel)
                    .addComponent(idField, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(startPointLabel)
                    .addComponent(startPointField, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(endPointLabel)
                    .addComponent(endPointField, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(fareLabel)
                    .addComponent(fareField, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                        .addComponent(deleteButton)
                        .addComponent(newButton)
                        .addComponent(updateButton))
                    .addComponent(saveButton))
                .addContainerGap())
        );

        layout.linkSize(javax.swing.SwingConstants.VERTICAL, new java.awt.Component[] {saveButton, updateButton});
    	this.returnInitState();
    }// </editor-fold>//GEN-END:initComponents
	private void masterTableFocusGained(java.awt.event.FocusEvent evt) {
		// TODO add your handling code here:
		this.newButton.setEnabled(true);
		this.deleteButton.setEnabled(true);
		this.updateButton.setEnabled(true);
		this.saveButton.setEnabled(false);

		this.idField.setEnabled(false);
		this.startPointField.setEnabled(true);
		this.endPointField.setEnabled(true);
		this.fareField.setEnabled(true);

		int i = this.masterTable.getSelectedRow();
		this.idField.setText(this.masterTable.getModel().getValueAt(i, 0)
				.toString());
		this.startPointField.setText(this.masterTable.getModel().getValueAt(i, 1)
				.toString());
		this.endPointField.setText(this.masterTable.getModel().getValueAt(
				i, 2).toString());
		this.fareField.setText(this.masterTable.getModel().getValueAt(
				i, 3).toString());
	}

	private void returnInitState() {
		this.newButton.setEnabled(true);
		this.deleteButton.setEnabled(false);
		this.updateButton.setEnabled(false);
		this.saveButton.setEnabled(false);

		this.idField.setText("");
		this.idField.setEnabled(false);
		this.startPointField.setText("");
		this.startPointField.setEnabled(false);
		this.endPointField.setText("");
		this.endPointField.setEnabled(false);
		this.fareField.setText("");
		this.fareField.setEnabled(false);

		// 更新视图
		String sql = "select * from route";
		ManagerPanelService.initFromDatabase(this.masterTable, sql);
	}

    // Variables declaration - do not modify//GEN-BEGIN:variables
    private javax.swing.JButton deleteButton;
    private javax.swing.JTextField endPointField;
    private javax.swing.JLabel endPointLabel;
    private javax.swing.JTextField fareField;
    private javax.swing.JLabel fareLabel;
    private javax.swing.JTextField idField;
    private javax.swing.JLabel idLabel;
    private javax.swing.JScrollPane masterScrollPane;
    private javax.swing.JTable masterTable;
    private javax.swing.JButton newButton;
    private javax.swing.JButton saveButton;
    private javax.swing.JTextField startPointField;
    private javax.swing.JLabel startPointLabel;
    private javax.swing.JButton updateButton;
    // End of variables declaration//GEN-END:variables

	Connection conn = Database.getConn();
	Statement stmt = Database.createStmt(conn);

}