Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

A method for parsing and storing excel content into a database based on the Spring MVC framework

A database and framework technology, applied in the database field, can solve problems such as easy parsing errors and large amount of code, and achieve the effects of clear code hierarchy, less code amount, and improved work efficiency

Inactive Publication Date: 2019-03-15
SICHUAN CHANGHONG ELECTRIC CO LTD
View PDF2 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] In view of the above problems, the present invention proposes a method based on the SpringMVC framework that excel content is parsed and stored in the database. The problem to be solved by the present invention is that the personnel who are currently engaged in JAVA WEB development need to complete the task of EXCEL content parsing and storage. Large and error-prone parsing problems

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • A method for parsing and storing excel content into a database based on the Spring MVC framework
  • A method for parsing and storing excel content into a database based on the Spring MVC framework
  • A method for parsing and storing excel content into a database based on the Spring MVC framework

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0022] In order to make the purpose, technical solution and advantages of the present invention clearer, the technical solution of the present invention will be described in detail below. Apparently, the described embodiments are only some of the embodiments of the present invention, but not all of them. Based on the embodiments of the present invention, all other implementations obtained by persons of ordinary skill in the art without making creative efforts fall within the protection scope of the present invention.

[0023] Such as figure 1 As shown, the method of parsing and storing excel content into the database based on the SpringMVC framework includes the following steps:

[0024] Step 1. Import the poi package. The full name of the POI package is Apache Poi, which is a free and open source cross-platform JAVA API written in JAVA. Apache POI provides APIs for Java programs to process Microsoft Office (Excel, WORD, PowerPoint, Visio, etc.) format files read and write f...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention discloses a method for parsing and storing excel content in a database based on a Spring MVC framework, Processing excel tables with poi packages, Compared to the traditional use of thejxl.jar package, The invention has fewer codes, and through the combination with Spring MVC, the logic is clearer, the code hierarchy is clearer, and errors are not easy to be made when the content isanalyzed. If the developer needs to complete similar functions in the working process, the method can greatly improve the working efficiency.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a method for parsing and storing excel content in a database based on a SpringMVC framework. Background technique [0002] The SpringMVC framework is one of the most commonly used frameworks in web development today, and excel is often used as a table in people's lives, such as various reports and lists. Therefore, in the web system, there is often a need to import an excel table and parse the content in the table and store it in the database. [0003] At present, the main implementation method for parsing and storing excel content in the database is to use the jxl.jar package, but the jxl.jar package does not provide a code implementation that can directly parse the excel content. Therefore, parsing and storing excel becomes A task that has a large amount of code and is easy to parse errors. For those engaged in JAVA WEB development, there is a simple and convenient method t...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
IPC IPC(8): G06F16/25
Inventor 刘俊林
Owner SICHUAN CHANGHONG ELECTRIC CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com