[Oracle] Database import and export

Oracle database import and export Article directory Oracle database import and export 1. expdp export 1. Log in as administrator 2. Delete previously tested users and corresponding data 3. Create a table space (source table–table to be exported) 4. Create a user and set the default table space and temporary table space for the user. […]

Get the content in Content-Disposition when exporting

import axios from ‘axios’ import { ElNotification, ElMessageBox, ElMessage, ElLoading } from ‘element-plus’ import { getToken } from ‘@/utils/auth’ import errorCode from ‘@/utils/errorCode’ import { tansParams, blobValidate } from ‘@/utils/ruoyi’ import cache from ‘@/plugins/cache’ import { saveAs } from ‘file-saver’ import useUserStore from ‘@/store/modules/user’ let downloadLoadingInstance // Whether to display re-login export let isRelogin = […]

thinkphp export excel

thinkphp export excel Use library: PHPOffice/PHPExcel GitHub – PHPOffice/PHPExcel: ARCHIVED The following is the core code: it can be changed according to specific needs. 1. Add the export method to the controller file use PhpOffice\PhpSpreadsheet\Helper\Sample; use PhpOffice\PhpSpreadsheet\IOFactory; use PhpOffice\PhpSpreadsheet\Spreadsheet; use PhpOffice\PhpSpreadsheet\Writer\Xlsx; use PhpOffice\PhpSpreadsheet\Cell\Coordinate; use PhpOffice\PhpSpreadsheet\Worksheet\PageSetup; use PhpOffice\PhpSpreadsheet\Cell\DataType; use PhpOffice\PhpSpreadsheet\Style\Fill; use PhpOffice\PhpSpreadsheet\Style\Color; use PhpOffice\PhpSpreadsheet\Style\Alignment; use PhpOffice\PhpSpreadsheet\Style\Border; […]

springboot export (POI)

POI official documents Introduce dependencies <!–POI–> <dependency> <groupId>org.apache.poi</groupId> <artifactId>poi</artifactId> <version>4.1.2</version> </dependency> <dependency> <groupId>org.apache.poi</groupId> <artifactId>poi-ooxml</artifactId> <version>4.1.2</version> </dependency> <dependency> <groupId>org.apache.poi</groupId> <artifactId>poi-ooxml-schemas</artifactId> <version>4.1.2</version> </dependency> Definition annotation We combine custom annotations to make exporting more convenient and concise and easier to expand. @ExcelField @Target(ElementType.FIELD) @Retention(RetentionPolicy.RUNTIME) public @interface ExcelField { /** *Field name */ String name() default “”; /** * […]

tp6.0+PhpSpreadsheet+Excel table import and export methods with pictures

use PhpOffice\PhpSpreadsheet\IOFactory; use PhpOffice\PhpSpreadsheet\cell\Coordinate; /** * Submit EXECL form with pictures to import data */ public function upload_field_excel_post() { $file_url = $this->request->param(‘file_url’); //File path if (!empty($file_url)) { $filePath = $_SERVER[‘DOCUMENT_ROOT’] . ‘/upload/’ . $file_url; //If the file exists if (file_exists($filePath)) { //Check whether the file exists $exts = pathinfo($filePath, PATHINFO_EXTENSION); //File type // There are […]

java compress folder and export ZIP tool class

package sol.edrms.v2.util; import lombok.extern.slf4j.Slf4j; import org.apache.commons.lang3.StringUtils; import javax.servlet.ServletOutputStream; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import java.io.*; import java.net.URLEncoder; import java.util.List; import java.util.zip.ZipEntry; import java.util.zip.ZipOutputStream; /** * @Author: * @Time: * @Description: */ @Slf4j public class FileUtil {<!– –> private static final int BUFFER_SIZE = 2 * 1024; /** * Compressed folder * * @param sourceFile The folder […]

SpringBoot export Html to Pdf

1. Project directory 2. pom.xml <!– html to pdf –> <dependency> <groupId>com.itextpdf</groupId> <artifactId>html2pdf</artifactId> <version>3.0.2</version> </dependency> <!– Chinese font support –> <dependency> <groupId>com.itextpdf</groupId> <artifactId>font-asian</artifactId> <version>7.1.13</version> </dependency> <!– Stream processing –> <dependency> <groupId>commons-io</groupId> <artifactId>commons-io</artifactId> <version>2.11.0</version> </dependency> <!– Read files in the resource directory –> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-web</artifactId> <version>2.6.3</version> </dependency> 3. Code TestService package com.cnbai.service; import com.cnbai.utils.HtmlToPdfUtils; import […]

Discussion on how winscope implements the export scheme design on the user version – Maxima android framework vehicle-mounted mobile phone system development

Background After Brother Ma explained how to use winscope to analyze various flash black, black screen and other problems, many students who bought the course began to use this tool for actual company projects, but many students began to find another problem, that is It was found that the relevant winscope could not be captured […]