1 В избранное 0 Ответвления 0

OSCHINA-MIRROR/xsxgit-mybatis-sql-spring-boot-starter

Клонировать/Скачать
Внести вклад в разработку кода
Синхронизировать код
Отмена
Подсказка: Поскольку Git не поддерживает пустые директории, создание директории приведёт к созданию пустого файла .keep.
Loading...
README.md

mybatis-sql-spring-boot-starter

star

Описание

Полноценный плагин для работы с SQL в Mybatis

Текущая версия

1.0.1 (отправлена в центральный репозиторий)

Инструкция по установке

mvn clean install

Инструкция по использованию

1. Подготовительные работы

  1. Добавление зависимости:
<dependency>
    <groupId>wiki.xsx</groupId>
    <artifactId>mybatis-sql-spring-boot-starter</artifactId>
    <version>1.0.1</version>
</dependency>
  1. Включение логирования:

в yml формате:

logging:
  level:
    wiki.xsx.core: debug

в properties формате:

logging.level.wiki.xsx.core=debug
``````properties
logging.level.wiki.xsx.core=debug

2. Демонстрация результатов (сравнение с исходным SQL запросом в MyBatis)

2020-11-05 00:00:22.018  INFO 6596 --- [           main] wiki.xsx.learn.LearnApplication          : ======================вставка======================
2020-11-05 00:00:22.182 DEBUG 6596 --- [           main] w.x.core.mybatis.MybatisSqlInterceptor    : ==>      MySQL: INSERT INTO test ( id, name, age, birthday, create_time ) VALUES( null, '张三', 30, '1990-01-01', '2020-11-05 00:00:22' ) 
2020-11-05 00:00:22.184 DEBUG 6596 --- [           main] wiki.xsx.learn.TestDao.insert            : ==>  Preparing: INSERT INTO test ( id, name, age, birthday, create_time ) VALUES( ?, ?, ?, ?, ? ) 
2020-11-05 00:00:22.227 DEBUG 6596 --- [           main] wiki.xsx.learn.TestDao.insert            : ==> Parameters: null, 张三(String), 30(Integer), OnClickListener 1990-01-01(String), 2020-11-05 00:00:22.018(Timestamp)
2020-11-05 00:00:22.234 DEBUG 6596 --- [           main] wiki.xsx.learn.TestDao.insert            : <==    Updates: 1
2020-11-05 00:00:22.236  INFO 6596 --- [           main] wiki.xsx.learn.LearnApplication          : ======================вставка======================
2020-11-05 00:00:22.237  INFO 6596 --- [           main] wiki.xsx.learn.LearnApplication          : ======================обновление======================
2020-11-05 00:00:22.238 DEBUG 6596 --- [           main] w.x.core.mybatis.MybatisSqlInterceptor    : ==>      MySQL: UPDATE test SET name = '张三', age = 32, birthday = '1990-01-01', create_time = '2020-11-05 00:00:22' WHERE id = 1 
2020-11-05 00:00:22.238 DEBUG 6596 --- [           main] wiki.xsx.learn.TestDao.updateByPrimaryKey : ==>  Preparing: UPDATE test SET name = ?, age = ?, birthday = ?, create_time = ? WHERE id = ? 
2020-11-05 00:00:22.239 DEBUG 6596 --- [           main] wiki.xsx.learn.TestDao.updateByPrimaryKey : ==> Parameters: 张三(String), 32(Integer), 1990-01-01(String), 2020-11-05 00:00:22.237(Timestamp), 1(Integer)
2020-11-05 00:00:22.243 DEBUG 6596 --- [           main] wiki.xsx.learn.TestDao.updateByPrimaryKey : <==    Updates: 1
2020-11-05 00:00:22.244  INFO 6596 --- [           main] wiki.xsx.learn.LearnApplication          : ======================обновление======================
2020-11-05 00:00:22.244  INFO 6596 --- [           main] wiki.xsx.learn.LearnApplication          : 
```learn. LearnApplication          : ======================выборка======================
2020-11-05 00:00:22.250 DEBUG 6596 --- [           main] w. x. core. mybatis. 
```MybatisSqlInterceptor   : ==>      MySQL: SELECT id, name, age, birthday, create_time FROM test WHERE id = 1 AND name = '张三' AND age = 32 AND birthday = '1990-01-01' 
2020-11-05 00:00:22.250 DEBUG 6596 --- [           main] wiki. xsx. learn. TestDao. select            : ==>  Preparing: SELECT id, name, age, birthday, create_time FROM test WHERE id = ? AND name = ? AND age = ? AND birthday = ? 
2020-11-05 00:00:22.251 DEBUG 6596 --- [           main] wiki. xsx. learn. TestDao. select            : ==> Parameters: 1(Integer), 张三(String), 32(Integer), 1990-01-01(String)
2020-11-05 00:00:22.271 DEBUG 6596 --- [           main] wiki. xsx. learn. TestDao. select            : <==      Total: 1
2020-11-05 00:00:22.272  INFO 6596 --- [           main] wiki. xsx. learn. LearnApplication          : ======================выборка======================
2020-11-05 00:00:22.272  INFO 6596 --- [           main] wiki. xsx. learn. LearnApplication          : ======================удаление======================
2020-11-05 00:00:22.274 DEBUG 6596 --- [           main] w. x. core. mybatis. MybatisSqlInterceptor   : ==>      MySQL: DELETE FROM test WHERE id = 1 AND name = '张三' AND age = 30 AND birthday = '1990-01-01' AND create_time = '2020-11-05 00:00:22' 
2020-11-05 00:00:22.274 DEBUG 6596 --- [           main] wiki. xsx. learn. TestDao. delete            : ==>  Preparing: DELETE FROM test WHERE id = ? AND name = ? AND age = ? AND birthday = ? AND create_time = ? 
2020-11-05 00:00:22.275 DEBUG 6596 --- [           main] wiki. xsx. learn. TestDao. delete            : ==> Parameters: 1(Integer), 张三(String), 30(Integer), 1990-01-01(String), 2020-11-05 00:00:22.272(Timestamp)
2020-11-05 00:00:22.277 DEBUG 6596 --- [           main] wiki. xsx. learn. TestDao. delete            : <==    Updates: 0
2020-11-05 00:00:22.277  INFO 6596 --- [           main] wiki. xsx. learn. LearnApplication          : ======================удаление======================

Комментарии ( 0 )

Вы можете оставить комментарий после Вход в систему

Введение

плugi для полной SQL-инструкции MyBatis Развернуть Свернуть
MulanPSL-2.0
Отмена

Обновления (2)

все

Участники

все

Язык

Недавние действия

Загрузить больше
Больше нет результатов для загрузки
1
https://api.gitlife.ru/oschina-mirror/xsxgit-mybatis-sql-spring-boot-starter.git
git@api.gitlife.ru:oschina-mirror/xsxgit-mybatis-sql-spring-boot-starter.git
oschina-mirror
xsxgit-mybatis-sql-spring-boot-starter
xsxgit-mybatis-sql-spring-boot-starter
master