控制台打印sql没问题就是添加不到表里，把控制台sql复制到mysql中运行就可已添加

Question

09:43:12.404 [http-nio-8080-exec-4] DEBUG java.sql.Connection:27 - {conn-100143} Connection
09:43:12.405 [http-nio-8080-exec-4] DEBUG java.sql.Connection:27 - {conn-100143} Preparing Statement: insert into user_currentcy_account_info (o_c_a_i_id,c_i_no,balance,create_date_time,status) values(?,?,?,?,?)

09:43:12.405 [http-nio-8080-exec-4] DEBUG o.s.jdbc.datasource.DataSourceUtils:110 - Fetching JDBC Connection from DataSource
09:43:12.419 [http-nio-8080-exec-4] DEBUG java.sql.PreparedStatement:27 - {pstm-100144} Executing Statement: insert into user_currentcy_account_info (o_c_a_i_id,c_i_no,balance,create_date_time,status) values(?,?,?,?,?)

09:43:12.419 [http-nio-8080-exec-4] DEBUG java.sql.PreparedStatement:27 - {pstm-100144} Parameters: [8f3de5e04c654c2f93974e0cd38ddbf9, 20161031792910317771292672, 0, 20161209093957, 01]
09:43:12.420 [http-nio-8080-exec-4] DEBUG java.sql.PreparedStatement:27 - {pstm-100144} Types: [java.lang.String, java.lang.String, java.lang.Integer, java.lang.String, java.lang.String]
09:43:12.426 [http-nio-8080-exec-4] DEBUG o.s.jdbc.datasource.DataSourceUtils:332 - Returning JDBC Connection to DataSource

Answer 1

看你的log好像适合数据库连上的 看下你是否配置了事务 或者说事务没有提交呢