lendhandler.java

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

/*
 *LendHandler.java：建立借用归还操作的控制类。
 */

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

public class LendHandler extends MyHandler implements ActionListener {
   LendModel em;
   public LendView lenEv;
   public LendView retEv;
   DbConn dbc, dbc2, dbc3, dbc4, dbc5, dbc6;
   Connection conn, conn2, conn3, conn4, conn5, conn6;
   String sql, sql2, sql3, strStatus="", strUseby="", strReturn="", strEmp="", sqlEmp;
   
   public void actionPerformed( ActionEvent e) {
		
      	dbc = new DbConn();
      	dbc2 = new DbConn();
      	dbc3 = new DbConn();
      	dbc4 = new DbConn();
      	dbc5 = new DbConn();
      	dbc6 = new DbConn();
      	conn = dbc.getConnection();
      	conn2 = dbc2.getConnection();
      	conn3 = dbc3.getConnection();
      	conn4 = dbc4.getConnection();
      	conn5 = dbc5.getConnection();
      	conn6 = dbc5.getConnection();
      
   	if (e.getActionCommand() == "len") {
   		int t=Integer.parseInt((String)lenEv.p1.jtfAssetId.getSelectedItem());
   		sql="select status, useby from asset where assetid = "+t;
   		try {
      		Statement stmt = conn.createStatement();
      		ResultSet rset = stmt.executeQuery (sql);
      	
      		while (rset.next()) {
				strStatus=rset.getString(1);
				strUseby=rset.getString(2);
      		}
      	
      		conn.commit(); 
      		rset.close();
      		stmt.close();
      		conn.close();
      	}
      	catch (java.sql.SQLException s) {
			System.out.println("exception: " + s.getMessage());
      	}
   		
   		if(strStatus.equals("正常") && strUseby.equals("")){
//   		if(true){	
   			em = new LendModel((String)lenEv.p1.jtfAssetId.getSelectedItem(),
			        (String)lenEv.p1.jcbEmpNo.getSelectedItem(),
			        lenEv.p1.jtfUseDate.getText(),
			        lenEv.p1.jtfRetDate.getText(),
			        (String)lenEv.p1.jtfIsReturn.getSelectedItem(),
			        lenEv.p1.jtfLender.getText(),
			        lenEv.p1.jtfRemarks.getText());
			em.lendReturn();
			int n=Integer.parseInt((String)lenEv.p1.jcbEmpNo.getSelectedItem());
			sqlEmp="select ename from employee where empno = "+n;
			try {
	      		Statement stmt6 = conn6.createStatement();
	      		ResultSet rset6 = stmt6.executeQuery(sqlEmp);
	      		
	      		while (rset6.next()) {
					strEmp=rset6.getString(1);
      			}
	      		
	      		conn6.commit(); 
	      		stmt6.close();
	      		rset6.close();
	      		conn6.close();
	      	}
	      	catch (java.sql.SQLException s) {
				System.out.println("exception: " + s.getMessage());
	      	}
	      	
			String sqlUp="update asset set useby='"+strEmp+"'where assetid = "+t;
			try {
	      		Statement stmt4 = conn4.createStatement();
	      		int m = stmt4.executeUpdate(sqlUp);
	      	
	      		conn4.commit(); 
	      		stmt4.close();
	      		conn4.close();
	      	}
	      	catch (java.sql.SQLException s) {
				System.out.println("exception: " + s.getMessage());
	      	}
		}else{
			JOptionPane.showMessageDialog(lenEv,"此产品不能借用！");
		}
	    
   	}
   	
   	if (e.getActionCommand() == "ret") {
   		int t=Integer.parseInt((String)retEv.p1.jtfAssetId.getSelectedItem());
   		sql2="select isreturn from lend where assetid = "+t;
   		
   		try {
      		Statement stmt2 = conn2.createStatement();
      		ResultSet rset2 = stmt2.executeQuery (sql2);
      	
      		while (rset2.next()) {
				strReturn=rset2.getString(1).trim();
      		}
      	
      		conn2.commit(); 
      		rset2.close();
      		stmt2.close();
      		conn2.close();
      	}
      	catch (java.sql.SQLException s) {
			System.out.println("exception: " + s.getMessage());
      	}
   		
   		if(strReturn.equals("借用")){
   			sql3="delete lend where assetid="+t;
	   		try {
	      		Statement stmt3 = conn3.createStatement();
	      		int m = stmt3.executeUpdate(sql3);
	      	
	      		conn3.commit(); 
	      		stmt3.close();
	      		conn3.close();
	      	}
	      	catch (java.sql.SQLException s) {
				System.out.println("exception: " + s.getMessage());
	      	}
	      	
	      	String sqlUp="update asset set useby='' where assetid="+t;
			try {
	      		Statement stmt5 = conn5.createStatement();
	      		int m = stmt5.executeUpdate(sqlUp);
	      	
	      		conn5.commit(); 
	      		stmt5.close();
	      		conn5.close();
	      	}
	      	catch (java.sql.SQLException s) {
				System.out.println("exception: " + s.getMessage());
	      	}
		}else{
			JOptionPane.showMessageDialog(retEv,"此产品不能归还！");
		}
	    
   	}
   	
   	if (e.getActionCommand() == "lensel") {
   	    
   		em = new LendModel((String)lenEv.p1.jtfAssetId.getSelectedItem(),null,null,null,null,null,null);
   		em.select();
		lenEv.p1.jcbEmpNo.setSelectedItem(em.getEmpNo());
		lenEv.p1.jtfUseDate.setText(em.getUseDate());
		lenEv.p1.jtfRetDate.setText(em.getRetDate());
		lenEv.p1.jtfIsReturn.setSelectedItem(em.getIsReturn());
		lenEv.p1.jtfLender.setText(em.getLender());
		lenEv.p1.jtfRemarks.setText(em.getRemarks());
   	}
   	if (e.getActionCommand() == "retsel") {
   	    
   		em = new LendModel((String)retEv.p1.jtfAssetId.getSelectedItem(),null,null,null,null,null,null);
   		em.select();
		retEv.p1.jcbEmpNo.setSelectedItem(em.getEmpNo());
		retEv.p1.jtfUseDate.setText(em.getUseDate());
		retEv.p1.jtfRetDate.setText(em.getRetDate());
		retEv.p1.jtfIsReturn.setSelectedItem(em.getIsReturn());
		retEv.p1.jtfLender.setText(em.getLender());
		retEv.p1.jtfRemarks.setText(em.getRemarks()); 
   	}
   }
}