Excel导入

最新推荐文章于 2022-10-26 09:21:15 发布

不秃能强吗？

最新推荐文章于 2022-10-26 09:21:15 发布

阅读量71

点赞数

文章标签： servlet java apache

本文链接：https://blog.csdn.net/liuwu2121/article/details/125977993

版权

package cn.linkey.rulelib.BPM08U002;

import java.util.*;
import cn.linkey.dao.*;
import cn.linkey.util.*;
import cn.linkey.doc.*;
import cn.linkey.factory.*;
import cn.linkey.wf.*;
import cn.linkey.rule.LinkeyRule;
import cn.linkey.org.LinkeyUser;
import java.math.BigDecimal;
import java.sql.SQLException;
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.Statement;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.DriverManager;
import org.apache.commons.fileupload.FileItem;
import org.apache.commons.fileupload.disk.DiskFileItemFactory;
import org.apache.commons.fileupload.servlet.ServletFileUpload;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.xssf.usermodel.XSSFCellStyle;
import org.apache.poi.ss.usermodel.CellValue;
import java.text.SimpleDateFormat;
import org.apache.poi.ss.usermodel.DateUtil;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;

import com.alibaba.fastjson.*;
import cn.linkey.app.AppUtil;
import java.sql.ResultSet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.PrintWriter;
import java.util.regex.Matcher;
import java.util.regex.Pattern;
/**
* @RuleName:批量创建维护信息导入规则
* @author admin
* @version: 8.0
* @Created: 2022-05-25 11:03:59
*/
final public class R_BPM08U002_P008 implements LinkeyRule {

   @Override
   public String run(HashMap<String, Object> params) throws Exception {

   String v=BeanCtx.g("WF_DocUnid");
   String CJZ= BeanCtx.getUserName();
   SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss:SSS");
String now3 = df.format(System.currentTimeMillis());

   String sqlsc="delete from BPM08U002_010";
   Rdb.execSql(sqlsc);
   HttpServletRequest request = BeanCtx.getRequest();
DiskFileItemFactory factory = new DiskFileItemFactory();
factory.setSizeThreshold(1024 * 1024 * 10);// 内存存储的最大值
ServletFileUpload upload = new ServletFileUpload(factory);
upload.setSizeMax(1024 * 1024 * 10);//设置文件上传大小
HttpServletResponse response = BeanCtx.getResponse();
response.setContentType("text/html");
PrintWriter out = response.getWriter();