usermanagerjpanel.java

客运售票管理信息系统

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

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

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

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

		this.idField.setEnabled(true);
		this.nameField.setEnabled(true);
		this.passwordField.setEnabled(true);
		this.sexField.setEnabled(true);
		this.roleField.setEnabled(true);
		this.saveButton.setEnabled(true);
	}

	@Action
	public void deleteRecord() {
		String sql = new String("delete from user where 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.passwordField.getText().isEmpty()
				|| this.nameField.getText().isEmpty()
				|| this.sexField.getText().isEmpty()
				|| this.roleField.getText().isEmpty()) {
			javax.swing.JOptionPane.showMessageDialog(this,
					"以上4个字段均不得为空，请保持正确的数据输入！", "警告", 2/* warning */);
			return;
		}

		String sql = new String("update user set password = '"
				+ this.passwordField.getText() + "',name = '"
				+ this.nameField.getText() + "', sex = '"
				+ this.sexField.getText() + "', role = "
				+ Short.parseShort(this.roleField.getText())
				+ " where 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.nameField.getText().isEmpty()
				|| this.passwordField.getText().isEmpty()
				|| this.sexField.getText().isEmpty()
				|| this.roleField.getText().isEmpty()) {
			javax.swing.JOptionPane.showMessageDialog(this,
					"以上5个字段均不得为空，请输入相应数据！", "请输入", 2/* warning */);
			return;
		}
		String sql = new String("insert into user values ('"
				+ this.idField.getText() + "','" + this.nameField.getText() + "','"+ this.passwordField.getText()
				+ "','" + this.sexField.getText()+ "',"+ Short.parseShort(this.roleField.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();
        nameLabel = new javax.swing.JLabel();
        passwordLabel = new javax.swing.JLabel();
        sexLabel = new javax.swing.JLabel();
        roleLabel = new javax.swing.JLabel();
        idField = new javax.swing.JTextField();
        nameField = new javax.swing.JTextField();
        passwordField = new javax.swing.JTextField();
        sexField = new javax.swing.JTextField();
        roleField = 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(UserManagerJPanel.class, this);

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

        deleteButton.setAction(actionMap.get("deleteRecord")); // NOI18N
        deleteButton.setFont(resourceMap.getFont("nameField.font")); // NOI18N
        deleteButton.setText(resourceMap.getString("deleteButton.text")); // NOI18N
        deleteButton.setName("deleteButton"); // NOI18N

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

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

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

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

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

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

        idField.setFont(resourceMap.getFont("nameField.font")); // NOI18N
        idField.setEnabled(false);
        idField.setName("idField"); // NOI18N

        nameField.setFont(resourceMap.getFont("nameField.font")); // NOI18N