mybatis flex

영어 | 简体中文

MyBatis-Flex는 우아한 Mybatis Enhancement Framework입니다.

특징

1. MyBatis-Flex는 매우 가볍고 Mybatis에만 의존하며 다른 타사 종속성은 없습니다.
2. 기본 CRUD 연산자 및 Entity 클래스의 페이징 쿼리
3. 행 매핑 지원으로 엔터티 클래스 없이 데이터베이스를 추가, 삭제, 수정 및 쿼리할 수 있습니다.
4. 여러 데이터베이스를 지원하고 방언을 통해 유연하게 확장
5. 결합된 기본 키와 다양한 기본 키 콘텐츠 생성 전략 지원
6. 매우 친숙한 SQL 쿼리, IDE가 자동으로 메시지를 표시하므로 실수에 대한 걱정이 없습니다.
7. 더 작은 놀라움

안녕하세요 세상(봄 없이)

1단계: 엔터티 클래스 작성

 @ Table ( "tb_account" )
public class Account {

    @ Id ( keyType = KeyType . Auto )
    private Long id ;
    private String userName ;
    private Date birthday ;
    private int sex ;

    // getter setter
}

2단계: 매퍼 클래스 작성(BaseMapper 확장이 필요함)

 public interface AccountMapper extends BaseMapper < Account > {
    // only Mapper interface define
}

3단계: 데이터 쿼리 시작

예 1: 기본 키로 쿼리

 class HelloWorld {
    public static void main ( String ... args ) {

        HikariDataSource dataSource = new HikariDataSource ();
        dataSource . setJdbcUrl ( "jdbc:mysql://127.0.0.1:3306/mybatis-flex" );
        dataSource . setUsername ( "username" );
        dataSource . setPassword ( "password" );

        MybatisFlexBootstrap . getInstance ()
                . setDataSource ( dataSource )
                . addMapper ( AccountMapper . class )
                . start ();

        AccountMapper mapper = MybatisFlexBootstrap . getInstance ()
                . getMapper ( AccountMapper . class );


        // id = 100
        Account account = mapper . selectOneById ( 100 );
    }
}

예2: 쿼리 목록

 // use QueryWrapper to build query conditions
QueryWrapper query = QueryWrapper . create ()
        . select ()
        . from ( ACCOUNT )
        . where ( ACCOUNT . ID . ge ( 100 ))
        . and ( ACCOUNT . USER_NAME . like ( "zhang" ). or ( ACCOUNT . USER_NAME . like ( "li" )));

// execute SQL：
// SELECT * FROM tb_account
// WHERE tb_account.id >=  100
// AND (tb_account.user_name LIKE '%zhang%' OR tb_account.user_name LIKE '%li%' )
List < Account > accounts = mapper . selectListByQuery ( query );

예3: 페이징 쿼리

 // use QueryWrapper to build query conditions
QueryWrapper query = QueryWrapper . create ()
        . select ()
        . from ( ACCOUNT )
        . where ( ACCOUNT . ID . ge ( 100 ))
        . and ( ACCOUNT . USER_NAME . like ( "zhang" ). or ( ACCOUNT . USER_NAME . like ( "li" )))
        . orderBy ( ACCOUNT . ID . desc ());

// execute SQL：
// SELECT * FROM tb_account
// WHERE tb_account.id >=  100
// AND (tb_account.user_name LIKE '%zhang%' OR tb_account.user_name LIKE '%li%' )
// ORDER BY tb_account.id DESC
// LIMIT 40,10
Page < Account > accountPage = mapper . paginate ( 5 , 10 , query );

QueryWrapper 샘플

선택하다 *

 QueryWrapper query = new QueryWrapper ();
query . select (). from ( ACCOUNT )

// SQL:
// SELECT * FROM tb_account

열 선택

 QueryWrapper query = new QueryWrapper ();
query . select ( ACCOUNT . ID , ACCOUNT . USER_NAME ). from ( ACCOUNT )

// SQL:
// SELECT tb_account.id, tb_account.user_name
// FROM tb_account 

 QueryWrapper query = new QueryWrapper ()
    . select ( ACCOUNT . ID
        , ACCOUNT . USER_NAME
        , ARTICLE . ID . as ( "articleId" )
        , ARTICLE . TITLE )
    . from ( ACCOUNT . as ( "a" ), ARTICLE . as ( "b" ))
    . where ( ACCOUNT . ID . eq ( ARTICLE . ACCOUNT_ID ));

// SQL:
// SELECT a.id, a.user_name, b.id AS articleId, b.title
// FROM tb_account AS a, tb_article AS b
// WHERE a.id = b.account_id

기능 선택

 QueryWrapper query = new QueryWrapper ()
        . select (
            ACCOUNT . ID ,
            ACCOUNT . USER_NAME ,
            max ( ACCOUNT . BIRTHDAY ),
            avg ( ACCOUNT . SEX ). as ( "sex_avg" )
        ). from ( ACCOUNT );

// SQL:
// SELECT tb_account.id, tb_account.user_name,
// MAX(tb_account.birthday),
// AVG(tb_account.sex) AS sex_avg
// FROM tb_account

