emphandler.java

java课程的资料以及实验的代码

/*
 *EmpHandler.java：建立职工实体类的控制类。
 */

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.event.*;
import java.sql.*;

public class EmpHandler extends MyHandler implements ActionListener {
   EmpModel em;
   public EmpView addEv;
   public EmpView uptEv;
   DbConn dbc;
   Connection conn;
   String sql, strEmpno="";
   
   public void actionPerformed( ActionEvent e) {
   		dbc = new DbConn();
      	conn = dbc.getConnection();
   	
   	if (e.getActionCommand() == "add") {
	    em = new EmpModel(addEv.p1.jtfEmployeeId.getText(),
			addEv.p1.jtfEmployeeName.getText(),
			addEv.p1.jtfPosition.getText(),
			addEv.p1.jtaRemark.getText());
	    em.insert();
   	}
   	if (e.getActionCommand() == "upt") {
		em.setAll(uptEv.p1.jtfEmployeeName.getText(),
		uptEv.p1.jtfPosition.getText(),
		uptEv.p1.jtaRemark.getText());
		em.update();
   	}
   	if (e.getActionCommand() == "sel") {
   	    if (Share.verify(uptEv.p1.jtfEmployeeId)) {
   		em = new EmpModel(uptEv.p1.jtfEmployeeId.getText(),null,null,null);
   		em.select();
		uptEv.p1.jtfEmployeeId.setText(em.getEmpno());
		uptEv.p1.jtfEmployeeName.setText(em.getEname());
		uptEv.p1.jtfPosition.setText(em.getPosition());
		uptEv.p1.jtaRemark.setText(em.getRemarks());
	    }
   	}
   	if (e.getActionCommand() == "del") {
   		int t=Integer.parseInt(uptEv.p1.jtfEmployeeId.getText());
   		sql="select assetid from lend where empno = "+t;
   		try {
      		Statement stmt = conn.createStatement();
      		ResultSet rset = stmt.executeQuery (sql);
      	
      		while (rset.next()) {
				strEmpno=rset.getString(1);
      		}
      		
      		conn.commit(); 
      		rset.close();
      		stmt.close();
      		conn.close();
      	}
      	catch (java.sql.SQLException s) {
			System.out.println("exception: " + s.getMessage());
      	}
      	if(strEmpno.equals("")){
	      		em.delete();
				uptEv.p1.jtfEmployeeId.setText(em.getEmpno());
				uptEv.p1.jtfEmployeeName.setText(em.getEname());
				uptEv.p1.jtfPosition.setText(em.getPosition());
				uptEv.p1.jtaRemark.setText(em.getRemarks());
	     }else{
	      		JOptionPane.showMessageDialog(uptEv,"此职员有未归还资产"+"\n"+"不能删除！");
	   }
   	}
   }
}