前言:
眼前朋友们对“csvjava”大致比较重视,各位老铁们都想要剖析一些“csvjava”的相关资讯。那么小编也在网络上搜集了一些关于“csvjava””的相关文章,希望我们能喜欢,我们快快来学习一下吧!poi框架 framework-poi
> 简单、好用且轻量级的海量excel,csv文件导入导出解决方案。解决火狐浏览器中文编码问题。
> 注:excel的合并功能及复杂功能,使用代码实现比较复杂,框架只提供单行的导入导出。
如何使用?
引入Maven依赖或下载jar包
<dependency> <groupId>com.github.fartherp</groupId> <artifactId>framework-poi</artifactId> <version>3.0.4</version> </dependency>
CSV常用例子:
CSVRead.read(CSVReadTest.class.getResourceAsStream("/a.csv"), new CSVReadDeal<CsvReadDto>() { // 单条数据处理(每一行对应一个javabean) public CsvReadDto dealBean(String[] arr) { CsvReadDto dto = new CsvReadDto(); dto.setId(Long.valueOf(arr[0])); dto.setName(arr[1]); dto.setAge(Integer.valueOf(arr[2])); return dto; } // 批量数据处理(可以批量入库) public void dealBatchBean(List<CsvReadDto> list) { Assert.assertEquals("name1";, list.get(0).getName()); Assert.assertEquals("name2", list.get(1).getName()); Assert.assertEquals("name3", list.get(2).getName()); } // 批量加载多少数据,统一处理(默认1000) public int getBatchCount() { return super.getBatchCount(); } // 从第几行开始加载(默认跳过第一行) public int skipLine() { return super.skipLine(); } });
2.CSV文件导出:
String filename = "TEST"; String[] title = SheetsTitlesEnum.USER_LOGIN_LOG.getTitle(); List<String[]> bodyList = new ArrayList<>(); CsvUtil.writeCsvFile(filename, title, bodyList);
3.浏览器下载CSV文件:
HttpServletResponse response = null; HttpServletRequest request = null; String filename = "TEST"; String[] title = SheetsTitlesEnum.USER_LOGIN_LOG.getTitle(); List<String[]> bodyList = new ArrayList<>(); CsvUtil.writeCsvFile(response, request, filename, title, bodyList);
Excel常用例子:
1.Excel文件导入:
ExcelRead.read(ExcelReadTest.class.getResourceAsStream("/a.xls"), new ExcelReadDeal<ExcelReadDto>() { // 单条数据处理(每一行对应一个javabean) public ExcelReadDto dealBean(Row row) { ExcelReadDto dto = new ExcelReadDto(); dto.setId(new BigDecimal(row.getCell(0).toString()).longValue()); dto.setName(row.getCell(1).toString()); dto.setAge(Integer.valueOf(row.getCell(2).toString())); return dto; } // 批量数据处理(可以批量入库) public void dealBatchBean(List<ExcelReadDto> list) { Assert.assertEquals("name1", list.get(0).getName()); Assert.assertEquals("name2", list.get(1).getName()); Assert.assertEquals("name3", list.get(2).getName()); } // 批量加载多少数据,统一处理(默认1000) public int getBatchCount() { return super.getBatchCount(); } // 从第几行开始加载(默认跳过第一行) public int skipLine() { return super.skipLine(); } });
2.Excel文件导出:
String[] title = new String [6]; title[0] = "登录时间"; title[1] = "用户名"; title[2] = "访问端"; title[3] = "版本系统"; title[4] = "登录IP"; title[5] = "状态"; String fileName = "D:\\style1.xls"; FileExcelWrite.<ExcelDto>build(title, fileName) .setLargeDataMode(false) .deal(obj -> { String[] result = new String[6]; result[0] = obj.getTime(); result[1] = obj.getName(); result[2] = obj.getClient(); result[3] = obj.getVersion(); result[4] = obj.getIp(); result[5] = obj.getStatus() + ""; return result; }) .list(ExcelWriteStyleTest.getList())// 默认情况下导出数据达到excel最大行,自动切换sheet,(xlsx=1048576,xls=65536) .list(ExcelWriteStyleTest.getList1()) .write();
3.Excel文件导出(风格,可以自定义风格):
Map<String, Object> map = new HashMap<>(); map.put("quoteCurrency", "ETH"); map.put("symbol", "USDT_ETH"); map.put("startTime", "2019-01-09 00:00:00"); map.put("endTime", "2019-01-09 12:00:00"); String fileName = "D:\\styleInputStream.xls"; FileExcelWrite.<ExcelDto>build(this.getClass().getResourceAsStream("/c.xls"), fileName) .additional(map) .deal(new WriteDeal<ExcelDto>() { public String[] dealBean(ExcelDto obj) { String[] result = new String[3]; result[0] = obj.getId() + ""; result[1] = obj.getName(); result[2] = obj.getAge() + ""; return result; } public int skipLine() { return 4; } }) .list(getList()) .write();
4.浏览器下载Excel文件:
String[] title = new String [6]; title[0] = "登录时间"; title[1] = "用户名"; title[2] = "访问端"; title[3] = "版本系统"; title[4] = "登录IP"; title[5] = "状态"; String fileName = "D:\\style1.xls"; HttpServletResponseExcelWrite.<ExcelDto>build(title, fileName, request, response) .setLargeDataMode(false) .deal(obj -> { String[] result = new String[6]; result[0] = obj.getTime(); result[1] = obj.getName(); result[2] = obj.getClient(); result[3] = obj.getVersion(); result[4] = obj.getIp(); result[5] = obj.getStatus() + ""; return result; }) .list(ExcelWriteStyleTest.getList())// 默认情况下导出数据达到excel最大行,自动切换sheet,(xlsx=1048576,xls=65536) .list(ExcelWriteStyleTest.getList1()) .write();
公告模块框架 framework-common
包括各种util,例如:日期DateUtil,BigDecimalUtil等等
压缩框架 framework-compress
提供各种压缩方式1.bzip22.gzip3.jar4.tar5.zip6.zlib7.shell命令(gzip,targz)
核心框架 framework-core
1.整合easyui分页功能2.验证码3.整合easyui树结构4.统一前端请求后的返回参数5.发送邮件,包括html邮件
db操作框架 framework-database
封装操作数据库的基本操作(增删改查)
异常体系框架 framework-exception
1.mysql数据库返回的错误信息,转成可识别信息2.oracle数据库返回的错误信息,转成可识别信息3.通用的异常返回的错误信息,转成可识别信息
文件处理框架 framework-file
1.ftp2.nfs
net框架 framework-net
1.ftp2.sftp
poi框架 framework-poi
1.csv读取及下载2.excel读取
加密解密框架 framework-security
1.不可逆:base64,MD52.对称密钥:AES,DES,3DES3.非对称密钥:RSA
framework-filter
1、支持切面过滤2、和spring环境集成 配置方式是: web.xml <filter> <filter-name>frameworkFilter</filter-name> <filter-class>org.springframework.web.filter.DelegatingFilterProxy</filter-class> <init-param> <param-name>targetFilterLifecycle</param-name> <param-value>true</param-value> </init-param> </filter> <filter-mapping> <filter-name>frameworkFilter</filter-name> <url-pattern>/*</url-pattern> </filter-mapping> spring 配置文件 <bean id="frameworkFilter" class="cn.vanskey.filter.web.FrameworkFilterFactoryBean"> <property name="filters"> //过滤器配置 <util:map> <entry key="myfilter"> <bean class="com.zrj.pay.cashier.action.demo.MyFilter"/> </entry> </util:map> </property> <property name="filterChainDefinitions"> <value> /** = myfilter //过滤器和路径的对应关系 </value> </property> </bean>关注后私信“FrameworkPoi”就会收到详细文档介绍,喜欢的关注下每天会推出更多技术精品。
标签: #csvjava #oraclecsv日期 #oracle怎么导入cvs文件 #csv怎么导入mysql报错 #oracle导出xml