public static boolean deleteDept(String depName)
	{

		ResultSet rs = null;
		Connection con = null;
		PreparedStatement ps = null;
		boolean result = true;
		try {
			String sql = "DELETE FROM department WHERE UPPER(deptName)=(?)";
			con = ConnectionPool.getConnectionFromPool();
			ps = con.prepareStatement(sql);
			ps.setString(1, depName.toUpperCase());
			ps.executeUpdate();
		} catch (Exception ex) {
			ex.printStackTrace();
		} finally {
			if (rs != null) {
				try {
					rs.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
			}
			if (ps != null) {
				try {
					ps.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
			}
			if (con != null) {
				try {
					ConnectionPool.addConnectionBackToPool(con);
				} catch (Exception e) {
					e.printStackTrace();
				}
			}
		}
		return result;

	}