spring boot 与mybatis 整合配置日志打印

最新推荐文章于 2024-07-26 15:01:45 发布

大巨魔战将

最新推荐文章于 2024-07-26 15:01:45 发布

阅读量1.3w

点赞数

本文链接：https://blog.csdn.net/bianfu2008zhi/article/details/53693242

版权

application.properties

mybatis.check-config-location=true

mybatis.mapper-locations=classpath*:mapper/*.xml
mybatis.type-aliases-package=com.myjsp.dao

spring.datasource.url=jdbc:mysql://localhost/credit?useUnicode=true&characterEncoding=utf8
spring.datasource.username=root
spring.datasource.password=root
spring.datasource.driver-class-name=com.mysql.jdbc.Driver

#显示sql

logging.level.com.myjsp=DEBUG

@RunWith(SpringJUnit4ClassRunner.class)
@SpringApplicationConfiguration(classes = MyjspApplication.class)
@WebAppConfiguration
public class MyjspApplicationTests {
@Autowired BlackDao blackdao;
@Test
	public void contextLoads() {
		Black temp=blackdao.selectByIdNo("522625199705243315");
		System.out.println(temp);
	}

}

mysql 删除重复数据

DELETE FROM black WHERE id NOT IN (SELECT minid FROM (SELECT MIN(id) AS minid FROM black GROUP BY idno) b);