How the Collector handles class text data calculations

Json

Java has enough class libraries to parse and generate JSON, but lacks subsequent computing power. The collector supports multilayer structure data and can parse the JSON into a computable memory data table without losing information for further processing.

JSON data is available in the following format:

{

"Order": [

{

"Client": "Beijing Run Dry Software",

"Date": "2015-6-23",

"Item": [

｛

"Product": "HP Notebook",

"Number": 4,

"Price": 3200

},

{

"Product": "Dell Server",

"Number": 1,

"Price": 22100

}]

},...]

}

To write to the order table in the database, the structure is: orderid,client,date; and OrderDetail table, the structure is: orderid,seq,product,number,price orderdetail table, OrderID and SEQ are generated sequentially.

	A
1	=file ("Data.json"). read () [email protected] (). Order
2	=a1.new (#:orderid,client,date)
3	=a1.news (item; A1.#:orderid,#:seq,product,number,price)
4	>[email protected] (A2,order)
5	>[email protected] (A3,ordedetail)

The collector parses a multilayer JSON string into a multi-tiered dataset, and the A2 item field is a table.

In addition to parsing, you can use the collector to generate multilayer JSON strings from a multi-tier dataset.

Excel

Excel is equivalent to already structured text. Java has an open source class library (such as a POI) capable of parsing XLS, which is powerful but too low-level and highly complex to develop. The collector encapsulates the POI, which can be read into the XLS into a two-dimensional data table for further operation.

The contents of Range.xls and Position.xls are as follows:

Range.xls				Position.xls
Range	Start	Stop		Point	Position
Range1	4561	6321		Point1	5213
Range2	9842	11253		Point2	10254
...				...

To position for each line of Position.xls, find start/stop to overwrite it in Range.xls, and then add the contents of the corresponding row in Range.xls to Posistion.xls.

	A
1	=file ("Range.xls") [email protected] ()
2	=file ("Position.xls") [email protected] ()
3	=a2.derive ([email protected] (position>=start&&position<=stop)). Range:range, T.start:start,t.stop:stop)
4	=file ("Result.xls"). Exportxls (A3)

When the collector is read into XLS, it can take advantage of existing computing power. VBA with Excel can only be hard-coded to implement join, very cumbersome, and sometimes have to import the database to do.

How the Collector handles class text data calculations