mysql端口配置问题,sql也是正确的,为什么查不出来?在workbench里就可以

来源:4-8 DAO层单元测试编码和问题排查(上)

台风下雨天

2017-03-15 17:02

信息: Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 3, acquireRetryAttempts -> 2, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 1000, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> z8kfsx9m1m0nssi1s77551|7aaca91a, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.mysql.jdbc.Driver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> z8kfsx9m1m0nssi1s77551|7aaca91a, idleConnectionTestPeriod -> 0, initialPoolSize -> 3, jdbcUrl -> jdbc:mysql://127.0.0.1:3306/graduation?useUnicode=true&characterEncoding=utf8, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 30, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 10, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -> 0, preferredTestQuery -> null, properties -> {user=******, password=******}, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false ]

16:33:54.730 [main] DEBUG o.m.s.t.SpringManagedTransaction - JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@5af9926a] will not be managed by Spring

16:33:54.736 [main] DEBUG o.a.dao.AccountDao.queryByName - ==>  Preparing: select a_id,a_name,a_password,a_grade,a_enable from account where a_name = ? and a_password = ? and a_enable = 1 

16:33:54.908 [main] DEBUG o.a.dao.AccountDao.queryByName - ==> Parameters: admin(String), 123(String)

16:33:54.941 [main] DEBUG o.a.dao.AccountDao.queryByName - <==      Total: 1

16:33:54.949 [main] DEBUG org.mybatis.spring.SqlSessionUtils - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1b5bc39d]

null三月 15, 2017 4:33:54 下午 org.springframework.context.support.GenericApplicationContext doClose

信息: Closing org.springframework.context.support.GenericApplicationContext@731f8236: startup date [Wed Mar 15 16:33:52 CST 2017]; root of context hierarchy

Disconnected from the target VM, address: '127.0.0.1:42779', transport: 'socket'



写回答 关注

3回答

  • qq_慕姐7081625
    2019-04-08 16:58:02

    问一下啊该怎么解决

  • weibo_希森立喔力_04101935
    2017-04-05 17:28:12

    请问题主最后如何解决该问题的?

    台风下雨天

    只是没有封装成实体类,查是查出来了

    2017-04-08 13:47:52

    共 1 条回复 >

  • 按动碳素笔
    2017-03-21 14:52:50

    什么查不出来?日志里不是有 Total: 1?

    _桃花依旧笑... 回复台风下雨天

    怎样自动封装呢 在action里面加入bean对象 然后get set方法?

    2018-04-03 10:30:13

    共 2 条回复 >

Java高并发秒杀API之业务分析与DAO层

Java实现高并发秒杀API的第一门课,还等什么,赶快来加入吧

87424 学习 · 496 问题

查看课程

相似问题