어디

 QueryWrapper queryWrapper = QueryWrapper . create ()
    . select ()
    . from ( ACCOUNT )
    . where ( ACCOUNT . ID . ge ( 100 ))
    . and ( ACCOUNT . USER_NAME . like ( "michael" ));

// SQL:
// SELECT * FROM tb_account
// WHERE tb_account.id >=  ?
// AND tb_account.user_name LIKE  ?

존재한다, 존재하지 않는다

 QueryWrapper queryWrapper = QueryWrapper . create ()
    . select ()
    . from ( ACCOUNT )
    . where ( ACCOUNT . ID . ge ( 100 ))
    . and (
        exists (
            selectOne (). from ( ARTICLE ). where ( ARTICLE . ID . ge ( 100 ))
        )
    );

// SQL:
// SELECT * FROM tb_account
// WHERE tb_account.id >=  ?
// AND EXIST (
//  SELECT 1 FROM tb_article WHERE tb_article.id >=  ?
// )

그리고 (...) 또는 (...)

 QueryWrapper queryWrapper = QueryWrapper . create ()
    . select ()
    . from ( ACCOUNT )
    . where ( ACCOUNT . ID . ge ( 100 ))
    . and ( ACCOUNT . SEX . eq ( 1 ). or ( ACCOUNT . SEX . eq ( 2 )))
    . or ( ACCOUNT . AGE . in ( 18 , 19 , 20 ). or ( ACCOUNT . USER_NAME . like ( "michael" )));

// SQL:
// SELECT * FROM tb_account
// WHERE tb_account.id >=  ?
// AND (tb_account.sex =  ?  OR tb_account.sex =  ? )
// OR (tb_account.age IN (?,?,?) OR tb_account.user_name LIKE  ? )

그룹화 기준

 QueryWrapper queryWrapper = QueryWrapper . create ()
    . select ()
    . from ( ACCOUNT )
    . groupBy ( ACCOUNT . USER_NAME );

// SQL:
// SELECT * FROM tb_account
// GROUP BY tb_account.user_name

데

 QueryWrapper queryWrapper = QueryWrapper . create ()
    . select ()
    . from ( ACCOUNT )
    . groupBy ( ACCOUNT . USER_NAME )
    . having ( ACCOUNT . AGE . between ( 18 , 25 ));

// SQL:
// SELECT * FROM tb_account
// GROUP BY tb_account.user_name
// HAVING tb_account.age BETWEEN  ? AND ?

주문 기준

 QueryWrapper queryWrapper = QueryWrapper . create ()
        . select ()
        . from ( ACCOUNT )
        . orderBy ( ACCOUNT . AGE . asc (), ACCOUNT . USER_NAME . desc (). nullsLast ());

// SQL:
// SELECT * FROM tb_account
// ORDER BY age ASC, user_name DESC NULLS LAST

가입하다

 QueryWrapper queryWrapper = QueryWrapper . create ()
    . select ()
    . from ( ACCOUNT )
    . leftJoin ( ARTICLE ). on ( ACCOUNT . ID . eq ( ARTICLE . ACCOUNT_ID ))
    . where ( ACCOUNT . AGE . ge ( 10 ));

// SQL:
// SELECT * FROM tb_account
// LEFT JOIN tb_article
// ON tb_account.id = tb_article.account_id
// WHERE tb_account.age >=  ?

한계... 오프셋

 QueryWrapper queryWrapper = QueryWrapper . create ()
    . select ()
    . from ( ACCOUNT )
    . orderBy ( ACCOUNT . ID . desc ())
    . limit ( 10 )
    . offset ( 20 );

// MySql:
// SELECT * FROM `tb_account` ORDER BY `id` DESC LIMIT 20, 10

// PostgreSQL:
// SELECT * FROM "tb_account" ORDER BY "id" DESC LIMIT 20 OFFSET 10

// Informix:
// SELECT SKIP 20 FIRST 10 * FROM "tb_account" ORDER BY "id" DESC

// Oracle:
// SELECT * FROM (SELECT TEMP_DATAS.*,
//  ROWNUM RN FROM (
//          SELECT * FROM "tb_account" ORDER BY "id" DESC)
//      TEMP_DATAS WHERE  ROWNUM <=30)
//  WHERE RN >20

// Db2:
// SELECT * FROM "tb_account" ORDER BY "id" DESC
// OFFSET 20 ROWS FETCH NEXT 10 ROWS ONLY

// Sybase:
// SELECT TOP 10 START AT 21 * FROM "tb_account" ORDER BY "id" DESC

// Firebird:
// SELECT * FROM "tb_account" ORDER BY "id" DESC ROWS 20 TO 30

질문?

1. Account.java로 QueryWrapper에 대한 "ACCOUNT" 클래스를 생성하는 방법은 무엇입니까?

IDE로 프로젝트를 빌드하거나 maven 빌드 명령을 실행합니다: mvn clean package

더 많은 샘플

1. Mybatis-Flex 전용(네이티브)
2. 스프링이 포함된 Mybatis-Flex
3. 스프링 부트가 포함된 Mybatis-Flex

위챗 그룹