代码备份

@SuppressWarnings("deprecation")
	@Override
	public boolean excelUserInfoToExcel(HttpServletRequest request,
			HttpServletResponse response) {
		// 文件名称
		String fileName = "用户信息";
		String tempPath = request.getRealPath("/");
		String className = "com.***.ExcelUser";
		// 表格名称
		String tableName = "用户信息";
		/**
		 * // 字段名称 String[] columns = new String[16]; columns[0] = "姓名";
		 * columns[1] = "所属软件用户组"; columns[2] = "所属岗位"; columns[3] = "登陆账号";
		 * columns[4] = "员工ID"; columns[5] = "手机号码1"; columns[6] = "手机号码2";
		 * columns[7] = "办公电话"; columns[8] = "家庭电话"; columns[9] = "办公地址";
		 * columns[10] = "家庭地址"; columns[11] = "紧急联系人"; columns[12] = "联系人电话";
		 * columns[13] = "工作Email"; columns[14] = "私人Email"; columns[15] = "备注";
		 * 
		 * // 字段类型 String[] types = new String[16]; types[0] = types[1] =
		 * types[2] = types[3] = types[4] = types[5] = types[6] = types[7] =
		 * types[8] = types[9] = types[10] = types[11] = types[12] = types[13] =
		 * types[14] = types[15] = "String"; // 数据 ArrayList<String[]> rows =
		 * new ArrayList<String[]>(); List<User> users =
		 * this.userDao.exportUsers(); for (User user:users) { String roleInfos
		 * = getGroupInfoByUser(user); String stationInfos =
		 * getStationInfoByUser(user); // 封装数据 String[] row = new String[16];
		 * row[0] = String.valueOf(user.getFullName()); row[1] =
		 * String.valueOf(roleInfos); row[2] = String.valueOf(stationInfos);
		 * row[3] = String.valueOf(user.getUsername()); row[4] =
		 * String.valueOf(user.getEmployeeId()); row[5] =
		 * String.valueOf(user.getMobilePhone1()); row[6] =
		 * String.valueOf(user.getMobilePhone2()); row[7] =
		 * String.valueOf(user.getOfficePhone()); row[8] =
		 * String.valueOf(user.getHomePhone()); if(user.getAddress()!=null){
		 * row[9] = String.valueOf(user.getAddress().getOfficeAddress());
		 * row[10] = String.valueOf(user.getAddress().getHomeAddress()); }else{
		 * row[9] = String.valueOf(""); row[10] = String.valueOf(""); } row[11]
		 * = String.valueOf(user.getEmergencyUsername()); row[12] =
		 * String.valueOf(user.getEmergencyPhone()); row[13] =
		 * String.valueOf(user.getOfficeEmail()); row[14] =
		 * String.valueOf(user.getPrivateEmail()); row[15] =
		 * String.valueOf(user.getDescription()); // 放入相关rows rows.add(row); }
		 */
		// 数据
		ArrayList<ExcelUser> rows = new ArrayList<ExcelUser>();
		List<User> users = this.userDao.exportUsers();
		for (User user : users) {
			ExcelUser excelUser = new ExcelUser();
			String roleInfos = getGroupInfoByUser(user);
			String stationInfos = getStationInfoByUser(user);
			excelUser.setFirstName(String.valueOf(user.getFullName()));
			excelUser.setRoleInfos(String.valueOf(roleInfos));
			excelUser.setStationInfos(String.valueOf(stationInfos));
			excelUser.setUsername(String.valueOf(user.getUsername()));
			excelUser.setEmployeeId(String.valueOf(user.getEmployeeId()));
			excelUser.setMobilePhone1(String.valueOf(user.getMobilePhone1()));
			excelUser.setMobilePhone2(String.valueOf(user.getMobilePhone2()));
			excelUser.setOfficePhone(String.valueOf(user.getOfficePhone()));
			excelUser.setHomePhone(String.valueOf(user.getHomePhone()));
			if (user.getAddress() != null) {
				excelUser.setOfficeAddress(String.valueOf(user.getAddress()
						.getOfficeAddress()));
				excelUser.setHomeAddress(String.valueOf(user.getAddress()
						.getHomeAddress()));
			} else {
				excelUser.setOfficeAddress(String.valueOf(""));
				excelUser.setHomeAddress(String.valueOf(""));
			}
			excelUser.setEmergencyUsername(String.valueOf(user
					.getEmergencyUsername()));
			excelUser
					.setEmergencyPhone(String.valueOf(user.getEmergencyPhone()));
			excelUser.setOfficeEmail(String.valueOf(user.getOfficeEmail()));
			excelUser.setPrivateEmail(String.valueOf(user.getPrivateEmail()));
			excelUser.setDescription(String.valueOf(user.getDescription()));
			// 放入相关rows
			rows.add(excelUser);
		}
		// 导出到excel
		try {
			// CommonExcel.getCommonExcel().exportExcel(fileName, tableName,
			// columns,types, rows, response, tempPath);
			boolean result = ExcelExport.createExcel(rows, className, tempPath,fileName, tableName);
			if (result) {
				return true;
			} else {
				return false;
			}
		} catch (Exception e) {
			e.printStackTrace();
			return false;
		}
	}