require_attendance_view.java

javaGUI编写的人事管理系统(毕业学生答辩可参考)

package project;

import javax.swing.*;
import java.awt.Rectangle;
import javax.swing.border.TitledBorder;
import java.awt.Color;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.ResultSet;
import java.awt.event.MouseEvent;
import java.awt.event.MouseAdapter;
import java.awt.event.KeyEvent;
import java.awt.event.KeyAdapter;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class Require_attendance_view
    extends JPanel implements All_view {
  JFrame mainframe = null;
  JButton return_Btn = new JButton();
  JLabel jLabel1 = new JLabel();
  JLabel jLabel2 = new JLabel();
  JLabel jLabel3 = new JLabel();
  JLabel jLabel4 = new JLabel();
  JLabel jLabel5 = new JLabel();
  JLabel jLabel6 = new JLabel();
  JLabel jLabel7 = new JLabel();
  JLabel jLabel8 = new JLabel();
  JLabel jLabel9 = new JLabel();
  JLabel jLabel10 = new JLabel();
  JLabel jLabel11 = new JLabel();
  JLabel jLabel12 = new JLabel();
  JLabel jLabel13 = new JLabel();
  JLabel jLabel14 = new JLabel();
  JLabel jLabel15 = new JLabel();
  JLabel jLabel16 = new JLabel();
  JLabel jLabel17 = new JLabel();
  JLabel jLabel18 = new JLabel();
  JLabel jLabel19 = new JLabel();
  JLabel jLabel20 = new JLabel();
  JTextField id_text = new JTextField();
  JTextField jTextField2 = new JTextField();
  JTextField jTextField3 = new JTextField();

  JLabel[][] show_label = new JLabel[4][12];
  JLabel jLabel21 = new JLabel();
  JLabel jLabel22 = new JLabel();
  JLabel jLabel23 = new JLabel();
  JLabel jLabel24 = new JLabel();
  JScrollPane jScrollPane1 = new JScrollPane();
  JTable jTable1 = null;
  DataMap dm = null;
  public Require_attendance_view(JFrame mainframe) {
    this.mainframe = mainframe;
    try {
      jbInit();
      set_show_lable_pos();
      initial_table();
      jScrollPane1.getViewport().add(jTable1);
      setPanelPosOnDesktop(this.mainframe);
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }

  }

  public void setPanelPosOnDesktop(JFrame frame) {
    this.setLocation( ( ( (Frame1) frame).get_Container_width() -
                       this.getSize().width) / 2,
                     ( ( (Frame1) frame).get_Container_height() -
                      this.getSize().height) / 2);
  }

  public void closeCurrentPanel(JFrame frame) {
    ( (Frame1) frame).remove_panel();
    frame.repaint();
  }

  public void set_focus() {
    id_text.selectAll();
    id_text.requestFocus();
  }

  public void requestFocus() {
    set_focus();
  }

  private void set_show_lable_pos() {
    for (int i = 0; i < show_label.length; i++) {
      for (int j = 0; j < show_label[i].length; j++) {
        show_label[i][j] = new JLabel("0");
        show_label[i][j].setSize(29, 26);
        show_label[i][j].setLocation(213 + 32 * j, 484 + i * 32);
        this.add(show_label[i][j]);

      }

    }
  }

  private void jbInit() throws Exception {
    this.setLayout(null);
    this.setSize(800, 700);
    return_Btn.setBounds(new Rectangle(666, 652, 104, 29));
    return_Btn.setText("返  回");
    return_Btn.addActionListener(new
                                 Require_attendance_view_return_Btn_actionAdapter(this));
    jLabel1.setText("员工工号：");
    jLabel1.setBounds(new Rectangle(154, 401, 83, 27));
    jLabel2.setText("正常出勤");
    jLabel2.setBounds(new Rectangle(151, 484, 71, 27));
    jLabel3.setText("迟到天数");
    jLabel3.setBounds(new Rectangle(151, 517, 75, 27));
    jLabel4.setText("早退天数");
    jLabel4.setBounds(new Rectangle(151, 547, 74, 30));
    jLabel5.setText("矿工天数");
    jLabel5.setBounds(new Rectangle(152, 582, 68, 30));
    jLabel6.setText("1月");
    jLabel6.setBounds(new Rectangle(213, 453, 29, 26));
    jLabel7.setText("2月");
    jLabel7.setBounds(new Rectangle(240, 453, 29, 26));
    jLabel8.setText("3月");
    jLabel8.setBounds(new Rectangle(270, 453, 29, 26));
    jLabel9.setText("4月");
    jLabel9.setBounds(new Rectangle(298, 453, 29, 26));
    jLabel10.setText("5月");
    jLabel10.setBounds(new Rectangle(331, 453, 29, 26));
    jLabel11.setText("6月");
    jLabel11.setBounds(new Rectangle(362, 453, 29, 26));
    jLabel12.setText("7月");
    jLabel12.setBounds(new Rectangle(393, 453, 29, 26));
    jLabel13.setText("8月");
    jLabel13.setBounds(new Rectangle(424, 453, 29, 26));
    jLabel14.setText("9月");
    jLabel14.setBounds(new Rectangle(455, 453, 29, 26));
    jLabel15.setText("10月");
    jLabel15.setBounds(new Rectangle(487, 453, 29, 26));
    jLabel16.setText("11月");
    jLabel16.setBounds(new Rectangle(523, 453, 29, 26));
    jLabel17.setText("12月");
    jLabel17.setBounds(new Rectangle(557, 453, 29, 26));
    jLabel18.setText("合计");
    jLabel18.setBounds(new Rectangle(610, 455, 38, 23));
    jLabel19.setText("姓名:");
    jLabel19.setBounds(new Rectangle(344, 401, 74, 27));
    jLabel20.setText("部门:");
    jLabel20.setBounds(new Rectangle(493, 400, 74, 29));
    id_text.setBounds(new Rectangle(219, 401, 102, 25));
    id_text.addKeyListener(new Require_attendance_view_id_text_keyAdapter(this));
    jTextField2.setEditable(false);
    jTextField2.setBounds(new Rectangle(380, 402, 105, 26));
    jTextField3.setEditable(false);
    jTextField3.setBounds(new Rectangle(538, 401, 100, 27));

    jLabel21.setHorizontalAlignment(SwingConstants.CENTER);
    jLabel21.setText("0");
    jLabel21.setBounds(new Rectangle(607, 487, 34, 24));
    jLabel22.setHorizontalAlignment(SwingConstants.CENTER);
    jLabel22.setText("0");
    jLabel22.setBounds(new Rectangle(607, 516, 34, 24));
    jLabel23.setHorizontalAlignment(SwingConstants.CENTER);
    jLabel23.setText("0");
    jLabel23.setBounds(new Rectangle(607, 551, 34, 24));
    jLabel24.setHorizontalAlignment(SwingConstants.CENTER);
    jLabel24.setText("0");
    jLabel24.setBounds(new Rectangle(607, 583, 34, 24));
    jScrollPane1.setBounds(new Rectangle(25, 38, 741, 332));

    this.add(return_Btn);
    this.add(jLabel2);
    this.add(jLabel1);
    this.add(id_text);
    this.add(jLabel19);
    this.add(jTextField2);
    this.add(jLabel20);
    this.add(jTextField3);
    this.add(jLabel6);
    this.add(jLabel7);
    this.add(jLabel8);
    this.add(jLabel9);
    this.add(jLabel10);
    this.add(jLabel11);
    this.add(jLabel12);
    this.add(jLabel13);
    this.add(jLabel14);
    this.add(jLabel15);
    this.add(jLabel16);
    this.add(jLabel17);
    this.add(jLabel18);
    this.add(jLabel3);
    this.add(jLabel4);
    this.add(jLabel5);
    this.add(jLabel21);
    this.add(jLabel22);
    this.add(jLabel23);
    this.add(jLabel24);
    this.add(jScrollPane1);

  }

  public void return_Btn_actionPerformed(ActionEvent e) {
    closeCurrentPanel(mainframe);
  }

  private void initial_table() {
    DataBase db = new DataBase();
    String s1 = "select e1.* ,m1.zc as '12月正常',m1.cd as '12月迟到',m1.zt as '12月早退',m1.kg as '12月矿工' from ";
    String s2 = "(select e1.* ,m1.zc as '11月正常',m1.cd as '11月迟到',m1.zt as '11月早退',m1.kg as '11月矿工' from ";
    String s3 = "(select e1.* ,m1.zc as '10月正常',m1.cd as '10月迟到',m1.zt as '10月早退',m1.kg as '10月矿工' from ";
    String s4 = "(select e1.* ,m1.zc as '9月正常',m1.cd as '9月迟到',m1.zt as '9月早退',m1.kg as '9月矿工' from ";
    String s5 = "(select e1.* ,m1.zc as '8月正常',m1.cd as '8月迟到',m1.zt as '8月早退',m1.kg as '8月矿工' from ";
    String s6 = "(select e1.* ,m1.zc as '7月正常',m1.cd as '7月迟到',m1.zt as '7月早退',m1.kg as '7月矿工' from";
    String s7 = "(select e1.* ,m1.zc as '6月正常',m1.cd as '6月迟到',m1.zt as '6月早退',m1.kg as '6月矿工' from ";
    String s8 = "(select e1.* ,m1.zc as '5月正常',m1.cd as '5月迟到',m1.zt as '5月早退',m1.kg as '5月矿工' from ";
    String s9 = "(select e1.* ,m1.zc as '4月正常',m1.cd as '4月迟到',m1.zt as '4月早退',m1.kg as '4月矿工' from ";
    String s10 = "(select e1.* ,m1.zc as '3月正',m1.cd as '3月迟到',m1.zt as '3月早退', m1.kg as '3月矿工' from ";
    String s11 = "(select e1.* ,m1.zc as '2月正常',m1.cd as '2月迟到',m1.zt as '2月早退',m1.kg as '2月矿工' from ";
    String s12 = "(select e1.* ,m1.zc as '1月正常',m1.cd as '1月迟到',m1.zt as '1月早退',m1.kg as '1月矿工' from ";
    String s13 =
        "(select employee_id as'工号', name as '姓名',m1.depart_name as '工作部门' from ";
    String s14 = "(select * from employee_table where useful = 1) as e1 left outer join depart_table as m1 on e1.dep_id = m1.depart_id) as e1 left outer join attendance_table as m1 on 工号 = m1.id and m1.Currmonth ='1') as e1 left outer join attendance_table as m1 on 工号 = m1.id and m1.Currmonth ='2') as e1 left outer join attendance_table as m1 on 工号 = m1.id and m1.Currmonth ='3') as e1 left outer join attendance_table as m1 on 工号 = m1.id and m1.Currmonth ='4') as e1 left outer join attendance_table as m1 on 工号 = m1.id and m1.Currmonth ='5') as e1 left outer join attendance_table as m1 on 工号 = m1.id and m1.Currmonth ='6') as e1 left outer join attendance_table as m1 on 工号 = m1.id and m1.Currmonth ='7') as e1 left outer join attendance_table as m1 on 工号 = m1.id and m1.Currmonth ='8') as e1 left outer join attendance_table as m1 on 工号 = m1.id and m1.Currmonth ='9') as e1 left outer join attendance_table as m1 on 工号 = m1.id and m1.Currmonth ='10') as e1 left outer join attendance_table as m1 on 工号 = m1.id and m1.Currmonth ='11') as e1 left outer join attendance_table as m1 on 工号 = m1.id and m1.Currmonth ='12'"
        ;
    String sql = s1 + s2 + s3 + s4 + s5 + s6 + s7 + s8 + s9 + s10 + s11 + s12 +
        s13 + s14;
//String sql ="select employee_id as'工号', name as '姓名',m1.depart_name as '工作部门' from (select * from employee_table as e1 where useful = 1) as e1 left outer join depart_table as m1 on e1.dep_id = m1.depart_id";
    ResultSet rs = db.executeQuery(sql);
    dm = new DataMap(rs);
    db.close();
    MyTableModel tm = new MyTableModel(dm.get_DataMap_Array(),
                                       (Object[]) dm.get_Column_Title());
    tm.setEditable(false);
    jTable1 = new JTable(tm);
    jTable1.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
    jTable1.addMouseListener(new Require_attendance_view_jTable1_mouseAdapter(this));
  }

  public void jTable1_mouseClicked(MouseEvent e) {
    id_text.setText(jTable1.getValueAt(jTable1.getSelectedRow(), 0).toString());
    jTextField2.setText(jTable1.getValueAt(jTable1.getSelectedRow(), 1).
                        toString());
    jTextField3.setText(jTable1.getValueAt(jTable1.getSelectedRow(), 2).
                        toString());
    Require_attendance_C ra = new Require_attendance_C(this.mainframe, this);
    ra.show_record(id_text.getText(), this.show_label, jLabel21, jLabel22,
                   jLabel23, jLabel24);
  }

  public void id_text_keyPressed(KeyEvent e) {
    if (e.getKeyCode() == e.VK_ENTER) {
      Object[][] obj = dm.get_DataMap_Array();
      for (int i = 0; i < obj.length; i++) {
        if (id_text.getText().toString().equals( (String) obj[i][0])) {
          jTable1.setRowSelectionInterval(i, i);
          jTextField2.setText(jTable1.getValueAt(i, 1).toString());
          jTextField3.setText(jTable1.getValueAt(i, 2).toString());
          id_text.selectAll();
          break;
        }
      }
      Require_attendance_C ra = new Require_attendance_C(this.mainframe, this);
      ra.show_record(id_text.getText(), this.show_label, jLabel21, jLabel22,
                     jLabel23, jLabel24);

    }
  }

}

class Require_attendance_view_id_text_keyAdapter
    extends KeyAdapter {
  private Require_attendance_view adaptee;
  Require_attendance_view_id_text_keyAdapter(Require_attendance_view adaptee) {
    this.adaptee = adaptee;
  }

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

class Require_attendance_view_jTable1_mouseAdapter
    extends MouseAdapter {
  private Require_attendance_view adaptee;
  Require_attendance_view_jTable1_mouseAdapter(Require_attendance_view
                                               adaptee) {
    this.adaptee = adaptee;
  }

  public void mouseClicked(MouseEvent e) {
    adaptee.jTable1_mouseClicked(e);
  }
}

class Require_attendance_view_return_Btn_actionAdapter
    implements ActionListener {
  private Require_attendance_view adaptee;
  Require_attendance_view_return_Btn_actionAdapter(Require_attendance_view
      adaptee) {
    this.adaptee = adaptee;
  }

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