The invention relates to the technical field of
software development, and particularly provides an optimization method and device for realizing multi-table parallel query, based on a
java multi-thread technology, the method comprises the following steps: S1, providing a multi-thread class DataCallable, the multi-thread class realizes an interface class Callable owned by
java, and developers can transmit own
business data classes; s2, a
paging condition class OffsetPageDomain is provided and used for storing
paging conditions of a DataCallable class, and the
paging conditions comprise a start index and the number of pieces of query data; s3, an overall
process control class MultipleTable Query Service is provided, the overall
process control class is a calling entry, developers can transmit own
business data classes, the MultipleTable Query Service class provides a method start, the developers write codes to call the codes, and the start method transmits parameters of a
java class
list, page numbers and the number of pieces of each page. Compared with the prior art, the development
workload can be reduced, and the efficiency is improved.