CN105550261A - IBATIS-based quick search method - Google Patents

Abstract

The invention relates to the field of JAVA technology development, and particularly relates to an IBATIS-based quick search method. The IBATIS-based quick search method comprises the following steps: at first, establishing an object corresponding to a table, and querying corresponding data in a joint query mode; returning a result in a ResultMap mode; and establishing a corresponding relation of a return value and the object through the ResultMap, and classified packaging the results through groupBy attribute, wherein the query and package of one-to-many service are realized by one query sentence. By optimizing the query structure and the return value structure of ibatis, the problem of low query efficiency is solved; and the IBATIS-based quick search method can be applied to IBATIS-based quick search.

Description

A kind of method for quickly retrieving based on IBATIS

Technical field

The present invention relates to JAVA Technical Development Area, be specifically related to a kind of method for quickly retrieving based on IBATIS.

Background technology

At present, in the R&D process of JAVA, IBATIS is the conventional framework of persistent layer.IBATIS provides comparatively complete method for packing, and based on the automatic SQL statement of XML, conveniently can meet miscellaneous service demand and cross-platform demand.But when using the service inquiry of IBATIS process one-to-many, usually there will be N+1 problem.If namely inquire about a teacher, and inquire about this teacher with student time, first IBATIS can inquire about qualified teacher by a SQL statement, recycle teacher list, inquire about respectively this teacher with student.If there are 8 teachers, then need inquiry 9 times.To greatly reduce the performance of platform like this, even cannot meet the high concurrent demand of platform.

Summary of the invention

The technical matters that the present invention solves is to provide a kind of method for quickly retrieving based on IBATIS, to solve N+1 problem.

The technical scheme that the present invention solves the problems of the technologies described above is:

First set up the object corresponding with table, and inquire about corresponding data by the mode of conjunctive query; And result set is returned by the mode of ResultMap; ResultMap completes the corresponding relation of rreturn value and object, and realizes point class wrapper to result by groupBy attribute; Realize by a query statement, to a pair multiple services inquiry and encapsulation.

Described method comprises the steps:

1st step, set up object A, and comprise main attribute, comprising the id attribute of key;

2nd step, set up object B, comprise its all properties; Wherein in B, set up the List collection object of A;

3rd step, establish the table Tb corresponding with B, and determine that attribute id is major key;

4th step, establish the table Ta corresponding with A, the attribute tbid attribute that foundation is associated with the id of Tb in table;

5th step, in IBATIS property file, set up the rreturn value result of ResultMap type, wherein determined the corresponding relation of rreturn value and object A, B by property;

6th step, in result rreturn value, by the classified statistic method of groupBy attribute determination data, wherein groupBy=id;

7th step, correlation inquiry table Ta and Tb, and by Tb.id=Ta.tb_id correlation inquiry, and use result to return results.

The invention has the beneficial effects as follows: by this inquiry and method for packing, inquiry and the encapsulation of data can be realized by a SQL statement, will the I/O operation of system be greatly reduced like this, improve the execution efficiency of platform; And this mode, configuration is very succinct, can complete corresponding corresponding relation by XML, reduces code compilation work, reduces corresponding risk.

Accompanying drawing explanation

Below in conjunction with accompanying drawing, the present invention is further described:

Fig. 1 is process flow diagram of the present invention.

Embodiment

Lower mask body, to educate cloud shared platform, explains the detailed process of this invention in detail.

Education cloud is shared and be there is the information such as teacher, section's group, and wherein each education belongs to some sections group, below by way of the education under inquiry all sections group and section's group.

As shown in Figure 1; Comprise the steps:

1st step, set up object Teacher, comprising id, name attribute;

2nd step, set up object Subject, comprising id, name and set List attribute;

3rd step, establishment table t_subject, comprising id and name field;

4th step, foundation table t_teacher, comprising id, name, subject_id attribute;

5th step, in IBATIS property file, set up the rreturn value result of ResultMap type, groupBy=id really; And determine that data add the incidence relation of rreturn value and object

6th step, to be shown by collection query t_subject and t_teacher, and rreturn value is returned as result.

Claims (2)

1. based on a method for quickly retrieving of IBATIS, it is characterized in that: first set up the object corresponding with table, and inquire about corresponding data by the mode of conjunctive query; And result set is returned by the mode of ResultMap; ResultMap completes the corresponding relation of rreturn value and object, and realizes point class wrapper to result by groupBy attribute; Realize by a query statement, to a pair multiple services inquiry and encapsulation.

2. according to claim 1 based on IBATIS method for quickly retrieving, it is characterized in that: described method comprises the steps:

1st step, set up object A, and comprise main attribute, comprising the id attribute of key;

2nd step, set up object B, comprise its all properties; Wherein in B, set up the List collection object of A;

3rd step, establish the table Tb corresponding with B, and determine that attribute id is major key;

4th step, establish the table Ta corresponding with A, the attribute tb_id attribute that foundation is associated with the id of Tb in table;

5th step, in IBATIS property file, set up the rreturn value result of ResultMap type, wherein determined the corresponding relation of rreturn value and object A, B by property;

6th step, in result rreturn value, by the classified statistic method of groupBy attribute determination data, wherein groupBy=id;

7th step, correlation inquiry table Ta and Tb, and by Tb.id=Ta.tb_id correlation inquiry, and use result to return results.