frmemp.java~85~

用java实现的固定资产管理系统相信对于初学者可以从中学到一点知识....!

package 固定资产管理系统;

import java.awt.*;
import javax.swing.JInternalFrame;
import javax.swing.*;
import javax.swing.border.TitledBorder;
import javax.swing.table.JTableHeader;
import com.borland.jbcl.layout.XYLayout;
import com.borland.jbcl.layout.XYConstraints;
import com.borland.jbcl.layout.*;

import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.KeyEvent;
import java.awt.event.KeyAdapter;
import java.awt.event.MouseEvent;
import java.awt.event.MouseAdapter;

public class Frmemp extends JInternalFrame {
    ConnectDataBase cdb=new ConnectDataBase();
    BorderLayout borderLayout1 = new BorderLayout();
    JPanel jPanel1 = new JPanel();
    JPanel jPanel2 = new JPanel();
    JLabel lblwmpno = new JLabel();
    JTextField txtempno = new JTextField();
    JLabel lblempname = new JLabel();
    JButton btnadd = new JButton();
    JButton btndel = new JButton();
    JButton btnrenew = new JButton();
    JTextField txtempname = new JTextField();
    JLabel lblposition = new JLabel();
    JTextField txtposition = new JTextField();
    JLabel lblremarks = new JLabel();
    JTextField txtremarks = new JTextField();
    XYLayout xYLayout1 = new XYLayout();
    JPanel jPanel3 = new JPanel();
    JScrollPane jScrollPane1 = new JScrollPane();
    BorderLayout borderLayout2 = new BorderLayout();
    JTable jTable1 = new JTable(cdb.getempinfo());
    JTableHeader jTableHeader1 = jTable1.getTableHeader();
    TitledBorder titledBorder1 = new TitledBorder("职员信息");
    TitledBorder titledBorder2 = new TitledBorder("职员表");
    public Frmemp() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        getContentPane().setLayout(borderLayout1);
        lblwmpno.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        lblwmpno.setText("职员编号");
        txtempno.setText("");
        lblempname.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        lblempname.setText("职员名称");
        jPanel1.setLayout(xYLayout1);
        btnadd.setFont(new java.awt.Font("宋体", Font.BOLD, 13));
        btnadd.setText("入职");
        btnadd.addActionListener(new Frmemp_btnadd_actionAdapter(this));
        btndel.setFont(new java.awt.Font("宋体", Font.BOLD, 13));
        btndel.setText("离职");
        btndel.addActionListener(new Frmemp_btndel_actionAdapter(this));
        btnrenew.setFont(new java.awt.Font("宋体", Font.BOLD, 13));
        btnrenew.setText("更新");
        btnrenew.addActionListener(new Frmemp_btnrenew_actionAdapter(this));
        txtempname.setText("");
        lblposition.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        lblposition.setText("  职位");
        txtposition.setText("");
        lblremarks.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        lblremarks.setText("备注(可空)");
        txtremarks.setText("");
        jPanel3.setLayout(borderLayout2);
        jPanel1.setBorder(titledBorder1);
        jPanel3.setBorder(titledBorder2);
        this.setTitle("职员管理");
        jTable1.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        jTable1.setAutoResizeMode(JTable.AUTO_RESIZE_SUBSEQUENT_COLUMNS);
        jTable1.addMouseListener(new Frmemp_jTable1_mouseAdapter(this));
        jTable1.addKeyListener(new Frmemp_jTable1_keyAdapter(this));
        this.getContentPane().add(jPanel2, java.awt.BorderLayout.SOUTH);
        jPanel2.add(btnadd);
        jPanel2.add(btndel);
        jPanel2.add(btnrenew);
        this.getContentPane().add(jPanel1, java.awt.BorderLayout.WEST);
        jPanel1.add(txtremarks, new XYConstraints(75, 180, 90, 20));
        jPanel1.add(lblremarks, new XYConstraints(8, 180, 80, 20));
        jPanel1.add(txtposition, new XYConstraints(75, 130, 90, 20));
        jPanel1.add(lblposition, new XYConstraints(8, 130, 80, 20));
        jPanel1.add(txtempname, new XYConstraints(75, 80, 90, 20));
        jPanel1.add(lblempname, new XYConstraints(8, 80, 80, 20));
        jPanel1.add(txtempno, new XYConstraints(75, 30, 90, 20));
        jPanel1.add(lblwmpno, new XYConstraints(8, 30, 80, 20));
        this.getContentPane().add(jPanel3, java.awt.BorderLayout.CENTER);
        jPanel3.add(jTableHeader1, java.awt.BorderLayout.NORTH);
        jPanel3.add(jScrollPane1, java.awt.BorderLayout.CENTER);
        jScrollPane1.getViewport().add(jTable1);
        jTableHeader1.setReorderingAllowed(false);
    }

    public void btnadd_actionPerformed(ActionEvent e) {
        if(txtempno.getText().equals("") || txtempname.getText().equals("") ||
           txtposition.getText().equals("") ){
            JOptionPane.showMessageDialog(this,"输入的职员信息不完整","错误",
                                                   JOptionPane.ERROR_MESSAGE);
          }
        else{
            int flag=JOptionPane.showConfirmDialog(this,"确定真的要把当前的职员信息添加吗？",
                                                            "入职信息",0);
                    if(flag==0){
                        cdb.empaddinfo(txtempno.getText(), txtempname.getText(),
                                       txtposition.getText(),txtremarks.getText());
                        jTable1.setModel(cdb.getempinfo());
                    }
        }
    }

    public void btndel_actionPerformed(ActionEvent e) {
        int r;
        r=jTable1.getSelectedRow();
        if(r>=0){
            int flag=JOptionPane.showConfirmDialog(this,"确定真的要把当前的职员信息删除吗？",
                                                            "离职信息",0);
            if(flag==0){
                String no = jTable1.getValueAt(r, 0).toString();
                cdb.empdelinfo(no);
                jTable1.setModel(cdb.getempinfo());
            }
        }
        else
            JOptionPane.showMessageDialog(this,"没有选中职员表中的任何一项","错误",
                                          JOptionPane.ERROR_MESSAGE);
    }

    public void btnrenew_actionPerformed(ActionEvent e) {
        if(txtempno.getText().equals("") || txtempname.getText().equals("") ||
           txtposition.getText().equals("") ){
            JOptionPane.showMessageDialog(this,"输入的职员信息不完整","错误",
                                                   JOptionPane.ERROR_MESSAGE);
          }
        else{
            int flag=JOptionPane.showConfirmDialog(this,"确定真的要把当前的职员信息更新吗？",
                                                            "更新信息",0);
                    if(flag==0){
                        cdb.emprenew(txtempno.getText(), txtempname.getText(),
                                       txtposition.getText(),txtremarks.getText());
                        jTable1.setModel(cdb.getempinfo());
                    }
        }
    }

    public void jTable1_keyPressed(KeyEvent e) {
        if(e.getKeyCode()==e.VK_DOWN){
            int r = jTable1.getSelectedRow();
            if(r>=jTable1.getRowCount()-1){
                r=jTable1.getRowCount()-2;
            }
            txtempno.setText(jTable1.getValueAt(r+1,0).toString());
            txtempname.setText(jTable1.getValueAt(r+1,1).toString());
            txtposition.setText(jTable1.getValueAt(r+1,2).toString());
            txtremarks.setText(String.valueOf(jTable1.getValueAt(r+1,3)));
        }
        else if(e.getKeyCode()==e.VK_UP){
            int r = jTable1.getSelectedRow();
            if(r==0){
                r=1;
            }
            txtempno.setText(jTable1.getValueAt(r-1,0).toString());
            txtempname.setText(jTable1.getValueAt(r-1,1).toString());
            txtposition.setText(jTable1.getValueAt(r-1,2).toString());
            txtremarks.setText(String.valueOf(jTable1.getValueAt(r-1,3)));
        }

       else if(e.getKeyCode()==e.VK_PAGE_DOWN){
            int r = jTable1.getRowCount() - 1;
            txtempno.setText(jTable1.getValueAt(r, 0).toString());
            txtempname.setText(jTable1.getValueAt(r, 1).toString());
            txtposition.setText(jTable1.getValueAt(r, 2).toString());
            txtremarks.setText(String.valueOf(jTable1.getValueAt(r,3)));
        }
        else if(e.getKeyCode()==e.VK_PAGE_UP){
            txtempno.setText(jTable1.getValueAt(0, 0).toString());
            txtempname.setText(jTable1.getValueAt(0, 1).toString());
            txtposition.setText(jTable1.getValueAt(0, 2).toString());
            txtremarks.setText(String.valueOf(jTable1.getValueAt(0,3)));
        }
    }

    public void jTable1_mousePressed(MouseEvent e) {
        int r = jTable1.getSelectedRow();
        txtempno.setText(jTable1.getValueAt(r,0).toString());
        txtempname.setText(jTable1.getValueAt(r,1).toString());
        txtposition.setText(jTable1.getValueAt(r,2).toString());
        txtremarks.setText(String.valueOf(jTable1.getValueAt(r,3)));
    }

    public void jTable1_mouseClicked(MouseEvent e) {
        if(e.getClickCount()==2){

    int r=jTable1.getSelectedRow();
    int c=jTable1.getSelectedColumn();
    jTable1.setValueAt(jTable1.getValueAt(r,c),r,c);


        }
    }


}


