Слияние кода завершено, страница обновится автоматически
Полноценный плагин для работы с SQL в Mybatis
1.0.1 (отправлена в центральный репозиторий)
mvn clean install
<dependency>
<groupId>wiki.xsx</groupId>
<artifactId>mybatis-sql-spring-boot-starter</artifactId>
<version>1.0.1</version>
</dependency>
в yml формате:
logging:
level:
wiki.xsx.core: debug
в properties формате:
logging.level.wiki.xsx.core=debug
``````properties
logging.level.wiki.xsx.core=debug
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 )