Shulou(Shulou.com)06/02 Report--

This article mainly introduces the SpringBoot framework how to manage Xml and CSV file types, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let Xiaobian take you to understand.

1. Brief introduction of document types 1. XML documents

XML is an extensible markup language, which is used to tag electronic documents to make them structural. Tags refer to the information symbols that computers can understand, through which computers can process all kinds of information, such as data structures, formats, and so on. It can be used to mark data and define data types. It is a source language that allows users to define their own markup language. It is suitable for network transmission and provides a unified method to describe and exchange structured data of applications.

2. CSV documents

CSV documents, comma-separated document content values, whose files store structural data in plain text. An CSV file consists of any number of records, separated by some kind of newline character; each record consists of fields, and the delimiters between the fields are other characters or strings, the most common being commas. CSV is a general and relatively simple file format, which is usually used in the field of big data for large-scale data handling operations.

2. XML file management 1. Dom4j dependency

Dom4j is an API package for operating XML files based on Java, which is used to read and write XML files. It has the characteristics of excellent performance, powerful function and easy to use.

Dom4j dom4j 1.6.1 jaxen jaxen 1.1.62, based on API encapsulation method

It involves reading, loading, traversing, creating, modifying, deleting and other common methods of XML files.

Public class XmlUtil {/ * create document * / public static Document getDocument (String filename) {File xmlFile = new File (filename); Document document = null; if (xmlFile.exists ()) {try {SAXReader saxReader = new SAXReader (); document = saxReader.read (xmlFile) } catch (Exception e) {e.printStackTrace ();}} return document;} / * * traversal root node * / public static Document iteratorNode (String filename) {Document document = getDocument (filename); if (document! = null) {Element root = document.getRootElement () Iterator iterator = root.elementIterator (); while (iterator.hasNext ()) {Element element = (Element) iterator.next (); System.out.println (element.getName ());}} return document } / * create XML document * / public static void createXML (String filePath) throws Exception {/ / create Document object Document document = DocumentHelper.createDocument (); / / create a node. The first node defaults to the root node Element rootElement = document.addElement ("project"); Element parentElement = rootElement.addElement ("parent"); parentElement.addComment ("version description") Element groupIdElement = parentElement.addElement ("groupId"); Element artifactIdElement = parentElement.addElement ("artifactId"); Element versionElement = parentElement.addElement ("version"); groupIdElement.setText ("SpringBoot2"); artifactIdElement.setText ("spring-boot-starters"); versionElement.setText ("2.1.3.RELEASE"); / / set the output code OutputFormat format = OutputFormat.createPrettyPrint () File xmlFile = new File (filePath); format.setEncoding ("UTF-8"); XMLWriter writer = new XMLWriter (new FileOutputStream (xmlFile), format); writer.write (document); writer.close ();} / * Update node * / public static void updateXML (String filePath) throws Exception {Document document = getDocument (filePath) If (document! = null) {/ / modify the specified node List elementList = document.selectNodes ("/ project/parent/groupId"); Iterator iterator = elementList.iterator (); while (iterator.hasNext ()) {Element element = (Element) iterator.next (); element.setText ("spring-boot-2") } / / set the output code OutputFormat format = OutputFormat.createPrettyPrint (); File xmlFile = new File (filePath); format.setEncoding ("UTF-8"); XMLWriter writer = new XMLWriter (new FileOutputStream (xmlFile), format); writer.write (document); writer.close () }} / * Delete node * / public static void removeElement (String filePath) throws Exception {Document document = getDocument (filePath); if (document! = null) {/ / modify the specified node List elementList = document.selectNodes ("/ project/parent"); Iterator iterator = elementList.iterator () While (iterator.hasNext ()) {Element parentElement = (Element) iterator.next (); Iterator parentIterator = parentElement.elementIterator (); while (parentIterator.hasNext ()) {Element childElement = (Element) parentIterator.next () If (childElement.getName (). Equals ("version")) {parentElement.remove (childElement);} / / sets the output code OutputFormat format = OutputFormat.createPrettyPrint (); File xmlFile = new File (filePath) Format.setEncoding ("UTF-8"); XMLWriter writer = new XMLWriter (new FileOutputStream (xmlFile), format); writer.write (document); writer.close ();}} public static void main (String [] args) throws Exception {String filePath = "F:\ file-type\\ project-cf.xml" / / 1. Create document Document document = getDocument (filePath); System.out.println (document.getRootElement (). GetName ()); / / 2, root node traversal iteratorNode (filePath); / / 3, create XML file String newFile = "F:\ file-type\\ project-cf-new.xml"; createXML (newFile) / / 4. Update XML file updateXML (newFile); / / 5, delete node removeElement (newFile);}} 3, execute effect diagram

3. CSV file management 1. CSV file style

You don't need to rely on a specific Jar package here, just read it as a normal file.

2. File reading @ Async@Overridepublic void readNotify (String path, Integer columnSize) throws Exception {File file = new File (path); String fileName = file.getName (); int lineNum = 0; if (fileName.startsWith ("data-")) {InputStreamReader isr = new InputStreamReader (new FileInputStream (file), "GBK"); BufferedReader reader = new BufferedReader (isr); List dataInfoList = new ArrayList (4); String line While ((line = reader.readLine ())! = null) {lineNum + +; String [] dataArray = line.split (","); if (dataArray.length = = columnSize) {String cityName = new String (dataArray [1] .getBytes (), "UTF-8") DataInfoList.add (new DataInfo (Integer.parseInt (dataArray [0]), cityName,dataArray [2]));} if (dataInfoList.size () > = 4) {LOGGER.info ("Container data:" + dataInfoList); dataInfoList.clear () } if (dataInfoList.size () > 0) {LOGGER.info ("Last data:" + dataInfoList);} reader.close ();} LOGGER.info ("number of read data bars:" + lineNum);} 3. File creation @ Async@Overridepublic void createCsv (List dataList,String path) throws Exception {File file = new File (path); boolean createFile = false If (file.exists ()) {boolean deleteFile = file.delete (); LOGGER.info ("deleteFile:" + deleteFile);} createFile = file.createNewFile (); OutputStreamWriter ost = new OutputStreamWriter (new FileOutputStream (path), "UTF-8"); BufferedWriter out = new BufferedWriter (ost) If (createFile) {for (String line:dataList) {if (! StringUtils.isEmpty (line)) {out.write (line); out.newLine ();} out.close ();} 4. Write the test interface

This is based on the Swagger2 management interface test.

@ Api ("Csv Interface Management") @ RestControllerpublic class CsvWeb {@ Resource private CsvService csvService; @ ApiOperation (value= "File Reading") @ GetMapping ("/ csv/readNotify") public String readNotify (@ RequestParam ("path") String path, @ RequestParam ("column") Integer columnSize) throws Exception {csvService.readNotify (path,columnSize); return "success" } @ ApiOperation (value= "create File") @ GetMapping ("/ csv/createCsv") public String createCsv (@ RequestParam ("path") String path) throws Exception {List dataList = new ArrayList (); dataList.add ("1, Beijing, beijing"); dataList.add ("2, Shanghai, shanghai"); dataList.add ("3, Suzhou, suzhou"); csvService.createCsv (dataList,path) Return "success";}} Thank you for reading this article carefully. I hope the article "how the SpringBoot Framework manages Xml and CSV file types" shared by the editor will be helpful to you. At the same time, I hope you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.