class Frmemp_jTable1_keyAdapter extends KeyAdapter {
    private Frmemp adaptee;
    Frmemp_jTable1_keyAdapter(Frmemp adaptee) {
        this.adaptee = adaptee;
    }

    public void keyPressed(KeyEvent e) {
        adaptee.jTable1_keyPressed(e);
    }
}


class Frmemp_jTable1_mouseAdapter extends MouseAdapter {
    private Frmemp adaptee;
    Frmemp_jTable1_mouseAdapter(Frmemp adaptee) {
        this.adaptee = adaptee;
    }

    public void mousePressed(MouseEvent e) {
        adaptee.jTable1_mousePressed(e);
    }
}


class Frmemp_btnrenew_actionAdapter implements ActionListener {
    private Frmemp adaptee;
    Frmemp_btnrenew_actionAdapter(Frmemp adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btnrenew_actionPerformed(e);
    }
}


class Frmemp_btndel_actionAdapter implements ActionListener {
    private Frmemp adaptee;
    Frmemp_btndel_actionAdapter(Frmemp adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btndel_actionPerformed(e);
    }
}


class Frmemp_btnadd_actionAdapter implements ActionListener {
    private Frmemp adaptee;
    Frmemp_btnadd_actionAdapter(Frmemp adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btnadd_actionPerformed(e);
    }
}