bean searcher Download - bean searcher Source code download

bean searcher

JAVA source code

v4.3.5

Download

logo

English | 中文

Documentation：https://bs.zhxu.cn
阿里云最低 1 折：https://www.aliyun.com/minisite/goods?userCode=zugtbi5w
JueJin blogs：
- Writing code like this is 100 times more efficient than using MyBatis directly!
- What's the difference between Bean Searcher and MyBatis Plus?
Only one line of code to achieve:
- Retrieval from multi tables
- Pagination by any field
- Combined filter by any field
- Sorting by any field
- Summaries with multi field
- Return VO directly
Design thinking: Bean Searcher's thinking
Architecture:

Change log：CHANGELOG
Performance：see the report
Gitee 企业版：https://gitee.com/enterprises?invite_code=Z2l0ZWUtMTM5MzQxMg%3D%3D

Features

Support one entity mapping to multi tables
Support dynamic field operator
Support group and aggregation query
Support Select | Where | From subquery
Support embedded params in entity
Support field converters
Support sql interceptors
Support sql dialect extension
Support multi datasource and dynamic datasource
Support annotation omitting and customizing
Support field operator extension
and so on

⁉️WHY

This is not a repeating wheel

Although CREATE/UPDATE/DELETE are the strengths of Hibernate, MyBatis, DataJDBC and other ORM, queries, especially complex list queries with multi conditions, multi tables, paging, sorting, have always been their weaknesses.

Traditional ORM is difficult to realize a complex list retrieval with less code, but Bean Searcher has made great efforts in this regard. These complex queries can be solved in almost one line of code.

For example, such a typical requirement：

The back-end needs to write a retrieval API, and if it is written with traditional ORM, the complexity of the code is very high

But Bean Searcher can：

? Achieved with one line of code

First, you have an Entity class:

@SearchBean(tables="user u, role r", joinCond="u.role_id = r.id", autoMapTo="u")
public class User {
  private long id;
  private String username;
  private int status;
  private int age;
  private String gender;
  private Date joinDate;
  private int roleId;
  @DbField("r.name")
  private String roleName;
  // Getters and setters...
}

Then you can complete the API with one line of code :

@RestController
@RequestMapping("/user")
public class UserController {

    @Autowired
    private BeanSearcher beanSearcher;              // Inject BeanSearcher

    @GetMapping("/index")
    public SearchResult<User> index(HttpServletRequest request) {
        // Only one line of code written here
        return beanSearcher.search(User.class, MapUtils.flat(request.getParameterMap()), new String[]{ "age" });
    }

}

This line of code can achieve：

Retrieval from multi tables
Pagination by any field
Combined filter by any field
Sorting by any field
Summary with age field

For example, this API can be requested as follows:

GET: /user/index

Retrieving by default pagination:

{
  "dataList": [
    {
      "id": 1,
      "username": "Jack",
      "status": 1,
      "age": 25,
      "gender": "Male",
      "joinDate": "2021-10-01",
      "roleId": 1,
      "roleName": "User"
    },
    ...     // 15 records default
  ],
  "totalCount": 100,
  "summaries": [
    2500    // age statistics
  ]
}

GET: /user/index? page=1 & size=10

Retrieval by specified pagination
GET: /user/index? status=1

Retrieval with status = 1 by default pagination
GET: /user/index? name=Jac & name-op=sw

Retrieval with name starting with Jac by default pagination
GET: /user/index? name=Jack & name-ic=true

Retrieval with name = Jack(case ignored) by default pagination
GET: /user/index? sort=age & order=desc

Retrieval sorting by age descending and by default pagination

GET: /user/index? onlySelect=username,age

Retrieval username,age only by default pagination:

{
  "dataList": [
    {
      "username": "Jack",
      "age": 25,
    },
    ...     // 15 records default
  ],
  "totalCount": 100,
  "summaries": [
    2500    // age statistics
  ]
}

GET: /user/index? selectExclude=joinDate

Retrieving joinDate excluded default pagination

Parameter builder

Map<String, Object> params = MapUtils.builder()
        .selectExclude(User::getJoinDate)                 // Exclude joinDate field
        .field(User::getStatus, 1)                        // Filter：status = 1
        .field(User::getName, "Jack").ic()                // Filter：name = 'Jack' (case ignored)
        .field(User::getAge, 20, 30).op(Opetator.Between) // Filter：age between 20 and 30
        .orderBy(User::getAge, "asc")                     // Sorting by age ascending 
        .page(0, 15)                                      // Pagination: page=0 and size=15
        .build();
List<User> users = beanSearcher.searchList(User.class, params);

Demos：

v4.x - demos
v3.x - demos

Rapid development

Using Bean Searcher can greatly save the development time of the complex list retrieval apis!

An ordinary complex list query requires only one line of code
Retrieval from single table can reuse the original domain, without defining new Entity

? Easy integration

Bean Searcher can work with any JavaWeb frameworks, such as: SpringBoot, SpringMVC, Grails, Jfinal and so on.

SpringBoot / Grails

All you need is to add a dependence:

implementation 'cn.zhxu:bean-searcher-boot-stater:4.3.4'

and then you can inject Searcher into a Controller or Service:

/**
 * Inject a MapSearcher, which retrieved data is Map objects
 */
@Autowired
private MapSearcher mapSearcher;

/**
 * Inject a BeanSearcher, which retrieved data is generic objects
 */
@Autowired
private BeanSearcher beanSearcher;

Solon Project

All you need is to add a dependence:

implementation 'cn.zhxu:bean-searcher-solon-plugin:4.3.4'

and then you can inject Searcher into a Controller or Service:

/**
 * Inject a MapSearcher, which retrieved data is Map objects
 */
@Inject
private MapSearcher mapSearcher;

/**
 * Inject a BeanSearcher, which retrieved data is generic objects
 */
@Inject
private BeanSearcher beanSearcher;

Other frameworks

Adding this dependence:

implementation 'cn.zhxu:bean-searcher:4.3.4'

then you can build a Searcher with SearcherBuilder:

DataSource dataSource = ...     // Get the dataSource of the application

// DefaultSqlExecutor suports multi datasources
SqlExecutor sqlExecutor = new DefaultSqlExecutor(dataSource);

// build a MapSearcher
MapSearcher mapSearcher = SearcherBuilder.mapSearcher()
        .sqlExecutor(sqlExecutor)
        .build();

// build a BeanSearcher
BeanSearcher beanSearcher = SearcherBuilder.beanSearcher()
        .sqlExecutor(sqlExecutor)
        .build();